Request for better method to split a table into individual worksheets

[Amar Kapadia]

Hello:

I apologize if this has already been asked but I checked as much as I could
before posting. Also, if I am not sure where to post so please direct me if
I am posting in the wrong forum. Here is my request for a better solution:

Suppose I have a worksheet named Main which has a typical table (database)
with the fields listed in Row 1 and then the records listed below it. This
table (on Main) has been nicely formatted to our companies standards with
various column widths, colors, fonts, etc. One of the fields (Column N for
example) has one of 4 values (Southeast, Northeast, Central, West) for Team.
I need to make 4 new worksheets named (Southeast, Northeast, Central, West)
with look exactly like sheet Main (same formatting and look and feel) but
contain just their information. Currently, what I am doing is as follows:

Copy Worksheet Main
Rename it to Central
Autofilter my Table using Custom filter such as Column N <> "Central"
Delete all the rows
Take off the Autofilter
Great. Mission Accomplished. Now a worksheet named Cental looks just like
Main, but has just Central info.
Now I simply to this for each of the other teams.
Mission Accomplished.

My only question is there any feature of Excel that I am not using that may
make this process a little bit easier for me. I know the Pivot Table have a
Show Pages feature that kinda works they way I am looking for but I just
don't want to use Pivottables if I can help it.

Thanks in Advance. Any assistance would be greatly appreciated.

Amar

 

[Alan]

Try using the Auto Filter to get the necessary information displayed, then
highlight the whole sheet, copy it, then go to a blank worksheet and paste,
rename the new sheet,
Regards,
Alan.