Link to home
Start Free TrialLog in
Avatar of F Patel
F Patel

asked on

Excel VBA - to combine data of multiple worksheets from multiple workbooks

Hello All,

I have workbook A, B, C, D etc in a folder...
each workbook has four sheets... sheet 1, sheet2 etc.

I want to combine the data from sheet1 of all workbooks into sheet1 of master workbook (which already exists) and similarly sheet2 etc.

The workbooks are from different users... they all have same headings.

Your help will be much appreciated.
Avatar of Mike in IT
Mike in IT
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of F Patel
F Patel


Thank you Mike

What is the purpose of .range (). value?
To what line are you referring to?

When you are specifying a range it can be a single cell or multiple cells. The ".value" is just looking at the value(s) of the cell(s) specified by what it is attached to whether that is a Renge() object or a Cells() object.
Avatar of Tracy
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: Mike in IT (https:#a42440363)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

Experts-Exchange Cleanup Volunteer