I have a table in which I need the quantity in cell B to specify how many time the item(text) in cell A shows up on the following sheet. e.g. Cell A1: Chocolate Bars Cell B1: 5 will then show up in the next sheet as chocolate bar for the first 5 rows. Furthermore, Cell B1: Candy Cell B2: 3, the cells on sheet two after chocolate bar will be candy for 3 rows. Please help!
Bookmarks