Copying info from the same row in multiple tabs

rpikover

New Member
Joined
Nov 14, 2005
Messages
1
I am working with a workbook that has lets say 40 tabs in it. I want to create a summary tab. each of the 40 tabs are formatted identically and I need to extract info from the same exact cell from each sheet and put them in a row on the summary tab essentially creating a column with 40 rows of info. make sense? is there a way to do this?
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Hi:

Something like this might work....

If the sheets from which you want to sum A1-values are all re-named, then insert two new sheets and name them First and Last. Place all the relevant sheets between First and Last and use the formula...

=SUM(First:Last!A1)


plettieri
 

Watch MrExcel Video

Forum statistics

Threads
1,118,038
Messages
5,569,801
Members
412,293
Latest member
RJSCHILLER
Top