Fill out information fields

[warp765]

Hi there

Sheet1 contains a list of equipment and Sheet2 contains all the possible characteristics of the equipment. I need to match the 'Equipment Class' in Column L with Sheet 2 Column A, and copy over all the relevant characteristics in Sheet2 Column B to Sheet1 Column M.

I have attached an example workbook, and Sheet3 has the expected output for one row as an example.

Many thanks for your help.

[Paul]

Hi Warp, this code may work for you. It assumes all of your classes are grouped together on the List sheet, e.g. all of the VALVE entries are in sequential cells and don't exist elsewhere in the list. If they are scattered, you should probably sort that list alphabetically so they are grouped. If you can't do that, the code will need to be altered to find and count the number of 'VALVE' (or other class) entries and organize the output data accordingly.

Please Login or Register  to view this content.

[warp765]

Hi Paul,

Thank you it works well apart from a strange one with single criteria. The class 'Filter' only has one characteristic but it pastes with an empty row above and below the characteristic for each original row.

I was also wondering if you could add an error handler so that if a match isn't found the code just carries onto the next row?

Thanks!

[Paul]

Try this revised code to handle single criteria and errors if no match is found:

Please Login or Register  to view this content.

[warp765]

Paul, that's working great now. Thanks for your help.

I've added rep for you.