find the part of text and delete the row and loop continues

Hi,

Help me out with a script for the below requirement.

i have 40000 rows in only cell A. now out of that i want to delete the rows by finding out the part of the text and the loop should continue till the cell A is having a blank cell that is A40001.

Regards,
Vimala

Please Login or Register  to view this content.

hi,

thanks for the quick response....

but the macro is not moving to next row...

i will give my example again

Column A

date of the transaction
MCP id
MCP number
time of the transaction
amount
2349q3845792
location india
3408208957294
date of the transaction
MCP id
process sdkjfoawier
amount
2349q3845792
3408208957294

this is how my data look likes till the 40000 rows.... now i want to delete the rows which are begining with loction and process in the entire data....

by using a loop

please help me on this....

regards,
vimala

Hi, providing that you change "part of the text" to "location" then the macro will delete the rows beginning with location. i.e. with that data in column A on the activesheet, run this macro:

Please Login or Register  to view this content.

no its still not deleting the rows.....

Hi,

Please find attached an example workbook.

It includes a macro in module 1, and before and after sheets.

The before sheet is the layout of the data as you provided and the after sheet is after I ran the code in module 1.

Could you confirm that the after sheet is what you mean by the rows being deleted? Does the code not perform this when you run it?

yes............... in your work book it is working...

am using 2010 version and cursor is not even moving to the next cell in my work book... and the rows are not getting deleted...

it is not even prompting that it is done....

no activity is taking place in the sheet when I am running this.... macro

Hi - please upload the workbook for which it does not work (it doesn't need to be the full thing, just a reduced size version for which the code doesn't work and with sensitive data removed). To upload a workbook click go advanced and then attachments from the reply window.

Hi,

in the attached excel i need to delete the lines which are starting with location, mcp, last.

regards,
vimala

Hi,

The instr function is case sensitive so you would need to change "location" to "Location" for it to work in the attached file. Alternatively:

Please Login or Register  to view this content.

would not be case sensitive.

amazing.............. this is working out

thanks alot