Visual Basic Jobs

1. Create a macro based home page with buttons like - consolidate files , scan files and report 2. On click to consolidation, system opens the upload file option and user selects excel file to upload it. Other file format if used will throw error 3. Upload files will consolidate and throw duplicate row errors (if any) 4. Scan file will give option to user to scan the records in text file. It will handle no record found and duplicate scan error. On submit system will enable generate report button. On this report will be generated based on report selection. All scanned records will be removed from the consolidated file. 3. Generate report will regenerate report of already scanned based on date and show I scanned report with ageing. And alos create summary report date wise - total records c...

Hi, I'm looking for a macro that allows me to retrieve any stock data (Financial statement, Metrics, etc) from Yahoo Finance and Nasdaq. Thanks!

Buenas tardes, estoy buscando un freelancer que sepa trabajar con macros javascript, es para excel online de microsoft 365. Requerimiento principal IDIOMA ESPAÑOL

I have an excel work book with macros that will work on MacOS but not on iOS. I need a quote to fix it please.

I need to alphabetically order a column of cells, however there is data that in other columns that have to change with the order of the cell column that needs to change to alphabetical order. How do I do this?

Already have working GUI software built in Visual Basic but need to further improve same with professional look

i need to apply dpi on vb.net windows application screen resolution for object and font

I want an Excel VBA code to download various reports from GST portal normally GST portal takes 20 minutes to generate a report and thereafter it is available for download but we have seen various software‘s which are downloading GST report instantly I need similar Visual Basic code where in I can send GST number, username, password, required report and period You need to download that particular report in JSON from VBA code. Browser should not open every thing should go in the background Please also check attachment

Lütfen detayları görmek için Kaydolun ya da Giriş Yapın.

I need to alphabetically order a column of cells, however there is data that in other columns that have to change with the order of the cell column that needs to change to alphabetical order. How do I do this?

1. Aparezca una ventana que verifique en la hoja TROZADO la longitud de cada código no sea mayor en 30cm a la indicada en la hoja de TALA, en caso esto ocurra, indicar los códigos y su ubicación 2. En la Hoja LT en el botón “obtener Datos desde Bahia” adicionar a la programacion: 2.1 Que en la hoja “Bahia” los que esten marcados como R (columna K) o se haya ingresado algún valor en la la columna L en la GTF, estos no deben pasar de Bahia a LT 2.2 Aquellas trozas que tengan R o GTF se pinten de color rojo 2.3 Que cada lista tenga un maximo de 7 especies: 2.3.1 Verificar en el campo de “bahía” la primera especie que tiene una “X” y que no tiene ni “R” ni lleno el campo de GTF y buscar las ot...

we need excel excel expert for making automation setup for stock market

Se requiere equipo de trabajo para darle continuidad en desarrollo a una solución para el sector salud en Venezuela, sector privado.

I want to save as file with sales person name and data also available only for that sales person and rest will delete by VBA

Need a VBA developer should have exceptional VBA skills

¿Te gustaría apoyarnos en un proyecto de análisis de macros (Excel VBA) en mira de generar un reporte automatizado para nuestra empresa dedicada al E-commerce y en concreto a la venta por Amazon? Buscamos a una persona que nos eche una mano con el análisis de un documento que contiene una macro para lograr replicar su contenido y que se aplique a una plantilla de reporte para manejo interno. Presupuesto de 5 USD/h - queremos conocerte para revisar la posibilidad de trabajar juntos. Si estás interesad@ y posees Español conversacional, postúlate para concertar una entrevista

FILTER THE DATA AND VISUALIZE BY PIE CHART OR BAR CHART

We have a client who uses a print Macro within Microsoft Word which applies and saves the paper trays. So the user selects the first page which is on company headed paper from a specific tray, then selects the tray for continuous paper and then finally selects a tray for plain paper for a copy. The print macro works for the photocopiers but the client has now purchased HP Laserjet MFP M430 which works apart from the second page for continuous paper doesn't swop over but keeps printing on which ever tray is selected on the first page. The print template and the exportedUI file is available

