cell reference as variable?
On Jul 31, 9:34 pm, Ruthie wrote:
I have built a worksheet in Excel to print ID cards using data in another
worksheet exported from an accounting program. The field for the first name
is =([filename]Sheet1!$C$3). Is there a way to use a variable to copy the
next name in the file, ie, cell C4, without having to enter each one
manually?
Sorry if this has already been covered. I love Excel and know it will do SO
much more than I understand.
Thank you in advance.
You should be able to if you get rid of the absolutes ($ signs)
then you should be able to drag the formula down
|