Copy Cells from One Worksheet to Another

boldcode · Aug 24, 2011

Hello Everyone,

KEY INFORMATION that should be used in VBA code:

The two worksheets that I am using are:
Worksheet 1 Name: DoNotUseInvestmentRpt (Cells are copied from this worksheet)
Worksheet 2 Name: rptInvestment (Cells are pasted into this worksheet from worksheet "DoNotUseInvestmentRpt")

The two Pivot Fields that are being used in both worksheets are:
DoNotUseInvestmentRpt : Investment
rptInvestment: Investment

In both worksheets the Subtotal Label for the Pivot Field “Investment” that is produced automatically by the pivot table is:
Investment Total

 An EXPLANATION of what I am looking to do:

Desired Sub Procedure Name: Sub CopyCellsUnderInvest()

- After the Subtotal Row "Investment Total" in my pivot table worksheet “DoNotUseInvestmentRpt”:

-SELECT all the cells that come after this “Investment Total” Subtotal Row (which some cells will be blank because of the Pivot Table Grouping Feature) until the last cell with data in the last row and column:

For Example: Range (“A: …..to whatever the last cell with data in the last row and column is

-Then COPY these cells to my pivot table worksheet “rptInvestment” and PASTE them after the “Investment Total” Subtotal Row in my pivot table worksheet “rptInvestment”

boldcode · Aug 24, 2011

I started to create this code, but I still can't figure it out:

Code:

Sub CopyCellsUnderInvest()
    With Sheets("DoNotUseInvestment")
        .Range.Copy - HERE IS WHERE I CAN'T FIGURE OUT
    End With
    With Sheets("rptInvestment")
        -HERE IS WHERE I ALSO CAN'T FIGURE OUT - .Range.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
            False, Transpose:=False
    End With
End Sub

boldcode · Aug 25, 2011

Solved: Copy Cells from One Worksheet to Another

I figure it out. Thanks everyone.

Copy Cells from One Worksheet to Another

boldcode

Active Member

Excel Facts

boldcode

Active Member

boldcode

Active Member

Similar threads

Forum statistics

Share this page

Copy Cells from One Worksheet to Another

boldcode

Active Member

Excel Facts

boldcode

Active Member

boldcode

Active Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock