search for text in a file in a folder from an open file.
Posted on 2013-11-12
I need to search for a reference in a folder that has several tabs containing over 200,000 rows.
Is it possible with VBA code to look for the reference and if found enter Yes a cell on my open file.
So..... the file is in the path G:\Clients\Open Invoice\Open Invoice Documentation Database - UPDATED.xlsx
the file has 3 tabs: List1, List2, List3
My file [the one with the Macro] needs to look up the Reference that is in C5 and if it finds it in the above file in any of the Tabs return 'Yes' in my file cell J6 and if not found put 'No'
Previously I have been opening the file Open Invoice Documentation Database - UPDATED.xlsx and copying all 3 tabs onto a new sheet in my file and then doing a VLookup, but this seems to take forever.
Any help much appreciated.
I realise this could be a tricky one or even impossible.