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.

Attached Files

autofillauto.xlsx (11.1 KB, 26 views)