Copy Cells from multiple Worksheets in same workbook.

  • Thread starter Thread starter OceanSS
  • Start date Start date
O

OceanSS

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
 
Back
Top