Recent content by DanG

Not everyone has Access on their computers and it's easier to pass around a workbook. But I'm with you on that. Tables seem to be very cool and have a lot going for them, but as I'm finding out they are very finicky. I totally had everything just the way I wanted with the tables thing, and then...

Thank you June7. I took your advice and renamed GA# to GANum...thank you! Your example is on the right path, I have tried different variations of it, but can't get it to work. The best I can get is it will select the entire GA# range. So just concentrating on the "$L$2:$L2" part of my...

So I'm trying to understand working with tables by using structured references and need a push. How would you write the formula below using only structured reference? The table name is "Activity" and the "L" column is "GA#" and the "N" column is "FlowingClients"...

I think I found the solution. Apparently, tables has an issue with hard references sometimes. So using a dynamic reference seems to be a good workaround, at least it worked for me. I used this instead: =INDEX(AdvGrpTable[AdvisorName], MATCH(INDIRECT("$b"&ROW()),AdvGrpTable[AdvGA'#], 0))

Hello, I am new to working with tables and have an issue when sorting. The issue seems to be related to the relative positioning when referencing an adjacent cell. Before sorting, the top cell and all the ones below show the correct relative action ($b2, $b3, $b4...). But after sorting it...

I see in your profile you're retired....keep giving answers like this and you'll find yourself working again :)....I wouldn't wish that on anyone, thanks again!

Mystery solved! Thank you very much, kind of a neat trick.

Please see the attached example. Make a new entry into column 2 & 3 and you will see a result appears. The thing is there is no formula in column until you enter into the other columns. I am curious as to how this works

Not that I see, I will upload tomorrow as it's on my work computer. Sent from my SAMSUNG-SM-N910A using Tapatalk

Thank you, the thing is there is no formula. A formula only appears in Columb 1 when Columb 2 & 3 have numbers entered into them. Otherwise it is completely empty. It's magic I say! There is no vba involved. Sent from my SAMSUNG-SM-N910A using Tapatalk

Hello, I have an existing worksheet that has a table of data and column 1 had no data or formula in it unless numbers are entered into column 2 & 3. I have seen this before but can't remember where, I think it has to do with tables? Can anyone tell me how this is working and how I can change...

I know this has been dead for a loooonnnggg time, but I was looking to soldve this problem today...and here it was! Thank you!

Solved! The problem was "FileFormat:=xlExcel9795", I changed it to "=xlExcel8".

Hello, We just converted from Excel 2003 to 2010 and I am getting the following error "Error 1004 - Method 'SaveAs' of object_Workbook failed".. The code worked fine in 2003. The macro uses the contents of the clipboard to supply the Workbook name. and uses "DataObj.GetText" to do this. I have...