Populating rows from a worksheet to a second worksheet
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
|