jimrward
Well-known Member
- Joined
- Feb 24, 2003
- Messages
- 1,899
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
Ok, I have managed to get to a point with my 120k row data set and produce various PQ modules to extract the data I require, so this might be my last question for a while
The issue I have now is I want to summarise the data in the numerous tables produced on a summary sheet, all laid out on an A3 sheet so I can print it off. I will be going for a best fit to minimise the white space and group similar items together, hopefully this will be a once off manual process where the tables with a fairly static number of rows will be placed in one section and the more dynamic elsewhere on a page
How can I teach PQ to output to a summary sheet where I specify the range to occupy, every time I try to change the parameters in Load To.. it keeps defaulting back. I do I need to write some VBA to go to each table, and copy an paste the data to where I want it
The issue I have now is I want to summarise the data in the numerous tables produced on a summary sheet, all laid out on an A3 sheet so I can print it off. I will be going for a best fit to minimise the white space and group similar items together, hopefully this will be a once off manual process where the tables with a fairly static number of rows will be placed in one section and the more dynamic elsewhere on a page
How can I teach PQ to output to a summary sheet where I specify the range to occupy, every time I try to change the parameters in Load To.. it keeps defaulting back. I do I need to write some VBA to go to each table, and copy an paste the data to where I want it