Excel VBA Jobs
VBA, short for Visual Basic for Applications, is the programming language of Excel, as well as other Microsoft Office applications. It allows users to write functions or commands in a spreadsheet, with the aim of automating certain aspects of Excel. Other uses of Excel VBA is the creation of custom commands, developing add-ons, and making user-defined functions.
Hire Excel VBA DevelopersI have a working but complex excel file full of formulas and has multiple sheets that interact for calculations. I need a simple website that asks for a couple of user inputs and from the provided input calculates the result on the excel file provided then displays the result on the same website. The excel file does this on the background.
Consolidate multiple bank csv/xls/pdf downloads. The exercise is to extract data from a range of downloaded transaction files and insert these into a single cumulative dataset. The cumulative dataset should then be able to automatically update a Pivot Table in a Microsoft Excel workbook. The platform is a Windows 10 64-bit PC. The downloads are carried out at least monthly. There are variations...
I have thousands of excel files and I would like to automate the process of deleting all the columns and keep only the column labelled "email".
Hi, First of all I am a mac user and the program needs to run on Mac. I then utilise Microsoft Office Outlook and Chrome. I get specific data from an email source with certain values. The values need to be inputed into an online form. I need to check every form before I submit them but I wouldn't like to input the information. That needs to happen automatically. I can explain in more d...
Need an excel expert which can deliver result within 2-3 days for reconciliation of bank account with bank scroll receipts Bank scroll receipt is bifurcated in multiple branches which is been credited in bank account in different manner sometimes amount is a little different sometimes more then one amount of receipt is merged and credited in bank account and accounts can also be different I will...
I have a 1-page Visio template with a limited number of text boxes used to print labels for products. I needed a script or methodology that I could use in order to fill all necessary information on a TXT or CSV file, so that the Visio file text fields populate automatically with it to avoiding human data insertion errors. NOTE 1: The proposed solution should be compatible with Microsoft Visio ...
There are more than 60 excel files. For each of them, you need to save each 30 rows data into 1 csv.file. The total rows number of 60 excel files are around 600000. Prefer program solution rather than manual solution. Thanks
Busco alguien que me programe una macro en Excel VBA para escrapear informacion de los productos de Amazon, Rakuten y Yahoo shopping en base a una palabra clave. Los detalles por privado. Lo que quiero: - Una macro de excel que coja los valores de la columna “palabras clave”, y vaya una por una buscando en Amazon, Rakuten y Yahoo shopping y guardando la siguiente información de...
Im Rahmen einer wissenschaftlichen Arbeit muss ein Excel-Tool erstellt werden. Dies muss in den Grundzügen bis Donnerstagmittag 18.07. fertig gestellt sein. Das Tool berechnet die Nutzungsdauer von Objekten anhand unterschiedlicher Einflussfaktoren. Der Anwender kann entscheiden, ob er simpel per vordefinierter Eingangsgröße, oder detailliert per genauer Auswahl von Parametern, ei...
