Hi, i need a search macro, to search in multiple xlsx files.
I will have a xlsx file for every product that i have.
The xlsx file will be named after product reference.
Example
references:
3042 (3042.xlsx)
1578/2 (1578/2.xlsx)
188A (188A.xlsx)
413689 (413689.xlsx)
103 (103.xlsx)
...etc.
each xlsx file will have the same head table, only some info will be different.
head table:
nr crt...references...info1...info2...info3...info4...info5....
1.........188A...........x..........x.......x.........x........x....
Then, i will have a master wbook with search macro, and i need this macro to search after references and to display the content of that file.
Can this be done?
Thanks!
I will have a xlsx file for every product that i have.
The xlsx file will be named after product reference.
Example
references:
3042 (3042.xlsx)
1578/2 (1578/2.xlsx)
188A (188A.xlsx)
413689 (413689.xlsx)
103 (103.xlsx)
...etc.
each xlsx file will have the same head table, only some info will be different.
head table:
nr crt...references...info1...info2...info3...info4...info5....
1.........188A...........x..........x.......x.........x........x....
Then, i will have a master wbook with search macro, and i need this macro to search after references and to display the content of that file.
Can this be done?
Thanks!
