Ok I would like to know if it is possible to fill in 1 excel document with 2 completely separate excel documents.
about the 2 documents
Both documents will be called the say the only difference is the date on the end in the format YYYY-DD-MM
Document 1 will be "todays"
Document 2 will be "yesterdays"
the 2 document are created everyday and placed on a network drive, is possible to put the collated excel document in a folder above the folder in which the dynamic files will be in.
I hope this is enough info for someone to go on let me know if this makes no sense and I'll try again if some one is able to do this please contact me asap
Thanks
TT
about the 2 documents
Both documents will be called the say the only difference is the date on the end in the format YYYY-DD-MM
Document 1 will be "todays"
Document 2 will be "yesterdays"
the 2 document are created everyday and placed on a network drive, is possible to put the collated excel document in a folder above the folder in which the dynamic files will be in.
I hope this is enough info for someone to go on let me know if this makes no sense and I'll try again if some one is able to do this please contact me asap
Thanks
TT
