(I'm very, very new to VBA, so sorry for my ignorance)
I have to do a pacing report every week for our sales. I have pivot tables set up to pace our current sales for the week against last week, and the same week last year.
Currently, for example, to update the pivot tables I go to the wizard and drag the data field corresponding to last week's date and put in the data field corresponding to this week's date.
I'd like to avoid the wizard and incorporate these steps into a program to do the pivot tables in addition to several other steps I need to do.
I have a form with a list box to select the dates. How can I use the values from the listbox to put the corresponding field in the data box? (Or if you have a better idea, I am definitely open to suggestions.)
A huge Thank You in advance for any tips!
I have to do a pacing report every week for our sales. I have pivot tables set up to pace our current sales for the week against last week, and the same week last year.
Currently, for example, to update the pivot tables I go to the wizard and drag the data field corresponding to last week's date and put in the data field corresponding to this week's date.
I'd like to avoid the wizard and incorporate these steps into a program to do the pivot tables in addition to several other steps I need to do.
I have a form with a list box to select the dates. How can I use the values from the listbox to put the corresponding field in the data box? (Or if you have a better idea, I am definitely open to suggestions.)
A huge Thank You in advance for any tips!
