LinkBack URL
About LinkBacks
Dear All,
I have a workbook with multiple sheets , final sheet has a data of all sheets , in the first sheet i want to select what results to be shown in that final sheet ,, specially the week and the LDM
Below image calrfying more
excel iss3.png
Want to select Filter Results from another sheet
Dear All,
I have a workbook wi
Below image calrfying more
excel iss3.png
Any help please?
Responding to your own post removes it from the list of Unanswered Threads.
I'd highly recommend you attach an example of your actual workbook. Not a lot of users are going to want to recreate your workbook from scratch when you have one readily available. Save a copy with sensitive information removed and upload it.
Filtering of one tab from another via cell entry is going to involve some VB worksheet change events.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Done , on http://www.excelforum.com/excel-form...ml#post3748185Originally Posted by daffodil11
How are you selecting them? Dropdown menu? User entry?
drop down is better if it is possible
Am writing the code now
I used a INDEX(..SMALL(IF(MATCH to pull unique words to the ValidationList tab to create the dropdowns.
Then, I used a Worksheet_Change macro on your first page to kick off filtering based on those ranges and words on your last page.
If you change the dropdown to the starting position, it will clear the filter as well.
You will need to update the array formulas on ValidationList tab to include your actual ranges, as well as in the VB code.
Please Login or Register to view this content.
I did another thing if you could check
I set a code for a command button to check the cells and make the filter upon it
The problem is that:
I can't select an option for select all
I want to make a multi option select ( check dropdown list ) to check more than week at once
Kindly advice what is better , your sol or mine
and advice how i can change upon my requiremnts now ??
but so far ,, BIG THANK U
Kindly check attached
Test values.xlsx
If you don't save your workbook as .XLSM you lose all of the coding.
There is no code or macros in the book you just attached.
oky , check attached,
I did solved first request , now , if it is blank it will select all , but the other thing is to select more that value , i can't do it so far
Kindly check attached
Test values.xlsm
Hey Friend,
Did u found out a way to select more than week or more than LDM ? a list like the autofiliter list , a dropdown with selection
I do not know of any way to make multiple selections with a dropdown list. You may wish to open a new thread with that as the subject.
However, if you want will select multiple values via a filter and text, you can type names in beginning at J7 and include as many as you want and this macro can do it.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks