I recorded a macro and successfully came up with this: However, two of the file names change daily to reflect the date.. So I am not sure if this will work tomm when the file's name has been changed.
Any help is appreciated. Thank you.. I am basically opening up files off a shared drive and copying the values into a given spreadsheet..if there is a simpler process than the below to achieve it that would be great. But it works fine as of n
Please Login or Register to view this content.
Bookmarks