Completed

URGENT: Excel 2016 Macro

I need this right now, so if you want to apply please consider start working on it immediatelly after awarded.

I have 1 Excel 2016 spreadsheet with 4 sheets (3 sheets will only be used for this project)

I need a vba macro to compare and take following actions:

The unique key value is in "Documentation" sheet column "D" ("WorkID#").

COMPARE 1:

Compare "Documentation" sheet column "D" ("WorkID#") sheet against "5YP" column "C".

Instructions:

If "WorkID" exists in "Documentation" sheet, then:

update column "E" ("MSPO UID") in "Documentation" sheet

update column "G" ("Project Manager") in "Documentation" sheet

update column "H" ("Phase") in "Documentation" sheet

COMPARE 2:

Compare "5YP" against "Documentation", search for Projects not listed in "Documentation" sheet.

Instructions:

If "WorkID#" (column "C") from "5YP" does not exists in "Documentation" sheet column "D", then:

1) Clear contents and formats in "NewProjects" sheet (Done already)

2) Copy all rows in "NewProjects" sheet (to have a sheet with only new projects listed)

3) Update "Documentation" sheet. Add to the end of existing rows:

write into "Documentation" column "C" ("Site/Function") cell from sheet "5YP" column "H" ("Site/Function")

write into "Documentation" column "D" ("WorkID") cell from sheet "5YP" column "C" ("WorkID")

write into "Documentation" column "E" ("MSPO UID") cell from sheet "5YP" column "D" ("MSPO UID")

write into "Documentation" column "F" ("Name") cell from sheet "5YP" column "A" ("Name")

write into "Documentation" column "G" ("Project Manager") cell from sheet "5YP" column "E" ("Project Manager")

write into "Documentation" column "H" ("Phase") cell from sheet "5YP" column "B" ("Phase")

Full spreadhseet will be provided once the project is awarded.

Skills: Excel, Visual Basic, Microsoft Office, Excel VBA

See more: excel 2000 macro web, convert excel 2000 macro excel 2007 macro, excel comparing macro code, google maps api add marker value, excel vba macro paste adjacent column, data excel sheet macro, excel project macro samples, paste excel vba macro, website add key words search engines, excel vba macro databases, macro script add text file, macro install add ins excel, excel internet macro add, macro install add excel, add additiona value set numbers excel, excel 2010 macro add, urgent excel macro

About the Employer:
( 25 reviews ) Santiago, Chile

Project ID: #20343762

Awarded to:

Aishwaryakumari

Dear Client, I can do this Job. I have excellent experience of Excel (VBA/MACROS/FORMULA'S),Data entry, Web Scrapping and Web Research for more than 4 Year’s. Never ends up until you are 100% satisfied with each and e More

$30 USD in 1 day
(16 Reviews)
3.1

9 freelancers are bidding on average $26 for this job

P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$50 USD in 1 day
(308 Reviews)
7.3
mtdevil369

Hi, I am having good knowledge on excel,micros and VBA module development. I have developed many automation process in excel. I am able to develop your process as well. Please come on freelancer chat to discuss many mo More

$20 USD in 1 day
(120 Reviews)
5.9
peternjoroge37

I am a Professional Accountant and a writer with 6 years of experience in both. Among the areas I am more and comfortable in includes copywriting, technical writing, excel sheets, marketing, Law, Accounting, Architectu More

$20 USD in 1 day
(0 Reviews)
1.9
sophiajaprince

Having completed training in excel, I believe I am the perfect candidate for this job. I am available to begin right away.

$20 USD in 7 days
(0 Reviews)
0.0
NoSonforhim

Hello, I read your project description and understand all. I have rich experience in Excel VBA and Macros. I will make the perfect product what you want. I promise to complete your project within your time and budget More

$25 USD in 2 days
(1 Review)
0.0
sharktiger

Good day! I'm a licensed full stack programming developer and designer. I have many experiences in laravel, wordpress, CI, python as backend. And I had several experiences in angular.js, react.js, node.js, Vue.js, m More

$20 USD in 7 days
(1 Review)
0.0
gazalolubrahim

Portfolio: [login to view URL] Cv:[login to view URL] With a Bachelor’s Degree in Electronic Engineering, hands-on experience creating and implementing software applications, and the ability to d More

$35 USD in 1 day
(0 Reviews)
0.0
sa9076209

I am a senior student taking BS in Computer Science and very inclined in Mathematics. I am very diligent with the projects I do. Rest assured that I don't take any projects that I know I won't be able to finish. Than More

$10 USD in 7 days
(0 Reviews)
0.0