Vba excel macro

[Pushpreet_Singh1 (Pushpreet Singh)]

I made pivot table using vba with coloumn id ,name n gender but if i have to put id in filter field of pivot table what orientation should i use like i have used row field for age and gender, so what i will use for filtering using ID USING VBA MACRO

[THIRU_NANI (NaNi)]

Hey!

If we’re using the Preview version (22.7) we have an activity called Filter Pivot Table… There you can play around this…

Regards,
NaNi

[Gokul001 (Gokul Balaji)]

HI @Pushpreet_Singh1

You should be able to accomplish this task quickly and easily with a small bit of VBA code:

Remove Pivot Table Filters with VBA – Excel Pivot Tables

Have a look on it

How to use macro filter excel?

I want to filter date in excel in sheet CaseCA and sheet CaseCH. input.xlsx (11.1 KB) output.xlsx (10.8 KB) I have variable for dateCasaCA as string = 01/01/2021 and variable for dateCasaCH as string = 02/05/2021 Condition : I want filter date in sheet CasaCA by date < dateCasaCA (01/01/2021) and filter date in sheet CasaCH by date < dateCasaCH (02/05/2021) and write it in same file. Please guide me about it.

Regards
Gokul