Adding a new row after linking worksheets in Excel

Copper Contributor

I have linked two worksheets so that data feeds from sheet 2 into sheet 1 (the master). However, when I add a row or column to sheet 2, it does not appear on sheet 1. How do I get new columns and rows to appear automatically on sheet 1?

1 Reply
You need to use VLOOKUP or INDEX-MATCH, the arguments of which depend upon the structure of your data and the results you want to be returned therefrom.