View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Cell Capture Multiple WorkSheets?

Excel2003 ... I have approx 90 WorkSheets ... Cell D6 of each worksheet
contains a value I wish to capture in a single worksheet Col. I can select
each cell & then select Cell D6 of the applicable worksheet, but I will have
to do this 90 times ... & I have other Values I need to capture same way.

Sooo ... is there a "Magic" way to do this?

Thanks ... Kha