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) …

@fairymemay - Here you go DateFilter_Noona.zip (107.9 KB) Currently I have the input date of 22/05/2021 so you see 4 rows filetered, and if you change the date to 20 you will see no rows. Please do delete the Output sheet try both the dates [image] Once you understood what is happening, Repeat t…

@fairymemay - Are you specifically looking for macro ?? we can easily use LINQ query to filter the result and write to the output sheet.

@prasath17 I’m ok for use LINQ query. But I want to write in same file and same sheet. Please guide me.

@fairymemay - may I ask why? Since you have 5 rows in the input sheet and 2 in the output for CaseCA if you write the output to the same sheet your other rows will still be there I am afraid. So I won’t write it to the same sheet.

@prasath17 If clear data from sheet CaseCA and CashCH before write. Is it possible or not?

@fairymemay - That is equivalent to writing the result to new sheet or the new workbook right???

[image] fairymemay: Can write in new sheet but same name (delete original sheet) ? You can’t do that…May be first we can delete the sheet and create a new sheet with same name…

@prasath17 Delete the sheet and create a new sheet with same name // okay Please solution for filter excel to me.

@fairymemay - Here you go DateFilter_Noona.zip (69.2 KB) Please remove the “input_Org.xlsx” from the folder and then run the workflow you will see the output gets created. date in sheet CasaCH by date < dateCasaCH (02/05/2021) → For this case, only one date qualified because your date format in …

@fairymemay - Did you get a chance to try this? If yes and solved your query , please mark my post as solution.

How to use macro filter excel?

Help Activities

fairymemay (noona) May 20, 2021, 1:29pm 7

@prasath17 Ok , If can’t write in same sheet.
Can write in new sheet but same name (delete original sheet) ?

Topic		Replies	Views
Filter date in Excel (by use macro) Activities excel , activities , question	0	640	May 20, 2021
How to Filter Date by macro? Activities excel , activities , question	1	1071	June 8, 2021
Filter column in excel Activities excel , activities , question	6	901	April 7, 2021
Filter the date in excel Activities excel , activities , question	10	862	January 6, 2021
Deleting rows from a sheet after filtering Help excel	34	7762	March 28, 2018

How to use macro filter excel?

Related topics