View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
D. D. is offline
external usenet poster
 
Posts: 53
Default 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