Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating excel file, adding code to it from code, VBE window stays | Excel Programming | |||
How can I modify my code to offset the defined range and repeat theprocedure instead of duplicating my code? | Excel Programming | |||
Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code does | Excel Programming | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming |