ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Collating a set of separate excel files into a single worksheet or (https://www.excelbanter.com/excel-discussion-misc-queries/147380-collating-set-separate-excel-files-into-single-worksheet.html)

Andy

Collating a set of separate excel files into a single worksheet or
 
Hi,

I am a Maths teacher and have a set of self marking excel worksheets that
have been completed by students. What is the most efficient way of collating
their results?



Ron de Bruin

Collating a set of separate excel files into a single worksheet or
 
Hi andy

You can start here
http://www.rondebruin.nl/copy3.htm
If you not want to use code you can use the add-in


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Andy" wrote in message ...
Hi,

I am a Maths teacher and have a set of self marking excel worksheets that
have been completed by students. What is the most efficient way of collating
their results?




All times are GMT +1. The time now is 08:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com