Hello! What I'm looking to do is duplicate each row a different number of times (either in the same sheet or a new sheet) so that there end up being x # of instances of each row as defined by column C.
Example:
I have looked up duplication macros and found some that work well, but they duplicated by a set number of times and I need to duplicate various times per row.
Thanks a ton!
Example:
Excel Workbook | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Item # | Item | Copy | ||
2 | PRO-CEL-00-BLK | 2000-2003 Toyota Celica | 4 | ||
3 | PRO-CEL-03-BLK | 2003-2005 Toyota Celica | 3 | ||
Beginning |
Excel Workbook | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Item # | Item | Copy | ||
2 | PRO-CEL-00-BLK | 2000-2003 Toyota Celica | 4 | ||
3 | PRO-CEL-00-BLK | 2000-2003 Toyota Celica | 4 | ||
4 | PRO-CEL-00-BLK | 2000-2003 Toyota Celica | 4 | ||
5 | PRO-CEL-00-BLK | 2000-2003 Toyota Celica | 4 | ||
6 | PRO-CEL-03-BLK | 2003-2005 Toyota Celica | 3 | ||
7 | PRO-CEL-03-BLK | 2003-2005 Toyota Celica | 3 | ||
8 | PRO-CEL-03-BLK | 2003-2005 Toyota Celica | 3 | ||
Result |
I have looked up duplication macros and found some that work well, but they duplicated by a set number of times and I need to duplicate various times per row.
Thanks a ton!