Query: Automatically transfer complete rows?
I have to set up some sort of budget management tool for my work place.
Because it's not me who's doing the data entry for this, I need to design it so that it's lazy-proof. Unfortunately, Access is not an option. Basically, here's what I'm trying to do: 1) Set up a Master worksheet, where every incoming order to the Supply officer has its own line. Columns for dates ordered, received, estimated and actual costs, a box for notes/modifications, and the actual order number and department receive their own boxes as well. 2) Set up multiple slaved worksheets that are identical to the first, except that only information pertaining to individual departments show up on each sheet. This information needs to be auto-filled from the Master page, without any other user-entry. (Basically, only the Master worksheet ever gets modified by hand, everything else is automated based upon entries in the Master.) 3) The slaved worksheets must be permanent entities, modifed automatically by entries made in Master, because I'll be setting up formulas in other cells linking budget numbers from the master and total costs from each department going back to the master. I have seen a couple of solutions that would work, but the problem was that they created new worksheets each time a button was pushed to update new information, and that's just not going to work. So, say I have the following (obviously, there's more to it; this is just a simplification): ____ Master Department.....Order#............Cost Management...MG001.............$45.00 Operations......OP001.............$37.50 Management...MG002.............$121.00 ____ I then want to be able to see the following two worksheets: ____ Operations Department.....Order#............Cost Operations......OP001.............$37.50 ____ Management Department.....Order#............Cost Management...MG001.............$45.00 Management...MG002.............$121.00 ______ Any help anyone can give me in this would be very greatly appreciated. Thanks |
Query: Automatically transfer complete rows?
Still looking for help from anyone who can assist; thanks.
|
All times are GMT +1. The time now is 10:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com