Thread: copying a reference
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary L Brown
 
Posts: n/a
Default copying a reference
Check out the 'Indirect' function.

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"jrw" wrote:

I have 13 worksheets titled Jan - Dec and Total. Each of the Jan - Dec
worksheets are set up identical but after each month, different data is
entered for that month. The Total worksheet has 12 columns titled Jan - Dec.


Total!A1 = Jan!$A$1.

Is there a way to copy the reference in Total!A1 to Total!A2 so that
Total!A2 = Feb!A$1$, Total!A3 = Mar!$A$3, etc... ????
Reply With QuoteReply With Quote