ExcelBanter - Copy same range of data from all workbooks and paste into consolid

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Copy same range of data from all workbooks and paste into consolid (https://www.excelbanter.com/excel-programming/327319-re-copy-same-range-data-all-workbooks-paste-into-consolid.html)

Copy same range of data from all workbooks and paste into consolid

Jeff,

Take a look he

http://www.rondebruin.nl/copy3.htm

hth,

Doug

"JEFF" wrote in message
...
Hi All,

I'd like to be able to go to each workbook in a folder and copy the same
data range from each and paste into a consolidated workbook. For example,
go
to each workbook in Folder X, copy the contents in Sheet1 (range A1:A3),
and
paste into Consolidated.xls..... This implies that the contents copied
from
workbook A would go into row 1, the contents from workbook B would go into
row 2, and so on....

Any help would be greatly appreciated!