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!
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!