Completed

MS Excel VBA Macro

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.

Skills: Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps

See more: excel vba macro paste adjacent column, paste excel vba macro, excel vba macro databases, excel macros, excel vba programming for dummies, useful vba codes for excel, vba excel functions, how to create a macro in excel 2016, vba excel examples, vba excel pdf, use of macros in excel, excel vba macro programming bids, excel vba macro calculate business days, excel vba macro find text morld, generate report excel vba macro, excel vba macro optimization, excel vba macro protect cell, excel vba macro charts, running excel vba macro sql server, excel vba macro scripter

About the Employer:
( 2 reviews ) Lexington, United States

Project ID: #19040543

Awarded to:

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 in 4 days
(10 Reviews)
3.0

15 freelancers are bidding on average $127 for this job

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 More

$211 USD in 3 days
(95 Reviews)
6.1
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 in 3 days
(81 Reviews)
5.9
SShtv

Hi, I am interested in your proposal and I am ready to solve your task. I have a large and successful hands-on experience in processing and analyzing data in Excel, as well as visualizing the data and constructing in More

$150 USD in 3 days
(77 Reviews)
5.9
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 More

$150 USD in 3 days
(74 Reviews)
5.6
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 More

$150 USD in 3 days
(42 Reviews)
6.0
webanis

Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br;

$155 USD in 3 days
(21 Reviews)
4.1
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 More

$150 USD in 3 days
(17 Reviews)
3.6
hassan115781

Hi there! I'm interested in your project. I have read through and perfectly understood the available instruction for your project. My diverse skill set perfectly matches the project. It is my strong belief that you wi More

$88 USD in 3 days
(1 Review)
1.2
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 More

$111 USD in 3 days
(0 Reviews)
0.0
js72c

Hello. I am very pleasure the opportunity to discuss this job with you. I am a full time freelancer with skills and experience on PHP and PHP frameworks, JavaScript and JS frameworks and etc. Especially, I have ex More

$100 USD in 3 days
(0 Reviews)
0.0
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 More

$88 USD in 3 days
(1 Review)
0.7
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 More

$111 USD in 2 days
(0 Reviews)
0.0
$111 USD in 7 days
(0 Reviews)
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 in 10 days
(0 Reviews)
0.0