Family monthly budget1.xlsm
Attached is the file associated with this thread.
I am new to VBA and therefore more or less illiterate. I need a code written that will allow me to enter information into this budget spreadsheet. The sheet name to enter information is called ‘push’. The information on that sheet corresponds with cells on the remaining monthly sheets.
What we need to have is for us to be able to enter currency into cells on the ‘push’ sheet and have it correspond with the cells on the correct month’s sheet. Cell E5 will be used to enter the correct sheet. A button needs to be placed on the ‘push’ sheet in cell A5 to activate the code. All currency added to ‘push’ sheet will need to return to ‘0’ when the button is activated.
On the corresponding sheet, the information needs to be entered into the cells in the ‘actual cost’ columns and add. Every time currency is ‘pushed’ it will need to add to the currency already in the monthly sheet. This way we won’t have to add the numbers one by one when entering information.
I hope this is enough information. As I mentioned, I am just beginning to learn VBA and will need specific instructions as to how to proceed.
Thanks in advance!
Bookmarks