R
Roxy
I would like to copy an existing worksheet and paste it. Using the default
naming of example "Earned Income Method 1" and when copied "Earned Income
Method 1 (2)". When this is pasted I would like a row to be inserted into
the master worksheet "Family Totals" and the total from cell H38 in "Earned
Income Method 1 (2)" to carry over into the "Family Totals" worksheet into a
new cell B4.
Could someone please help me?
This is what I was using before
Private Sub Workbook_NewSheet(ByVal Sh As Object)
Worksheets("Family Totals").Rows(4).Insert
Worksheets("Family Totals").Cells(4, 1).Value = Sh.Name
End Sub
however instead of new sheet being inserted I want users to be able to
copy/move the sheet then paste and have the new total carry forward to the
master worksheet.
naming of example "Earned Income Method 1" and when copied "Earned Income
Method 1 (2)". When this is pasted I would like a row to be inserted into
the master worksheet "Family Totals" and the total from cell H38 in "Earned
Income Method 1 (2)" to carry over into the "Family Totals" worksheet into a
new cell B4.
Could someone please help me?
This is what I was using before
Private Sub Workbook_NewSheet(ByVal Sh As Object)
Worksheets("Family Totals").Rows(4).Insert
Worksheets("Family Totals").Cells(4, 1).Value = Sh.Name
End Sub
however instead of new sheet being inserted I want users to be able to
copy/move the sheet then paste and have the new total carry forward to the
master worksheet.