Hi,
I have 42 excel files with 2 tabs of multiple columns each. All layouts and column titles are the same.
Every workbook was sent to me "shared", which has created several limitations. I can unshare a file when it is opened and get back full capabilities, but I don't know how to do this when it is not opened... if this is even possible.
There is no possibility of getting these files in unshared status from the original sender.
I need to add many rows of data (both tabs) from every file into one master file. Copy-Paste is taking too long.
I'm not a novice, but definitely not superadvanced. Anyone out there who can help with a non-VBA solution please?
Thank you!!!
I have 42 excel files with 2 tabs of multiple columns each. All layouts and column titles are the same.
Every workbook was sent to me "shared", which has created several limitations. I can unshare a file when it is opened and get back full capabilities, but I don't know how to do this when it is not opened... if this is even possible.
There is no possibility of getting these files in unshared status from the original sender.
I need to add many rows of data (both tabs) from every file into one master file. Copy-Paste is taking too long.
I'm not a novice, but definitely not superadvanced. Anyone out there who can help with a non-VBA solution please?
Thank you!!!
