analyzing cell data in first three columns of sheet 1 to accurately update sheet 3

[samsonitewayoff]

Hello again,

This is my step 2 of a previous thread.Step1

I would like to take the newly updated data from sheet 1, analyze the first 3 columns of cell data for discrepancies between it and sheet 3's first 3 columns of cell data, if none are seen, I'd like the last 4 columns (adjacent cell data to the first 3 columns cell data) on sheet 3 to be updated with the new data from sheet 1. If there are any discrepancies between sheet1's first 3 columns and sheet3's first 3 matching columns of cell data, add a new row on sheet 3 and populate new cell data from sheet 1 (columns A-H).

Before this takes place though, I need sheet 3 copied entirely and pasted into sheet 2.

I've attached a sample sheet for better understanding.

Any help would be grand!

Thanks in advance,
Seth

[dilipandey]

Hi Seth,


As you have sheet names as Update, yesterday and Today in your workbook, would be better if you provide your briefing basis these names as I am not able to find which one should be sheet 3 and sheet 1... thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[samsonitewayoff]

Hi Seth,


As you have sheet names as Update, yesterday and Today in your workbook, would be better if you provide your briefing basis these names as I am not able to find which one should be sheet 3 and sheet 1... thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Sorry for the misinformation, the sheets are in order 1,2,3. So Update = sheet1, Yesterday = sheet2, and Today = sheet3

[dilipandey]

Hi Seth,

See the attached file with instructions.. thanks.

sampleInventory.xlsm

Regards,
DILIPandey

<click on below 'star' if this helps>