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,020 points
2,643 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,720 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,720 points
1,034 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,720 points
313 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
1,079 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,495 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
803 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,690 points
976 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,720 points
1,299 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