98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA importing files from various worksheets and workbooks into o
VBA importing files from various worksheets and workbooks into o
Resolved · Medium Priority · Version 2010
Fri 5 Dec 2014, 17:38Delegate Zainab said...
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!
Sun 7 Dec 2014, 11:36Trainer Jens said...
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
Attached files...
DecJanMay.xlsx
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Checking formulas with multiple operatorsWhen dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right: |
