Hello,

I have an Excel file with 2 worksheets. One containing Order Info called
"Orders" and another named "Analysis" which contact some fixed data and two
columns for automatic fill in from the "Orders" sheet.

I would like to create a code or macro when execute, transfer the Order# and
Prod Start columns from the "Orders" sheet to "Analysis" sheet taken the Qty
into account. so, if the order# has a quantity of 2, then it will fill in two
rows for one Order. The sample data is below. Thanks for any help.

Analysis sheet:
Line Plan Date Actual Date Order#
100 12/9/09
101 12/10/09
102 12/10/09
103 12/11/09
104 12/14/09
105 12/14/09
106 12/15/09
107 12/18/09
108 12/29/09

Orders Sheet:
Order# Prod Start Qty
167834 1/22/10 2
172916 2/1/10 2
169001 2/1/10 2
169003 2/2/10 2

RESULT of Analysis sheet:
Line Plan Date Actual Date Order#
100 12/9/09 1/22/10 167834
101 12/10/09 1/22/10 167834
102 12/10/09 2/1/10 172916
103 12/11/09 2/1/10 172916
104 12/14/09 2/1/10 169001
105 12/14/09 2/1/10 169001
106 12/15/09 2/2/10 169003
107 12/18/09 2/2/10 169003
108 12/29/09