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?