dilipramadas
11-14-2010, 03:54 AM
Hi all,
I have a repetitive task every month where I've to copy 30 files to another folder and rename the file with current month name. Once done, then i open each file to make more changes to the format, formulas (which show month on month, year on year, quarter on quater variance), month name in 5 sheets. It takes me more than 5 hours to make the changes.
every month i do this thrice. is there a better way to reduce the time taken and increase the efficiency?
thanks in advance.
:banghead:
I have a repetitive task every month where I've to copy 30 files to another folder and rename the file with current month name. Once done, then i open each file to make more changes to the format, formulas (which show month on month, year on year, quarter on quater variance), month name in 5 sheets. It takes me more than 5 hours to make the changes.
every month i do this thrice. is there a better way to reduce the time taken and increase the efficiency?
thanks in advance.
:banghead: