You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Excel MVP Michael Alexander wanted to share one VBA-free method that he uses to combine multiple Excel worksheets into one data set.
Ahh, the classic story. Boy gets job. Boy becomes the department data collector. Boy meets 25 Admins who send him a spreadsheet every week. Boy copies and pastes into one workbook. Boy lights himself on fire. Combining multiple Excel worksheets into one data table is such a common task, I would bet a pound of bacon that most of us have been through that ordeal once or twice. The good news is that you can just scour the internet, and you'll probably find dozens of techniques for combining multiple Excel files together. Here's one simple way you can leverage Access to combine multiple Excel files (without VBA).
Ahh, the classic story. Boy gets job. Boy becomes the department data collector. Boy meets 25 Admins who send him a spreadsheet every week. Boy copies and pastes into one workbook. Boy lights himself on fire.
Combining multiple Excel worksheets into one data table is such a common task, I would bet a pound of bacon that most of us have been through that ordeal once or twice.
The good news is that you can just scour the internet, and you'll probably find dozens of techniques for combining multiple Excel files together.
Here's one simple way you can leverage Access to combine multiple Excel files (without VBA).
Click over to Michael’s Excel and Access blog for more information about this method.
Comments: (1) Collapse
Mike's great and has a sequel: datapigtechnologies.com/.../using-access-to-combine-multiple-excel-files-method-2
Comments: (loading) Collapse