ExcelBanter - Different workbooks to one worksheet

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Different workbooks to one worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/101656-different-workbooks-one-worksheet.html)

Jan

Different workbooks to one worksheet

Is it possible to merge several workbooks into one worksheet? And how can
that be accomplished? I've seen code where it could separate worksheets into
workbooks and wanted to know if there's a way to reverse that process.
Thanks.
--
Jan

Ron de Bruin

Different workbooks to one worksheet

Look here Jan
http://www.rondebruin.nl/copy3.htm

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

"Jan" wrote in message ...
Is it possible to merge several workbooks into one worksheet? And how can
that be accomplished? I've seen code where it could separate worksheets into
workbooks and wanted to know if there's a way to reverse that process.
Thanks.
--
Jan

Jan

Different workbooks to one worksheet

Thanks Ron!
--
Jan

"Ron de Bruin" wrote:

Look here Jan
http://www.rondebruin.nl/copy3.htm

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

"Jan" wrote in message ...
Is it possible to merge several workbooks into one worksheet? And how can
that be accomplished? I've seen code where it could separate worksheets into
workbooks and wanted to know if there's a way to reverse that process.
Thanks.
--
Jan

All times are GMT +1. The time now is 06:21 AM.