Good Evening,
I am horrible with Marcos and VBAs, and I believe I am going to need something like this for what I am trying to do.
I am working with Build of Materials to produce one item, and for each item I need certain amount of materials.
I have one sheet that shows an item that is running and what line it is running on. I would like to see if there is a VBA that would copy and paste all of the items that it takes to create one case (From a master sheet of all items and materials used for each item) and paste all of the lines into another tab for each line that they are running on. I have attached a snip of what I am working on to help. (The rows that need to be copied and pasted will vary depending on each item number).
Please let me know if you can help me!
Snip of BOMs.xlsx
Bookmarks