Keep row at the end of pivot table

[ShaliniGomes]

Hi,

I don't know exactly how to do this. In pivot table1 for "Date" I want to find the row with the word Target 1 and move the entire row to the end of the pivot table.

How can I do this with VBA?


Thanks in advance

[nathansav]

I am not sure, i dont think it is.

[ShaliniGomes]

Is there another way to keep the row with Target 1 always at the end of pivot table?

[nathansav]

You could have an array formula type affair on a separate sheet just taking a direct link, but changing for the last row.

Is it definately in need of a pivot?

[ShaliniGomes]

Yea it has to be in a pivot table. I'm not sure how I am meant to execute your suggestion...

[nathansav]

I think it is,

Please Login or Register  to view this content.

basically that 4 is the pivotitems count, so i'd have a play with that.

[ShaliniGomes]

Thanks, what can I do if pivot table is always dynamic and it adds a new row each day?

[nathansav]

Still use the pivotitems count, this will be as dynamic as the report is.

[ShaliniGomes]

Okay thanks so much Nathan :-). I will try it when I get to work tomorrow

[nathansav]

Not a problem, refresh the pivot table before you take the count, so you can be certain its correct

[ShaliniGomes]

its not working

Please Login or Register  to view this content.

Everytime I add a new item it adds a new row even though I have specified to only have 22 items. If I could get code to find "Target 1" in col B and move it down one, then that will do the trick.

Any ideas?

[nathansav]

Can you attach an example please? "Target 1" or "1 Target"

[nathansav]

Please Login or Register  to view this content.

This works fine for me.