Visual Basic Jobs

Hello, i have some problems that needs to be solved today asap. More info will be given in chat

I want to create an excel dashboard in vba. I am looking for an vba expert from Mumbai. All the payments will be done via freelancer.com only.

Hi I need some VBA code to return a maximum value from a column in a closed Excel workbook. The source file name and path is in a named cell "Data_FilePath" in the application workbook and the value would be returned to another named range in the application workbook. The full file path cannot be hard coded into the VBA as the file names and paths change for different entities/departments. I have been using the the MAX function in the destination cell but this does not now suit as the names/paths change.

Look to dump data from a Google forms website (CSV) into a excel workbook with an active sheet for each client, that will automactically move the data from the data dump sheet to each clients seporate active sheet. The data includes billables, printing costs, credit card charges, etc.

Hi Freelancers. I attach 2 files, a vídeo showing the task and the file that needs the macro. I simply want to make all lists "level 1" or father, continuous... Please dont copy paste, or I will ignore your bid...

Report Printer with QR Image Purpose The motivation behind this project is that new regulation in my country demands that there is a QR image that contains invoice details. The current programs running in our company is dos based and will be difficult to add QRs with the government regulations into. Goal The program will take a tab delimited text file from a directory, The application should capture this text file and populate a report and put the dynamic QR into. And save this pdf to the system and send it directly to printer. Type of program Running as a service in the background with logging such as if error occurred, if file is found, etc …. With time stamps This program should be installable on many devices and have a conf file to specify some items such key and director...

data input IP info entry excel edit. see the attached for details.

Objective= I have macro which needs to modify the logic to add some new feature , its very simple modification. message me i will provide the macro.

I need some vb.net code that will read an XML document using XMLReader and parse out the following elements from the link at the bottom: PMID ArticleTitle Combine all AbstractText elements of Abstract into one variable loop all elements in MeshHeadingList MeshHeading and make into a comma separated string ie: "Antineoplastic , adverse effects, therapeutic use, Precursor B-Cell Lymphoblastic Leukemia-Lymphoma" loop all elements in KeywordList Keyword and make into a comma separated string ie: "L/D-amino acid, RNAi, cancer, chirality" from ,33022057,33868789&retmode=xml Multiple documents are all pulled at the same time. I need the code to loop each xml document and write the 5 variables; PMID, ArticleTitle, Abstract, MeshHeadingList and KeywordList. Thes...

i need the excel automation expert for multiple jobs. Details will be discussed.

i need the excel automation expert for multiple jobs. Details will be discussed.

i need the excel automation expert for multiple jobs. Details will be discussed.

Google sheet macro expert needed for multiple jobs. Details will be discussed

Google sheet macro expert needed for multiple jobs. Details will be discussed

I have a large excel sheet that is already pre-formatted with some documentation based on inputs on a "data" tab. However, I also import tables from my metabolic cart and a separate heart rate variability app. Once imported, I need to manually work with the data to create the charts because some athletes go shorter and others go longer, so I'm always adjusting the input row length based on their test duration. I'm looking for a solution where I can paste these CSV tables into one excel document, set a few parameters (e.g., I want the "time" column auto-split into 3 minute segments, or 4 minute segments, etc.) and then I want that data pulled so I can get a minute by minute average, plus stage average for every 1, 3, or 4 minutes, whatever time length I spec...

Can you automate your task using PAD? Example. Open excel, update month, unhide tabs, change data in a cell, copy values in a column paste it as value to a column in another cell, click on hyperlink inside excel, input variable on browser field, wait till data loads, extract as excel, copy data from extract to open file?

My project name bank reconcilliation . Bank statement text formate convert to excel and sepret debit credit entry with macro

Having 7 plus of experience in developing macros

I need a VBA excel expert for an advanced job need to be done in 3 weeks and it basically extracts all codes and function done in an excel sheet and converts it into python functions job deadline: maximum 3 weeks salary: 500-750$ for not wasting time only experts bids

This isn't a really tough one I guess, but I am not able figure out how to do this as I am not an excel expert. I need to create a Pivot which looks like the table in the "Requirement" tab of the excel sheet uploaded on the below link I managed to add my Pivot table in the "Data and Pivot" tab, but I am struck at the below step - request you to help. Adding "% pending" column as an additional column Note that I tried "Calculated Field" option, but since the "Completed" and "Pending" columns in the Pivot are not the actual columns themselves but are column cell values represented as columns, I am not able to add the "% Pending" column as "Calculated Field" I am able to "Show Value as" "...

Work is only to pull out data from nse option chain or of open intrest and put into into Excel sheets .. And that I need is of real time in nifty and how much calls and puts are bought and also plotting of data in numbers and as well as in line graphs For refrence I have uploaded some files.

For travel company back end work, we need automation of excel sheet that can capture data in form of different components to calculate total cost. I have attached excel sheet that we use to calculate the tour cost...we feed different rates like hotels, transport, meals, guides etc etc to calculate per person cost. doing manually takes time, so if automation is possible by uploading the data in form of cvb files..and then we can just choose what is needed.

