I have two sheets in Excel that both contain data and would like to merge data.

[waldz]

Hi Guys,

I have two sheets in Excel that both contain data.

Both pages have a unique column which is labeled 'ItemNumber'. This runs from 100000 through to 106144. Apart from this column, both sheets have different columns with different data. I would consider the 'ItemNumber' to be the unique identifier of the row.

I would like to create another sheet that brings in and merges all the data from both sheet.

How would I do this? I guess it would be some sort of merge? Hoping someone can point me in the right direction!

(sorry if I'm not as clear as I could be)

 

[hiker95]

waldz,

Fishing trip? Wow, sounds fantastic - Enjoy!

We had a wonderful time. Great food, lots of exercise, did not see or catch any trout, and, the best part was the time spent with my son, one on one.

You've been a great help, it appears to work beautifully.

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.