How to delete the last unwanted rows

[zaska]

Hello,

I have Sorted list of data with serial numbers. My task is to identify the last serial number which is 8 in the below and delete all the rows to the end after the last serial number. Can anyone look if it can be done using a VBA?


S.NO
1
2
3
4
5
6
7
8
BRANCH-NAME
CONDITION IS DISPLAYED FOR
CONDITION IS DISPLAYED FOR
CUSTOMER-NAME
CUSTOMER-NAME
LIST
LIST

Regards,

Zaska

[Richard Buttrey]

Hi,

You don't really need a macro, although you could of course encode the process below in a macro.

Enter in B2 and copy down

Please Login or Register  to view this content.

Then filter column B for the word 'Delete', select all the filtered rows and hit the delete key.

[zaska]

Sir,

Thanks for the suggestion. Could you please tell me how to encode the same process into this macro. As i have to deal with many excel sheets iam looking for a vba.

Please Login or Register  to view this content.

Thank you

[dilipandey]

Hi zaska,

Try below code:-

Please Login or Register  to view this content.

see attachment:- Delete rows after heading.xlsm


Regards,
DILIPandey
<click on below * if this helps>

[Richard Buttrey]

Hi,

Your macro does not appear to contain the same data as your example. For instance you refer to column C in your macro, but there is nothing in column C. Similarly there are no cells with '----' in them.

If you are seeking answers here it's incumbent on you to let us have all relevant information.
The sort of looping macro you have in mind is not the most efficient way. Can I suggest you manually try the process I gave you and if this works then let me know and I'll encode that in a macro for you. Otherwise provide an example of your real data which includes all possible conditions.

[zaska]

Hello,

I am herewith attaching the example file which includes the real data. I want to sort the data according to the serial number in column a and delete the rest of the unwanted rows after sorting.

Thank you

[jindon]

Is this what you are after?

Please Login or Register  to view this content.

[Richard Buttrey]

It has come to my attention that this is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed.

Thread Closed.