MS Excel VBA Macro

Slutfört Publicerat 5 år sedan Betalades vid leverans
Slutfört 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.

Datainmatning Databehandling Excel Visual Basic Visual Basics för apps

Projekt-id: #19040543

About the project

13 offerter Distansprojekt Aktivt 5 år sedan

Tilldelades:

maguirrer

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.

$80 USD inom 4 dagar
(23 omdömen)
3.8

13 frilansare har lagt bud på i genomsnitt $127 för det här jobbet

rinabuoy13

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.

$100 USD inom 3 dagar
(95 omdömen)
6.1
dvcontact

Hi, You may not select the right candidate without knowing what your project on writing Excel macro enabled RACI chart for documenting the tasks, roles, and responsibilities on a “RACI” worksheet will look like. Fortu Mer

$150 USD inom 3 dagar
(49 omdömen)
6.3
periyannas

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

$211 USD inom 3 dagar
(103 omdömen)
6.2
sloker18

With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and macro/VBA development. I read your project descriptions carefully. I checked t Mer

$150 USD inom 3 dagar
(82 omdömen)
5.8
paulodayto08

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

$150 USD inom 3 dagar
(25 omdömen)
3.8
ravim211071

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

$88 USD inom 3 dagar
(2 omdömen)
1.1
aakuaakash92

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

$111 USD inom 3 dagar
(0 omdömen)
0.0
marjoramirez13

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

$111 USD inom 2 dagar
(0 omdömen)
0.0
Sbd5674

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

$155 USD inom 10 dagar
(0 omdömen)
0.0