| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Select same range from large number of workbooks
I would like to find a method for extracting the same column from a large
number of indentically formatted Excel workbooks. I would like to line up the extracted columns next to one another on a workbook. How can I do this? Thanks! Bill |
|
#2
|
|||
|
|||
|
Hi Bill
Try this http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "BillC" wrote in message ... I would like to find a method for extracting the same column from a large number of indentically formatted Excel workbooks. I would like to line up the extracted columns next to one another on a workbook. How can I do this? Thanks! Bill |
|
#3
|
|||
|
|||
|
Ron,
This link is excellent. The macro for copying columns worked right out of the box. Great link btw. "Ron de Bruin" wrote: Hi Bill Try this http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "BillC" wrote in message ... I would like to find a method for extracting the same column from a large number of indentically formatted Excel workbooks. I would like to line up the extracted columns next to one another on a workbook. How can I do this? Thanks! Bill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I cannot select a range | Excel Discussion (Misc queries) | |||
| Select a range | Excel Discussion (Misc queries) | |||
| How to add one number to a range of numbers | Excel Worksheet Functions | |||
| Not enough memory for large workbooks | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
