I've put this together to assist backup of multiple workbook data to defined locations. There is no error checking to ensure that files etc. exist, and it is not comprehensive with PasteSpecial options (easily added)
Feedback welcome.
Regards
MD
I've put this together to assist backup of multiple workbook data to defined locations. There is no error checking to ensure that files etc. exist, and it is not comprehensive with PasteSpecial options (easily added)
Feedback welcome.
Regards
MD
Last edited by mdmackillop; 07-20-2008 at 08:22 AM. Reason: Attachment updated as Post #3
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'