View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
OceanSS OceanSS is offline
external usenet poster
 
Posts: 2
Default Copy Cells from multiple Worksheets in same workbook.

I have a work book with mutiple worksheets and would like to create a summary
worksheet of certain cells within the other worksheets. I now I can copy and
past each cell, but is there a quicker way? For example I would like to copy
celsl sheet1!C15 through sheet10!C15 into individual cells in the summary
worksheet