Visual Basic for Apps jobs

I have started a data collection with Excel and VBA (Data Entry forms). I need to have it completed, that is to have some functions programmed with VBA. Also, my code is possibly sloppy and will need to be enhanced. It will possibly be an ongoing project. In the immediate, some features need to be created. For example, a search module, both for companies and contacts, need to be created in order t...

Hi we need someone to develop a small function like the Backlink Checker of the Excel SEO tools. This function checks if your Backlink is still live on the Website that hosts your article and linked back to you. It also says if the link is follow or nofollow

you are required to demonstrate proficiency with Visual DSS™ (a DSS development language/DSS generator)

I am looking to hire an excel expert, must be a VBA expert (no recording of macro as it will require you to write custom code). I will require you to make a template for me to import various balance sheets. I will share further details with the short listed freelancers. Please start your application with the word - "VBA EXPERT" so that I am aware that you have read the job posting. Also ...

I am looking to hire an excel expert, must be a VBA expert (no recording of macro as it will require you to write custom code). I will require you to make a template for me to import various balance sheets. I will share further details with the short listed freelancers. Please start your application with the word - "VBA EXPERT" so that I am aware that you have read the job posting. Also ...

I need an excel spreadsheet template with searchable functions to filter through my orders. I need to be able to search all orders by: names order numbers flavours of meals ordered delivery days I have attached an example export in which I would like to search for example: only orders with: SIZE OF MEALS: Large showing only orders size large or PRODUCT NAME: pesto chicken and only showing ...

It's a fairly complex project. We're trying to move from an Excel spreadsheet the holds project data to a Project master tracker. Projects should be "grouped" by project year (sub-subprojects). We've created a basic form to input the project data that would normally be put into the Excel spreadsheet, as well as having created a "master" template to be used for...

This is a short term solution we are looking for, long/medium term will are installing an ERP/MRP system. Currently we use a shared ms outlook calendar. This stores when orders are to be manufactured and their progress is logged within the subject line of the appointment. The issue is, updates of progress happen once a day - after paper sheets are updated onto the calendar. What we would like; Th...

We need help cleaning up some Intacct reports that were set up during a system implementation over a year ago. We also need help loading budgets into Intacct. Someone preferably who can code in VBA and can set up a query to build our budget upload.

We will provide few input files. Macro should read content from the input files and prepare excel sheet in pre-defined formats. It should also run validation checks based on defined logic and flag if any error.

A vba macros code to copy sheets in a workbook such that "2017" is made to "2017c", the new sheet "2017c" is a copy of the sheet "2017" without formulas in it.

Currently, the excel VBA breaks down all the mailing address into groups of 30 in a sheet Errors in this macro: 1) The final sheet does not have "A" in column A first row, "B" in column B first row, "C" in column C first row with the entire row frozen 2) The sheet starts from Sheet 3 not Sheet 1 Please rectify

I have an assembly language project are you experienced in this?

Hi Jay P., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Looking for a an excel VBA programmer to convert 1757 vcf files to excel. Ongoing work available for right freelancer. Highly Experienced Only.

1 Develop an Excel macro in this Excel workbook that compares the values between Sheet1 and Sheet2 2 Compare just the first column in Sheet1 to the first column in Sheet2 3 Create a new worksheet named Compare Result that shows the result of the comparison 4 If the Compare Result worksheet already exists then delete and create a new worksheet named Compare Result 5 The Compare Result worksheet...

I work with PDFs that have the same layout (11 columns), same names of columns (5 columns) but different number of rows. What should the program do?: 1) Convert this PDF to an excel format. 3) Extract only specific 5 columns out of the 11 (the columns place is fixed within the PDF) 2) Change the name automatically of some columns after converting. 3) Replace some data by ruining a vlocku...

I have a list of contacts in Excel. I need to be able to email the contact by pressing a button which will open up Outlook and pull the information from the active row into the email - like a mailmerge. This needs to be a button task as my users have limited IT knowledge. I have attached some screenshots to explain what I mean further. Thanks Dan

International trading company, current ERP doesnt produce robust documents Need a system, can be VBA/Spreadsheet or GUI based that produces, Proforma invoice, Sales Contract, Packing List, Commercial Invoice Data (Customers supplier Items) can be migrated into it and others can be migrated

i have some issues in pivot macro. where it is ignoring the page, its printing only pivot from macro.