LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Create a report using multiple queries

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where can I learn how to create parameter queries in Excel? Mark Excel Discussion (Misc queries) 1 January 23rd 06 02:31 PM
Multiple queries Simon Shaw Excel Programming 1 April 7th 05 09:43 PM
Create List of Queries dave Excel Programming 1 January 14th 05 07:19 PM
simple workbook create/copy queries monika Excel Programming 1 April 8th 04 05:28 AM
Multiple Web Queries Andreww[_2_] Excel Programming 3 December 8th 03 10:46 PM


All times are GMT +1. The time now is 09:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"