# Should be simple..

#### Jito463

##### New Member
Ok, this should be simple, but I can't seem to figure out how. I've searched here and on Google for the past hour, and I can't seem to discover how to do this.

I'm using Excel 2003 (still haven't upgraded to 2007), and I've got a spreadsheet I use for my business with 13 sheets (12 months, plus an annual tally). The primary cell of importance is always B2 on the 12 monthly sheets. It tallies up all the data from the month into a single cell (a simple =SUM formula). I want to automatically update the cells on the first sheet with the data from the corresponding monthly sheet.

For example, January is sheet 2 and the annual tally is sheet 1. I want to copy from sheet 2, cell B2 (the monthly total), to sheet 1, cell B5. For February, from sheet 3, cell B2, to sheet 1, cell B6. And so on, and so forth.

I know this should be super simple, but I can't seem to figure out the command. I would be grateful for any assistance in this. For now, I'm simply manually entering the data in the annual sheet, but I would prefer it autoupdate.

Last edited:

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Try

=INDIRECT(TEXT(DATE(1,ROW(A1),1),"mmm")&"!B2")

in B% and copy down

While that didn't work, and turned out to be far more complicated than I was looking for, your mention of the "indirect" command got me searching online in a different path than before. Turns out, it was super simple, like I originally thought. I simply needed the following formlua in my first sheet (the annual tally)

=01!B2

Where 01 = my January totals and B2 = the cell I wanted to copy from. Simple.

Thanks for trying anyway, I really do appreciate it.

Mine was generic to work out the sheet name automatically. Oh well!

I've always preferred the Einstein approach. "Everything should be made as simple as possible, but not one bit simpler".

Replies
5
Views
256
Replies
6
Views
359
Replies
41
Views
489
Replies
3
Views
142
Replies
5
Views
192

1,203,506
Messages
6,055,801
Members
444,825
Latest member
aggerdanny

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back