I am trying to create a form that will populate a specific months associated entries. I have a spreadsheet that we use to track costs based on a 24 month schedule The workbook has data sheets for each property and I'd like to create a form that will open and allow the user to enter the values for costs associated with the property and then take those values and fill in the appropriate cells on the appropriate sheet in the current month or have some way to select what month to place them.

Each data sheet for each property has the same 24 month structure as well as the same row items.

For example ... each sheet has "Rent" "utilities" "Repairs" ... ect. as row items/labels

The workbook is used to calculate profits, occupancy, and costs for 12 months (trailing 12 is what we call it) based on a date value entered. The data value is the first thing done when updating the spreadsheet for the current month. Each months workbook is saved as a unique file once the data is entered for that particular month.

Any help would be appreciated.