S
Smurrf
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
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