Loop and AutoFill

A

Anonymous

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code for auto filling in Excel based on number of months, & start date 1
Text File Import (Date problem) 0
Autofill destination incrementing date by 1...don't want it to 3
Macro to be to split an amount based on it value and spread over aperiod (months) 1
Customer Penetration 3
AutoFill a large list 9
Grocery list 1
Grossery Budget spred sheet. 2

Top