Populating worksheet B from Worksheet A - VBA help

**bos1234** · 07-15-2013, 12:15 AM

Hi everyone,
I have the following scenario:
I have two worksheets RAW and BOM. What I would like to do is populate the BOM sheet FROM the RAW for certain components.

For example in BOM worksheet I have VXL5-50 (highlighted in yellow). So for that component, I search sheet1--> 'connector type' column and look if that string exists. If it does, then I increment by 1 in the QTY column in the BOM worksheet

Please Login or Register  to view this content.

Excel file is attached at the bottom

thank you

**AlphaFrog** · 07-15-2013, 01:05 AM

Try this...

Please Login or Register  to view this content.

**nilem** · 07-15-2013, 01:07 AM

Hi bos1234,
maybe formula, such as (in C18 sheet 'BOM')

Formula:

Please Login or Register  to view this content.

**bos1234** · 07-15-2013, 01:27 AM

thanks very much guys.
@alphafrg - appreciate it. It works fine.

@nilem - thanks for the easy solution. Appreciate it!

Not sure which one to adopt. The RAW table will always be different each day/month hence am not sure if countif can be flexible. I think the vba code might solve this issue. I will experiment and see how it goes

thanks once again!

regards,
bos1234