Pull from Table by Root # and Regroup in Summary

[ChemistB]

I'm in over my head on this code. I have a list of items required in for manufacture (on Summary sheet Col A) and a table on Sheet Table where costs were calculated using Sys1 or Sys2. I am attempting to run a macro which will go through the table looking for the items in Summary and paste them into Col F:I if Sys1 and J:L if Sys2 (see expected results in attachment). My code so far

Please Login or Register  to view this content.

Can anyone give me some next steps? Actually, I'd like it to total for sys1 and sys2 for each item also. Thanks in advance.

[mrice]

Does this help?

Please Login or Register  to view this content.

[ChemistB]

Thanks, I'm getting there. I need the macro to identify the root number though. It's only pulling over exact matches. The examples I gave are fairly complete. It always starts with the number, then either nothing, an R or a - followed by another number. Values can go into the thousands though so if I'm looking for 103, I don't want it to return 1030 or 1039 but it should return 103-1 or 103R.

[ChemistB]

I have continued this in a new thread. Part 1 is solved.

http://www.excelforum.com/excel-prog...ml#post2492035

[mrice]

Possibly..

Please Login or Register  to view this content.

[ChemistB]

Nope, that didn't work either. Check referenced thread (post #4) for latest attachment/coding. Thanks.