Can I make multiple excel workbooks populate information to one main wrkbk real time?

U

Ufs102

To give you an idea of what I am trying to accomplish... I run a
mortgage company and I have about 16 loan officers I personally manage.
Currently each of them keep their own excel pipeline of loans in
progress in their personal folder on the server, of which I have to go
into each one to check on.

I can design the new pipelines however here is my main goal. I'd like
to create one large read only (to them) pipeline with all the loan
officers names in it, along with the appropriate info to the loan. I
would like to create personal pipelines for each of them to input their
data into. I would like that data to be moved into the main pipeline
and fill the appropriate fields. Basically I assume all of the design
is cake, but getting multiple workbooks to sync is the biggest key. It
really doesn't have to be real time, even some sort of script that would
update the information in the main pipe from everyone's personal pipes.

_*Does_anyone_know_how_snag_information_from_multiple_workbooks_and_populate_it_into_a_single_main_workbook_without_going_through_the_manual_exporting_information_stuff?*_

Thank you ahead of time!
 

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

Similar Threads

Real-Time Co-Authoring stops working 0
Excel pay service? 1
Copy range to multiple workbooks 2
summarizing data from various workbooks 4
How do I get one worksheet to update when others change? 1
AUTO-POPULATE WORKBOOK WHEN OTHER WORKBOOKS ARE CHANGED 0
Summarizing multiple workbooks to other multiple workbooks 0
Data from multiple workbooks 1

Top