Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creat the records based on the values in another sheet
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate excel sheet based on values in a separate sheet | Excel Discussion (Misc queries) | |||
color few records based on data in another sheet | Excel Worksheet Functions | |||
how do I creat a table of medians based on a second field? | Excel Worksheet Functions | |||
who creat this spread sheet? | Excel Discussion (Misc queries) | |||
How to Creat multiple copies of sheet | Excel Discussion (Misc queries) |