Summary sheet for multiple worksheets
 

Hi

This is my first post on here so please bare with me.

I have produced a worksheet for staff to enter details of the hard and
software they use. I need to pull their replies into 2 summary sheets
(hardware and software). I know where that data is in each worksheet (i.e.
B5, B9, B10 etc). I have over 110 worksheets to collate at present but this
will increase.

Is there any script that could be used to collate this?

Thanks for any help that can be given

John

Summary sheet for multiple worksheets
 

Hi JohnnieBoy

I have over 110 worksheets
Workbooks ?

Try
http://www.rondebruin.nl/summary2.htm


For worksheets see
http://www.rondebruin.nl/summary.htm


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



"JohnnieBoy" wrote in message ...
Hi

This is my first post on here so please bare with me.

I have produced a worksheet for staff to enter details of the hard and
software they use. I need to pull their replies into 2 summary sheets
(hardware and software). I know where that data is in each worksheet (i.e.
B5, B9, B10 etc). I have over 110 worksheets to collate at present but this
will increase.

Is there any script that could be used to collate this?

Thanks for any help that can be given

John