Hello,

Was wondering if there was a more quick way to link rows in sheets. I have a
XLS file with three sheets, sheet 1 being the master. I would like to
highlight rows in sheet 1 and tell it to link to sheet 2 or 3 and add rows
as need. Currently I have to highlight a row and then goto either sheet 2 or
3 and paste link, very time consuming.

Thanks JR

hi
in your target sheet you could enter something like
='master_sheet'!A1
in the designated target cell

--
Regards
Frank Kabel
Frankfurt, Germany

JR wrote:
> Hello,
>
> Was wondering if there was a more quick way to link rows in sheets. I
> have a XLS file with three sheets, sheet 1 being the master. I would
> like to highlight rows in sheet 1 and tell it to link to sheet 2 or 3
> and add rows as need. Currently I have to highlight a row and then
> goto either sheet 2 or 3 and paste link, very time consuming.
>
> Thanks JR