Search results

I got it...must have had something wrong so just started from scratch and it worked Thanks so much for your help! Very much appreciated!

Thanks so much for your help... Unfortunately it's still not zeroing out the previous item (when the previous item contains more components). I've been playing around with the code all day and can't seem to crack this one detail.

Thanks...figured out the error. However, when I select and item that has less components than the previous item I selected it's still not clearing all of the lines in the summary....Any ideas as to why this is still occuring? Also, the code assumes the Item is numeric - Is there a way to...

Thank Kanti....Almost there. I'm getting an error that reads 'Argument not optional' I modified the code slightly to reflect some changes to where I want the data placed on the sheet and where I placed the drop-down "Data" has a header and the Item # is in column A starting on Line 1...

Thanks. I actually previously created a macro. When I go to the VBA editor the code is there, but when I go to run the macro in excel I don't see the macro (it's not available as an option. In the VBA editor the code is associated with an object (the worksheet that I want the macro to run...

When I open a new worksheet in Excel 2007 and click on 'Macros' under the 'Developer' tab excel will not let me create a new marco. The 'create' button (and all other buttons) are grayed out. Any suggestions? Thanks

Thanks Kchiba. The macro you suggested almost gets me to where I need to get...just 3 issues: 1) I want a user to be able to change the required Item to be searched for (Cell A1 on the Summary) tab by selecting from a drop-down. I can easily add the drop down, but how do I get the macro to...

I have a summary sheet which contains multiple recipes for multiple items. The sheet is structured as such: Parent item Component item # Qty required Item # 1 Component # 1 0.5 Item # 1 Component # 12 6 ..... Item # 26 Component # 3 12 Item # 26...