|
Master sheet data HELP!(please)
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 |
Master sheet data HELP!(please)
In SHEET2 cell A1 enter:
=SHEET1!A1 copy this cell and paste it everywhere you need it. -- Gary''s Student - gsnu200906 "Blueliner975" wrote: 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 |
Master sheet data HELP!(please)
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" wrote: In SHEET2 cell A1 enter: =SHEET1!A1 copy this cell and paste it everywhere you need it. -- Gary''s Student - gsnu200906 "Blueliner975" wrote: 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 |
Master sheet data HELP!(please)
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!! -- Gary''s Student - gsnu200906 "Blueliner975" wrote: 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" wrote: In SHEET2 cell A1 enter: =SHEET1!A1 copy this cell and paste it everywhere you need it. -- Gary''s Student - gsnu200906 "Blueliner975" wrote: 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 |
Master sheet data HELP!(please)
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? "Gary''s Student" wrote: 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!! -- Gary''s Student - gsnu200906 "Blueliner975" wrote: 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" wrote: In SHEET2 cell A1 enter: =SHEET1!A1 copy this cell and paste it everywhere you need it. -- Gary''s Student - gsnu200906 "Blueliner975" wrote: 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 |
Master sheet data HELP!(please)
Copy all then Paste SpecialPaste LinkOKEsc
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 On Mon, 5 Oct 2009 16:43:02 -0700, Blueliner975 wrote: 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" wrote: In SHEET2 cell A1 enter: =SHEET1!A1 copy this cell and paste it everywhere you need it. -- Gary''s Student - gsnu200906 "Blueliner975" wrote: 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 |
Master sheet data HELP!(please)
Select ALL the cells on Sheet1 and copy them. Then click on only A1 in
Sheet2 and paste/special/format -- Gary''s Student - gsnu200906 "Blueliner975" wrote: 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? "Gary''s Student" wrote: 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!! -- Gary''s Student - gsnu200906 "Blueliner975" wrote: 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" wrote: In SHEET2 cell A1 enter: =SHEET1!A1 copy this cell and paste it everywhere you need it. -- Gary''s Student - gsnu200906 "Blueliner975" wrote: 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 |
| All times are GMT +1. The time now is 06:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com