Hello, and Thank you in Advanced for your reply's.
I am trying to compare two sheets of data to find differences between them,
Below are screen shots of each the sheets of the serial numbers from the equipment we rent, the names have been removed for security.
Below is a screenshot of the data we receive from our provider
RAWImage.png
And this is the data that we exported from our system.. much neater
ManImage.png
eXAMPLE.xlsx
So my Goal is to be able to compare between the two, in laymans terms I would like the data from sheet2 to pull data from sheet1 and display it next to the serial.
Like say Sheet2D4 Cell does a check on its contents and looks at sheet1 to see if it exist and reply with the copy of the serial,
If you also know a way to make Sheet1s data be alot more presentable without having to manually move the cells that would be awesome.
Any information would be appreciated, Merry Christmas and have a good day.
Bookmarks