Hi all
I have ripped a macro from the internet and tweaked it to do what I want but I'm wanting a few additional options that I'm a little hazy on how to do.
All the macros are doing are clearing data, open the first delivery note in a folder, look for specific text in one column of the delivery notes, If it is there copy the row, paste row into original workbook, close delivery notes, repeat with next delivery notes.
I wish to add after each row what PO it relates to (cell A18 on the Delivery notes) and the Delivery note number (cell F10 on the Delivery notes OR file name).
I also wish to search for multiple part numbers simultaneously and have one part number on one sheet and the next on another sheet.
See attached files for macro and workbooks.
Bookmarks