copying a reference
 

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... ????

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... ????