Previous Topic Next Topic

Copy data from multiple workbook in one new workbook.

Closed
Dev saini - Apr 5, 2017 at 05:01 AM
Hello,

I have 10 workbooks and have data on Sheet 2 with same Title from Column "B2:N2".
All workbooks are in one folder.
I want to create a mastersheet for all workbooks so i can get data from all workbooks in this mastersheet.
Data is store in Sheet 2 in all workbook.
Data Title is same so i want to collect all data in sheet 1 in Mastersheet.
when anybody add data in those workbook so data will copy in that master sheet.

Please tell me macro for that.

Regards
Dev Saini

Similar discussions

copy a row from one worksheet to another, based on criteria
wy -
vcoolio -

15 responses
Excel - A macro to create new workbook and copy data
Shridharb2002 -
TrowaD -

29 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
Copy Worksheet to another Workbook (unopened)
Josh -
Josh -

6 responses
Excel multiple functions in one cell
todd -
rizvisa1 -

1 response