Vba optimizationpekerjaan
Membuat aplikasi VBA- excell untuk tracking portofolio saham dengan ketentuan sbb: 1. Menggunakan Real time data (1-5 min) 2. Update data saham secara otomatis ke portofolio saham 3. Dapat melakukan penambahan dan pengurangan transaksi saham pada portfolio 4. Dapat melaklukan sorting berdasarkan Nama saham, keuntungan (jumlah atau %), berdasarkan
using a premade Form Create a Formula that searches five Columns of a database by using "Command" buttons to chose a feature of the item you want. Then use a Text Box to enter a value of number of items required---go to the Column that matches the results of the five features that lined up. multiply the number in the text box with the---the results will be placed in text box at the end o...
I have data in excel files such as - date, time,symbol, buy/sell, qty, price. i want vba codes to find first transaction of any day for particular symbol( buy or sell) and later for same symbol on same date - it should add/reduce qty from first transation qty eg. first transaction is sell - it should display qty as "-" and later for same symbol it
I have data in excel files such as - date, time,symbol, buy/sell, qty, price. i want vba codes to find first transaction of any day for particular symbol( buy or sell) and later for same symbol on same date - it should add/reduce qty from first transation qty eg. first transaction is sell - it should display qty as "-" and later for same symbol it
...line items using the Spire Purchase Order Module. SPOKE currently uses ODBC connections to a PostgreSQL 10.5 Database via Excel to perform controlled calculations and executes VBA script to import values back into the PostgreSQL database of Spire. We will provide full current Code for review. SPOKE needs to be completely rebuilt in Python 3 and use the
My company sends employees to client sites on a repeating schedule to check and maintain equipment. They use a multi-column 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...
...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 worksheets > ...
I 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
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 the autosave macro 3-Want to print la...
Hi Vba A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
...programmer. I want a programme that will open a specific 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
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; • Expert in Process Automation Using
Need help with fixing Excel VBA Application. The work requires deep knowledge and hands-on expertise with Class, Modules, Userform, Treeview...
I am looking to automate and streamline a major part of my business using Microsoft Access and Access VBA’s. 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 Thi...
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 the autosave macro 3-Want to print la...
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
Wholesale/e-commerce clothing business based in the Republic of Ireland 1. 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
...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 with the flexibility of Excel and VBA, coupled with the infrastructure that powers a trading
...ribbon [log masuk untuk melihat 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 please add the xml code to your blank excel file (for example via Custom UI editor). If you can recommend me better xml ribbon editor let me know. Please do
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
We currently have a working copy of one Word Document that uses 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
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
Hello, I have a multiple changing values in multiple sheets what I want is to make a button that type all numbers that are connected to foumula to non formula cells for example: Name: [log masuk untuk melihat URL] Views: 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 nee...
...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 generate the
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
