Code for auto filling in Excel based on number of months, & start date

D

Diane Sulton

I have an excel spreadsheet with
Invoice data across in rows.
These are subscriptions with start and end dates. I want to
automatically fill in the appropriate column [Jan, Feb, March, April,
May ....etc] the total amount of the invoice divided by the number of
months. If I have $100 for the invoice amount, and a subscription
period of 10 mos, and the subscription starts in Jan. I want to search
the row, look for the start date, the amount of the invoice/number of
months of subscriptions, and place this amount in the appropriate
columns(Jan, Feb, March...etc).

Thank you!


*** Sent via Developersdex http://www.developersdex.com ***
 

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

Like to start using Access 1
Pivot table - show monthly data based on start/end date data 0
Custom Macro for pulling information into one sheet 0
how to sum values of an unkown number of cells 3
create a formula to know last months column character or number 0
Help showing active months between two dates 5
Transfer data as per there date in there month. 0
Pls Help on from date tranfer amount to month 3

Top