Autopopulating expenses in a monthly checking ledger

Hello everyone! I have set up a workbook with my checking ledger and monthly budget on separate sheets. In the budget sheet I have expenses assigned with due dates. I know how to prefill the date column in the checking ledger, but I'm looking for a way to autopopulate the transaction column with data from the monthly budget each time a given date occurs. Example: On the monthly budget sheet, mortgage payment is assigned the 1st of the month and the utilities bill is assigned the 27th of the month; I autofill three months worth of dates, say 10/1/2013 to 12/31/2103, and the mortgage transaction appears on 10/1/2013, 11/1/2013, and 12/1/2013 and the utilities transaction appears on 10/27/2013, 11/27/2013, and 12/27/2013. Is this possible?

Welcome to the forums!

This is very possible!

Assuming a list of dates down Column A: =if(day(a1)=1,"Mortgage",if(day(a1)=27,"Utilities",""))

Next, enter it as an array. With the cell active and the cursor in it, hold Ctrl + Shift and then Enter. This will put { } around it, and it's not the same as manually typing them in. Then just drag the formula down the list of dates and it will autopopulate.

Thank you for your timely, helpful response and the warm welcome! Is there a way to link the values within the quotation marks in your example formula to the values I already have in my Budget worksheet? I tried substituting "=Budget!A3" and so forth for "Mortgage" but it simply returned the text "=Budget!A3" rather than returning the intended cell reference. I would like to do this so that as I change my budget amounts for a given item it will reflect on the ledger. Thanks!

Yes, you were very close. Just do the same thing without quotes and make sure it's Budget!$A$3 so the reference remains absolute.

Assuming A3 = Mortgage, A4 = Utilities:

=if(day(a1)=1,$A$3,if(day(a1)=27,$A$4,""))