B
bdiff
I generate reports by combining 4 queries into a worksheet. I listed them
Q1, Q2, Q3 & Q4 by using the 'insert entire rows for new data, clear unused
cells'. The number of records by each query changes. I'm left with empty
rows, records overlapping, and old data left over from a previous report each
time a generate a new report.
I wish to automate the process by selecting the parameter, clearing the old
data, combine the four queries into one list, sort two columns and print.
Q1, Q2, Q3 & Q4 by using the 'insert entire rows for new data, clear unused
cells'. The number of records by each query changes. I'm left with empty
rows, records overlapping, and old data left over from a previous report each
time a generate a new report.
I wish to automate the process by selecting the parameter, clearing the old
data, combine the four queries into one list, sort two columns and print.