Hello. I'm using Excel 2002 on a PC.
I'll keep this as brief as possible.
I want to move the contents of a folder [containing various filetypes] to another folder, based on user input.
i.e.
On C: drive I have folders called day1, day2, day3
On D drive I have folders called archive1, archive2, archive3
So I want the user to be posed the question 'Which day to move?'. In this case if the user input '1' the files would be moved from day1 to archive1.
All the folders in question already exist. Ideally this could move the contents of more than one folder at a time i.e. if the user input '1' the contents of folders day1 and night1 would be moved.
Any help will be greatly appreciated, and thanks in advance.
Bookmarks