I'd like a macro that would search cell content for 'abc' in multiple sheets and then copy the found content to a new sheet?
I'd like a macro that would search cell content for 'abc' in multiple sheets and then copy the found content to a new sheet?
Can there be more than one occurrence of "abc" in each sheet? Do you want to search all sheets or just some of the sheets? If just some sheets, what are their names? Where in the new sheet do you want to paste each found value and what is the name of the new sheet?
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Please Login or Register to view this content.
"ThankyouFor Attention * And Your Help!!"
Using dictionary
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks