Linking one worksheet to another?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to link one worksheet to another sheet in a separate workbook, and I
need the destination worksheet to update accordingly if rows or columns of
data are inserted into the source sheet. Can anyone help me? I need a user
group to get real-time data in the linked workbook, but no be able to see all
of the data in the source sheet. I can create the link, and when I made
edits to existing cells, the data transfer occurs. However, if I add a row
with the data or column, the linked sheet will not pickup the added
information. Any suggestions?
 
Jay, can you arrange the source sheet so that the formula in the destination
sheet is a VLOOKUP formula or similar formula?
 
I don't know, I can try it I guess. I would have to do a Vlookup for every
cell in the destination sheet right?
 
Yes, probably so. If your data are nicely arranged in columns or rows it
should be easy enough.
 
You must log in or register to reply here.

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

Excel Move or Copy Stopped Working? 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Link from 1 worksheet to 4 different worksheets 1
How to Lock sort on a data entry sheet. 1
Sorting Linked Data Between Sheets 3
Link to another worksheet 1
Linking value of cell on one worksheet to a column on another work 1
linking data from one worksheet to another 1

Back
Top