Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for auto filling in Excel based on number of months, & start date
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for auto filling in Excel based on number of months, & start date
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate number of months based on one date | Excel Discussion (Misc queries) | |||
Excel for calculating stock cover based on a number of months sale | Excel Worksheet Functions | |||
Excel - Changing value of a date by a number of calendar months | Excel Worksheet Functions | |||
HOW ?Excel chart auto insert /populate a code based on date | New Users to Excel | |||
Auto Protecting cells & auto filling date | Excel Discussion (Misc queries) |