Inserting new rows into existing data

[mark the excel novice]

Hi,

I'm trying to update data with new rows whilst keeping all the previous data entered. All the data in columns A-C are exportable - Column D is manually added notes.

In the example below we had 3 fruits on the day I first exported the data and I've added a comment in column D.

Is it possible to re-export the data (now with 5 fruits) but keep the data in the "Notes" column from my previous export?

Column A	Column B	Column C	NOTES		Column A	Column B	Column C	NOTES
Apples	50​	Monday	Delivered AM		Apples	50​	Monday	Delivered AM
Pears	100​	Tuesday			Peaches	25​	Monday	Missed Delivery
Oranges	150​	Wednesday	Delivered PM		Pears	100​	Tuesday
					Bananas	200​	Wednesday	Delivered AM
					Oranges	150​	Wednesday	Delivered PM

 

[shinigamilight]

Yes you can do that by right clicking on the row number and clicking insert

 

[mark the excel novice]

Thanks @shinigamilight but I'm not sure that explained the problem correctly. I tried to do a very basic example but maybe a more detailed explanation is required.

Let's say I have 2 documents - the first one has the following and I get this on Monday:

Column A	Column B	Column C
Apples	50​	Monday
Pears	100​	Tuesday
Oranges	150​	Wednesday

I then have a master document which I paste columns A/B/C into then in column D I add notes:

Column A	Column B	Column C	NOTES
Apples	50​	Monday	Delivered AM
Pears	100​	Tuesday
Oranges	150​	Wednesday	Delivered PM

Then on Friday, I export a new (updated version) of document 1. This document has the same information from Monday but additional information is scattered within the document. Peaches have now become line 3 and Pears have become line 4 for example.

Column A	Column B	Column C
Apples	50​	Monday
Peaches	25​	Monday
Pears	100​	Tuesday
Bananas	200​	Wednesday
Oranges	150​	Wednesday

What I want to achieve is the ability to paste the whole of Friday's export into the master document whilst keeping the comments in the D column aligned to the correct row.

Column A	Column B	Column C	NOTES
Apples	50​	Monday	Delivered AM
Peaches	25​	Monday	Missed Delivery
Pears	100​	Tuesday
Bananas	200​	Wednesday	Delivered AM
Oranges	150​	Wednesday	Delivered PM

So the above example is what I want to see. However, if I just pasted the new document 1 in columns A/B/C I would see this:

Column A	Column B	Column C	NOTES
Apples	50​	Monday	Delivered AM
Peaches	25​	Monday
Pears	100​	Tuesday	Delivered PM
Bananas	200​	Wednesday
Oranges	150​	Wednesday

This is wrong, as Line 3 is showing Pears "Delivered PM" The note that I originally put for Oranges.

My real version of this document is not using fruit and has more columns that need to move down with the changes. I would like to know if there is any way of doing that.

 

[shinigamilight]

Does the master sheet contain data from the past too? If the master sheet contains data only for the week what you can do is use index and match to pull the notes from the master sheet to the Friday sheet and make the Friday sheet your master sheet.

 

[mark the excel novice]

@shinigamilight it's only for the week - so how would I get the INDEX MATCH to work?

I've attempted it but coming up short...

In my workbook, I have master (where I add column D), export 1 & 2.

As suggested I tried to add my formula to export 2 but I'm not quite getting the right result.

My formula attempt was =INDEX(Master!$A$1:$D$4,MATCH(1,(A:A=Master!A2)*(B:B=Master!B2)*(C:C=Master!C2),0),4)

But as you can see it's displaying the notes but on the wrong rows. Below is what i want to see.

Thanks in advance for any extra help with the formula

 

[shinigamilight]

D2: =IFERROR(INDEX(Master!$D$2:$D$4,MATCH(A2&B2&C2,Master!$A$2:$A$4&Master!$B$2:$B$4&Master!$C$2:$C$4,0)),"")

 

[mark the excel novice]

Thanks so much. This was exactly what i needed. Appreciate all your time helping me here.