Use the macro recorder: Use Excel's FIND function to find the name, copy and paste it elsewhere. Save the macro and post the workbook so someone can help you witha Find.Next loop.
(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)- Click Advanced next to Quick Post button at the bottom right of the editor box.
- Scroll down until you see "Manage Attachments",
- Click the "Choose" button at the upper left (upload from your computer).
- Select your file, click "open", click "upload"
- Once the upload is completed the file name will appear below the input boxes in this window.
- Close the Attachment Manager window.
- Click "Submit Reply"
Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!
Bookmarks