How to create a macro to pull data from one sheet to another based on cell information

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.

I want the macro to put the info into sheet two.

Background: I have the sheet linked to an online spreadsheet. Everytime the spreadsheet is opened, it populates whatever data is in the spreadsheet online.

So no one will be entering or altering the data in this spreadsheet.

I want it copy pasted. leaving the general sheet having ALL the info, and a new sheet opens with only the data containing the criteria (i.e. Government) in the practice group (I) column. \

Does this answer your question?

Ultimately I will take the macros and make buttons for each one, so when the user opens the file it will be a sheet with buttons, and when they click which info they want it will take them to that new sheet. I don't need the codes for that (At least I think I should be able to do it) I'm just lost on how to get this particular macro to work.

All in one macro would be great, but I don't know if it's needed. As far as the other sheets being cleared and re-populated, that's fine.

Apologies if I'm not being clear enough.

I don't want/need the sheets to already exist when the file is opened.

If possible, Id like for when the sheet is opened there are two sheets existing. 1. Splash page (containing the buttons that will navigate user) 2. the main page containing all info pulled from online.

For instance, if user clicks the "Government" button, I want a new sheet, "sheet 3" to be created with the rows of info that contain Government, in column (I) Practice Groups.

I just need the code for the macro to do this. I will then take the macro, link it to a button and thats that .. I think?!?!

Now when the user goes back to home (splash) screen andclicks another button, say " Corporate/Securities" for instance then a new sheet will activate with the info for that.

Would sheets 1 - 15 or how many ever dif. choices I have already have to exist or can the code just create a new sheet?

So is this possible?

It should only be displayed on the new sheet while retaining it in the main sheet.

Thanks sooo much.

I am going to try it out and see how it works. Please give me a few hours as Im swamped at work. Just wanted to let you know I'll respond a little later on.
Thanks.

Your problem can also be solved successfully through Pivot Tables and
hyperlink.
I will help you, if required.

Sorry about that.

As far as the sheets. My "main" sheet is named Main, as you have it in your code. The government sheet does pop up once I hit the button, but there is nothing that populates the sheet, not even the headers.

For some reason the code still isnt working.

I found out how to create the proper pivot tables I need for each factor. Is there a macro I can create that creats the pivot table when I run it.?

Advanced Filter?

Yes I am getting a error code 9.

Thank you for all of your help btw.