simple task with macro, but not catching right spots

I recorded a macro and set it to use relative ref. ,but it seams to be using exact addresses. I want to use the macro on several sheets, so I don't think I want the sheet name in the macro. See attached.  Thanks.
Who is Participating?
Patrick MatthewsConnect With a Mentor Commented:

If what you really want to do is make the row labels repeat in the PivotTable, this can be done without a macro if you are using Excel 2010 or later.  If you right-click in the row labels area and select Field Settings, go to the Layout & Print tab on the Field Settings dialog.  Check the box for Repeat Item Labels.

If that is not what you wanted, or if you are using Excel 2007 or earlier, then please post the code you recorded (or re-post the file as an xlsm), as Thomas suggested.


<aside to Thomas: :) >
You need to load as an xlsm file if you want us to see the macro. Or you can post the code.

Patrick MatthewsCommented:
Be nice to this guy, he's family :)
Come on Patrick, did I go zorvek on him?

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.