How to use macro filter excel?

[fairymemay (noona)]

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

Please guide me.

[prasath17 (Guru)]

@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.

[fairymemay (noona)]

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

[prasath17 (Guru)]

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

[fairymemay (noona)]

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

[prasath17 (Guru)]

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

[fairymemay (noona)]

@prasath17 Delete the sheet and create a new sheet with same name // okay

Please solution for filter excel to me.

[prasath17 (Guru)]

@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 the sheet is dd/MM/yyyy.

Hope this helps…

[prasath17 (Guru)]

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

[fairymemay (noona)]

@prasath17 If I use my excel , it show error as below.

File excel : input.xlsx (15.5 KB) ( I delete sensitive date in my file)

I edit filter as below.

Please guide me more.

[prasath17 (Guru)]

@fairymemay

If I use my excel , it show error as below.

Whatever the sheet you initially shared, i have provided the fully working code…

Recently shraed one is not in proper date format. Check the cell type on top it is “General”

This is our original format

[fairymemay (noona)]

@prasath17 If​ I​ want​ use​ format​ General.
How to solve. XAML?

[prasath17 (Guru)]

@fairymemay

If​ I​ want​ use​ format​ General.

I can help. But May I know why your original requirement has changed?

[fairymemay (noona)]

@prasath17 Now, I​ download​ file​ from​ internal​ system.​----->due​ date​ format​ type​ General.
But original​ file​ that​ example​ data

[fairymemay (noona)]

@prasath17 If you have free time Please advise for​ solve this case.

Thank​ you.

[prasath17 (Guru)]

@fairymemay - please let me know what is the exact filtering requirement?

[fairymemay (noona)]

@prasath17 I have variable date1 as sting = 20/05/2021

I want filter sheet caseCA column Due Date (format type General) < date1 and write in same sheet.
but if column Due Date not have data < date1 , I want to show header in sheet only.

input.xlsx (20.9 KB)

Please suggest​ solution​ for​ this​ case.

[prasath17 (Guru)]

@fairymemay - I will work on this today and let you know.

[prasath17 (Guru)]

@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

Once you understood what is happening, Repeat the process for CaseCH sheet by yourself.