Excel vba expert needed write jobs
Build a completely new application – from scratch – using an existing Application which was created in Excel using ODBC connections to a PostgreSQL Database Accounting Application called Spire. The objective is to build a new SPOKE application in Python 3.7.x. If you have ever wanted to be part of building a new application in Python 3 – completely
...paper form, adding a row for each visit. We would like to replace the paper with entries directly into Excel. The employees will not be asked to learn the details of Excel, so we need to add some automation. Each client site will have a separate Excel file (hosted on Dropbox or similar for shared access) and we need a template from which to create them
... I've added sample calculation to get "Result" worksheet. Since this is repetitive work and the dataset may contain hundreds of data, I was wondering if there any way to write VBA code to get "Result" worksheet from the "Data set". What I did manually is: creating pivot table > copy filtered data to new worksheets > processing new workshee...
...need two VBA subs written to automate certain portions of my workflow. 1. Write a sub that triggers when I receive an email from "______" sender with "_____" subject name. Sub is simple... open email attachment, copy contents, open file on desktop, paste contents, save desktop file, close desktop file, close email attachment. 2. Write a loop that
Hello, I want to make aproject that makes the follow to my existing excel workbook : Inside "Data" sheet tab: 1- Want to make macro assigned to checkbox1 that autosave the workbook every 15 minutes without any messages or prompts just save the file on intervals. 2- Want when uncheck the checkbox 1 that autosave the workbook every 15 minutes to stop
Hi Vba A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
...website. It will download pdf files from it and then transfer content from those files to an excel (again programmed with VBA) to sort contents in columns. The programme should also be able to open 2-3 more websites and download query results into the same excel and compare these results with the contents from the previously mentioned PDFs. I thank you
...website. It will download pdf files from it and then transfer content from those files to an excel (again programmed with VBA) to sort contents in columns. The programme should also be able to open 2-3 more websites and download query results into the same excel and compare these results with the contents from the previously mentioned PDFs. I thank you
Expert EXCEL VBA Developer Needed ASAP - Work From Home Want to Work from home on Various Exciting and Challenging Projects? We are seeking to hire a Team member who has an EXPERT STATUS in ALL these following areas: • Expert in VBA Application Development in Excel; • Expert in All Excel Functions and Formulas; &bu...
Need help with fixing Excel VBA Application. The work requires deep knowledge and hands-on expertise with Class, Modules, Userform, Treeview...
...We are a customizable, healthy meal delivery company and I need a Microsoft Access expert that can design database specific to my needs that will integrate fully with the online CRM that my company currently uses. The CRM provides new orders as both emails and Excel reports thus This Access App needs to have the following major capabilities. In take:
Looking an Excel & Access VBA guy to work behalf of my company. I am looking for full time position, Not for just few months. I already have an excel guy but we have lots of projects. So looking to hire one more person. Its an ongoing position for right person, For couple of years. I prefer someone from Venezuela and Peru.
We are a marketing agency in England and we are wanting to hire a freelancer to complete some VBA coding work on one of our client's excel spreadsheets. More information available on request.
Hello, I want to make aproject that makes the follow to my existing excel workbook : Inside "Data" sheet tab: 1- Want to make macro assigned to checkbox1 that autosave the workbook every 15 minutes without any messages or prompts just save the file on intervals. 2- Want when uncheck the checkbox 1 that autosave the workbook every 15 minutes to stop
Want a simple yet super fast method to insert a list of data in array OR a Range to Azure SQL. 1. The method should be able to dynamically assign columns name. 2. The insert method must do a batch insert instead of one by one. 3. The method should be able to insert 10, 000 records within 20 seconds or faster. 4. Please don't use the ExportRangeToSQL method from the internet, I already ha...
I want a CRM created Using Excel and VBA. Files Need to be copied from raw data sheet and a dashboard need to be created using the raw data and calculations and formulas. Message to get full review of the project before you start. Thank you
Vba macro to read an excel file and to write data in a new excel file. It is the same data but firmatted differently
We need a VBA developer that is experienced with Excel, VBA, and Jira. Need an Excel macro to connect to Jira query for Epics, stories, linked test cases, bugs found during testing. I have all of the JQL needed to find the issues in Jira.
Wholesale/e-commerce clothing business based i... We download our orders off various websites into a excel file - each row is an order with details an individual header. 2. We would like to automatically created a new worksheet (template that we already use - formatted into a job sheet) from the individual rows of orders in the downloaded excel sheet.
Seeking VBA Script to Print Defined excel range and save to PDF format from Print button. Need naming convention of file to reference name tags when saving. Naming convention should be: "FOUO - Artifact Table (MEMO NAME, PLATE NUMBER, REV).PDF Looking to save in C:/TEMP folder or active directory and then potentially open up outlook email with it
OpenAPI for Excel is an add-in that ports a broad range of OpenAPI functionality straight into Excel. I need a programmer well versed in VBA techniques and procedures to install, implement and setup an excel platform using procedures provided by the provider of the OpenAPI service using Microsoft Excel (2010 and later) OpenAPI for Excel provides you
Hello, as the xml syntax for excel ribbon has changed with the new excel version, I need to convert the excel 2007 ribbon [login to view URL] to excel 2016 ribbon [login to view URL] because I think this is causing the performance issues in my excel file. Please add the similar icons also. Let me know if I need to do any changes in VBA. For any testing p...
The Clear All button will 1, Uncheck all the checked CheckBoxes 2. Clear all contents in rows E6:E16 3. After 1 & 2 is complete, reps will then start checking the boxes in column AW for the reasons they want to display from column AW. These will then get listed starting in E6. After the reps completes checking the boxes, the data from column AW will display is column 3. 4. Blanks that app...
We have a Macro (VBA) written for some data cleaning but there is some bug due to which it's not working properly. Need to rectify the errors
Im lookin for someone to encrypt my VBA strings so other people cant read but the macros should work I have the VBA script with me
I want a CRM created Using Excel and VBA. Files Need to be copied from raw data sheet and a dashboard need to be created using the raw data and calcualtions and formulas. Message to get full review of the project before you start. Thank you
...a form created with VBA that captures data in the form and exports to excel. We have three other documents that need to be duplicated using the same VBA code structure to create a form that is the same as the Word document, allow input to the form, the input to the form is saved back to the Word document and then exports to Excel. One added feature for
Objective = Create simple Excel VBA Script which will merge multiple columns value and generate list. attached are the specs.
Send email for each row and include the header as well based on condition. see attachment
Skills Required: Web Scraping, Excel automation, VBA script, XML HTTP requests, Java script, headless browser, Anti-blocking, user-agent string, etc. Please see attached files: - Project Description - Starting Excel Spreadsheet with headers - Screenshot of one webpage from where scraping is to be done, showing the values Please do not send automated
Hello there! I have some ecxel spreadsheets where is a lot of information, I want to make this ecxel sheets more informative...more informative, and for this i want some worker who can add some tables da formulas there to see statistic information and many more. So i want person who know ecxel and vba in advance. Please don't bid if you can't do it.
A VBA module (see attachment for code) uses an unmanaged function to create a Virtual COM object that exposes file properties. I am looking for a VB.Net equivalent to access the unmanaged function. Need someone familiar with managed/unmanaged memory issues.
Some minor correction in a code vba excel 2007. Need to be done less than 24hrs. Based Greece
VBA Script in Excel to take information based on date ranges, from three different sheets, to produce batch documents with the same layout a template NOTE "Outline formatting would not paste into Freelancer Table" Need this weekend. • Availability- Must be Immediate. o We have to turn in documents for a job we completed by Sunday afternoon • Overview
I want a CRM created Using Excel and VBA. Files Need to be copied from raw data sheet and a dashboard need to be created using the raw data and calcualtions and formulas. Message to get full review of the project before you start. Thank you
I want a CRM created Using Excel and VBA. Files Need to be copied from raw data sheet and a dashboard need to be created using the raw data and calcualtions and formulas. Message to get full review of the project before you start. Thank you
...13 Size: 209.9 KB I want a button that when pressed all values that resulted from formula in cells (C33:K33) to be typed to (C2:K2) with no formula and can be removed when needed also I want it to affect a number of 6 similiar sheets contain the same table simulatanuosly I searched the web and had this code : im xVal As String 'Update by Extendoffice
*the budget is just a place holder, please quote what you think fair and will get excellent solution for b/m described tool I am looking for a way to transfer my excel workbook that has VBA macros to be an online tool, it is a sheet that is used to create three reports automatically, i want the users to be able to login, add/change information then
I want a CRM created Using Excel and VBA. Files Need to be copied from raw data sheet and a dashboard need to be created using the raw data and calcualtions and formulas. Message to get full review of the project before you start. Thank you
need a vba excel macro expert for multiple jobs. Details will be shared with winning bidder.
need a vba excel macro expert who can help complete multiple tasks.
The program should be able to load (import) any kind of (x,y) data either automatically or semi automatically (user interacts with a sample file and defines where the header stops and where the real data begins/ ends.) All of the important parameters (color or not, linewidth, axis labels, ticks, font sizes, legend (content and position), . . . ) should be adjustable in an easy and intuitiv...
we have done the first project excel but is not multicreteria search could u pls assist us with the devlopment of excel vba
i need a vba script in dutch that randomly selects a number of questions in a excel list, There are several tabs with categorized questions. I want to make a choice of wic questions cats are te be selected. vba script must be dutch
Hello VBA experts, Below is the project: 1. Gather data for every customer into Excel using integrated SQL query (I have query) 2. Use this data to be presented in a "nice" format - it is a customer summary when customers ask what does their portfolio look like today, i want to generate this via Excel 3. Save this in to a PDF format and email to the
excel macro for baris projectexcel macro for baris project
I have a macro that scrapes a website in Chrome - and while it still runs, the macro previously would keep clicking a button on the site until more data was displayed. This is no longer working, and it is not finishing cleanly, it seems to be stuck in some loop when it should have finished. Small job, budget A$12
Hi There, Only those with verifiable Excel and Excel VBA experience living in Singapore need apply. I have written quite an extensive Aviation related program in Excel with upwards or 10k lines of code. I am by no means an expert at VBA and I would like to sit down with someone who has extensive skills to help me iron out some issues and generally
