Linking data from worksheet to worksheet

[MKSG_puzzled]

I have the first page of my workbook as my summary page. I then have 50
other worksheets that have individual data on them. How do I create a
template (if you can) for the worksheets to tie their data into the main
summary page. For example: I want to publish the following example data from
each of the worksheets to the summary page:

Project #
Project Name
Contract Amount
Location

 

[Francis]

How is your data in other sheets layout look like?
--
Hope this help

Please click the Yes button below if this post have helped in your needs

Thank You

cheers, francis

 

[MKSG_puzzled]

I am creating this from Scratch so I can make the summary page and all the
worksheets look anyway I want them to - that is why I am asking the question
so that as I am creating this document, I set it up correctly at the
beginning to have all the data summarized properly.

 

[MKSG_puzzled]

I am creating this master workbook now. They can look anyway I want them to.
This is why I am asking the questions so that I can set it up correctly.

 

[Dave Peterson]

I don't know the details of your data, but I bet it would be much simpler if all
the raw data was on a single sheet.

Add an indicator field (essentially an indicator that would have told you what
sheet that data would be on) to each row. And one logical record per row--don't
split your logical data over multiple rows.

Then you'll be able to make charts, use autofilter, sort the data, and even
create pivottables.

Spreading the raw data over 50 different sheets sounds very bad to me.

If the data won't fit on a single sheet, then maybe excel isn't the application
you should be using--maybe a real database program would be a better suit
(Access????).

 

[MKSG_puzzled]

The individual worksheets for each project are going to contain more
information than what is on the summary sheet...each project manager will
have to update their information. The summary sheet is for the Director who
will look at the main points but will then have the capability to go to the
individual worksheets for additional information as needed. Is this not a
possibilitiy?

 

[Dave Peterson]

The summary sheet could be as simple or as complex as you want--it shouldn't
have any impact on what the detail sheet(s) would hold.

But sure, you can do it. But I think it adds a lot of complexity to the
workbook.

I still think that putting the data in one sheet--even if you have to recreate
the giant data worksheet each time you get input from the managers would be a
first step. Well, that's the way I'd approach it.