Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
distributed sheet model
I need to have the following basic interaction with different pieces of data,
and am hoping to not have to go the Access route: 1) several reps that input data onto a pretty simple sheet, where they are taking customer order data, and then "logging" that order onto a running list (small macro to take the line that has the data they enter, and put it into the list below, expanding the named range of the list). 2) the running list from each of the rep sheets then goes into a consolidated list of all orders 3) that consolidated list updates to other folks, who perform steps along the process of that order Catch is that the consolidated order sheet will be diffcult to have running all the time. Therefore I'm stuck trying to figure out how to get information pushed into that sheet, so that the folks that need to draw from that list to fill their own task lists have an updated file from which to update (hope that makes sense...central file pulls from the reps, and individual process folks pull from central). If it were always open, it could just automatically update from the rep files. But if it's closed, the end-process folks can choose updates when opening their file, but is it possible to get the central file to open itself and update from the rep files? Would greatly appreciate any creative suggestions. Thx. -- Boris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Geeting Sheet background from Excel object model | Excel Discussion (Misc queries) | |||
Justify distributed? | Excel Discussion (Misc queries) | |||
Distributed Addins | Excel Programming | |||
Distributed retrival | Excel Worksheet Functions | |||
Distributed Spreadsheets | Excel Programming |