Copying row based on partial cell match and paste into existing worksheets

Hi,

I could really use some help here. I have been working on this for a week now and have only gotten so far as to create a new worksheet for each unique cell in column A but I need to search column A and copy each row based on partial match because I have a few cells with the similar contents and I need these grouped together.

I have attached a sample of what I need and I would really appreciate any help.

Thanks

Hi Colin,

Nice to see a fellow Dubliner in here!

Take a look at the attached workbook. I think it will do what you want - i.e. copy each of the various Customer data rows to the appropriate "Category" worksheets, and to the "Other" category worksheet if no Category is specified in the "Customer" data cell.

Hope this helps - please let me know how you get on.

Regards,

Greg M