Our company sells engineered products which, by nature, can get fairly expensive. We issue official proposals to potential customers in response to their RFQ's. Our engineering effort (to design the requested product for subsequent price-out by our accounting/finance department) is often quite arduous. This proposal effort changes hands numerous times throughout the proposal-creation process (from salesman to engineering back to salesman to customer back to salesman, etc.) with individual names and Action-Due Dates assigned to each said change-of-hands.

We want to insure that "things" don't start slipping through the proverbial crack (missed action dates, etc.).

Sorry for the lengthy description of the problem I'm trying to solve.

Throughout the proposal-creation process, one pieces of information may be critical to some people (e.g., Next Action-Due Date) and another piece of info critical to others (e.g., Proposal Due Date ... or maybe Estimated Proposal Value).

What I'd like to do is this:
1. Have a Master (source) Spreadsheet on which I record each newly-issued Proposal Number, Customer Name, Sales Rep, Product Line, Est Value, Next Action-Due Date, Proposal Due Date, etc., etc., etc. I would be the only person with access to that Master. That Master Spreadsheet already exists.

2. Have multiple Slave (destination) Spreadsheets that automatically upload data as entries are made in the Master. That, of course, isn't a problem and I already have one Slave ... and the auto-update of that Slave works just fine.

3. But I want to have at least 3 Slaves, each of which has its auto-uploaded data (from the Master) sorted on different columns. And as each new row of proposal data is inputted to the Master (and auto-uploaded to each of these 3 sorted Slaves), I want that new row of data automatically sorted within each of those 3 Slaves. I don't want to have to re-sort each Slave after new data in uploaded from the Master ... which is what I have to do now.

I am currently not using Visual Basic syntax because what I've tried so far tends to resort the Master as well as the Slave. I want the Master to be a purely chronological-entry screen (by Proposal Number). All the auto-sorting should be done in the Slaves only.

Can anybody help?

Thanks!

kacker@rpsct.com