Master sheet data HELP!(please)

[Blueliner975]

I am trying to copy data from SHEET1 (my master sheet) to SHEET2. It is ALOT
OF DATA. i want to be able to make changes to SHEET1 and have them
automatically appear on SHEET2. Is anyone available to walk me thru this...
im online on AIM YAHOO and MSN messengers and can be reached via telephone if
anyone is willing.

AIM xcobraxhueyx
YAHOO Blueliner975
MSN Blueliner975
Phone US ONLY 760-419-8249

 

[Gary''s Student]

In SHEET2 cell A1 enter:

=SHEET1!A1

copy this cell and paste it everywhere you need it.

 

[Blueliner975]

Is this the ONLY way to do that. there are hundreds of lines and cells that
need to be linked this way (im using excel 2007)

 

[Gary''s Student]

Once the formula has been entered in A1, Click on it and drag the mouse to
the right and down. This will hilight a large area.

Then in the formula bar, click the end of the formula.
Then touch CNTRL-ENTER
This will copy the formula to the entire hilighted area in one fell swoop!!

 

[Blueliner975]

Ok i did something similar to that .. i inputed the formula =sheet1!a1 and
that worked... then i clicked the little cross in the bottom right corner of
sheet2:a1 and it copied everything... NEW PROBLEM... it isnt taking the
formating from the master sheet i.e. color text cell size is there a way to
do that as well?

 

[Gord Dibben]

Copy all then Paste Special>Paste Link>OK>Esc

Just a note...........blank cells on Sheet1 will be treated as 0 in Sheet2

To prevent that =IF(Sheet1!A1="","",Sheet1!A1)

Paste Link won't do that for you.

You must enter the formula in one cell then simply copy by dragging to other
cells.


Gord Dibben MS Excel MVP

 

[Gary''s Student]

Select ALL the cells on Sheet1 and copy them. Then click on only A1 in
Sheet2 and paste/special/format