Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create a set of sheets that will update from a master?
I'm using excel to outline a publicity campaign for 4 groups. I want one
overall sheet with all the groups and seperate sheets with more detailed info - is there anyway of typing into both a master copy and an other copy at the same time? |
#2
|
|||
|
|||
You can reference a cell in another sheet eg in A1 on Sheet1 enter
=Sheet2!C4 so that whatever you type in Sheet2 C4 also appears in Sheet1 A1. It sounds like you want a summary sheet and 4 details sheets. In a cell on the summary sheet, type = into a cell, click on the tab of one of your detail sheets, click the cell you want duplicating and press enter. The formula will be built as you progress. Once you have all the entries in place, it would be a good idea to protect the summary sheet, so nobody can enter data into it and overwrite the formulae. -- Ian -- "funky_funky_almonds" wrote in message ... I'm using excel to outline a publicity campaign for 4 groups. I want one overall sheet with all the groups and seperate sheets with more detailed info - is there anyway of typing into both a master copy and an other copy at the same time? |
#3
|
|||
|
|||
funky_funky_almonds Wrote: I'm using excel to outline a publicity campaign for 4 groups. I want one overall sheet with all the groups and seperate sheets with more detailed info - is there anyway of typing into both a master copy and an other copy at the same time? Hi f_f_a Try using links On the sheet you want to link to the master sheet type = into the cell you want linked to the master sheet cell, then click in the cell you are linking to on the master sheet and hit Enter Now when you type into the cell on the master sheet, the cell on the linked sheet will show the same info -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=467067 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros for Protect/Unprotect all sheets in a workbook | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Can't create dynamic charts | Charts and Charting in Excel | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Template in Excel | New Users to Excel |