Link Rows From One Sheet To Another

J

JR

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
 
F

Frank Kabel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

moving rows to another sheet 3
More Rows/One Sheet vs More Sheets/Less Rows for best performance? 1
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Copy Data from One sheet to Different Sheets 1
deleting rows from one sheet based on 2nd sheet 1
How to list cells from two sheets that has different values in theirneighboring column? 8
Figuring out a lengthy formula. Probably quite simple... 3
Copy certain rows to new worksheet 1

Top