Thread: [Solved] Autofill Automation
View Single Post
 
Old 03-03-2013, 06:33 AM
Parkiee1981 Parkiee1981 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Nov 2012
Posts: 2
Parkiee1981 is on a distinguished road
Default 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.
Attached Files
File Type: xlsx autofillauto.xlsx (11.1 KB, 26 views)
Reply With Quote