For travel company back end work, we need automation of excel sheet that can capture data in form of different components to calculate total cost. I have attached excel sheet that we use to calculate the tour cost...we feed different rates like hotels, transport, meals, guides etc etc to calculate per person cost. doing manually takes time, so if automation is possible by uploading the data in form of cvb files..and then we can just choose what is needed.

Please see attached for detailed brief.

I have setup remote temp readings that update in excel every second. When the internal temp reading in Col C equals the external temp in col E, the corresponding row in col G will highlight as a match and display the property and room where the match exists. I would like to know if it is possible for VBA code to be applied to do the following: Scan/loop Column G and if the row is not blank to take the output and send via telegram as an alert system. As the temperature moves a lot I would only like to be alerted once every hour but would prefer to leave the possibility of having this as a variable setting eg. every 5,10,15.20 mins linked to the excel document should I wish to change it. Must be flexible if I was to add additional columns so that the overall code is not interrupted.

Se requiere modifica macros excell utilizadas para imprimior etiquetas de precios. Las macros estan funcionandol pero cambio el requerimiento del formato de impresion. son 10 macros y la modificacion debe aplicarse a todas. Hay que cambiar 5 formatos. El archivo adjunto muestra formatos actuales y el cambio requerido para cada uno

EXPERIENCED USING VBA AND SCRAPING A DYNAMIC WEBSITE. must be within 3 hours of eastern standard time zone

I need someone advanced in Excel to help me with my Excel training and project! Please only serious bids!

I need a visual basic expert for my job

GESKE model the information is attached to the file. PLEASE make sure that you read well through it and that you can do it before contacting me. Thanks, and i cannot wait to work with you

I need to get the formula on percentage

We have an excel file that has info in and want this as a DB within access. We would like to have a scenario where we input information into excel and then a macro or coding to send this to the access DB. i have included the excel spreedsheet and we only need to use the second tab for onboarding candidates The form must have information surrounding the record and also provide various reporting this is an urgent project and will need it completed in 1 day

The project is about product analysis plus preparing data for power bi using macro(S) and lastly report.

The project is about product analysis plus preparing data for power bi using macro(S) and lastly report.

Need help in creating an Excel workbook for a small company to manage its budget, cost, revenue. I already have a template to build from.

I am looking for a data collection form with conditional fields, once form is filled the data needs to be exported to excel and xml file, no connection to database is required Need this in VB.net

Converting 32-bit excel spreadsheet to 64-bit This is now a freeware download and I don't know if this can be modified @The24CarrotsIncPrabhakar G. @The24CarrotsIncidified

Hello, I have files.I need fix some it within Excel,power apps.I will share more details.I need you are expert.I will share only selected person .do you know power apps & Excel. deadline 24 hrs Thank you

Redesign the ui of a VB.net project

This is an Excel 2021 Microsoft Office 365 template called "bill paying checklist". I'm trying to figure out what function(s) I would use to automatically subtract the bill amount (for example, $50 in cell H4) from my Total Bills amount (for example, SUM(H4:H47) in cell H48, let's say $200) after I insert a checkmark in any cell in column K (by double-clicking). Value for checkmarks = 1. The result would indicate how much I still owe in cell J48; thus, if all bills are check-marked the result should be $0. Thank you!!

necesito ayuda con una configuracion de excel

Hello, I have files.I need fix some it within Excel,power apps.I will share more details.I need you are expert.I will share only selected person .do you know power apps & Excel. deadline 24 hrs $30 max. Thank you

I am looking for a VBA programmer who can work Mon to Sat 10-6 PM EST time. Your English should be good. And you need to be very good in VBA and excel automation. Its not a one time project, You will work for us ongoing on our all excel VBA projects. Only serious VBA programmers.

Full time VBA programmer who can work Mon to Sat, 10 AM EST to 6 PM EST. Your English should be good and you should be very good in VBA and excel automation. IF you can;t work in this timeframe, then dont bid. Only experienced person, no time wasters. Its not a one time project, You will work for our company as a full time Employ and we can pay weekly/Monthly. You need to work on different projects.

Hello, i have a visual basic website combind with php and need some help with some functions. More details will be given in chat

Dear Freelancers. I have one excel sheet where I need to apply vlookup from second file. I will give you formula as well. you need to just paste that formula. In one sheet I have 1lac 50k rows and second has 8lacs data. I will give you formula as well. My system is working very slow. Remember if you high configuration system then apply otherwise you will be irritate. but work is very simple.

I am looking for an Excel expert to help me for developing my current Excel file to a more advanced file for extracting data from RAW data and developing a base-line correction equation for the raw data. Only those who know about base-line correction on Excel express their interest.

I would like to create a visual of real time from microcontroller and populate on excel

Need forms created accessible on mobile devices to populate existing Excel templates. For use as daily register. Example of templates to populated provided. Need excellent Excel knowledge to streamline set up.

Want to create a leave tracker in MS forms. that will also have approval/ rejection leave from reporting manager. and what to save its data on excel.