xlstudent1
New Member
- Joined
- Sep 2, 2014
- Messages
- 1
I am looking for a way to search the entire worksheet of multiple spreadsheets within a single folder for values greater than 100. If cells values of greater than 100 are found, then these will be listed in a worksheet/tab with file directory, worksheet name, cell address, cell value, and hyperlink to that cell.
I have been able to find the code below which was very helpful for searching for a particular text strings. However, it is values (I think they are integers!?) that I need to search for (that are greater than 100).
My VBA skills are basic and therefore not sure where to start. Any hints/tips would be great or a modification of the code below would be fantastic.
Thanks for your help!
http://www.get-digital-help.com/2014/01/08/search-all-workbooks-in-a-folder/
I have been able to find the code below which was very helpful for searching for a particular text strings. However, it is values (I think they are integers!?) that I need to search for (that are greater than 100).
My VBA skills are basic and therefore not sure where to start. Any hints/tips would be great or a modification of the code below would be fantastic.
Thanks for your help!
http://www.get-digital-help.com/2014/01/08/search-all-workbooks-in-a-folder/