Hello,
I was hoping you would be able to help me with the following situation. For instance, I have a product Z that is made up of the following materials: 30% a, 60% b, and 10% I. Additionally, I is made up of 40% c and 60% d.
I need to be able to list out both possibilities, where Z = 30%a, 60% b, 10% I and Z = 30%a, 60%b, 4%c, and 6% d. This situation occurs for 100's of products, so I would need the vba code to search through a large data set.
I appreciate any help. Thank you.
Please attach a sample workbook illustrating a before and after example.
To attach a workbook, click the 'Go Advanced' button below and use the paperclip in the toolbar to navigate to your workbook.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Please see attached. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks