Hi all,

I have a daily task that I do for work that I was wondering could be made more efficient through use of a macro. Currently I have a spreadsheet which I have set up to format reports to a way in which is useful to me on a daily basis - I simply have to copy and paste the new report into the macro based workbook, run the macro and its good to go. I was wondering if there was a way to get a macro to run this copy+paste function for me.

Basically the files which I copy + paste are saved into a new destination folder every day - I would like the macro to create a popup box for me asking me where the folders are (or if there was another way), and then copy specific files into specific sheets in the macro based workbook.

any help is appreciated - I'm very new to VBA and I think this is out of my scope of limited understanding.

Thanks
Gavin