I am using a macro which picks up a value from a sheet "Overview" goes to sheet "Input" and does an auto-filter in "Input" sheet. Then it picks up the filtered column and uses it further.
I have an issue with auto-filter when the value in "Overview" sheet is something like >= 200K amount . Excel Macro piks it up as a greater than filter, instead of being just a normal "equal to" with the filter on the provided value.
I am just a beginner so if this question sounds basic, please forgive me