Copy Cells from multiple Worksheets in same workbook.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

link few worksheets in one summary sheet 1
Require formula to search across multiple worksheets 2
Copy data from unlocked cells 3
Copy absolute formulas 1
Copy/Paste Question 3
Formulae Ref Different Worksheets 1
Linking multiple worksheets in one workbook 2
Referrences of multiple cells from one worksheet to another 3

Top