Query: Automatically transfer complete rows?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top