Zainab has attended:
Excel Intermediate course
Excel Advanced course
VBA importing files from various worksheets and workbooks into o
Hi
How do I import data from various workbooks and worksheets into one worksheet. I need to match the data to specific headings in the destination worksheet. For example:
workbook1 has worksheets June and August data
workbook2 has worksheets July, September and October data
workbook3 has worksheet May
I need to import the above data into one worksheet but in the following order:
May, June, July, August, September and October.
Help!
RE: VBA importing files from various worksheets and workbooks in
Hi Zianab,
Thank you for the forum question.
I have attached 3 workbooks to the answer.
One destination workbook with a destination worksheet and a criteria sheet and two source workbooks. Create a folder and put the two source workbooks in the folder (do not put the destination workbook in the same folder). Run the macro in the destination workbook.
If you look at the macro I have added some explanation.
I hope this will guide you in the right direction.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
DecJanMay.xlsx
