Populating rows from a worksheet to a second worksheet
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 |
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 |
Populating rows from a worksheet to a second worksheet
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? |
All times are GMT +1. The time now is 06:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com