Glad you asked.
You see the excel is system generated. Originally the spreadsheet would look like the one I had attached except without the NAME column which I had manually added. And the Template column is updated on a weekly basis depending on the transactions.
Because I know all the locations by heart I had added the Name column and simply jotted down the names (Assignees) according to the locations they work on. My problem is that I have to regenerate the excel every week (maybe less) to show the assignees their work progress and I have to write the name column every time which is boring b/c sometimes the lines sometimes reach more than 5000. Is there any better way to do it in the long run? I hope it's clear now and I really don't know that much when it comes to excel and your help would be much appreciated.
|