Bernard
thanks for the filter advice, I will try that.
However, in every shop that I have worked, multiple spreadsheets in a master
spreadsheet are called "tabs". That is just the way it is. the whole file
is called a "spreadsheet", and each individual page is a "tab". The only
place that you find tabs called "worksheets" is in the documentation.
Thanks
Joe

"Bernard Liengme" wrote:

Have you thought of using Data | Filter | AutoFilter?
Then you can have the data on one sheet but with a click of the mouse
display just category A, or B, or Z
Might impress the boss

Tell him/her it is poor data management to have the same data in two places.

BTW: please talk about "worksheets" - "tabs" are the thingies (that's a tech
term) for the itty-bitty things you click to open a worksheet. Knowing the
correct terminology improves communication with other users and, most
importantly, enable you to use Help better.

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Joe" wrote in message
...
I am looking for a function that will break up a spreadsheet into separate
tabs, using a field. I dont know how much time I have wasted when
management
wants "all category A in one tab, all category B in the next tab, and so
on
thru category Z." It is all the same spreadsheet, with each category in a
separate tabbed sheet. So I spend hours cutting and pasting. Then, there
is
some small change in the input data spreadsheet, so I have to start all
over
again.