Ok, I'm creating a spreadsheet to keep my check register and categorize my expenses. I have created drop downs for debt/check/deposit and for the categories of expenses. The only thing left to do at this point is that I want the spreadsheet to autofill the next check number when I use the drop down for "check". Does anyone know how this can be done? Thanks in advance. ---------- For example: If(d1="check", last check #+1, 0) The section in blue is what I don't know how to do.