I made a roster and I would like that every week I use a macro to renew
the main format (up till here I can do) of the roster and it will
automatically transfer all totals (ie: leave taken, extra/over time,
etc) onto a different worksheet/file.

So, every week it will send (via the macro) previous data and save it
onto a different location so that at the end of the month/year/period I
can view totals to see how much leave, extra/over time people have taken
so I can calculate the payroll.

Any ideas?


--
pisanichris
------------------------------------------------------------------------
pisanichris's Profile: http://www.excelforum.com/member.php...o&userid=28138
View this thread: http://www.excelforum.com/showthread...hreadid=476525