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
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
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.
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