Input to Master and Have Multiple Slaves Each Sort That Data Differently

**AmeriKen** · 11-11-2009, 08:55 AM

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

**Richard Buttrey** · 11-11-2009, 09:47 AM

Hi,

From your description I suggest you use a macro in each slave document which sorts the data in the way you want.

Place that in a Sub at Module level, then Call that Sub from the slave's Workbook_Open event. Then each time the sub is opened it will be in the right order.

You could also if necessary add a line of code to the Master's auto updating macro to call the Slave's Sort macro, although that's only necessary if you want to see the Slave sorted correctly immediately you've populated it.

HTH

**AmeriKen** · 11-11-2009, 10:07 AM

Thanks, Richard.

The Slaves will likely be open constantly by at least one individual (and certainly on (constant) display on the 42" lcd monitor in the conference room). So I would certainly want to add a line of code to the Master's auto updating macro to call the Slaves' Sort macros so that the Slaves would re-sort immediately as they're re-populated with new Master data entries/changes.

Sadly, however, most of your reply is Greek to me. I'll plug your syntax into Google and see if it responds with some Macros For Dummies suggestions.

In any case, thanks for your reply. At the very least, I know that it is doable.

Is there any chance that I can contract you services to affect the suggested solution(s)?

Ken