Hi all,
I need help coding some stuffs in Excel 2013
I have a table set up for monthly salary info input. My boss wants it to be copied and moved down the sheet for every new month. At the same time, I need to delete the non-fixed content, so that the table can be available for a new money. E.g. I don't delete the names, the title...etc. Only the "hour worked" is deleted.
Essentially, table 1 in the very top, every month, you press on the macro button, table 1 is copied, and pasted immediately following table 1, call this table 2. Then for the next month, table 1 will be copied again with new info, and pasted immediately after table 1 (above table 2 though).
I tried to use Macro recording, but it is not working for some reason. Please help.
I need help coding some stuffs in Excel 2013
I have a table set up for monthly salary info input. My boss wants it to be copied and moved down the sheet for every new month. At the same time, I need to delete the non-fixed content, so that the table can be available for a new money. E.g. I don't delete the names, the title...etc. Only the "hour worked" is deleted.
Essentially, table 1 in the very top, every month, you press on the macro button, table 1 is copied, and pasted immediately following table 1, call this table 2. Then for the next month, table 1 will be copied again with new info, and pasted immediately after table 1 (above table 2 though).
I tried to use Macro recording, but it is not working for some reason. Please help.
