Autofill Automation
Hello,
Not really sure what to call the post/thread but I guess I am trying to work out a way to automatically autofill lots of cells so Autofill Automation makes sense.
On a weekly basis I have to compile my departments performance figures. 170 employees over 12 teams in 3 sections.
When i pull the data i have 186 names that I have to use the autofill action on (dbl clicking the bottom right corner of the cell).
This takes some time doing it individually and was wondering if there is a shortcut or a macro i need to create to help me do this automatically.
I have added a sample worksheet to show what i have and what i end up with after many minutes of boring manual labor.
Any help would be greatly appreciated.
Thanks
Stuart.
|