ThrottleWorks
Excel Ninja
Hi,
I need help for filtering the data in VBA.
I need to filter the value as per month names.
I have given an input box where user puts the name of the month.
The user can select any month between Jan to Dec.
This values is stored in cell B1.
My problem is, I want to filter the data on the basis of value in cell B1.
For example if the user has selected December, the macro should filter the data for December.
Can anyone please help me here, I tried recording, but macro is recording the particular cell value as string & doesn’t get changed even if if we changed the value in B1.
I need help for filtering the data in VBA.
I need to filter the value as per month names.
I have given an input box where user puts the name of the month.
The user can select any month between Jan to Dec.
This values is stored in cell B1.
My problem is, I want to filter the data on the basis of value in cell B1.
For example if the user has selected December, the macro should filter the data for December.
Can anyone please help me here, I tried recording, but macro is recording the particular cell value as string & doesn’t get changed even if if we changed the value in B1.