Hire Freelancers & Find Freelance Jobs

Excel VBA

By | August 29, 2017

I have attached a sample excel file.FunctionsEntry 1. be able to enter a number (i.e. 111), if number exists in column B, then updated column A to “Yes” and highlight the records in red. If the number does not exists then display message “Number does not Exists”Entry 2. be able t

Excel projects inc bespoke VBA

By | September 12, 2017

Excel project requiring and in-depth knowledge of VLOOKUPS, Pivot Tables, Dashboard Reporting and bespoke VBA programming.The current project is a quoting tool for an international freight forwarding company.

VBA Excel Website parser

By | September 9, 2017

Hi,I need to parse a website daily.This is the main link https://www.racenet.com.au/racing-form-guide/Within this link there is multiple race tracks for each specific day.I need a VBA parser to recognise this and to parse the data behind each race course for specific dates that could be selected on

We have a legacy MS Excel that interfaces with Mathcad that we would like to completely rewrite within MS Excel potentially with the use of VBA. The program was written in 1996, so it is likely that the functionality currently resides within Excel to perform the required calculations.

Excel Macro VBA

By | August 30, 2017

I have contact data in Excel (all in one Column), need to convert it in proper format. I mean to say bifurcation of all information in separate column. For eg, First Name, Last Name, Address, mobile, email etc

Excel Macro VBA

By | August 30, 2017

I have contact data in Excel (all in one Column), need to convert it in proper format. I mean to say bifurcation of all information in separate column. For eg, First Name, Last Name, Address, mobile, email etc

Data Retrieval Engine in Excel

By | September 12, 2017

Freelance Job – Data Retrieval Engine in Excel I am looking for a qualified Excel VBA specialist to build a stock data retrieval add-in application that is to be used within excel, to retrieve vital stock market financial data from certain websites.The purpose of retrieving such data is for stock se

I would like to match columns from a source file to multiple excel files.The macro/vba should output a new file showing all matches and any rows that do not match.

VBA organize and sort arrays

By | August 25, 2017

I’m a vba rookie and automating an Excel file for work.This retrieves data from another excel file and sorts it under certain conditions. I am using a master array which divides data over a couple other arrays. This arrays contain ‘blocks’ of rows. This blocks have to be filtered, organi

Excel code

By | August 22, 2017

I use Windows 10/Excel 2013/Adobe Acrobat DC 10I need the complete VBA code to convert a fillable PDF to an Excel workbook/worksheet using VBA to execute the “file/export to/spreadsheet/Microsoft Excel workbook’ commands in Adobe Acrobat DC 10 from Excel.The full path to the file to be conv