Hi
I have a file that I would like to open using VBA and then copy column a, then paste into my worksheet column d to update it
The file I want to open is in a shared file and there is a choice of week to select
eg.
the macro would follow the file path and then prompt to choose the required week file, then when the week file is selected it will open and copy column A and paste into column D of my worksheet then close the selected week file
Any help appreciated
Bookmarks