Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-03-2013, 06:33 AM
Parkiee1981 Parkiee1981 is offline Autofill Automation Windows 7 64bit Autofill Automation Office 2007
Novice
Autofill Automation
 
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, 24 views)
Reply With Quote
  #2  
Old 03-04-2013, 06:46 AM
OTPM OTPM is offline Autofill Automation Windows 7 32bit Autofill Automation Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 03-15-2013, 10:39 AM
KsT KsT is offline Autofill Automation Windows XP Autofill Automation Office 2007
Novice
 
Join Date: Nov 2010
Location: Northeast
Posts: 10
KsT is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 03-15-2013, 01:19 PM
Parkiee1981 Parkiee1981 is offline Autofill Automation Windows 7 64bit Autofill Automation Office 2007
Novice
Autofill Automation
 
Join Date: Nov 2012
Posts: 2
Parkiee1981 is on a distinguished road
Default

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!!!!
Reply With Quote
  #5  
Old 03-15-2013, 01:24 PM
KsT KsT is offline Autofill Automation Windows XP Autofill Automation Office 2007
Novice
 
Join Date: Nov 2010
Location: Northeast
Posts: 10
KsT is on a distinguished road
Talking You're welcome

Glad to be able to help, Parkie1981
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autofill Automation Autofill a form which is contingent on a dropdown selection. biffle0764 Word 2 05-09-2012 12:54 PM
Autofill Automation E-mail address AutoFill Emerogork Outlook 3 07-17-2011 03:44 PM
AutoCorrect Or AutoFill Johnny thunder Outlook 0 05-02-2011 03:37 PM
Autofill Automation address box autofill outlook 2003 simpo067 Outlook 2 11-30-2010 10:12 PM
Autofill Automation Need cells to autofill with color Silver Rain 007 Excel 1 10-22-2009 08:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:27 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft