Johsua has attended:
Excel Advanced course
Macro Recording
If I wished to get a Macro to perform a repeated action, such as within a workbook I wish it to Update the data in all the Pivot Tables in sequence, how do I script it to not end until all tables have been modified, and also how does one get it to realise where all the Pivot tables are in the workbook. Also is this the same process for Office programs such as Powerpoint and Access, or are they scripted in a different maner?
RE: Macro Recording
Hi Joshua
Thanks for your post.
Visual Basic for Applications (VBA) can be written to work with all MS Office applications (2003 or earlier, in 2007, not PowerPoint), with coding being the same except for slight modification depending on the which application you are working in.
By the brief you have we may be able to assist with consultancy.
3 steps to organising consultancy
1) email us some examples of your work, and list your key objectives). we will then profile & review your requirements
2) We will then send you a proposal
- Scope of work
- Timeframes
- Pricing
3) Sign our consultancy agreement
If you wish to progress this then please let us know.
Regards
Jacob
