Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

pivot tables

ResolvedVersion 2003

Raj has attended:
Excel Intermediate course
Excel Advanced course

Pivot Tables

Can Pivot tables be programmed via a macro?

RE: Pivot Tables

Hi Raj,


Thank you for your question regarding Pivot Tables.


Yes, PivotTables can be programmed via a macro. We cover this in detail in the Excel VBA course.

Below is a link to the course outline

https://www.stl-training.co.uk/excel-vba-2007.php


I hope this resolves your question. If it has, please mark this question as resolved.


If you require further assistance, please reply to this post.


Kind Regards,


Nafeesa

Microsoft Office Specialist Trainer

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Fri 13 Aug 2010: Automatically marked as resolved.

Excel tip:

Autofit column width – Excel (all versions)

a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Excel to automatically set the column width to fit the contents of the column (autofit)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.