Terminé

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.

Compétences : Excel, Visual Basic, Microsoft Office, Excel VBA

en voir plus : 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

Concernant l'employeur :
( 25 commentaires ) Santiago, Chile

Nº du projet : #20343762

Décerné à:

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 Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(16 Commentaires)
3.1

9 freelance font une offre moyenne de $26 pour ce travail

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(308 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(120 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1 Évaluation)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0