ExcelForum.xlsxI need a macro to find all text "Taco" in Column A , B , C, D.
Taco should then be copied in the same row it is found but to Column G.
I am new to Macros and really would love some help on figuring this one out. There are currently 26,331.
Thank you so much for your help.
Last edited by westsoldman; 11-11-2012 at 03:25 PM. Reason: Add spreadsheet
Probably i can't help you with your question.
But you get better help if you add an excel file, without confidentional information.
Please also add the desired result in your file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Here is the Spreadsheet. Thanks for responding. I am wanting to search for Tacos in columns A,B,C,D and put tacos in column G. I will then go through and Search for Burger and do the same. I will do this for about 15 items so it would be great if I could get a macro as there are almost 27,000 menu items I have at this point. I really could use some help if any body has time to help.
Thanks
Give this a try
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Mike!
sSearchTerm = "Taco" should be Tacos
AB33,
I looked at post one and it said Taco, either way it will find both.
Re your PM
Try this
Please Login or Register to view this content.
Or you can try this one with a box to input searchword.
Its Mikes solution but with a seach box to find the word.Please Login or Register to view this content.
God Luck
Abjac
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks