Loop to copy all rows containing specific values

Hi all

First post, excuse me if a goof it up.

I have a table of data that goes from columns C to Q. The data starts in C9 and the Q range will vary. It is a table of invoice data, with the Director's name being in column J. It is sorted by column J. I need to copy all the rows (columns C:Q only) that contain a given director's name in to the relevant worksheet which will also have that name. The worksheets all already exist, and the data only ever needs to be pasted (values only) to cell C9, as long as it goes as a group.

I hope this makes sense, I have trawled many forums and can't figure out how to make any of them work. If anyone could help I would be most grateful.

I will not post any of the code that I have tried as nothing works at all close to what I need.

Thanks very much in advance.

WW

you should upload a workbook with a before and after situation or at least a sample workbook that looks like the workbook you're working in

OK thanks I didn't know to do that.

Attached is a sample book with the source table and four output tabs.

Cheers
W

maybe something like this

Please Login or Register  to view this content.

Hi nilem

Thank you, that worked perfectly for the sample data.

For my actual data I only need to copy what is in columns C:Q and paste them to columns C:Q on the corresponding sheet (starting at row 9). I can't figure out how to alter your code to get it to work, sorry.

Any help again much appreciated.

Cheers
W

maybe so

Please Login or Register  to view this content.