Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lists in excel
Good morning First,English is not my language.Then, I make an apology for my mistakes. Here's my excel project vba. I have a table and I want to create some lists. In fact, I want one list for each filter. If I have five filters, I want to print five lists. It is just an example. The number of the filters can be high: 50,etc...I don't know beforehand this number.The other difficult is that I want to put my filter in different columns. For example,I have a filter in the first column. I will have five lists. After, I put a filter in the third column and I will have three other lists.The result is eight lists. I have used the recorder: Selection.AutoFilter Field:=1, Criteria1:="My first filter" Selection.AutoFilter Field:=1, Criteria1:="My second filter" ........ And I begin again with my third column. But, if the number of filters is high, it's too long. How can I put all filters in my code without write them one by one? I want to print all my lists in one time. Thanking you in advances for your help -- Raiby ------------------------------------------------------------------------ Raiby's Profile: http://www.excelforum.com/member.php...o&userid=37755 View this thread: http://www.excelforum.com/showthread...hreadid=573382 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists from multiple source lists | Excel Worksheet Functions | |||
LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
lists from other lists in excel | Excel Worksheet Functions | |||
Form lists influencing other lists | Excel Programming |