how can you view cells from different worksheets in to one sheet,.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,
I have multiple worksheets, more than 200 of them, and i wanted to summarize
some cells in to one sheet, I know how to do it by entering the code manually
(='7'!$D2), this shows cell d2 in sheet 7, but is there a function to do that
like drag or something?
 
You must log in or register to reply here.

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
How do i collate data from different sheets in one sheet? 8
Unlink cells- how? 0
Need to highlight cells in special order 0
Code to format cells on several worksheets 2
Need to merge worksheets - Excel 2003 0
SOS! how do I do multiple-value lookup in Excel 2007? 1
Referrences of multiple cells from one worksheet to another 3

Back
Top