On a daily basis, I need to look up a series of different orders against a master report to check current statuses. I've tried Power Pivot, but run into problems where the data isn't properly indexed as it contains duplicate values.

As a workaround I've recorded this macro to xlookup the Order and Order Line on my tracker spreadsheet against the daily master spreadsheet. Once the value is obtained, I copy and pastevalue the result before moving onto the next cell in the row. Once the row is complete, the macro takes me to the start of the next line. I'm using pastevalue is to prevent the spreadsheet from being bloated with lots of XLOOKUP formulas.

Ideally I'd like to run the macro continuously until it encounters END as well as to ignore empty cells but move onto the next row to continue. Does anyone have any suggestions please ?

Please Login or Register  to view this content.