hey everyone,
is there a way to delete rows if all criteria are met?
what I mean is this.....
I can generate a report and send it to excel,
if I have 5 columns say and I am missing info in one column, I want to keep the row, if the row is full, I dont need it, so delete it
Code:
1
1, 2, 3
1, 2, 3, 4, 5 delete this as it has all the info
1, 2, 3, 4, 5 delete this as it has all the info
so that I am left with only the rows that dont have all columns filled.
I must explain at this point, that the information is stored in a database, the report is really for me to fill in the blanks, if you know what I mean.
so I don't want to trawl through hundreds of sheets of paper, to update only a handful of rows.
ik