Need VBA to create inputbox for multiple values & filter multiple columns
Hi, there
I have the excel file with 51 columns & over 600000 rows. I need to filter out specific values with multiple columns in order to do pivot table later.
As there will be using different headers for sorting out specific / multiple value every time, would you please to create VBA code with input box function (the comma) for selecting multiple headers of requested columns simultaneously? Also, appreciate that the specific / multiple values can be input with the comma for filtering requested data as well.
Please note that the testing file only got 70 rows for your reference.
to create VBA code with input box function (the comma) for selecting multiple headers of requested columns simultaneously? Also, appreciate that the specific / multiple values can be input with the comma for filtering requested data as well.
Reply With Quote
