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
• 27,940 points
116 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
• 51,600 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
• 51,600 points
67 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 in Others by narikkadan
• 51,600 points
33 views
0 votes
1 answer
0 votes
1 answer

How to add a Header Row to a ListView in Flutter?

Hi@akhtar, You can use ListView.builder method in your ...READ MORE

answered Sep 15, 2020 in Others by MD
• 95,420 points
2,818 views
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
523 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
2,387 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
• 22,940 points
110 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,640 points
283 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
• 51,600 points
127 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