ExcelBanter - Retrieve Data from closed workbooks

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

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

- - Retrieve Data from closed workbooks - Ron de Bruin (https://www.excelbanter.com/excel-programming/310614-re-retrieve-data-closed-workbooks-ron-de-bruin.html)

Ron de Bruin

Retrieve Data from closed workbooks - Ron de Bruin

See your other thread

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Myriam" wrote in message ...
I am using Ron's code to retrieve data from closed workbooks.
How can I transpose the output in the destination workbook?

e.g., Data1 Book 1
Data2 Book 2

All times are GMT +1. The time now is 12:30 PM.