Create Rows in a new sheet from 2 other sheets

[Nomas]

Hi All,

Here is my need/scenario


There are 3 sheets

Sheet 1
Sheet 2
Sheet 3

Sheet 1 is a variable data input sheet that has a variable data set in a fixed range from A2:W100

Sheet 2 is a Carbon Copy of Sheet 1 that is made upon opening Excel

here is what I need

I need Sheet 3 to only populate the full row from sheet 1 that have any cell value that has changed on Sheet 1 when checked vs sheet 2 (Sheet 3 will have Sheet 1 values only).

Thanks in advance for any help

 

[CaseyP]

if i am reading this correctly, a simple IF <> formula may work here,

quick question, will the data always be the same cell range for all three sheets?

 

[Nomas]

Yes the data sets are fixed in size

Sheet 1 and two will start out the same, if no changes then sheet 3 would not populate anything. If Row 12 on Sheet 1 is modified then it would appear on as the top row in sheet three with the same data from sheet 1. But what I am also looking for is that the rows on sheet 3 will not hold formulas leading to a larger than necessary file. So in the case above with row 12 on sheet 1 populating row 1 on sheet 3, if no other data was moved then row 2 on sheet 3 would be blank (not holding a formula). Basically sheet 3 grows down as sheets 1 and 2 dont match up in the check.