View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mister_Paul_K Mister_Paul_K is offline
external usenet poster
 
Posts: 1
Default Multiple blocks (double column lists) turned into drop down list

I'm not sure how to explain the situation without missing out on the little
details... Anyhow, I have the following:

5 Blocks. A block in my definition here would be a two column list which
includes cells merged somewhere in the center. The five double-column so
called lists that I have, also have special formatting and blanks between
rows and they are of different lengths. Let's say List number 1, has 90 rows
and list number 2 has 120 rows but all have double columns and special
formatting that can not be erased not to mention at least one cells' merger
somewhere in the center.

What I need:

I need to make a button that'll pop those lists. These are part of another
bigger application. The application is tarrifs' selection. And each "block"
applies to a certain type of clients, but other details in the application
like Name, Address, Comments, Approval status, etc... apply to all clients. I
do have a heading name for each tarrif plan but I'm tight on losing any
formatting from each block.

If anyone needs any extra information I'll be more than willing to provide
it so you can provide me with the answer I'm looking for.

Many thanks,

Paul