Thread: [Solved] Financial Data Organization
View Single Post
 
Old 06-14-2010, 04:09 AM
Kimberly Kimberly is offline Windows 7 Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

In general, it is much better to place all of the data in a single range on a single worksheet when you can (whenever the structure is the same.)

I don't know what calculations you are doing, or what Data1, Data2, etc are, but by placing the data on a single sheet, you can easily take advantage of features like filtering and pivot tables. And of course, simple division is a bit easier too.

I don't know what Data1 Data2 Data3 are, and they are probably fine, but since I don't know what they are, I will mention that it is easy to fall into using for column labels what should be data in a column. For example, if I sold vegetables on the side of the highway, I would want a field for Item and another for Quantity. Not a field for Corn and a different field for Beans, etc. Again, I dont knowyour data and I really doubt you need to change this, but I thought I should mention it.
Reply With Quote