Same formula for each sheet?

J

Jeremiah

I have an accounting spreadsheet set up where I can input my income and all
my expenses. I have four sheets set up, one for each quarter. I want each of
the sheets to be exactly the same, but obviously the numbers for each quarter
will be different. Is there a way to automatically update the formulas on
each sheet based on the first sheet? In other words, if I change the formula
in B5 on sheet one, I need it to update the formula for B5 on the other three
sheets as well.
 
G

Gord Dibben

One method...........

Select all 4 sheets prior to editing B5 on the active sheet.

Changes will be done to all sheets.

DO NOT FORGET to ungroup the sheets when complete.


Gord Dibben MS Excel MVP
 

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

formula question... 2
How to automatically paste cells from one sheet to another sheet? 1
Lock location of sheet within a spreadsheet 4
Printing worksheets 3
Line charting the same series using data from multiple sheets? 1
copy formula - keep cell same but increment sheet numbers 5
Totaling the same cells from different sheets 8
Complex formula help , please. 13

Top