how to create combined summary worksheet

  • Thread starter Thread starter ccampbel
  • Start date Start date
C

ccampbel

Hello,

I want to take all of the data from several worksheets
within the same workbook and create a summary worksheet
with all the data so that when I update the data on one
worksheet, it is propigated to the summary worksheet.
Can't figure out how to do this.

Suggestions?

Thanks!
 
ccampbel said:
Hello,

I want to take all of the data from several worksheets
within the same workbook and create a summary worksheet
with all the data so that when I update the data on one
worksheet, it is propigated to the summary worksheet.
Can't figure out how to do this.

Suggestions?

Thanks!
Click to expand...

Do you mean that you want (for example) A1 on the summary sheet to be the
sum of cells A1 on all the other sheets?
If so, you create formulas on the summary sheet such as
=SUM(Sheet1:Sheet9!A1)
 
Right click on the excel logo just to the left of file>view code>insert
this.
Modify to suit and save workbook

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If ActiveSheet.Name <> "Sheet1" Then
x = Sheets("sheet1").Cells(65536, "a").End(xlUp).Row + 1
Target.EntireRow.Copy Sheets("sheet1").Cells(x, 1)
End If
End Sub
 
Hi,

No, I want to take 10 worksheets of data, multiple columns
and rows in each worksheet, and essentially copy that data
to one single worksheet. That single worksheet would then
contain ALL data from all the other worksheets. I want
this to be a "live" worksheet so that if I make a change
on any of the 10 other sheets, the data on the "summary"
worksheet will reflect the change.

Thanks for your help!
 
Did you try it? What it will do is copy the entire row from the active sheet
(if NOT Sheet 1) to the next available row in column A of sheet Sheet 1.
This will happen whenever you change a cell in the whatever the active sheet
is.
So, if you type 11223 in any cell and that row has something in col a, the
row will be copied to sheet1.
 
Back
Top