cut and paste and navigating betwwen sheets and deleting extra sheets

HI All,

Please see my attached sheet, in which i have data in sheet1
and i remove certain rows based on criterias and paste in some four rows below the used rows again in sheet1

i thought of cutting the specific rows and pasting it in sheet2 and after completeing analysing all rows in sheet1
for criteria, finally copying all cut data in sheet2 and pasting it below the used rows in sheet1 and deleting sheet2.

i created a code but answer is only bugs...(as i have limited resources not able provide the code.. wil provide it shortly)

Can any one please help if you have other ways also welcome..

Hi All,

here is my code....

actually i need to remove row with specific text and paste it some 4 rows down the same sheet used rows.

what i did is using =left formula finding the needed text in one of column and using that =left text macro will remove rows and paste it to another sheet and again cut and paste in first sheet.

My doubt is if any of the text which i need comes in middle of the text in the row, where it cannot be known correctly through =left formula..

so it may cause error in logic...

Is there any other way to achieve...

If am not clear you can refer code and sample attached sheet, even though my explanation is not good. Please come back. Thanks.

Please Login or Register  to view this content.

My doubt is if any of the text which i need comes in middle of the text in the row, where it cannot be known correctly through =left formula..

Anyone have suggestions??? please come forward....Thanks.....