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...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...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
...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 in a certain visualisation format
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.
I need a 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
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 ...
...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
...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 have, and
...example of what the resulting spreadsheet should be like, along with the data I used to manually create the file. Note that the template spreadsheet contains buttons that run macros that allow additional data to be inputted so in your solution so your solution will most likely need to programatically click those buttons. For example, if the input data
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 th...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 in the USA has macros enabled... he still cannot see the images. Help required please.
I was looking for a program that could actually copy and paste specific folder to its destiny that I will choose, it has to delete older version of files ...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 spreadsh...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.
...keywords Search Volume Group (manually to be grouped by us, but is sped up with n-gram & conditionally formatting) N-gram details: Based on keyword data in spreadsheet after 1st macros organize, remove duplicates & finish sorting. Want ability to view n-gram keyword cluster data. In short say keyword phrase is “men shirt” (bigram), want to view combined data
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
...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. for the RTD. I am getting it from a company named truedata They provide me
...separately. A youtube video has been included to explain the goals and examples, which have been also included in the attached Excel file as well as some sample data. If macros must be enabled to achieve the goals, please communicate to me AHEAD OF TIME! Project winner is welcome to format the non-data area to make the presentation better! https://youtu
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
Hi i'm...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 best solution.
hello, i need a fast developer to make a ...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 and finished today
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.
I need to modify an excel workbook
...be able to move selected columns between the 5 sheets. This is done in a variety of ways - see attached document for a proper explanation of how it works. I would like the macros to be updated to be more robust - explained in attached document. Essentially I'd like them do do a bunch of the formatting calculations that are currently done on page (e
I'd like to have an Excel worksheet with macros or other logic created that will take data copied from a web page and transpose that data into logical columns (fields) and rows (records) I have enclosed an Excel worksheet with a sample of the pasted raw data (Sheet: Original Data Input) and the output desired from that data (Sheet: Output). Please
Hello, I have a spreadsheet and need two relatively simple macros written. The word document with instructions on what I need done is attached, I will send the excel file in chat. Let me know if you have any queries. Thanks !