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
|