Search string copy row to a different tab

[nikogeorgiev]

Dear all,

I need your help, and I will be very grateful if you could help me.

I have a spreadsheet in which I would like to search for a string (column E) The string starts with 1.ABCXXXXX. I would like to search all values that start with 1.ABC and copy the entire row in a different tab. I tried to do it myself but the code is not working well. Could you please tell me what I am missing? Many thanks

Please Login or Register  to view this content.

[judgeh59]

what exactly is "not working well"?....I can see one thing....I don't see where you are incrementing the variable j....looks like you will write over every row you copy....insert a j = j +1 inside the if statement....unless I'm missing something...HTH

[AB33]

Alternative to loop

Please Login or Register  to view this content.

[nikogeorgiev]

AB33 this is perfect working the way I want it to work. Is it possible to check for two criteria, i.e. 1.ABC and 2.ABC for example as I need to extract data that starts with either prefix

many thanks guys

[AB33]

Change this line

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

[nikogeorgiev]

AB33, Many thanks for that. Works perfectly for me