Alexandra has attended:
Excel VBA Intro Intermediate course
Microsoft excel
how do i design a pivot table?
RE: microsoft excel
Hi Alexandra
Thank you for your question.
Could you clarify whether you wish to design the pivot table using code, or manually with the pivot table wizard
Thanks
Stephen
RE: microsoft excel
Hi Stephen
I'd like to do it by code and use this code for different spreadhseets, so would I be able to copy and edit it when needed?
RE: microsoft excel
Hi Alexandra
Thanks for your update
Apologies for the delay. This was caused by a combination of health issues and onsite training.
You can build simple pivot tables using the code created on the VBA introduction course
To have it available for different files, I would suggest writing the code in a module in you personal macro workbook. If this is not visible in the VBE's project explorer, the simplest thing is to record a macro that is saved in the personal macro workbook. This will then make in available in the VBE.
If you need any guidance about more sophisticated pivot analyses please do not hesitate to get back to me
Regards
Stephen
