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