pljharvey
04-13-2010, 04:45 AM
Hello!
Right, this is my first post... I'm pretty much a complete novice when it comes to Macros, as I've only ever recorded them to do simple repetitive tasks
But, I'm now trying to expand the use of Excel within my daily role to make myself more efficient.
Each day, I generate a number of excel files used to calculate payment notices. So, they currently calculate any pay-offs and pump the data into sheet 1 of my workbook. I then save this workbook per it's name and email a copy of the sheet 1 to the other teams that require it
What I'm hoping to do, is just create a macro button somewhere on sheet 1 of this template, that then creates a separate workbook for "today's date" and copies the relevent data into row 2 of this created workbook... This process would then be repeated throughout the day, adding data to the next available empty row.
Than, at the end of the day I can just send out one file, with all of today's work on it, instead of a separate email/file as and when.
Is this possible to do? And is it very difficult?
Rgds,
Paul
Right, this is my first post... I'm pretty much a complete novice when it comes to Macros, as I've only ever recorded them to do simple repetitive tasks
But, I'm now trying to expand the use of Excel within my daily role to make myself more efficient.
Each day, I generate a number of excel files used to calculate payment notices. So, they currently calculate any pay-offs and pump the data into sheet 1 of my workbook. I then save this workbook per it's name and email a copy of the sheet 1 to the other teams that require it
What I'm hoping to do, is just create a macro button somewhere on sheet 1 of this template, that then creates a separate workbook for "today's date" and copies the relevent data into row 2 of this created workbook... This process would then be repeated throughout the day, adding data to the next available empty row.
Than, at the end of the day I can just send out one file, with all of today's work on it, instead of a separate email/file as and when.
Is this possible to do? And is it very difficult?
Rgds,
Paul