Automatic refresh in linked worksheet if row is added

B

Bleuberry

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
automatically?

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

Similar Threads

Lookups - how to obtain data from a master spreadsheet into another 5
using the =page! feature to transpose a row to column 0
Changing info from one worksheet to the next 1
IF statements with more than one date column 5
count values in range based on value in same row 1
instering rows in one worksheet that reflect another worksheet 1
Set formulae to read the adjacent or next spreadsheet 1
find cell with matching text, then reference cell in same row 2

Top