I just did a VBA course however I am having trouble getting started on this one.
I have a spreadsheet which I use do a rec each month. There are multiple tabs with the data (but the inputs vary) and instead of going through all of the tabs and copy pasting the table from the prior month below to create a new month.(one below the next). I want to be able to copy the prior months data and paste below leaving 2 rows in between. (It is a section of data A -E and about 12 rows down).
Then have the opening balances of the new month become the closing balance from the previous month.
I think the only way to do it will be to have a button in which I enter the closing date. So the opening date will be taken from the previous month and the closing date will be entered via an unput button.
Then run the above through all of the tabs so it is automated each month.
I have a spreadsheet which I use do a rec each month. There are multiple tabs with the data (but the inputs vary) and instead of going through all of the tabs and copy pasting the table from the prior month below to create a new month.(one below the next). I want to be able to copy the prior months data and paste below leaving 2 rows in between. (It is a section of data A -E and about 12 rows down).
Then have the opening balances of the new month become the closing balance from the previous month.
I think the only way to do it will be to have a button in which I enter the closing date. So the opening date will be taken from the previous month and the closing date will be entered via an unput button.
Then run the above through all of the tabs so it is automated each month.
