I recorded a macro to make a few pivot tables. My goal is have a table at the top of a sheet, and create several pivot tables underneath using that data as a source.
My problems are that the sources of the data refer to the original. In the first code below, how do i make the source be the active sheet, and the entire set of data starting at A1? Same thing with the second code.
Thanks for any help. 


Please Login or Register  to view this content.
Please Login or Register  to view this content.