Need help Newbie here

[mac7988]

I have data that is in random order.

when excel see's a article example " fas 4041"

I need it to reference another sheet and create rows of data containing parts needed for project.

example

column A(component id) column B(quantity)

fas4041 200


I want a macro to look at another sheet and find all the parts to make this component.

It will edit this sheet to input

parts needed in additional rows

parts needed as follows

fas4040 200
ibs 8x16 400
tin 4506 400
lks 8x25 200

[FDibbins]

Hi and welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the adress bar)

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.