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
Bookmarks