Filter datatable containing blanks and write range data

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

2 Likes

@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

@raj.parsana

Check as below

Hope this helps you

Thanks

1 Like

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

2 Likes

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

3 Likes

@raj.parsana

Glad it helped you

You can follow MyChannel for more references

Thanks

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

2 Likes

Yup its fast and reliable!!

Thanks for your input also… @ppr

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.