Filter data Table can only put filtered data to another sheet instead of filtering in the original sheet with uncheck or check the data we want. Any way we can have the same function as “Text Filter”? Thanks.
Hi @li.yu
you can write an excel vba macro using invoke VBA activity, that will filter the data in excel itself…
Thanks
Thanks, but I want to filter column H, which with value out, than to have Column H - Column G, the result will be in column I, after the calculation, will remove filter option.
thanks, but I have little VBA experience.
what you have to apply in the filter…
filter all values not blank.
Please find the reference
Sub filter()
Range("A1:H" & Cells(Rows.Count, 1).End(xlUp).Row).AutoFilter Field:=4, Criteria1:="<>"
End Sub
it will filter in 4th column change column number as you want,
Thanks
2 Likes
yes, it works, very appreciated!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.