Hello all!
I am not sure if I should post this here or another section so please do direct me to the right place if this is the wrong area to post this.
I really need help with something that might be very easy but I just can’t wrap my head around this.
We have a workbook for one of our subsidiaries that we update daily. The workbook has 12 worksheets for each month. Within the worksheet we have columns with each working day and the cash movement that happened that day (the receipts and the payments). At the beginning of every month, we create a copy of previous month spreadsheet and label it with the current month and delete all the info of the previous month cash movements and keep all the formulas. I wanted to see if there is a way I can create a macro to do the following for example:
Take January’s worksheet and create a new worksheet and delete all the cell contents except the formulas. I also want it to link the ending balance for an account on the last day of the month as the beginning balance for the new month.
Please let me know how I can do this.
Thank you so much!!!