Formula won't copy

[kwright58]

Can someone please tell me why I cannot copy & paste this formula into another worksheet so that it will calculate correctly:
=$D10-Table2[[#This Row],[BHG 6%]]

I have tried copy & paste and typing it in, cannot get it to function properly. HELP Please???

kathy

[TMS]

Your profile says 2003 but that looks like a Structured Table Reference from 2007 and above. Is that correct?

#This Row relates to the current row within the Table. I suspect that is the problem if you are copying it elsewhere.

It might help to understand if you post a sample workbook.

Regards, TMS

[kwright58]

Yes it is 2007, didn't see the option to change the version. Thank you for the info about the #This Row, the person who made this spreadsheet used some very detailed formulas when simple ones would have worked but this one I had not used before. Thanks again

[TMS]

User CP | My Settings | Edit Profile | My Microsoft Office Version:

If you need more help, upload a sample workbook, or ...



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[FDibbins]

Hi and welcome to the forum

I guess Im not alone in my dislike of the way excel presents structured formulas in the new "tables". More often than not, I will type the references in manually, I find them easier to see/understand that way

[TMS]

@FD: kind of defeats the object, don't you think?

[FDibbins]

Not if you have problems reading what the ref is

[TMS]

I rather like them but it a) takes some getting used to and b) makes for some hellishly long formulae

[FDibbins]

Sometimes its hard for an old dog to learn new tricks lol

[TMS]

You're way younger than me, heh, heh!