Forum

But how to sort /group the date in pivot table chronologically ??

Thanks Sunny got it ... Have a ncie weekend..

Thansk Sunny the idea, it helps a lot. Will try tweak the macro you so generous offer a little to suit for the Bank System upload.

Sorry forget attachment

Thanks millions Ken! Honestly we learn a lot from this forum!

Ken, If you don't mind can you upload the Worksheet with the VB for our reference , of course all sensitive or cret data to be covered-up or t...

Cannot run the VB, prompt syntax error Pls try store to a worksheet and run to see if problem can be fixed

I tried it works perfectly, tks Sunny.

I think many agreed in the Forum, your methodology to tackle the problem is compresensive enough to Excel users... Make life a lot easier ...

After a bit modificaion to incorporate the formula you set up, finally did work out well in the Report template, our deep thanks to you Sunny again.

Thank Sunny wil give it a try, to see if work ..

Because we must use the format designated by Headoffice, pivot table format NOT accepted So what we want is to insert the Code Net balance from the...