Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop and AutoFill
Please help!
I'm new to vb in excel. I've attempted to automate this in excel. The data is as follows: Column A Column B Column C Start Date Amount #ofmonths I need to take the amount divided the number of months, and spread it over a period of time. If the start date is from Jan 01, 2005 with a 12 month period, then the amount/# of months, is spread from Jan05 to Dec05. I have also set up columns naming them Jan05, Feb05, March05, etc, so I can spread the amount over the period of months. I'm thinking I should loop through the start dates, to see what column to start spreading the amount/#ofmonths, and then do an autofill based on the #ofmonths. Please help, I've tried all different kinds of code scenarios. *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop and AutoFill
With formulas only! No VBA!
http://cjoint.com/?dbt6apTVJH HTH -- AP "Anonymous" a écrit dans le message de ... Please help! I'm new to vb in excel. I've attempted to automate this in excel. The data is as follows: Column A Column B Column C Start Date Amount #ofmonths I need to take the amount divided the number of months, and spread it over a period of time. If the start date is from Jan 01, 2005 with a 12 month period, then the amount/# of months, is spread from Jan05 to Dec05. I have also set up columns naming them Jan05, Feb05, March05, etc, so I can spread the amount over the period of months. I'm thinking I should loop through the start dates, to see what column to start spreading the amount/#ofmonths, and then do an autofill based on the #ofmonths. Please help, I've tried all different kinds of code scenarios. *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop and autofill | Excel Discussion (Misc queries) | |||
AutoFill Loop | Excel Programming | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Q. Autofill question: Can I autofill alpha characters like I can numbers? | Excel Programming |