Excell budget worksheets

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

Guest

Newb here....needing some help...

I am using 4 work sheets to represent the four weeks in a month.
I want to be able to put say "dog food" in B23 on all four work sheets
and then have that value show up on each sheet and also a running
grand total of it on the main sheet (first one).

I can figure out how to link the worksheets together so that when I enter
on worksheet 2 it shows up in a total column on work sheet one etc.
Thanks !!!!
 
Click on the tab for sheet 1, and then, while holding down a shift key, click
on the tab for sheet 4. This will turn Group Mode on, and whatever you type
in one sheet gets typed in all sheets, this includes data, formatting and
formulas. To ungroup, right click on any of the selected tabs and select
ungroup sheets.
 
Back
Top