ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multiple blocks (double column lists) turned into drop down list (https://www.excelbanter.com/excel-discussion-misc-queries/137228-multiple-blocks-double-column-lists-turned-into-drop-down-list.html)

Mister_Paul_K

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


All times are GMT +1. The time now is 08:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com