Visual Basic for Apps Jobs

I currently work with a personal excel workbook and I want to be able to share this file with certain colleagues but there is certain information that I don't want them to be able to see. I have a very simple macro that when executed asks for a password to hide certain sheets of my excel (3 sheets) while leaving the other ones open and protected, except 3 sheets that I want my colleagues to work on. This works fine. BUT I WANT TO ADD to this same code a macro to hide and protect all the rows that in column "F" contains "Repartos" and "Facturas" only in my sheet named "transacciones". The sheet "transacciones" is a very long database (currently working on row 33293 and counting, so I want this to be smooth when I run the macro. There i...

I’m looking for a freelancer to help me create a Visual Basic for Applications (VBA) code for a game of poker that can recognize flushes and all. My goal is to have an output that would code the playing results, which would include a final table for the winner and a summary report of the game. To do this, I would like the freelancer to use a data structure of linked lists and stacks, and I would like the results to be able to be saved after the game. I’m looking for someone who is experienced in coding and with VBA coding in particular and who can produce a code that will meet my needs and requirements.

We’re looking develop formulas and a macro to reformat a document for our regular data import process. We receive a report from a partner organization on a daily basis and regularly need to reformat and upload the ticket data into our system. These are the basic requirements to make the sheet ready for our import: • Partitioning the Name field provided into First, Last, First 2, Last 2 columns • Partitioning the Csz column into separate city, state and postal code columns • Removing foreign country zip codes • Adjusting zip codes that start with 0 (the file does not include the 0 if it’s the leading number) • Removing extraneous columns • Removing rows with missing seats/seat locations • Partitioning the Seat Location column into Secti...

I am looking for an experienced VBA Excel programmer to help me with a project that requires data entry automation. The project is of an intermediate complexity, but I need the programmer to incorporate user interaction and feedback into the task. The project must be completed in a quality and efficient manner. Depending on the programmer's skillset and abilities, additional tasks may be added to the project. If you are interested in tackling this project, please contact me for more details. Thanks for your time!

We are looking for an experienced Excel VBA developper to create a Cutting stock optimisation Macro in excel. The goal of the project is to develop an efficient algorithm that sorts and maximizes the uses of our stock based on parts required. The objective is to take in data on Line 10. Sort the parts in order to maximize the bars (220) Output data on line 17 to 47. There are special parts that need to be marked as special after the output. The algorithm should handle up to 30 full bars or up to 150 parts. I want the code to run on one click of a button. The idea is similar to this: Thank you

I am in need of a VBA developer with webscraping skills to create a VBA macro for a project. The VBA developer should have intermediate level expertise and be proficient in MS Excel VBA. The project involves building an automated VBA macro that can scrape data from the web, extract it and store it in a suitable format. The macro should be able to pull data from multiple webpages and process them efficiently. Additionally, the macro should also be able to parse HTML documents, identify useful data and process them accordingly. The desired outcome is a program that can be used to robustly scrape data from the web in an automated way, and store it in the desired format. The project requires the developer to apply their skills to create a customised product with an adequate user interface ...

I am looking for a VBA developer to help me create poker hands for my project. It will be modeled after the game Texas Hold'em and will require the development of a suit class to help display the hand strength. On top of that, manual review will be used to analyze the hands, without relying on probability-based analysis or optimal strategy determination for this project. This project is time-sensitive, so the ideal candidate should have some experience with poker programming. I'm looking forward to working with you!

I need an excel Gantt chart that updates from a table that has recurring tasks. I need the chart to be a visual aid to interpret the data from the table. I record dates of start and finish in the table via App sheet and then. Ideally if it could also overlay a forecast i create too. its for management of a grazing cattle farm, there will be 16 paddocks ( which would be like tasks on a normal gantt chart) There is also approximately 7 mobs of cattle. attached is a copy of the data and a rough layout of the gantt chart. The different colours on the chart represent different mobs of cattle. The numbers on the chart are to help me analize how many days since the cattle left the paddock. The date out column in the data needs to automatically update to represent when that mob moves to a new padd...

I need vba expert who will design my excl font page as my sample with data scraping from yahoo

Open my excel spreadsheet and picture. Example - 1. Mark “ B2 ” DIA as 25 but “PAP” is 32 x 25 ELB (THAT IS WRONG TYPING ) When I type incorrectly in the pap area, the "ELB" must appear in red. (like this “ 32 x 25 ELB “) Pipe DIA and ELB must have the same first letter; if the letter is not the same, it needs to be changed to red. (see my picture) Example - 2. Mark "B8" has a diameter of 25 but "PAP" has a size of 25 x 25 x 32 (WRONG TYPING ) When I type incorrectly in the pap area, "BULL TEE" should appear in red.. (like this “ 25 x 25 x 32 “) Pipe DIA and Bull Tee's Last Letter must be equal; if not, it must be red. (see my picture Can you do all rows in excel vba

I am looking for a VBA Expert who can help me with a project that requires coding macros. I have a specific goal in mind that needs to be achieved and I would need the expert to work on it for 1-3 days. The right candidate should be good at Excel and have experience with dashboard generation. The below is the sample project requirement. You will be interviewed based on your performance to provide resolution to below illustration. Whomsoever- want to apply create the macro in attached file ''compare data" two data and bring difference in other tab. It should be professional and can use dashboard or chart..

I am looking for a freelancer to create a VBA code to create charts and do complex math calculations. This project is for personal use, and I require an advanced level of complexity for the code. The project must be done in VBA and no other programming language. If you think you are the right person for this job, I'd love for you to apply.

first page complete with the ability to add stocks. I provide the template. You have one sheet stock symbol graph. I asked for a separate tab or many tabs. When you add a stock new tab of monthly, yearly 1,5,10 years of data. Look at my example file attached.

Skills Required: - VBA - SQL - Any automation skills preferred! (python, google apps scripts) Deliverables: - develop an excel reporting solution that connects to our data warehouse and updates a set of charts and tables that we will work together to design. - we need to be able to automatically generate copies of this report for delivery to multiple clients, where the only difference is the data table connection (within the same database). Scope: - initially, we will develop 1-2 reports for a trial period. following that period we have up to ~30 excel templates that will need development, and may have additional opportunities for adjacent automation development work. When applying: If possible, please include an example excel report that you have developed in VBA that would allow for r...

Necesito optimizar mi gestor de correo electrónico Outlook 2010 y necesito que me desarrollen un par de Macros que agilicen el trabajo de envió y respuesta de emails. mas detalles en el momento que elija el desarrollador que lo pueda hacer.