I have 2 spreadsheets.

Spreadsheet 1 contains data from an external souce in columns A, B & C

Spreadsheet 2 contains a vlookup to column A of Spreadsheet 1.

If a new item appears in spreadsheet 1 is there any way to automatically insert a row and add it to spreadsheet 2. I guess I will have to add a formula in spreadsheet 1 column D to vlookup values in Spreadsheet 2 and if it comes up with a #NA result to somehow insert a row at that point and add it.

macke