Copy Row when Column Criteria is met

[eighty2scrambler]

I know this is a common question that arises on this forum. I have searched and found various Similar instances to my problem, however I can't seem to get pointed in the right direction.

What i have is a sheet with abotu 1000 rows of data and 21 columns. I want to scan column E for 13 different criteria types. If the criteria is met, then I would like to copy the same row of data.

here's the catch, I dont want the entire row of data, I only want about 10 of the rows. I want these to be pasted onto other sheets in the workbook.

Another problem I have run into is, IN column E, there are some spaces in soem of the rows. This has led to problems I have found in other solutions i have tried.

THANK YOU FOR YORU HELP in advance,

I am familar with VB some, if i can just get pointed in the right direction I think we can get this figured out.


Please let me knwo if I have been unclear, I can upload attachements to better understand what I'm doing.

[StephenR]

Yes, please attach a small sample of your data which illustrates your post.

[eighty2scrambler]

I am uploading a sample Set of data

The colums I want to keep Are:
E,G,H,K,L,P,Q,S,V when the certain criteria is met when searching in column E

[StephenR]

I'm afraid I don't follow this.

The data are not aligned - what is the significance of rows starting different columns (and none of them have 21 columns)?

And where are your 13 criteria?

[eighty2scrambler]

I do apologize for nto being correct, Disregard the "13" number I mentioned.

This report is a sales report, it contains Sales People in Column E (Along with other things),

I am trying to create additinoal Sheets 1 for each sales person, (In the sample data I only have 2 sales people) . Then on each sheet, it has their corresponding sales.
I left the data unaligned bcause when I pull the report from the software, this is the look and alignement of the report (Which is why I'm creating new sheets to simplify the look)

The criteria I woudl ike were the columne mentioned above I uploaded an updated sheet to maybe better describe my solution i'm trying to reach.

[StephenR]

I think I see now. So will the data for each person always be grouped in a single block running from columns D to V?

[eighty2scrambler]

Thank yous o much for your quick replies.

Yes the data will be formatted always exactly like it is, there will just be more rows and mroe sales people.

[StephenR]

This should work:

Please Login or Register  to view this content.

[eighty2scrambler]

Wow!!

I will have to study that code and see how you did that.

It does work.. i had to make one change. but wow!! thank you so much...