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
Bookmarks