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 VB
By | August 25, 2017
Have short term need for a VB programmer to write a series of modules that automates an existing manual process. The job has 4 phases:a) data integration of external sources into single workbook and create UI in Excel for query/reporting of sameb) using a) calculate equipment needs for various physi
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
Rewrite old Excel prog. using Excel/VBA
By | August 31, 2017
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
Create VB macros for Excel
By | August 29, 2017
Need a program to execute calculations for an Excel spreadsheet. Small job but may require multiple corrections and/or redesigns. Will need a signed NDA.
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
Match columns in multiple excel files
By | August 29, 2017
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.