Transfering large data to new worksheet

[kayboom]

I have a large spredsheet of date i need to extract information out of. What i want to do is isolate sertain data and create a new spread sheet on a new page with the same headers as the origial. Every week i will receive new data to add to the original spread sheet that will then need to be extracted to the new sheets. Ive done this years ago but cant seem to put my finger on what formulas to use. Any help would be greatly appreciated. Thank you.

 

[Trevor G]

Take a look at using a Filter and then copy the data to a new sheet if you want to automate it, then record a macro to add the filter and then copy to a new sheet. That would give you the basic code for what you might need.

 

[kayboom]

Thank you Trever....it was exactly what i needed. I really appreciate ur help!