Using VBA to combine data from 2 sheets using a common number.

[ZeroTrinder]

Good Afternoon All!

I have been searching for a while for a solution to this problem but I am still having issues (I don't think I am using the correct search terms!).

Basically I have 2 sheets that need combining,

"Sanding Report"
This contains a date and time in Column A, an ID number in B, a Sand location in C.

"Sheet1"
This contains an ID number in A (which is the common data), a diagram ID in B, ID code in C, Location in D and Location arrival time and date in E.

Basically I am trying to get a 3rd sheet created called "Sanding Overview" which has:

ID number in A, the sanding report sand location in B, sanding report date and time in C, Diagram ID in D, ID Code in E, Sheet1 Location in F and Location arrival time in G.

Something like this:

I would be running this with new data every day so ideally I need the "Sanding Report" and "Sheet1" to be deleted after and the "Sanding Overview" to be sorted by "Unit" and "Date and time" with the option to filter by end location (but all of that is just a dream at the moment, the initial hurdle is the biggest issue!)

If anyone can help it would be very much appreciated!

Thank you for you time,

Zero

 

[alansidman]

@ZeroTrinder
It is common forum courtesy to acknowledge all helpers and advise whether their solutions work for you or not. A good way to have your requests ignored in the future is to ignore people who have tried to help you.