Hi to ExcelForum,

I am new to the functions, formulas and codes in excel. But i have recently found the wonders with the usage of Excel templates which are having more functions, formulas and codes.

With a bit of little bit understanding, i have decided to create a template which will calculate my room budget. here are the details how i am thinking,

How to copy one value from sheet1 to sheet2 (with row increment in sheet2) for every button click.

Eg:

1. from DayExpance sheet, i have to copy a value in DayExpance sheet H7 to March_MonthExpance sheet C12 for one time button press.
2. When the button click happened, i need to update the entry count in DayExpance sheet and then for the next button press, i need to copy the same cell in DayExpance sheet which is H7 to March_MonthExpance sheet C13 (here Row should increment by one).
3. DayExpance sheet will be having a Reset Button to clear the entered data in the same sheet.
4. if the month is over, for the next month DayExpance template will be common but on the 1st day of new month it should create new month expanse sheet like say June_MonthExpance. (is it possible??)

Please give me your valuable suggestions and inputs to get a clear picture in implementing this.


Room Budget Template1.xlsm

plz, find the attached sheet to get a little more idea on my question.

Sorry for my poor english.