I am trying to get a formula to show in excel when the report runs so the user can trigger them to compute. I am having to use R1C1 style references due to the columns changing location on each tab of the report.
An example formula would be: =((((AL3*AF3*(AH3+AI3))-(X3*R3*(T3+U3)))+AREA!$L$16)/(((AH3+AI3)*AF3)-((T3+U3)*R3)+AREA!$L$12+AREA!$L$13))-AREA!$B$15

I beleive I am going to have to convert to R1C1 as below, to get the references to pan out on each tab:
=INDIRECT("R"&ROW()&"C"&COLUMN()+27,FALSE)-INDIRECT("R"&ROW()&"C"&COLUMN()+13,FALSE)

I have tried putting these in using a compute statement and had some luck with the first example, but now that I have to include &Row and &Column references, focus thinks these are variables. Any help?

Maverick01

Usually the trick is to add |

i.e.

COMPUTE BAD_SAMPLE/A20 = 'Q&A';
COMPUTE GOOD_SAMPLE/A20 = 'Q&|A';

Good luck,
Dave