Microsoft Office Forums Macro to automate Roster file refreshes based on a status value

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-22-2019, 12:40 AM
Tphil413 Tphil413 is offline Macro to automate Roster file refreshes based on a status value Windows 10 Macro to automate Roster file refreshes based on a status value Office 2016
Novice
Macro to automate Roster file refreshes based on a status value
 
Join Date: May 2019
Posts: 18
Tphil413 is on a distinguished road
Default Macro to automate Roster file refreshes based on a status value

Hey Forum,



I need some help with writing a series of macros to automate the refresh of HR information in my Roster-Payroll file. This file is used to track all filled and open roles including salary and other relevant information about the position (PID) and the employee that occupies that role (EID). The file is refreshed weekly with updated information from our HR systems. Currently these refreshes are performed manually and are time consuming and prone to error. Rather than a mass update, I want the ability to refresh a row at a time so I can review before I refresh. Thinking of linking the macro to a key stroke trigger to activate. The file has a status column that will dictate what the macro should do based on the status value. Just place your cursor in the status cell and activate the macros to refresh the row.

I've included a lot more detailed macro information in the attached example file. Note: All test data is fictitious, but the format of the file is identical to the real file I am trying to automate.

Thanks - any and all help is appreciated!
Attached Files
File Type: xlsx Example B.xlsx (496.7 KB, 5 views)
Reply With Quote
  #2  
Old 07-22-2019, 11:11 PM
Tphil413 Tphil413 is offline Macro to automate Roster file refreshes based on a status value Windows 10 Macro to automate Roster file refreshes based on a status value Office 2016
Novice
Macro to automate Roster file refreshes based on a status value
 
Join Date: May 2019
Posts: 18
Tphil413 is on a distinguished road
Default

Seems like a lot of lookers but no takers. Please give me feedback why I may not be getting any interest in my post. Is this request too involved, should I simplify or break it up.? Hoping someone out there can help!
Reply With Quote
  #3  
Old 07-25-2019, 09:43 AM
NoSparks NoSparks is offline Macro to automate Roster file refreshes based on a status value Windows 7 64bit Macro to automate Roster file refreshes based on a status value Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 743
NoSparks will become famous soon enoughNoSparks will become famous soon enough
Default

Quote:
Seems like a lot of lookers but no takers.
Views of the thread aren't necessarily people able or willing to assist. Could be Google searches including things like vba, macro, roster and automation returning a link to this thread.
The views/downloads of the attached file would be more indicative of those that may be interested in helping.

Quote:
Please give me feedback why I may not be getting any interest in my post.
Your post starts "I need some help with writing a series of macros to automate ... ", then
has an xlsx file and nothing that would indicate any attempt to write the macro yourself.
Doesn't come across as a request for 'help with... ', more like an order for a complete macro solution.

Quote:
Is this request too involved, should I simplify or break it up.?
You'll need to break it up within your macro regardless.
Reply With Quote
  #4  
Old 08-01-2019, 07:15 PM
Tphil413 Tphil413 is offline Macro to automate Roster file refreshes based on a status value Windows 10 Macro to automate Roster file refreshes based on a status value Office 2016
Novice
Macro to automate Roster file refreshes based on a status value
 
Join Date: May 2019
Posts: 18
Tphil413 is on a distinguished road
Default

Actually I successfully wrote the macros myself. Thanks for the feedback. Solved
Reply With Quote
  #5  
Old 08-02-2019, 07:43 AM
NoSparks NoSparks is offline Macro to automate Roster file refreshes based on a status value Windows 7 64bit Macro to automate Roster file refreshes based on a status value Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 743
NoSparks will become famous soon enoughNoSparks will become famous soon enough
Default

Quote:
Originally Posted by Tphil413 View Post
Actually I successfully wrote the macros myself. Thanks for the feedback. Solved
That's great.
Was pretty sure you could.
Fairly straight forward once you break it down and address the individual requirements one at a time.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show/Delete paragraph based on checkbox status mahaabub Word VBA 1 05-13-2019 05:33 PM
Late status based on end date gerhardstru Project 0 08-03-2018 01:09 AM
Automate word based on questionairre krishnamurthy.ka2810 Word 1 04-16-2018 03:51 PM
Macro to automate Roster file refreshes based on a status value Hide/Show text based upon check box status nathan.gray@emerson.com Word VBA 5 12-08-2017 01:08 PM
Macro to automate Roster file refreshes based on a status value Checking ref # status based on sheet2 ref #. aligahk06 Excel 1 04-26-2010 11:22 PM


All times are GMT -7. The time now is 08:19 AM.


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