copying a reference

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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... ????
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying formulas from multiple worksheets 1
Summing a non continuous range 7
2 dimensional date sort 1
Specify columns to add for months MTD Diff 3
Transposing Array 4
Looking formula that gives total of remaining months 6
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
value error 4

Back
Top