Hello friends,
@rkelchuri, @Ninett_Panfir, @Rammohan91, @balupad14, @Florent_Salendres, @vvaidya, @Palaniyappan, @ClaytonM
I have a spreadsheet in an Excel file where I want to delete rows which have columns populated in a certain way, but can this be done without a data table?
Can youplease share a sample workflow?
Thank you so much,
Cami :)
Hi
Yes of course we can remove set of rows without datatable
—It’s possible either with VBA script
But it’s not that robust and bit complicated
—Or still we got another option like
Insert/Delete rows activity
With which we can delete
Or
— even to be better to go for using datatable
Which has many simple ways that include
— Filter datatable activity
—remove datarows
— DefaultView menthods
Fine kindly refer for example on deleting rows of excel without datatable
Hope this would help you
Cheers @CamiCat
Thank you @Palaniyappan.
How is it possible to filter the rows to delete?
Not by indexes?
Thank you,
Cami
yes of course
in filter datatable activity along with filter wizard
we got two radio button options
KEEP or REMOVE
with remove we can filter the one we dont need
Cheers @CamiCat
You Replied on different topic than mine is : Remove rows Containing a Keyword A3 - #8 by Palaniyappan.
Anyway Thanks for Your Prompt Responses.
aaha
sorry for that
thanks for your kindness
Cheers @hsendel
any issues to be discussed @CamiCat
everything good
Cheers