I am trying to use Excel to build a register of work orders based on the work
requests. I have the work requests listed on a worksheet and they come in
three categories.

I want Excel to create three spreadsheets one for each category and for
Excel to polulate the correct worksheet as each new work request is added.

Is this possible?

--
Thanks for your help
Jeff L

You would need a macro that wouldn't be too hard to write. I would recommend
running a macro manually. You will also need a mtthod to make sure the same
entry didn't get moved to the individual category sheets twice.

"Jeff L" wrote:

I am trying to use Excel to build a register of work orders based on the work
requests. I have the work requests listed on a worksheet and they come in
three categories.

I want Excel to create three spreadsheets one for each category and for
Excel to polulate the correct worksheet as each new work request is added.

Is this possible?

--
Thanks for your help
Jeff L

Try this sample from my archives ..

A relatively simple, fast, non-array formulas solution
which achieves exactly what you seek:
http://www.savefile.com/files/430142
AutoCopy Lines to Resp Sht Non Array.xls
(Full details inside, nicely rendered. Easy to adapt ..)

Data is continuously entered in a master ("parent") sheet.
Lines will be neatly auto-copied to each individual ("child") sheet
based on the values within a key column
(All results will appear neatly packed at the top in each child sheet)

In your case, that key column will be
where you have your 3 categories listed, eg: Cat1, Cat2, etc

Rejoice? Celebrate it here, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Jeff L" wrote:
I am trying to use Excel to build a register of work orders based on the work
requests. I have the work requests listed on a worksheet and they come in
three categories.

I want Excel to create three spreadsheets one for each category and for
Excel to populate the correct worksheet as each new work request is added.

Is this possible?