HI,
I have a table with lots of data. In column 1 I have "week" in column 2 I have "name".
On a new sheet i would like to return al the rows (every week) based on the "name" i Select from a dropdown.
Can someone help me please?
Thnx in advance
HI,
I have a table with lots of data. In column 1 I have "week" in column 2 I have "name".
On a new sheet i would like to return al the rows (every week) based on the "name" i Select from a dropdown.
Can someone help me please?
Thnx in advance
Take a look at my attachment in Post #4 of this thread:
http://www.excelforum.com/excel-form...ml#post3973305
It is very similar to what you want to do.
Hope this helps.
Pete
exactly what i need.
But how did u create this dropdown?
It is not a form control or a activex?
It's a Data Validation drop-down, using the list of depts that I created on the other sheet.
Pete
Ok, found it. --> Data Validation --> list
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks