Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieven data from closed workbooks - Ron de Bruin
I am using Ron's code to retrieve data from closed workbooks.
The code works wonderful but I need to transpose the output on the destination book because I am copying a complete column from each workbook and I want to have the name of the book as the title. Instead of e.g. Range1 Book1 Range2 Book2 Range3 Book3 I need it: Book1................ Book2 ................. Book3 Range1(ColumnC) Range2(ColumnC) Range3(ColumnC) ETC. Thanks in advance for the help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Data from Closed Workbooks | Excel Worksheet Functions | |||
Retrieven data from closed workbooks - Ron de Bruin | Excel Programming | |||
Retrieve Data from closed workbooks - Ron de Bruin | Excel Programming | |||
Retrieve Data from closed workbooks - Ron de Bruin | Excel Programming | |||
get data from closed workbooks! | Excel Programming |