Darren has attended:
Excel VBA Intro Intermediate course
Issue re ManufacturerReport pivot data analysis
Simon,
re 'Delegate Training File Darren' you have copied, the pivot analysis for ManufacturerReport is adding the data as count rather than sum. Can't understand why this is the case when the exact coding for SalesPersonReport is correctly adding pivot analysis by sum. Could you please assist? Thanks, Darren.
RE: Issue re ManufacturerReport pivot data analysis
Hi Darren,
I am sorry I haven't replied earlier but I have been training solidly.
However, I am looking at the problem and when I find the rogue lines of code I will email you.
Regards
Simon
RE: Issue re ManufacturerReport pivot data analysis
Hi Darren,
Sorry for the delay in responding.
I have been over the code a number of times and cannot see where the problem line is.
I am sorry I couldn't answer the query.
Regards
Simon