ThrottleWorks
Excel Ninja
Hi,
I have one excel file. In column A, I have values such as ABC1200, DEF1300 etc.
I have a folder, this folder has multiple excel files. File names will be XYZ-ABC1200, UJM-DEF1300.
For example, cell A1 value is ABC1200, the macro should copy this value, go to folder.
Search this value, and open the file XYZ-ABC1200.
At present I am doing it manually, copy the cell value, go to the folder.
Paste in search bar, check the search results and open the correct file.
I tried searching on Google, but I am getting results for matching exact cell value with file name.
My problem is, I can not match exact, I have to check contains.
Can anyone help me in this please.
I have one excel file. In column A, I have values such as ABC1200, DEF1300 etc.
I have a folder, this folder has multiple excel files. File names will be XYZ-ABC1200, UJM-DEF1300.
For example, cell A1 value is ABC1200, the macro should copy this value, go to folder.
Search this value, and open the file XYZ-ABC1200.
At present I am doing it manually, copy the cell value, go to the folder.
Paste in search bar, check the search results and open the correct file.
I tried searching on Google, but I am getting results for matching exact cell value with file name.
My problem is, I can not match exact, I have to check contains.
Can anyone help me in this please.