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)
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)