Hello,

So I have a list of items that need to be constantly added to a list for auditing purposes. Problem is, the item names constantly change and also on occasion, new items are added.

Essentially, I am trying to write a script (very unsuccessfully) that will grab the data in sheet2 and pass it to sheet1. Seems simple via vlookup, however,
I am to go one step further and add a new column with every run of the macro. Not only that, but I also would like to add a new row if there is, in any way, a different value on sheet2 when passing to sheet1.

i.e.

Sheet 1
--------
Apple 1
orange 5 6
pear 7 8
car 2
fox 10
bananna 12
apple 4

Sheet 2
--------
car 2
apple 4
orange 6
pear 8
fox 10
bananna 12

Hopefully my example above will make sense of what I am trying to achieve.

Thanks.