How to link cells?

R

raven_guy

I am trying to link four formatted excel worksheets into one main sheet... I
know I can do it this way E;G sheet 1 a1=sheet2 a2. But I need to do it with
the whole sheet. Is there anyway to do this? Keep in mind it is not in a
pivot table.

R.
 
B

bj

When you say you need to do this with the whole sheet?
Where is Cell A1 on the four sheets supposed to show on your master sheet?
Are you using he entire sheet in each one (all 64000+rows and though all of
the columns.?
If there is to be an overlap of the information between the sheets, is
there a priority as to which data gets selected.
 
R

raven_guy

There is no prioirty... I will explain deeper.. he he he...

I have 4 employee's they are keeping track of all the work they do in one
spread sheet each. I want to be able to link those sheets into one workbook
that has 4 sheets in it... So I dont have to open 4 different sheets and copy
and paste to create reports. So for example... Jane has used a1-a1580 and
june has used a1-a2120 I want to be able to link them to one workbook with
individual pages.

hope that is better.
 
B

bj

there are several ways to do it.
How often do they update there information?
how often do you want to know their updates?
Do you want your workbook to be static (One made, it is stored for hat
month) or dynamic (it changes each month as the data is updated.)

The simplest is a once a month static Workbook.
open the first workbook and <edit><copy/move sheet> select copy sheet
and move to new workbook.
do the same thing to each of the workbooks and move to the same new workbook.

this can be done with a macro to just generate a new book each month.

The more dynamic you want your book, the more complex it gets to where you
have a master book and a macro runs to automatically update your information
every time they update their information. so if you define your needs for
updates, someone can probably recommend a macro do do what you need.
 
Top