If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Summary from multiple sheets
Hi,
I have an excel sheet with mutiple work sheets. Each worksheet has some data (numbers) in column G. The number of enteries in each sheet is different (Sheet 1 has 7 enteries, Sheet 2 has 27, etc). I want to create a summary sheet in the same file which would list the names of the sheets one below another (Name of sheet 1 in A1, Name of sheet 2 in A2, etc) and also sum the total from column G in each sheet against the names of the sheet in the next column. Please help. Thanks |
Thread Tools | |
Display Modes | |
|
|