Creating a Master Sheet.

[callen13]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have multiple sheets and want to create a master sheet so I can see all the data on one page. I also want to be able to update a cell or multiple cells in the master and then have the specific sheet updated automatically with the new information. Each sheet has the same column headers (11 columns), but different qtys of rows. I know how to link each cell to the master, but that will take too long since I have lots of cells...

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have multiple sheets and want to create a master sheet so I can see all the
data on one page. I also want to be able to update a cell or multiple cells
in the master and then have the specific sheet updated automatically with the
new information. Each sheet has the same column headers (11 columns), but
different qtys of rows. I know how to link each cell to the master, but that
will take too long since I have lots of cells...

Without knowing more about your data layout, it's hard to give a
specific suggestion.

Why do you need separate sheets - could an autofilter on the master
sheet, or a pivot table, provide the same information?

Is your data regularly organized so that you could drag a cell reference
and have XL update the address copied?

 

[CyberTaz]

Like John says, it's very hard to visualize your data arrangement without a
good deal more descriptive detail. Before you go any further, though, I'd
suggest you take into consideration what appears to be a possible
misconception ‹ Excel cells don't "send" information anywhere, so as long as
you have separate worksheets what you're calling a Master would have to
retrieve information from those locations by way of some sort of lookup. You
can't modify the data content from both the source sheet *and* the Master...
When you modify the source data the lookup formulas automatically update.

You might be better off storing all the source data on one sheet then using
other features of the program to sort, filter, summarize, etc.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Phillip Jones, C.E.T.]

As much as I hate to bring another program into this forum. He sounds
like he needs a relational Database. In which case FileMaker Pro might
work better That way any changes in the related sub files would be
reflected in the Master or main Database. Unless Excel has changed in
recent years, I'm unaware that you can do relational Databases in Excel
which by nature a spreadsheet program.

 

[callen13]

I've resolved my issue. I just copy and paste link the data from my Master Sheet into each appropriate sheet. So now when I update my Master the appropriate cells get updated as well.