Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a master sheet
Hi All,
I have 3 sheets with similar data on each one, divided by location. I want to make a master sheet (the 4th sheet) that combines all the information on the first three. I've designed the template already, but I'm having a problem copying the cells from each individual sheet. I want the master sheet to automatically display any changes made to any of the original three. When I use the "=", the master sheet displays a '0' if the cell on the original sheet is blank. I want an exact copy of what is on the original sheet; if the cell is blank on the original, I want it blank on the master. Any ideas? Thanks! Cam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically add records from a new sheet to master sheet | Excel Discussion (Misc queries) | |||
Master Sheet | Excel Worksheet Functions | |||
Changing the Master Sheet Formula | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel | |||
Master Sheet Row Insertion | Excel Discussion (Misc queries) |