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.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
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!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks