ExcelBanter - collate

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - collate (https://www.excelbanter.com/excel-worksheet-functions/203860-collate.html)

bubbly_silk

collate

How do I collate several spreadsheets into one worksheet?

ryguy7272

collate

This will do what you want:
http://www.rondebruin.nl/copy2.htm

Post back if you have any questions.

Regards,
Ryan---

--
RyGuy

"bubbly_silk" wrote:

How do I collate several spreadsheets into one worksheet?

Ashish Mathur[_2_]

collate

Hi,

You ay also want to read up on Data Consolidate in Excel;s help menu

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"bubbly_silk" wrote in message
...
How do I collate several spreadsheets into one worksheet?

All times are GMT +1. The time now is 02:45 AM.