Automatic refresh in linked worksheet if row is added



I have two worksheets, one is the master sheet, the second is linked
to the master such that specific columns in the master sheet appear in
the second worksheet. This is primarily so that I can sort dates and
create a gantt chart in the second sheet without using alot of the
unnecessary info in the master sheet. However, if I add a new row in
the master sheet, the new data does not appear in the second sheet
unless I retype the link in the first cell of the column, and click
and drag down the column every time. Is there a better way of doing
this so that any new data that is added (at the end of, in the middle
of) the master sheet will refresh and appear in the second sheet

Thank you


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