Control break report
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Control break report

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Please help me figure out this one. I am trying to create a report using SQL dump data as a text file coming into excel.
    i have 7 columns
    sorted by column A,B C ascending
    Column A has regional info EAST west North South
    Column B has 3 categories TEST, Production, no activity
    column c has names of the providers
    then column d,e,f,g has information related to providers.

    Now i want a report so that
    Column A ie East west north south comes on heading and column B becomes sub heading and all the providers within B are listed under it and all other information pertaining to them comes in the other columns.

    ie it shud look like

    North regions:
    --------------------------
    Providers in test
    a provider addr a addra zipa codea
    b provider addr b addrb zipb codeb
    c provider
    subtotal:
    Provider in production
    a
    b
    c
    subtotal
    Total :

    East region:
    Provider in test
    a
    b
    c
    subtotal
    provider in prod
    a
    b
    c
    subtotal
    totals
    Grand totals:

    Is it possible in excel
    Thanks







  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Anyone Knows even if it can be done?

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com