Filter datatable containing blanks and write range data

[raj.parsana (Raj Suresh Parsana)]

Hello All,

Filter Quantity with blanks and copy data of blanks and paste it to new sheet.

Example:-

After filtering, while pasting data, there are no rows in the new sheet.

Thanks Regards,
Raj

[ppr (Peter Preuss)]

@raj.parsana
In general filter datatable should work. For an alternate have a look here:
GetRowsWithBlanksByColList.xaml (8.6 KB)

Just configure the ColList Variable with the columns to check or adopt the statement to check only 1 column.

Let us know your feedback

[Srini84 (Srinivas Kadamati)]

@raj.parsana

Check as below

Hope this helps you

Thanks

[raj.parsana (Raj Suresh Parsana)]

Thanks but i want for particular column and this checks for all empty cells.

[raj.parsana (Raj Suresh Parsana)]

Thank you so much it worked, i did’nt knew this!!

[Srini84 (Srinivas Kadamati)]

@raj.parsana

Glad it helped you

You can follow MyChannel for more references

Thanks

[ppr (Peter Preuss)]

Code is doing this. As mentioned by me and @Srini84 the filter datatable should be the prefered solution approach

[raj.parsana (Raj Suresh Parsana)]

Yup its fast and reliable!!

Thanks for your input also… @ppr