#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 594
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to merge monthly workbooks into a quarterly workbook?? erinattbt123 Excel Worksheet Functions 6 September 19th 06 10:56 PM
Reference & update destin. cells on 1st machine from source workbook on 2nd machine. [email protected] Excel Discussion (Misc queries) 6 February 28th 06 05:15 AM
excel exits unexpectedly or hangs the second time I open workbook r_m_i Excel Discussion (Misc queries) 0 February 9th 06 10:14 PM
Repost:Automatically inserting a row in external workbook 50pingviner Excel Discussion (Misc queries) 3 December 28th 05 07:38 PM
How to hyperlink from a workbook to sheets in another workbook? MJOHNSON Excel Worksheet Functions 0 February 17th 05 08:31 PM


All times are GMT +1. The time now is 10:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"