Forum Discussion
Adding a new row after linking worksheets in Excel
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 row...
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.