Best Way to Structure a Workbook?

[andrewc]

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!

[6StringJazzer]

I think the way you are doing it is a best practice. The only reason I can think of to put the raw data in a separate workbook is if the data is frequently updated by a separate application and that is the only possible way to do it. Otherwise, if you only have one raw data file and one analysis file, I would make them the same file.

Why does the raw data use 20 worksheets?

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[XL&ME]

Here is a link that will give you tips on structuring and design of a workbook https://www.xelplus.com/excel-spreadsheet-design/

[andrewc]

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.

I have also posted my question here:

https://www.mrexcel.com/board/thread...iples.1154531/

[6StringJazzer]

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.

We have no objection to that and it's a good idea. We just ask that you provide the links. Thanks.

[6StringJazzer]

Here is a link

Please note that we normally do not permit links to commercial sites or competing forums. In this case I'll let it go because it is so directly relevant to the OP without registration or fee required, but take care in such posts in the future.

[andrewc]

Thank you both