Search worksheet based on mutliple cell values on another sheet.

Hi all,

I have a work book with two sheets that has data from different departments. This data is the daily production figures for a mining fleet. Page 1 has all the data from the operator logs, page 2 has the tonnes produced from the engineering department. Both parties export to this book then reports can be made.

In each sheet there six columns with the same data but in different order. I need to use sheet 1, row 1 and the six column values to look through the data in the sheet 2 for the row with the same values then copy the last column value of that row to sheet 1 row 1. Then loop it to do the same for each row in sheet 1.


Copy of tempdb (2).xlsm



I have tried a buch of codes from this site but can't get it working. Looking forward to see what you can come up with. I need to do it with vba as when the data is exported in from the various departments it clears any formulas on each page.

Added button to database sheet. See if this is what your after? See attached file.

Please Login or Register  to view this content.