kevinchurchill
New Member
- Joined
- Jul 20, 2015
- Messages
- 26
Hello everyone,
I need some help, im looking for a vba script that can loop through one specific folder and all of its subfolders located on a local network, in each of the subfolders there will be one or several .XLSM files,
in each file there will be a tab named DATA with a range from A1:K1, this range i would like to copy from each file that is contained within all the subfolders.
I then need to paste each range to a seperate file in another network location with each range copied then pasted on the next available line in my master data sheet
but in the cell K1 i would like to anchor a Hyperlink to the original file where the range was copied from.
Then finaly each time I open my master data sheet I would like the VBA script to update all the data ranges copied and add any new files that have arrived during the week on the next available line.
I know this is a big ask and for me impossible to do but for you experts maybe it's more easy than it sounds in writing, Thank you so much for your help.
I need some help, im looking for a vba script that can loop through one specific folder and all of its subfolders located on a local network, in each of the subfolders there will be one or several .XLSM files,
in each file there will be a tab named DATA with a range from A1:K1, this range i would like to copy from each file that is contained within all the subfolders.
I then need to paste each range to a seperate file in another network location with each range copied then pasted on the next available line in my master data sheet
but in the cell K1 i would like to anchor a Hyperlink to the original file where the range was copied from.
Then finaly each time I open my master data sheet I would like the VBA script to update all the data ranges copied and add any new files that have arrived during the week on the next available line.
I know this is a big ask and for me impossible to do but for you experts maybe it's more easy than it sounds in writing, Thank you so much for your help.
