Copy entire row to new sheet based on keywords
The government sends out spreadsheets with every project from government departments (http://smallbusiness.data.gov select data feeds FY2010 any department) This massive file needs to be filtered down to something I can use. How do I filter by selected keywords and copy entire row to new sheet? Doing it manually is tedious, a macro would be most helpful. Thanks!
Have you used the Data > filter > AutoFilter before? It's just the ticket for you. You can apply two keyword filters at once to a single column if you wanted making it breezy to see and grab all the rows that match all at once.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Awesome, Thanks
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks