Rayne
asked on
Excel column to add as filter
Hello All,
I have tried to add a new column to the table -[info]
I just want to add an extra layer of filter to the copied information. I have included a checkbox [onTeam] on the first sheet. The moment I click on that checkbox (onTeam) – it throws an object mismatch error. Please help and suggest any changes needed to ensure I properly add the extra column and then filter the data with that extra column as filter criteria by correctly updating the VBA code as well. I even expanded the criteriaRange to the new filter but the error persists
Thank You
R
newFilterColumn.xlsm
I have tried to add a new column to the table -[info]
I just want to add an extra layer of filter to the copied information. I have included a checkbox [onTeam] on the first sheet. The moment I click on that checkbox (onTeam) – it throws an object mismatch error. Please help and suggest any changes needed to ensure I properly add the extra column and then filter the data with that extra column as filter criteria by correctly updating the VBA code as well. I even expanded the criteriaRange to the new filter but the error persists
Thank You
R
newFilterColumn.xlsm
ASKER
Hello Stephen,
The goal is that when I click on the onTeam checkbox it filters the data that has only onTeam in the corresponding column. When I click the checkbox, it should put a 1 in the truth table (X4) which the filter then uses to organize/update the data accordingly…
The goal is that when I click on the onTeam checkbox it filters the data that has only onTeam in the corresponding column. When I click the checkbox, it should put a 1 in the truth table (X4) which the filter then uses to organize/update the data accordingly…
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, it does work now, Thank you!!!! Stephen, greatly appreciate you help :)
ASKER
Quick and awesome help
Set rChange = [info_Range].Cells(Right(s
strTmp is "onTeam", and Cells(m,2) has no meaning. I'm not sure what you're trying to achieve - can you elaborate?