comparing data in different sheets

  • Thread starter Thread starter bobwaits
  • Start date Start date
B

bobwaits

I have data set for each quarter, like sales, profits, margins. The dat
is for more than 1000 companies and in different worksheets: Eac
quarter is in each seperate worksheet.

It gets frustrating to keep on switching between each worksheet to ge
a comparative number. Is there a way out
 
In situations like this I generally create a summary sheet and reference
the cells from all of the other worksheets. Set up the layout for the
summary sheet and then select a cell you want to mirror the value from
another worksheet. With the cell selected, type "=" in the formula bar
and then (before hitting enter) go to the worksheet that has the data
you need. Click on the cell you want and hit enter. Whatever data is
in that cell will now be shown in mirror image on the summary page.
Once you've done this for all the cells (I know it's a pain with over
1000) it should save you a lot of flippling around for comparisons.
 
I am pretty new with EXcel. Here is a question. There are over 1,00
companies and 10 data set for each companies. So that's 10,000 dat
points for eight quarters. So that's 80,000. Would I have to manuall
link these 80,000 cells
 
So you're looking for an easy way to view 80,000 different Data sets..
if you find one, let me know.

You can reference ranges (just select 10 cells to reference and the
the 10 you want to mirror from another sheet). That may help you cu
down the time to link them. The format you're dealing with is prett
rough, it's just such a huge mass of data.

If you want to avoid manually doing it, you can also use the sam
command syntax for each sheet (assuming the cells locations are th
same). I'm afraid I don't know of any way to prevent you from typin
in 1000 different sheet names though.

For example:

To reference 10 cells (A1:A10) from a sheet named "Company1" to a se
of cells on a master sheet use:

='Company1'!A1:A1
 
Window|New window
and then
window|arrange|tiled (and resize manually)

Now you could see both worksheets at the same time.
 
And when you're ready to close that window, click on the one you want to dismiss
and hit ctrl-F4 or ctrl-W.

(don't forget to save with the number of windows you want (1??).)
 
Back
Top