LinkBack URL
About LinkBacks
Hello,
I would like to bulk search for the list of items (in column B) in column A and replace them with an "X". Can someone please help design a macro? I have attached the spreadsheet. Sorry for a redundant thread.
Thanks in advance.
Hello,
I would like to bulk search for the list of items (in column B) in column A and replace them with an "X". Can someone please help design a macro? I have attached the spreadsheet. Sorry for a redundant thread.
Thanks in advance.
This should do.
Please Login or Register to view this content.
Hi,
Thanks for responding. I tried the macro and I get a Run-time error '429'.
Maybe:
Please Login or Register to view this content.
Last edited by JOHN H. DAVIS; 11-06-2015 at 11:17 AM.
This will do it - you will need to edit the sheet code name to match your project (highlighted in red).
Please Login or Register to view this content.
Last edited by GeneralDisarray; 11-06-2015 at 11:17 AM.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
Originally Posted by gcdr
Are you on Mac?MS-Off Ver
Excel 2003
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks