Hello,
Trying to create a column in a worksheet that will reference numbers in a column in another worksheet (all exact same row numbering). I can do it one at a time but I have lots of rows. I get a formula like April2012'!$c$8 when I reference the first cell but can't copy it down the column unless I eliminate the second $. It's Excel 2000.
thx!