software

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

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?''.quot;jrwquot; wrote:

gt; I have 13 worksheets titled Jan - Dec and Total. Each of the Jan - Dec
gt; worksheets are set up identical but after each month, different data is
gt; entered for that month. The Total worksheet has 12 columns titled Jan - Dec.
gt;
gt;
gt; Total!A1 = Jan!$A$1.
gt;
gt; Is there a way to copy the reference in Total!A1 to Total!A2 so that
gt; Total!A2 = Feb!A$1$, Total!A3 = Mar!$A$3, etc... ????