Need help with VBA code
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 167834 1/22/10 101 12/10/09 167834 1/22/10 102 12/10/09 172916 2/1/10 103 12/11/09 172916 2/1/10 104 12/14/09 169001 2/1/10 105 12/14/09 169001 2/1/10 106 12/15/09 169003 2/2/10 107 12/18/09 169003 2/2/10 108 12/29/09 |
All times are GMT +1. The time now is 03:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com