• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filtering data based on the value (dynamic) in a cell

M

Mandar

New Member
I've created a dropdown list, I want to create a filter in a column which filters the data based on the selection in the dropdown list or a cell. The cell value or list value keeps on changing based on selection the filter should respond with the changes in selection.


Kindly help.
 
Hi Mandar,


I think you can create another table that filters list according to your drop down selection. That too will need formulas to be copied down the column. Is that OK??


Regads,
 
Thanks but I'm looking out for coding affecting changes in the filtered data as soon as the selection in dropdown list changes. Else I'll have to create separate macros for each selection which will be too lenghty. If we can have some code say like :


Selection.AutoFilter

ActiveSheet.Range("$B$11:$AN$2500").AutoFilter Field:=5, Criteria1:= (this refers to a cell whose value changes as per selection in the dropdown list or simply, changes the Criteria on making changes in the dropdown list)


If you can suggest me on this.


regards

Mandar
 
I'm looking out for coding affecting changes in the filtered data as soon as the selection in dropdown list changes. Else I'll have to create separate macros for each selection which will be too lenghty. If we can have some code say like :


Selection.AutoFilter

ActiveSheet.Range("$B$11:$AN$2500").AutoFilter Field:=5, Criteria1:= (this refers to a cell whose value changes as per selection in the dropdown list or simply, changes the Criteria on making changes in the dropdown list)
 
Hi, Mandar!

I don't fully understand your requirement. Would you please elaborate a bit more and consider uploading a sample file (including manual examples of desired output)? It'd be very useful for those who read this and might be able to help you. Thank you.

Give a look at the second green sticky post at this forums main page for uploading guidelines.

Regards!
 
You must log in or register to reply here.
Back
Top