Search results

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...

I'm taking that formula and dragging it down in the master sheet, in the target the will be B2 through Z2 not F2 (like my sample had). Is it not possible to just reference "A2" as I have described in the formula? I just feel if I can get that solved, it will do exactly as I need.

Thank you for your reply, This particula formula is one of the few that can be read from one workbook while the other (target) is closed (as far as I know). So the idea is to have a collection of files (target) read by a master file and as I receive an updated target file, I paste it over the...

Hello, I would like to modify the formula below to get the "Baker, Tom" part of the formula from a cell like "A1" and am not quite sure how to do it? Row A contains the names of the other worksheets. =SUMPRODUCT(--('C:\Documents and Settings\MyProfile\Desktop\Meeting\Lists\[Baker...

Thanks namliam, that makes sense!

namliam - You know, sometimes things come accross a bit harsh in writing, I'll give you the benifit of the doubt on this one :) Your input, to me anyways, was a bit abstract for my skills and you did not provide any sample code or pseudo code to better illustrate your concept. Roku - Thank you...