I have 3 Excel files that have in the column B the comments:
check. Column C contains the product numbers of the products that are either ok or need to be checked. I want to create a list (an overview) in another Excel file (4) of all the products that have the word "check" in column B in the other three Excel files (1,2,3).
I cannot use a pivot table in the three excels because it has to be refreshed manually. Filter is also not an option. I would like to use VBA/Macros in Excel.Excel 1
Status Product number check 1254968 ok 5541485 check 2153654 ok 4588999 ok 8954668 ok 6945665 check 7469968 check 6665448
Status Product number ok 7455561 ok 5145684 ok 4589666 check 4896471 check 1117347 check 5656478 ok 5256488
Status Product number ok 3389741 check 6754889 check 1489798 ok 6489646
Products to check 1254968 2153654 7469968 6665448 4896471 1117347 5656478 6754889 1489798
I expect to have a list with all the product numbers that need to be checked in my 4th. Excel.