#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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!
|
#3
|
|||
|
|||
Quote:
The views/downloads of the attached file would be more indicative of those that may be interested in helping. Quote:
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:
|
#4
|
|||
|
|||
Actually I successfully wrote the macros myself. Thanks for the feedback. Solved
|
#5
|
|||
|
|||
Quote:
Was pretty sure you could. Fairly straight forward once you break it down and address the individual requirements one at a time. |
|
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 |
Hide/Show text based upon check box status | nathan.gray@emerson.com | Word VBA | 5 | 12-08-2017 01:08 PM |
Checking ref # status based on sheet2 ref #. | aligahk06 | Excel | 1 | 04-26-2010 11:22 PM |