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.
My VBA skills are basic and therefore not sure where to start. Any hints/tips would be great or code would be great.
Thanks for your help!
My VBA skills are basic and therefore not sure where to start. Any hints/tips would be great or code would be great.
Thanks for your help!