ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Workbook Design (https://www.excelbanter.com/excel-discussion-misc-queries/126976-workbook-design.html)

[email protected]

Workbook Design
 
Data Lists are my primary use for Excel. I tend to import the data on
a Worksheet into columns A and B, for example. Skip a column for easy
use of the Go To function. Then, columns D and E are for calculations.
Is this common and why? Do some folks dedicate a single worksheet for
just data and then put calculations on a separate worksheet? What
would be the benefit? Thanks.


CLR

Workbook Design
 
One reason for putting "calculations" and other support data on another
sheet, is to keep it out of user's sight, and keep it from being corrupted
by the insertion of complete rows through the range of the support material.

hth
Vaya con Dios,
Chuck, CABGx3



wrote in message
ups.com...
Data Lists are my primary use for Excel. I tend to import the data on
a Worksheet into columns A and B, for example. Skip a column for easy
use of the Go To function. Then, columns D and E are for calculations.
Is this common and why? Do some folks dedicate a single worksheet for
just data and then put calculations on a separate worksheet? What
would be the benefit? Thanks.





All times are GMT +1. The time now is 02:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com