I have an excel with a lot of rows, and after some logical (running macros), the excel convert and gave some outputs. I need to migrate that logic to database. I have excel rows in a SQL table, and i need a Stored Procedure to transform the data to other table.
...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
An excel file with 11 tabs. The coder will create code so the user can add and delete rows with specific characteristics The coder will create code so the values entered in certain fields are summed to other worksheets
Realestate website. Just need code snipped inserted and working. Demo works but I cannot seem to get the submit form to work. Missing something simple but I just don't want to mess with it anymore. I run an IT company and we frequently have requests like this. I no longer want to do these small web projects. Looking for someone I can pass this work to. This is a site that uses the tool...
...work in the interior so we decided to outsource some projects. We have more than 350 projects per year so this would be the beginning of a great collaboration. We need to insert our render inside the image. We will need to eliminate the brand of the truck that is in front, it will also make the colors match and the image will look as professional
I need to fix a tiny error, I have a '' Select All '' button in my wordpress plugin, it selects all the data I get via xml, the error is that when I insert this data into the table it refreshes the page and does not insert. I need to correct this little mistake.
...extract data in a certain format for visualisation purpose. 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...
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
You will use (Arduino UNO + Ethernet Shield + RFID Module + Display + Warning Speaker) to develop a attendance device. Student will show their RFID card in front of RFID Module and your device will read that and send the card value to a certain url. You will send the value as a GET method I will receive it from my php code by GET method then I will code as my wish with the rfid value. You need to ...
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.
What we need/request : 1. Experience in listing items/products through platform on Prestashop 2. Experience in creation of titles and use of correct keywords (SEO) 3. Very good English language 4. We require a 10 to 20 listings per day 5. A person which will follow the team instructions We will provide the pictures, the prices, and link for inspirations. You will have to add the new product,...
...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
I'm looking to hire a developer that can create a script that can automate a few Wordpress posting tasks. Starting out the script needs to pull H4 titles from a webpage then paste that H4 title as the Wordpress post title & also paste it within the wordpress draft post text. The script also needs to scrape a portion of an iframe embed code from on the target page & paste that in a ...
...design waterless toilets and collect toilet usage data related to 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
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.
...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 to be used to create a record for the member of ...
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
Insert my Logo/Company Name in these animations so i can use them as a moving background for my website. 3 different animates attached i need made with my logo and text and converted into a video i can load as a background Drop box link with 3 animation folder designs: [login to view URL] Please
I need an insert card designed. This will be inserted into a product package for high quality Flameless Candles. Please visit the following website to get an understanding of our product: [login to view URL] The text for the insert card has been attached. I envisage the card having three clear sections to it. 1. Claiming a discount code and
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 also some work, in an Excel spreadsheet. Create a database in excel with macros
Need 2 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
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,
it has no problem with short query inserts. bu after upgrading it wont insert an array.. i know the file that does the insert. some query needs to be changed to fit php 5.2 .. there are some deprecated functions in php 5.3 ..[login to view URL]
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...
i have also some more work for my multivendor website like facebook fetching preview code , google informational information display on the right side to embed on my site .
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
I 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