Create a report using multiple queries

Discussion in 'Microsoft Excel Programming' started by Guest, May 4, 2006.

  1. Guest

    Guest Guest

    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.
     
    Guest, May 4, 2006
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bart E

    Multiple queries using *.dqy files

    Bart E, Aug 29, 2003, in forum: Microsoft Excel Programming
    Replies:
    0
    Views:
    492
    Bart E
    Aug 29, 2003
  2. monika

    simple workbook create/copy queries

    monika, Apr 7, 2004, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    232
    Bill Renaud
    Apr 8, 2004
  3. dave

    Create List of Queries

    dave, Jan 14, 2005, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    162
    Rob van Gelder
    Jan 14, 2005
  4. Guest

    Using a macro to create a report on another worksheet

    Guest, Apr 13, 2007, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    146
    Allen Lance
    Apr 13, 2007
  5. Scott_goddard

    Create multiple dropdown list for multiple colums; select more tha

    Scott_goddard, Mar 12, 2009, in forum: Microsoft Excel Programming
    Replies:
    0
    Views:
    163
    Scott_goddard
    Mar 12, 2009
Loading...

Share This Page