M
Marisa Salem
Hi
We use an Excel worksheet for each day in which we fill in details of what
contractors are assigned to what jobs. The trouble is that each time a job
is changed, we have to open more than one worksheet to check/change the
details (ie, each worksheet for each day is a separate Excel spreadsheet.
I'm trying to put the worksheets together based on months rather than days
ie a worksheet for each work day, in one file instead of lots. At the
moment, I've just lumped each day's worksheet into one spreadsheet for each
month, which is an improvement. Is it possible to have a macro or something
to create a new monthly spreadsheet using the template for each day, and
have it automatically put the day and date on each worksheet? Is there a way
of avoiding having for example, 20 tabs (for the working days each month) at
the bottom.
Thanks
Marisa
We use an Excel worksheet for each day in which we fill in details of what
contractors are assigned to what jobs. The trouble is that each time a job
is changed, we have to open more than one worksheet to check/change the
details (ie, each worksheet for each day is a separate Excel spreadsheet.
I'm trying to put the worksheets together based on months rather than days
ie a worksheet for each work day, in one file instead of lots. At the
moment, I've just lumped each day's worksheet into one spreadsheet for each
month, which is an improvement. Is it possible to have a macro or something
to create a new monthly spreadsheet using the template for each day, and
have it automatically put the day and date on each worksheet? Is there a way
of avoiding having for example, 20 tabs (for the working days each month) at
the bottom.
Thanks
Marisa