I am in the process of development a budget template. I have two columns; one with a total amount of money spent (A), and one with the months that that money will be spent in (B). To the right is a worksheet with Jul (C), Aug (D), Sept (E), etc. in respective columns. I was like the ability to be able to go into column B, type "July, August" (or month numbers if that is easier) and have the table to the right autofill with column A/number of months. For example, I spend 10000 in the months of July and August. I go into column B and type "July, August" and when I click enter, July fills with 5000 and August fills with 5000. Is this possible?
|
Similar Threads
