Hi everyone
trying to produce a macro that can find and return cell references within the workbook for any value entered in a cell. Pretty much like the find and replace excel option but where results can be pasted on the active sheet.
Example:
Based on value on cell A1 (this would be my search field), I would like to find the cell address for every match in the workbook.
My workbook sheets are referenced as "Mysheets" as I have tried to use find and match to no avail.
My workbook can contain up to 100 sheets named 1 to 100 with a Summary sheet (which is not part of my sheet array).
I prefer not to use Excel option "Find and replace" as I then want to use the returned cell references to do some further work on a vlookup table.
Hope it makes sense.
Thanks
JSantos77
trying to produce a macro that can find and return cell references within the workbook for any value entered in a cell. Pretty much like the find and replace excel option but where results can be pasted on the active sheet.
Example:
Based on value on cell A1 (this would be my search field), I would like to find the cell address for every match in the workbook.
My workbook sheets are referenced as "Mysheets" as I have tried to use find and match to no avail.
My workbook can contain up to 100 sheets named 1 to 100 with a Summary sheet (which is not part of my sheet array).
I prefer not to use Excel option "Find and replace" as I then want to use the returned cell references to do some further work on a vlookup table.
Hope it makes sense.
Thanks
JSantos77
