creat the records based on the values in another sheet

J

john_liu

I have a question on how to creat the records based on the values in another
sheet. Here is the situation. I have a sheet with the info like this:

Client_ID Order Quantity

100 product1 2
200 product2 1
300 product1 4
.......

What I want is to create the following info in another sheet based on above
quantity value. If the quantity value is 2, I want to create two
records..... In this case, the following info should be created:

Client_ID Order

100 product1
100 product1
200 product2
300 product1
300 product1
300 product1
300 product1
.......

Thanks for your help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database summary 4
create a macro for a combo box to change a pivot table 1
help on a formula (match and etc..) 1
Copy Order form into EXcel 1
Excel AutoFillOption 3
Change cell with command button 0
Lookup multiple items 6
Retrieving data based on most recent date 1

Top