Retrieven data from closed workbooks - Ron de Bruin

M

Myriam

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro: selecting ranges from list of names 2
Using ranges with Visual Basic, stuck... 6
How to Refer to Another Excel Workbook 1
How to validate path? --- bValidatePath ("") Then 7
Sending mail from Excel with CDO by Ron de Bruin 4
RON DE BRUIN Merge data from all workbooks in a folder HELP 1
copy to closed workbook on a different drive 3
how do import data from two sheets into one 2

Top