Pivottable Macro (output)

mhenk

Well-known Member
Joined
Jun 13, 2005
Messages
591
Hey folks. Right now, I have a pivottable, 7 items in the data field, 8 in the page section, and 1 in the row section.

I would like to create a series of check boxes, one for each of the 7 items in the data field, and a button, that, when pressed, will copy and paste the values from the corresponding columns of the pivottable to a new worksheet, along with the values of the row section. Has anyone ever done something like this before? Anything that can point me in the right direction? ANything I can answer to clear it up?

TIA! :biggrin:
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

mhenk

Well-known Member
Joined
Jun 13, 2005
Messages
591
Code:
If chkEPR.Value = True Then
    Range("A11:A2000").Select
    Selection.Copy
Reup:
    Sheets("Output").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Application.CutCopyMode = False
    Selection.Clear
    Sheets("FIPS PT").Select
    Range("G11:G2000").Select
    Selection.Copy
    Sheets("Output").Select
    Range("G1").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
End If
Exit Sub

I'm getting an error message at the line Range("G1").Select.

Can someone explain why? Select Method of Range class failed.[/quote]
 

Forum statistics

Threads
1,141,626
Messages
5,707,489
Members
421,510
Latest member
haroonstr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top