I want to run NSE website data on excel. Whenever rates changes excel should update same period of time.

I want to run NSE website data on excel. Whenever rates changes excel should update same period of time.

I have a 4 decks and each deck contains 10 parts. And each part contains 5-10 sub parts. So I want to create a excel where if i type a deck number then it should automatically check the stock of the sub parts and it has to show the list of parts that i can produce.

We have a client who uses a print Macro within Microsoft Word which applies and saves the paper trays. So the user selects the first page which is on company headed paper from a specific tray, then selects the tray for continuous paper and then finally selects a tray for plain paper for a copy. The print macro works for the photocopiers but the client has now purchased HP Laserjet MFP M430 which works apart from the second page for continuous paper doesn't swop over but keeps printing on which ever tray is selected on the first page. The print template and the exportedUI file is available

Please find attached spreadsheet for a base of what we are looking for. We need someone to: - add in compounding calculations in relation to debt - add in a graph that reflects information inputed by individual - the spreadsheet to look neat and tidy - including text - the current text looks 'clunky' as we have left spaces for calculations - we need the spreadsheet to be converted to a google docs/drive spreadsheet upon completion of the excel spreadsheet, with a link that creates a copy for an individual and has locked cells - locked cells that cannot be edited by individuals - we want arrows on our lists (data validation lists) to make the individual know it is a drop down. We do not want the client to click the arrow and it select, we want the dropdown to appear. Please se...

I have a bunch of formulas from an old text book I need turned into a spread sheet so I don't have to keep doing them by hand, all formulas need to be interlinked.

I wants service for dashboard preparation

Hacer un excell para el inventario de menaje de un hotel. Donde en la referencia del elemento si pueds hacer click y lleve a la foto.

I am looking for someone to develop and software. Environment: Office 365, Windows Objective of software: Automate the running of commands on excel files automatically. Choose the files that will be executed, Choose the commands that will be executed and need to work on a addon for auto update. I can explain everything in detail for shortlisted candidate. Only highly experienced programmers.

Please do not quote until you understand what needs to be programmed. Need to program three formulas in excel spreadsheet - see attached spreadsheet with detailed explanations

Please do not quote until you understand what needs to be programmed. Need to program three formulas in excel spreadsheet - see attached spreadsheet with detailed explanations

We have a client who uses a print Macro within Microsoft Word which applies and saves the paper trays. So the user selects the first page which is on company headed paper from a specific tray, then selects the tray for continuous paper and then finally selects a tray for plain paper for a copy. The print macro works for the photocopiers but the client has now purchased HP Laserjet MFP M430 which works apart from the second page for continuous paper doesn't swop over but keeps printing on which ever tray is selected on the first page. The print template and the exportedUI file is available

We have a client who uses a print Macro within Microsoft Word which applies and saves the paper trays. So the user selects the first page which is on company headed paper from a specific tray, then selects the tray for continuous paper and then finally selects a tray for plain paper for a copy. The print macro works for the photocopiers but the client has now purchased HP Laserjet MFP M430 which works apart from the second page for continuous paper doesn't swop over but keeps printing on which ever tray is selected on the first page. The print template and the exportedUI file is available on request

Need help creating a multi page bid proposal spreadsheet

hello everyone , looking for Supplier Scorecard Excel Template . the template will be used by three users ( u1 , u2 , u3) u1 : will evaluate the supplier according to fix critera with fix weighting u2 and u3 : evaluation criteria and evaluation weighting depends on the contract commercial types ( 3 kind of contracts ) the template shall show then the average of the three evaluation acoording to certain weighting ( eg , 40 % U1 ; 30 % U2 and 30% U3). Since the template will be shared by email . The respective user is not able to check the other evaluation of the two others users it would be also great to check the evaluation history of every supplier there will be one scorecard for every supplier

I have some CSV files. That needs to change something or product updates. I will provide you with all details. There are 10 similar tasks. If you do well. I will give you huge similar tasks.

