Hello-
I am creating a workbook where I have columns : First Name ; Last Name ; City; State ; Availability; Resume Sent to... ; Practice Group; Industry ; Additional Specialties ; Profile written? ; IFM complete?; Skyped or met?; Paperwork signed? ; References complete? ; Permission to market resume? ; Permission to use photo? ; Video introduction complete?
I would like to be able to create a macro that pulls the entries that have specific data in the practice group column (i.e Government ; Corporate/Securities; etc.) to another worksheet. And I want the headers in row 1 to go as well.
I have a little knowledge on code, but Im stuck.
If someone could give me the code to work for just rows with "Government" in the practice group column (I) to to be copied to another sheet and open that sheet when the macro is run. I should be able to switch the different names where needed to make a macro for each one.
Any help is well appreciated. Thanks guys.
Bookmarks