...speaking, [login to view URL] formulations, then combine the coding for all into a single macro. The Code for two macros will have to identify with some complexity a paste location back into a database. I expect the coding of the first four macros to consist of no more than 15 or 20 lines of code including an DIM statements. I have written code myself
I have a database with the Tables in it. I need work done in Macros and VBA. No SQL. See the Attached Power Point for Project description and See the Access Database and Excel workbook for examples and more explanations. I need this in the next two days ( I need it Tuesday). If your late I will give a rating that reflex that it was finished late
I need some help on writing simple macros to eg - To be able to select mutiple values in a combobox to store in a single cell - Selecting values in a combobox to store in a cell by typing first 2-3 letters from a longer list of values - Extracting values from a range of cells and sorting them based on a single column. Maybe the above tasks
I require assistance build some logic and macros into a google sheet to link employee requirements vs compliance. I have an example of a similar working sheet in Excel, however this new one requires to be a google sheet.
I need certain quite simple VBA macros written, which mainly do copy/pasting from excel file to another excel file, number searching, etc, quite simple operations. I will be available online as you work, so you'll receive all guidance real time. Project starts asap.
...take the students preferences 1-6 of who they'd like to bunk in with for the week. We usually sort this out manually, but there has to be a much quicker way to do it using Excel. (Is this a marriage problem?- I just read about it on this site) +Each student should have at least one preference- preferably their top 3 but not necessarily. +The problem
Need to process two different excel spread sheets with raw data on those. Freelancer would be provided with two different excel sheets each with a separate word file having 10 data processing tasks and these tasks need to be performed in terms of excel sheet processing. It is a time sensitive job and time allocated for procssing each data sheet is 45
We require 3 excel macros to organise data into tabs to help us with accounting. The macros just need to format and delete cells and finally, add them to a template. We've got precise instructions on the steps that the macro needs to make (with before and after examples), and an incomplete macro to help refer to. This requires Excel on a mac and understanding
Looking for a an Excel Expert to help create an excel for better Log Stock Trading Tracking. Requirements Formulas Macros Ex . Open position How much would a trade cost to open position ? How much am I going to pay for Broker Comission + Tax ? Amount of capital that is in play. Close trade. How much will I make when closing position ? Brokerage
...process in which we are inputting less than 10 values and copy, pasting, and saving different versions of the files. We are looking for someone to automate this process for us. Macros/formulas need to be able to: • Save multiple versions of multiple sheets • interact between multiple spreadsheets. • consecutively grab the next UPC code in a spreadsheet
I need help reformatting Excel tables and graphs. The Print Area selection and Print commands cause the program to freeze. Please do not respond unless you are an expert in graphs. Being an expert in VBA and macros is not relevant to this particular project. I won't select a contractor for one week for this project due to travel.
...estimate this will take 20 hours. You probably need a Mac to do this. You will need to be able to create 2 macros to speed up the process on your computer of creating a screenshot and moving to the next page. If you are on a Mac, I can give you these macros. You will also need Adobe Acrobat Distiller, Pro DC, or other software (e.g. on a Mac, PDF Editor 6
we have 23 Excel files every is different so i give you one file to understand the work if you done one file i give you the project (My Budget $250 for 23 Excel files) 1. Tracking of job status 2. Simple excel program. No macros 3. Able to change color 4. Able to use current date as reference
...Knowledge of Venn Diagram(you should be able to create a Venn Diagram using data from Excel dynamically), Set Theory (Union & Intersection), Macros etc is a must. You should be able to create multiple PDF reports(similar report for multiple entities in the excel) from the Excel data in a certain visualisation format. Files will be shared personally once
I need help creating a graph with three lines, each a very different scale. These graphs are created off of excel templates that I use to run hundreds of widely different files with widely different scales. I also need help modifying a sort macro.
...quotation in excel, that when y save it with a button made with macros can save the project in pdf, with a consecutive number, name of the client and name of the project as the name of that pdf plus at the same time when i push the save button start a database in another with the project name, client, date, quantity of product and amount. This excel will be
Objective = build macro which can compare data from the Sharepoint file to the CMD file and populate in the Sharepoint file the possible customer ID number from the CMD file. Things to consider == 1. Customer name and city should be leveraged to compare the records. 2. Customer names will not be 100% match so need to factor in some variances. As such, consider the following: a. If name is ...
I have atta...will want a UI interface that is clean. I am open to other software, with the exception of below: 1. Python 2. Anything with Java in it's name 3. Macros 4. Any software that needs additional software to work. It's important for you to know that I will be running on Windows Server 2008, that cannot be upgraded. Time frame is 3-4 days.
...number of flushes (usually more than one per user). We require some data manipulation to be able to produce valuable information for our company. I'm looking for an excel based tool with macros or similar capabilities to analyse data to produce a summary of results, with possibility for certain visual displays. The attached file shows the data we already
This project involves programatically populating an Excel spreadsheet. The solution must be a console application written in C# that reads the data from an input file, opens and populates a Excel template file I have provided, and then saves the results in another Excel file. The template file contains a significant number of fields, but I only need
I have a program I am running and would like to record my finger gestures and be able to replay them with exact precision. I a...and would like to record my finger gestures and be able to replay them with exact precision. I am using a Dell Precision M3800 w/Touch Screen. I would need to record multiple macros that I can play back with exact precision.
Hello, I have a basic spreadsheet already made in the general format of what i want, but i have no clue how to use macros. Basically i need a clickable ‘option buttons’ form, which staff will fill out as an audit. Once they fill out the form, they click sumbit, and the data gets inputted into a database list. The data from that database then needs
I have an Excel file, it has a lot of images in it (thumbnails) When I send this file to a customer in the UK he can open the file and he can see all the images. When I send the exact same file to a customer in the USA he can open the file but NOT see any of the images. I have used several file types such as macro enabled and also made sure the guy
I was looking for a program that could actually copy a...are .CSV. These CSV files are updated every minute but when I use excel to read them, the program that generates them stop working. So I though that copying and pasting could fix my problem. I need the latest numbers to generate something more accurate, i run bunch of macros in excel with it.
I have sales data for 3 months which I need to be sorted into pivots or graphs by product so that I can predict future volumes. I have a...have sales data for 3 months which I need to be sorted into pivots or graphs by product so that I can predict future volumes. I have also some work, in an Excel spreadsheet. Create a database in excel with macros
...scripts created to extract data from 2 different websites. Prefer VB, but open to other software, with the exception of the following: a. Anything with Java in it's name b. Macros c. Python I do want a UI to keep things clean. I do NOT want a web based program and the script needs to operate without the browser. I can't have Chrome blowing up and
Proofreading and editing write-ups Create macros using VBA scripting with various files
Proofreading and editing write-ups Create macros using VBA scripting with various files
Quality of experience in QTP/UFT Automation Testing, Vb Scripting, Vb Macros, Algorithms and Data Structure. Has an experience on working with SAP, Windows, Web and Mainframe applications along with Tectia, Powershell and Putty. Has good experience on working with Keyword driven and Hybrid Framework and can able to build the one considering the project
1 Workbook w/7worksheets E S M K A C R Worksheet E needs 4 “buttons” to start macros (1 each for worksheets S, M, K, and R) plus will use specified data for each to specify variables for worksheet columns Worksheet K (Run this for all rows (typically 180,000 – 200,00)) Column K has 2 variables that will be text characters defined in Worksheet E,
I have a speadsheet that needs to be moved to about 9 different pdf files. I would like to be able to save and print all docs with a one button click.
Job Brief (short): Looking for excel VBA expert to help us automate repetitive tasks we do in excel for keyword research. Final deliverable must work on both Windows Office & Mac Excel 2016. We use OneDrive, so if any external data sources are required, must be OneDrive (not Google Drive) compatible. Requirements • Excel VBA & Macro expert • Co...
Convert an Excel Macros VBA with fields, buttons, conditional cells, email reports and math formulas to an Android App to be used in a Tablet Android and easy data review from any device. Could you please see the attached files? One of them is my Downtime, Leaks, and Scrap form used to collect on real time data on different Production Cells (402 on
...am in need of designing a website for share market data analysis. I have the basic design in an excel. I am looking for someone who can make the excel work on a website. Those who are interested please go thru the sample file through. Look into the macros program and let me know the feasibility. if it can be made as a physical software also I am okay
The project here is to SET UP FORMULAS in an Excel worksheet to calculate commission Total and Sales Total. The data structure is fixed but the volume changes every time. The formulas must be able to calculate the cumulative commissions and sales for each individual that appears under Staff Name. Rules for each type of staff are different so the
I need to create mailing labels for a huge amounts. The source is a PDF I need a macros or a method to sort the Client name, company name and office address into the correct excel column. The lines of address are inconsistent. Sometimes 2 lines, sometimes 3 lines sometimes 4.
...following: 1. Python 2. Macros 3. Anything with Java in its name. It is important you understand that these will be hosted on a VPS, running Win 2008 Server. I cannot change that and I cannot do software upgrades. Your scripts need to work with this limitation. I have attached the instructions for each. Looking for the work to be completed within