browncountry
New Member
- Joined
- Feb 2, 2019
- Messages
- 13
A | B | |
1 | Item Number (Kit) | Qty |
2 | Kit 456 | 3 |
3 | Kit 123 | 1 |
4 | Kit 789 | 2 |
SHEET 1 | ||
A | B | |
1 | Item Number (Kit) | Parts within kit |
2 | Kit 123 | Part 1 |
3 | Part 2 | |
4 | Kit 456 | Part 1 |
5 | Part 2 | |
6 | Kit 789 | Part 1 |
7 | Part 2 | |
8 | Part 3 | |
SHEET 2 |
<tbody>
</tbody>
I have a sheet labeled "Sheet 1" with a list of part numbers (which are kits with multiple parts that go into them) and their quantities as shown above.
Sheet 2 is a master list of kits and the parts that belong to them. My objective is to search Sheet 2 for kits showing in Sheet 1 and copy and paste them in Sheet 3 the amount of times listed in Sheet 1 until I get to the last row of Sheet 1 with VBA code. Does that make sense?
Sheet 1 is an input sheet and Sheet 3 is an output sheet. If anyone has any suggestions on how to go about doing this, it would be very much appreciated! Thanks in advance.