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

0 votes

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

enter image description here

Sheet 2

enter image description here

Nov 29, 2022 in Others by Kithuzzz
• 38,010 points
2,324 views

1 answer to this question.

0 votes

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.

First Sheet

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 enter image description here

I hope this helps you.

answered Dec 10, 2022 by narikkadan
• 63,700 points

Related Questions In Others

0 votes
1 answer

In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel! ...READ MORE

answered Nov 25, 2022 in Others by narikkadan
• 63,700 points
865 views
+1 vote
1 answer

Automatically move an entire row of reference cell when one cell is moved or manipulated

You are describing how manually entered data ...READ MORE

answered Jan 15, 2023 in Others by narikkadan
• 63,700 points
244 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
973 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
3,314 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 23,260 points
626 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
841 views
0 votes
1 answer
0 votes
1 answer

Transpose column on one sheet to row on another, with linking

select A1:J1 in worksheet B and enter: =TRANSPOSE('worksheet ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,700 points
1,110 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP