Tamamlanmış

MS Excel 365 VBA Macro to find data in a list of projects and display results in a different sheet.

Hi. I have an excel spreadsheet with a list of projects and multiple columns with data related to each project.

I need an excel macro running through a button. This button is in a new sheet that I called "Finder".

In an specific cell (called "WorkID"), I should type a project ID number, then execute the button.

The button should search in "Documentation" sheet for the specific project data using its unique identifier called "WorKID"

Master data sheet is "Documentation". it contains a lot of projects and information for those projects

"WorkID" is the unique number of a project

The solution must be implemented in "Finder" sheet (through a button called "Load Data!")

Requirements:

When clicking the "Load Data!" button a vba macro should:

Read "D2" cell to get the WorkID number of a project

Search the project with the specified WorkID in "Documentation" sheet

Get all the information found in "Documentation" sheet for this specific WorkID number (columns "A" to "BA")

Populate data of the identified project (in sheet ("Finder")).

Cells "F6" to "K6" should be updated using the corresponding colors in Columns "BC" to "BH" in sheet "Documentation"

Considerations

- An example of the expected result is provided in the ""Finder" sheet

- Data populated in column "D" must have the same format (background colors, etc.) as it is in "Documentation" sheet

- Be carefull in cell "D39", it is a result of a VLookup function (see column "AI" in "Documentation" sheet). It should also have same background color and format.

Other

- The excel spreadhseet will be provided once the project is awarded.

- Macro solution cannot be password protected so source code is available.

Beceriler: Excel, Visual Basic, Uygulamalar için Visual Basic, Veri İşleme, Veri Girişi

Daha fazlasını gör: excel word vba macro example, excel macro copy paste data list websites, download historical stock data excel vba macro, select printer excel using vba macro, excel vba macro copy columns data, excel vba macro download yahoo stock data, vba macro paste excel data, excel pivot vba macro jobs, macro liking data ms excel, read webpage data excel vba macro, vba macro data entry txt file, vba macro data excel word, excel 2003 vba data list, excel macro data list, convert excel formulas vba macro, excel 2010 vba import data access, excel copy vba macro, excel 2007 vba macro programming

İşveren Hakkında:
( 31 değerlendirme ) Santiago, Chile

Proje NO: #26380625

Seçilen:

nilud

Hi, Can you give me some example file ?, I can give you an excellent solution , I have more than 20 years working experience VBA and programming. Can you come on chat for discuss this ?, are u online now ? Thanks N Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(8 Değerlendirme)
2.9

Bu iş için 20 freelancer ortalamada $22 teklif veriyor

mtdevil369

Hi, Greetings! ✅checked your project details :MS Excel 365 VBA Macro to find data in a list of projects and display results in a different sheet. ✅Completed Time : 24 hours or your requirement deadline . I would like Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(281 Değerlendirme)
6.8
rashedkhanrubel

Hi, I will make finder in excel using Visual Basic code as per your requirement with good and professional quality without any error. I have completed more then 200 project within 1 Year with 5 star review. You are gen Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(204 Değerlendirme)
6.4
AnowarRatul

Hello sir, I have read your project details carefully and understand it clearly. I have done this type of projects before. I can make a VBA Macro to find data in a list of projects and display results in a different sh Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(143 Değerlendirme)
5.7
reubengi

Hi there, I have good excel VBA experience and can create the macro tool to get the WorkID related data. Regards Reuben

$30 USD in 2 gün içinde
(18 Değerlendirme)
4.8
raoarslan56

I have completed many jobs related to the given description. I have a strong grip on MS Excel (VBA, Advance Filter, MACROS, Pivot Table, Vlookup, Hlookup, Data Validation, Conditional Formatting). You can check my revi Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
3.2
Jayant222

Hi there, I am an expert in this . I have gone through the project description and can help you on this project. Thanks, Jayant

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)
2.3
abdelhameed221

I can do it for you, I'm a professional Excel user with high speed, accuracy, and creativity. I've got a lot of experience in data entry and I'm familiar with this kind of project. Delivering on-time guarantee, I want Daha Fazla

$10 USD in 2 gün içinde
(2 Değerlendirme)
1.7
tanvirlxm

Hi, I read and understood your project requirement & interested to work for this project. I will start right now. Although I am new in freelancer, I can complete this project by the timeline. Please send a message so w Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
1.5
Hadaetullah2000

Hello there, I think I can so your job properly. You can hire me.. As I am new in freelancing. but I can do your project. Thank you

$15 USD in 2 gün içinde
(0 Değerlendirme)
0.0
rohitraut480

i m ready to do your wrok withn 7 days

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
Tuphanchorae

Dear manager I read your project proposal and it is matching with my skill. If you do not hesitate you can give me. I can start it as soon as possible. Further conversation can be done after your decisions. I am intere Daha Fazla

$25 USD in 5 gün içinde
(0 Değerlendirme)
0.0
Kchhatresh99

What makes me better than others is my punctuality and honesty. I would never accept a job proposal until I'm confident of making it successful.I am very much skilful with Microsoft Excel and Word. Relevant Skills and Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
rimonever493

Hello, I read your post & I believe I am perfect for the job you requested. I am new for this freelance sector but I respect any work.I have 4 yars data entry experience with ms word,excel & power [login to view URL] you select Daha Fazla

$12 USD in 2 gün içinde
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
umerwaheed0348

I will do your project in 2 days I have an expert team that has a lot of experience in these fields if you want better result then hire us thanks

$20 USD in 7 gün içinde
(0 Değerlendirme)
0.0
eusufnobi7

Dear Hiring Manager Take my great respect at first. As a Full Data Entry. I would highly to give me this project. Over the last 5 years, I have been working as a full data entry. Many Data Entry during this time. Aft Daha Fazla

$30 USD in 5 gün içinde
(0 Değerlendirme)
0.0
abdelrahmanA20

I have a great experience in data entry and can finish it faster than you think IAM abdelrahman Ahmed saied from Egypt

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
mrofiqul09

Hi I am specialist on data entry. I have done many data entry work. I can entry any data very fast without error. I am very hard worker and have enough time to work. Please select me for this job. If you select me for Daha Fazla

$10 USD in 2 gün içinde
(0 Değerlendirme)
0.0
Nabeelinayat07

Hey, I am copy writer and more than 8 year experience of data entry. I am currently accountant in govt project. I have more than 7 year experience of office job to handle reporting and other through MS Office. i have Daha Fazla

$15 USD in 7 gün içinde
(0 Değerlendirme)
0.0