View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kim
 
Posts: n/a
Default How do I pick the same cell in sheet 1!, Sheet2! and just drag

I am trying to list from 100s of sheets a number so I go to lets say F10 on
sheet 2 (sheet2!f10), (sheet3!f10), (sheet4!f10). How can I drag and copy so
sheets change?