View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JohnnieBoy JohnnieBoy is offline
external usenet poster
 
Posts: 2
Default 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