compare and compile nonblank data from seperate workbooks in an au
Assuming this is not a situation where you can simply share the master sheet,
I can think of one other possibility. Export the data from each returned
sheet to a text file, using FileSaveAs. Read each file from a macro
function, integrating the data into your master sheet.
" wrote:
Hello,
I am trying to simplify compiling of data from different users. Here
is the situation: A single master sheet is sent out to 5 different
regions. In this master sheet are hundreds and sometimes thousands of
shipping lanes. To simplify these lanes have an predetermined id
number, an origin, and a destination and a blank origin charge and
destination charge. If either the origin or destination resides in
that region, they fill in the appropriate charge and send back the
file.
|