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!")
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"
- 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.
- The excel spreadhseet will be provided once the project is awarded.
- Macro solution cannot be password protected so source code is available.
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
Bu iş için 20 freelancer ortalamada $22 teklif veriyor
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
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
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
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
Hi there, I am an expert in this . I have gone through the project description and can help you on this project. Thanks, Jayant
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
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
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
I have a great experience in data entry and can finish it faster than you think IAM abdelrahman Ahmed saied from Egypt