Hi, I'm trying to create a pivot table but without success. It's a very simple pivot which should group on a field called NAME and then sum the values. I first tried to record a macro and then use that code but that didnt work so I've "assembled" some code that almost works but not quite. Here's the code
If I take out the last line of code the pivot table creates but without a data field. When I put the last line in I get a syntax error which, for the life of me, I can't figure out....very frustrating... I'd appreciate any help...even if it means going back to scratchPlease Login or Register to view this content.
Many thanks
Bookmarks