Workbook Design Principles

[Graemea]

Hi,

I have a workbook that I update monthly that consists of around 20 worksheets containing raw data, a single sheet in which the data I need for an analysis is collated using VLOOKUPS against the raw data sheets and a final, presentation sheet that summarises the collated data with graphs and tables.

Is this a sensible way to structure a workbook or should the raw data be in a separate workbook and the collating and presentation in another?

Thanks!

 

[Fluff]

Cross posted Best Way to Structure a Workbook?

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered elsewhere.

 

[Graemea]

Hi.

Sorry!

The reason I posted on more than one forum was because I was hoping for a variety of opinions rather than a single answer to a problem which is usually what I think most of us would be looking for.

Thanks

 

[Graemea]

I have also posted my question at:

Best Way to Structure a Workbook? [SOLVED]

Hi, I have a workbook that I update monthly that consists of around 20 worksheets containing raw data, a single sheet in which the data I need for an analysis is collated using VLOOKUPS against the raw data sheets and a final, presentation sheet that summarises the collated data with graphs...

www.excelforum.com

 

[JonXL]

I have also posted my question at:

Best Way to Structure a Workbook? [SOLVED]

Hi, I have a workbook that I update monthly that consists of around 20 worksheets containing raw data, a single sheet in which the data I need for an analysis is collated using VLOOKUPS against the raw data sheets and a final, presentation sheet that summarises the collated data with graphs...

www.excelforum.com

What would be your motive for putting the data in a separate workbook?

Are you worried about people messing with it?

How often is everything updated?