| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Copy and paste subtotals-complex data range error | Excel Discussion (Misc queries) | |||
| copy and paste range of cells excluding hidden data in excel | Excel Discussion (Misc queries) | |||
| Copy same range of data from all workbooks and paste into consolid | Excel Programming | |||
| Copy/paste range variable between workbooks | Excel Programming | |||
Linear Mode