* Need Green color highlighted cell DATA in next sheet and also 01-4-2021 balance * if date is repeat 2 times than interest and penal interest is null 0 *penal interest rate is 3% if customer pay after 1 calendar month on only the extra days which Is he delayed payment *interest rate 12% yearly basis * whenever part payment or interest is received deducted this amount from principal amount *here daily interest calculation method is follow and interest calculation method is compound interest * after 1 month from loan opening date the accrual ( receivable ) interest calculation is require *customer pay any time randomly in month * if customer pay the amount then firstly this amount DEDUCTED from intere...

Trying to create a search form which lists delivery prices for every post code in the UK, Would like the end user to enter a postcode select parcel type and delivering costings to appear. All data is currently in an Access Database and Excel Spreadsheet. Thanks

I have source data which needs to be transformed to certain format subject to certain conditions etc. Some code already exists. It is working condition now. I need some enhancements to the existing work. The current scope of work is very limited. If I like your work I will send more your way as per the requirement

I have source data which needs to be transformed to certain format subject to certain conditions etc. Some code already exists. It is working condition now. I need some enhancements to the existing work. The current scope of work is very limited. If I like your work I will send more your way as per the requirement

Hi, so what i really need is, if you take a look on the attached file, i need to record some times in "Master sheet" , pull the data from "Pivot Table Sheet" with these conditions: 1. IN TIME Action = "EXT Main Gate In (13) (In)" Date = report date from Master sheet (C2 cell) --Time = between 17:00 and 19:00 for "Yellow" and "Green" shift --Time = between 05:00 and 19:00 for "Blue" and "Red" shift If that event will happened more than once between 17:00 and 19:00 for "Yellow" and "Green", return first time. If that event will happened more than once between 05:00 and 07:00 for "Blue" and "Red", return first time. 2. OUT TIME Action = "EXT Main Gate In (13) (In)" Date = r...

Looking to develop a spread sheet that can do the following for Darts competition that can range from 1 day to 1 year: 1. register players by payment 2. determine which players who have registered play on which board (no of boards determined by number of players) by previous results/rankings or random 3. Enter score results to determine order of ranking by each board 4. Player ranking updated by results + allocate nightly prize winning per board (choose whether to pay 1 or or more payers 5. Calculate prize pool allocation for the following - winner of leaderboard, nightly prizes, most 180's, shortest leg, highest peg, 170 finish, 9 dart, 10 dart, plus ability to enter or remove categories if required Thanks 5.

I am programming a program to draw the Mandelbrot set. I am stuck at the point where I need to assign a color to an individual pixel. I am confused-do I need a bitmap, a screen, or both?

I've attached a script, the task is to optimise it as it's taking a lot of resources and crashing. It's a Exchange email reader which will read all inbox and sentbox emails and export them to pdf. THE ONLY PART THAT HAS TO BE WORKING IS THE INBOX, THE SENTBOX IS NOT COMPLETED. This is a simple email reader which should not have performance problems as it's not a heavy program. Please make sure your bid is honest and you won't change it after I talk to you. This script itself did cost me 60$ so please be reasonable. If you complete this task I will give more work instantly. If your bid looks like a bot or copy paste I will decline it.

I need to add groups and buttons to each group from a table in the database It is better if you have this source is ready

Gosto apenas de coisas simples, não sou boa com texto ou da opiniões

Need to build an estimation template with dropdown menu. Price catalogue will be provided.

Hello, Loan Calculation Sheet & EMI Automatic Show In sheet.& Visual Basic Only Form Created. I Make Any Excel sheet created. Thank You..! Simple to Attached/

I need to update a spreadsheet from an export from supply chain to update build production week numbers but need to keep the production progress data and notes -ie so the update would capture any new production builds, update build week numbers for anything existing that has moved production slots whilst keeping the saved progress data for the existing builds

Its about production scheduling. I have ready excel file with vba code, just need small changes.

I want 1 advance excel in which advance profit can be for 1 excel.

I have an excel sheet with names and another with names email and number i need to match them for a call list