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
We have a repetitive 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
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
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
...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 o...
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
...the multiple customer IDs identified. 4. Flexibility of Macro - We need to be able to have Macro which can be flexible in case we need to add more to be considered in 2.b. 3 files 1. End result file – sample of what is expected to be delivered 2. Sharepoint file – sample of file from Sharepoint source (does not contain the customer ID number) 3. CMD file
...prefer VB for this, as I 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
...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.
...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 to be used to create a record for the member of staff being audited
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
...destiny that I will choose, it has to delete older version of files and then paste the new ones. It has to repeatedly do that, like every 3 minutes. The folder is very small, not more than 30mb. all files inside the folder are .CSV. These CSV files are updated every minute but when I use excel to read them, the program that generates them stop working
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 also s...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
...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, C13 and D13 Column L has
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 • Combine
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.
...names should be as follows: 1. Corporate Search 2. TAD Estates 3. Dallas Estates Will consider most programming languages, with the exception of the 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
...budget based app that helps me track my practise,the information and produce built must remain Intellectual Property (IP) Agreement ,i have built a excel macro as a prototype their are a number of macros ,but would like some help CC+ Software or program into a live app ,or iPhone, Mobile App Development, iPad, Objective C, Android. need advice on
...developer to make a one-page form with multiple parameters that user need to choose from drop down, radio, and text box finally the result will be that the user can generate a video player code (i will provide base code as url with macros ) will be 3 buttons. [login to view URL] [login to view URL] iframe code to embed [login to view URL] code work should start immediately an...
Hi, I need someone proficient in VBA who can build me a few Macros for an inventory stocktake sheet. I already have an activex combo box which generates a new entry every time I select a name from a drop down list. Now I need three things. 1. I need a button so that once the user inputs data (stock out, stock in etc), a confirmation pops up asking
I have excel macros coded with vbscript which imports data to MSSQL server. I require some amendmends on the code.