Suoritettu

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.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Visual Basic, Visual Basic for Apps

Näytä lisää: 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

Tietoa työnantajasta:
( 2 arvostelua ) Lexington, United States

Projektin tunnus: #19040543

Myönnetty käyttäjälle:

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 4 päivässä
(10 Arvostelua)
3.0

15 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

$211 USD 3 päivässä
(95 arvostelua)
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 3 päivässä
(81 arvostelua)
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 Lisää

$150 USD 3 päivässä
(77 arvostelua)
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 Lisää

$150 USD 3 päivässä
(74 arvostelua)
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 Lisää

$150 USD 3 päivässä
(42 arvostelua)
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 3 päivässä
(21 arvostelua)
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 Lisää

$150 USD 3 päivässä
(17 arvostelua)
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 Lisää

$88 USD 3 päivässä
(1 arvostelu)
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 Lisää

$111 USD 3 päivässä
(0 arvostelua)
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 Lisää

$100 USD 3 päivässä
(0 arvostelua)
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 Lisää

$88 USD 3 päivässä
(1 arvostelu)
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 Lisää

$111 USD 2 päivässä
(0 arvostelua)
0.0
$111 USD 7 päivässä
(0 arvostelua)
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 10 päivässä
(0 arvostelua)
0.0