Announcement

Collapse
No announcement yet.

Automatically Populate Cells Depending on the Date Range

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Automatically Populate Cells Depending on the Date Range



    Hi. I need some help on automatically populating recurring payments on the table.

    For example: I have the amount of the monthly payment, say, 10,000.00. Indicated on the next cell is the particular month it is going to start and the month its gonna end. Now I want it to automatically populate on another table I created with 12 columns referring to the 12 months in a year.

    How can I do that? For example, If i select January 2018 on the start date and select May 2018 on the end date, 10,000 will automatically appear on the columns for Jan, Feb, Mar, Apr and May.

    Please help.

    Thank you so much.
Working...
X