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)

Hi
If I understand you correctly you need to consolidate multiple datasheets into one summary sheet. If there are only ever 5 sets of data per person I would suggest that you have a Master Worksheet setup that contains links to each persons five sheets of data sheets. That way as soon as they update there data sheets your Master sheet updates automatically whether it is open or not.
For this to work the location of the Master and User Workbooks need to be on the same network constantly.
If you need any help setting this up let me know.
Good luck.
Tony

Parkie1981 re:Autofill Automation - If you are only trying to fill the name down for the 5 performance areas, try this.
1)Add a new column at A, numerically autofill all of the rows in column A (relevant to your data).
2)Sort by column B (Name# column)
3)at the first row with a blank in the name# column type = and point to the cell above, copy this formula to all the other blank cells in column B.
4)Resort by column A. The name# column now appears like your Finish example.
5)Copy column B, Paste Special, Values (overwriting the column).
6)Delete column A (sorting column) and you are done.
I do this all the time with large amounts of data.

KsT. You my friend are a genius. Im slightly annoyed thst I didnt think abkit that myself!! Thank you so much. You dont know how many hours you have saved me!!!!

Glad to be able to help, Parkie1981