Summary Question

G

Guest

I have several sheets(75) in one workbook. One of the sheets is a summary worksheet which contains data from an identical cell in each of the 74 worksheets. The summary worksheet has 74 different cells for each worksheet. Is there a fast way to put each worksheet cell into each of the 74 cells in the summary sheet.
 
F

Frank Kabel

Hi
have you a list of your 75 sheets in one column adjacent to the target
cell or is there a logic in the naming of theses sheets?. If yes using
INDIRECT could do what you want. So please provide some more details
:)
 

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

Excel Count If Formula Question 1
Copy/Paste Question 3
worksheet cross reference 6
formulae in excel worksheets 4
Excel lookup across entire workbook 1
Copy Cells from multiple Worksheets in same workbook. 2
link few worksheets in one summary sheet 1
lookup and populate with adjacent contents 2

Top