I have finished my financing page today along with the daily records page. On the financing page there is the total amount of outgoings per week and also the total outgoings for all the lessons together. There is a column which includes the income I gain from the lessons. All these columns are done with formulas using the +,- and * symbols to work. There is also a part at the bottom which says profits which is found out when the income from the lessons is taken away by the outgoings during a period of time.
The records sheet is simply a sheet that just requires a button. There is live data on the left of the criteria. This record sheet is simply here to help show the difference in each day after bookings are made or not. I needed live data on the left of the criteria as making a macro that copies data from another sheet would make it move back and forth so instead just copying it from the same sheet would mean no moving about needed and its much faster. Each time you click the button record the data pops out in a new column along with the date it was recorded.
No comments:
Post a Comment