When a row is added to one sheet automatically add a row to another sheet

Question

For Example: If I add a row between rows 1 & 2 in Excel sheet 1 then how can I reflect this change automatically in sheet 2?

Sheet 1

Sheet 2

Answer 1

Use the VLOOKUP function. Your Spreadsheet 2's first column will display the first column of Spreadsheet 1; the same is true for the second column.

Since this is your first sheet, you are free to edit the contents of columns A and B as you choose.

For the Second Sheet add the following functions

Column A - =IFERROR(VLOOKUP(Sheet1!$A$1:$A$1000, Sheet1!$A$1:$B$1000, 1, false), "")

Column B - =IFERROR(VLOOKUP(Sheet1!$A$1:$A$1000, Sheet1!$A$1:$B$1000, 2, false), "")

Now all changes from Sheet 1 will be shown in Sheet 2 

I hope this helps you.