If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excell budget worksheets
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 !!!! |
#2
|
|||
|
|||
Excell budget worksheets
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. -- Kevin Backmann "F_disk" wrote: 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 !!!! |
#3
|
|||
|
|||
Excell budget worksheets
thanks Kevin
"F_disk" wrote: 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 !!!! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
need a budget on excell how do I do it? | justhopen4 | Charts and Charting | 1 | March 20th, 2006 01:50 AM |
how do i duplex different orientation worksheets in excell | steve clarke | Setting up and Configuration | 1 | January 31st, 2006 03:07 AM |
Genisis of a Budget area | Ken | General Discussion | 2 | November 30th, 2005 01:17 PM |
How do I color the page tabs in Excell Worksheets? | MissDaizy | General Discussion | 2 | October 31st, 2004 02:55 PM |
Excell worksheets | Worksheet Functions | 2 | October 18th, 2003 09:54 AM |