Awesome pivot table help, works a treat, still interested in VBA code for learning purposes so I have attached sample data:
COCODE INDICATOR YEAR week 1 amount week 1 count
118 ALL 2006 -17953846.47 191
263 ALL 2006 -207425.23 55
267 ALL 2006 -21518.8 17
LE263 week 1 amount...
Hi
I get a data extract from a financial database for a couple of years at a time.
The data extract is exported into one excel worksheet. Each extract has many codes. Each code is broken down by 3 sub categories and financial years.
I want to copy the data in the extract and create worksheet...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.