Hi All, iam new to VBA ,
thankfully using Chandoo sir's one of the VBA codes,which is great ,
but need some changes for my requirement.
There was an artilce with below in Chandoo sir's website : I downloaded that workbook ,
Quickly filter a table by combination of selected cell values using VBA ,
Iam using this macro , but need some changes in it,
the filter is applied for the selected cells in the same sheet ,
What i need is : out of many columns(may be 40 my requirement), lets say i take 5 columns in another sheet , and after removing duplciates ( 1 col may have 10, another may have 50 cells of data etc ) ,
Now i make selection in this unique list table, filter should be applied/reflected to the main table which is in another sheet to the corresponding field for the selection from unique list table.
OR ,
Create unique validation list in one sheet , and based on selection from validation list, Filter should be applied on the main sheet ,
Note : Header will be same ,
but no.of columns will be very less may be 5 or 6 from the actual data which may have upto 40.
or
Apply same filter on both sheets at a time , one sheet containing less/ hidden columns with unique list, and another containing raw data.
could anyone please help on this?
__________________________________________________________________
thankfully using Chandoo sir's one of the VBA codes,which is great ,
but need some changes for my requirement.
There was an artilce with below in Chandoo sir's website : I downloaded that workbook ,
Quickly filter a table by combination of selected cell values using VBA ,
Iam using this macro , but need some changes in it,
the filter is applied for the selected cells in the same sheet ,
What i need is : out of many columns(may be 40 my requirement), lets say i take 5 columns in another sheet , and after removing duplciates ( 1 col may have 10, another may have 50 cells of data etc ) ,
Now i make selection in this unique list table, filter should be applied/reflected to the main table which is in another sheet to the corresponding field for the selection from unique list table.
OR ,
Create unique validation list in one sheet , and based on selection from validation list, Filter should be applied on the main sheet ,
Note : Header will be same ,
but no.of columns will be very less may be 5 or 6 from the actual data which may have upto 40.
or
Apply same filter on both sheets at a time , one sheet containing less/ hidden columns with unique list, and another containing raw data.
could anyone please help on this?
__________________________________________________________________
Mod edit : thread moved to appropriate forum ‼
Last edited: