Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Rows Between Worksheets
Hi-
I am trying to link rows (that are infinitely long in terms of data) between two different worksheets so that I dont have to retype all of the data. (I want them to be active links, so that if the data changes, it will automatically update). Is there a way to do this? (The first worksheet is a master that has a whole lot of information, and I would like the other worksheets to reference rows from the original...) Thank you very very much.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Rows Between Worksheets
In the other sheets you will have to set then up
eg: in sheet2 select the cell you want then type an equals sign = got to master sheet and selec tthe cell you want then press enter key. "veng" wrote: Hi- I am trying to link rows (that are infinitely long in terms of data) between two different worksheets so that I dont have to retype all of the data. (I want them to be active links, so that if the data changes, it will automatically update). Is there a way to do this? (The first worksheet is a master that has a whole lot of information, and I would like the other worksheets to reference rows from the original...) Thank you very very much.. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Rows Between Worksheets
Thank you for your reply, Exceluserforeman.
This allows me to link individual cells at a time; is there a way to link whole rows? Thanks again.... "exceluserforeman" wrote: In the other sheets you will have to set then up eg: in sheet2 select the cell you want then type an equals sign = got to master sheet and selec tthe cell you want then press enter key. "veng" wrote: Hi- I am trying to link rows (that are infinitely long in terms of data) between two different worksheets so that I dont have to retype all of the data. (I want them to be active links, so that if the data changes, it will automatically update). Is there a way to do this? (The first worksheet is a master that has a whole lot of information, and I would like the other worksheets to reference rows from the original...) Thank you very very much.. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Rows Between Worksheets
Select the entire row(s) and Copy.
Switch to other sheet and Paste SpecialPaste LinkOKEsc. Gord Dibben Excel MVP On Wed, 7 Dec 2005 06:42:02 -0800, "veng" wrote: Thank you for your reply, Exceluserforeman. This allows me to link individual cells at a time; is there a way to link whole rows? Thanks again.... "exceluserforeman" wrote: In the other sheets you will have to set then up eg: in sheet2 select the cell you want then type an equals sign = got to master sheet and selec tthe cell you want then press enter key. "veng" wrote: Hi- I am trying to link rows (that are infinitely long in terms of data) between two different worksheets so that I dont have to retype all of the data. (I want them to be active links, so that if the data changes, it will automatically update). Is there a way to do this? (The first worksheet is a master that has a whole lot of information, and I would like the other worksheets to reference rows from the original...) Thank you very very much.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting rows into worksheets that are protected | Excel Worksheet Functions | |||
sharing rows of data across multiple worksheets within a workbook | Excel Worksheet Functions | |||
How to link worksheets so editing one will edit others automatica | Excel Worksheet Functions | |||
Put same data in cells on two different worksheets (link?) | Setting up and Configuration of Excel | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |