Macros that can clear old data reference number data and pull the new reference up

Hi there,

Try the code below (update sheet name, table name and column header to your actual data/file;

Please Login or Register  to view this content.

Simply use autofilter to hide the processed entries. All you need to do is to assign a name to your table, for example Table1, and automatically run this tiny routine once a cell in the second column is filled:

Please Login or Register  to view this content.

Sample file here: Book1.xlsm. You can observe the code by right clicking on the tab and select View Code.
Compared with the solution in the previous post, I think this one is better if you want to review the processed entries.

Cheers