Home |
Search |
Today's Posts |
#1
|
|||
|
|||
linking one worksheet with another
I am trying to create a link between 2 worksheets - i have copied the source data and pasted it to the destination sheet, the data appears but there is not a link - the link is greyed out in the edit toolbar.
I have 3 columns of data approx 20 lines that i wish to link to another sheet, sometimes I will need to delete or insert lines in the source data but this is not transfering to the destination sheet. It recognises if i change the data in a current cell but not the addition of a new line? |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
linking one worksheet with another
In cell you want to link from type = and then using the mouse just click on
the cell you want to link to. This will create the link -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "debbieevans" wrote in message ... I am trying to create a link between 2 worksheets - i have copied the source data and pasted it to the destination sheet, the data appears but there is not a link - the link is greyed out in the edit toolbar. I have 3 columns of data approx 20 lines that i wish to link to another sheet, sometimes I will need to delete or insert lines in the source data but this is not transfering to the destination sheet. It recognises if i change the data in a current cell but not the addition of a new line? -- debbieevans |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking a worksheet to one in another book | Excel Discussion (Misc queries) | |||
Excel 2003 - Linking Formulas, Worksheet to Worksheet | Excel Discussion (Misc queries) | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
how do i use sumif when linking worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |