MS Excel VBA Macro
$30-250 USD
Betalades vid leverans
Epic
As a project manager I wish to have a macro enabled RACI chart where I can document the tasks, roles, and responsibilities on a “RACI” worksheet. On a “Role” worksheet, a list of names, roles, email addresses along with other personnel information is entered. On an “Email” worksheet, the results of the macro would be displayed in four (4) categories; “Responsible, Accountable, Consult, Include” in a copiable field next to each. When the project manager clicks on a task in the RACI tab then clicks on an email list button, the macro will find all roles associated with each of the four letters R, A, C, I in the columns associated with that row then build a respective list of email addresses separated according to each of the four letters on the Email tab. The project manager will then be able to copy the desired field per the category and paste it into his MS Outlook email address window.
User Stories
As a project manager, I wish to be able to change to order of the steps by changing the step number then resorting them with a pulldown tab at the top (existing).
As a project manager, I wish to be able to add roles to the RACI worksheet and not require any macro recoding for normal functionality.
As a project manager, I wish to see coded colors when R, A, C, I letters are selected in the fields of the RACI worksheet (existing).
As a project manager, I wish to be able to add a virtually unlimited number of tasks under the TASK column of the RACI worksheet without any recoding of the macro for normal functionality.
As a project manager, I wish to be able to add additional personnel to the Role worksheet without any recoding of the macro for normal functionality.
As a project manager, I wish to be presented the Email list worksheet as a result of pressing the email list button.
As a project manager, I wish to see the associated task placed in the field labeled “Task” in the Email worksheet as a result of pressing the email list button.
As a project manager, I wish to be able to name the workbook different names without any recoding of the macro for normal functionality.
Projekt-id: #19040543
About the project
Tilldelades:
Hello, I can help you with this project, please send me a message with some details like why you said about "macro recording", so I can start working on it inmediately.
13 frilansare har lagt bud på i genomsnitt $127 för det här jobbet
Hello, I am independent, experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. I am a certified PMP since 2012 and its valid till 2021. Willing t Mer
Hi Good Day! I've done a lot of work like this one before. I can help you to complete this project with high quality. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool t Mer
hi there I am an excel expert. I have done a number of project on macros and VBA. recently completed a macro on warehouse data entry and data management. earlier last week did an VBA code to automate downloading of dat Mer
Need Work Done? Post Your Project Now & Receive Competitive Quotes in Minutes. 14M+ Jobs Completed. 30M+ Trusted Users. 60 Second Quotes. 24/7 Support. Save Time & Money. 95% Rehire Rate. Services: Graphics & Design, W Mer
I'm writing to apply for the job post. Fast, excellent, and trustworthy! I am good and resourceful Virtual Assistant. I have a great experience in Data Entry, research and process related tasks.I am skilled and ver Mer
Hi, I am Sami B. an experienced developer in VBA for Microsoft Excel macro programming, I understood your request and I am glad to work on your project. BR