Thread: Applying a formula to multiple worksheets

Hi,

I am creating one worksheet that is a summary of many different worksheets.

My strategy is to insert in one column the names of the worksheets then the next column I insert a formula adding two cells contained the referenced worksheet. The problem is that I have 50 worksheets so I after i enter the formula "=Sheet1!A1+Sheet1A2", I have to do it 49 more times times b/c I don't know a way drag the formula down and make it automatically apply the next worksheet. Is there a way to do this in excel other by manually changing the names of the worksheets?

Thanks

Michael

Sorry if I have misunderstood your post but you can group work sheets.

IE select your first worksheet "Sheet1".

Holding the shift, navigate to the last sheet and click it (I.E "Sheet50") while still holding shift. You should notice the bar at the top change to the name of the spreadsheet & [GROUPED]

Whatever you do on any sheet while in grouped mode will be applied to every sheet.

IE if you type in a formula in cell a1 on sheet 1. The same formula will be applied on every sheet you have grouped.

Right click a sheet tab and click ungroup to undo the grouping.

Sorry if I wasn't clear. I'll try to explain differently.

I have a worksheet like this:

Column A Column B
Sheet 1 =Sheet 1!A1+Sheet 1A2
Sheet 2 =Sheet 2!A1+Sheet 2!A2
Sheet 3 =Sheet 3!A1+Sheet 3!A2
.
.
.
Sheet m

So in every cell on Column B, I have to manually change the formula to make it change spreadsheets. Is there a way I can avoid this?