Excel macro fill empty cells jobs
We need a technical guy who can support on developing a Macro or program to automate the certain manual process business.
Requirements for 2 kinds of desktop tool/Macro: [login to view URL] different csv files in the same folder. Using desktop tool/ macro to copy to one Excel [login to view URL] rows with certain values in certain row. This should be dynamic, there's a file that I can maintain. example: keyword || action ABC || delete row XYZ || replace value 3. Macro to sort, d...
I have a spreadsheet in excel that includes a macro simple (less than 50 lines of code) It mainly just moves stuff around I have recreated the spreadsheet in google sheets [login to view URL] but I can’t recreate the macro as I don’t know google apps script. Is this
I am trying to do two tasks on a Google Sheet I have. The tasks I would like done are to link 1 Sheet, called Order Summary which needs to be sorted by customer names. There is 1 sheet called Customers with 4 columns. As these columns are updated, I want the sheet Order Summary to update. I also would like 1 script added to sheet Order Summary that add 1 blank row between each customers orders ...
We would like a Macro to run inside of Coral Draw that will place the same PNG file onto a template that we will provide. The template will be of a Shirt and there will be different variations of that shirts colors. (Black, Navy and so on) It will need to allow us to batch the Images from on folder and then save the grouped image into either PNG
I have an excel spreadsheet that pulls 2 worksheets, parses and combines data, and creates a report for each customer. Lately the spreadsheet stopped working and is throwing a type mismatch error 13 on one of the routines. I do not know what changed but I need to get it fixed. I'm also open to just having the whole spreadsheet re-done or at least cleaned
I'm a poker player and have around 100 ranges that I would like a...that shows the idea exactly. The grid size on each sheet will vary, but each cell of the grids will link to pictures of ranges across the grids bet sizes. At the bottom of the excel video you'll see there are 6 sheets with the same macros on each. All the information will be provided.
...incomplete/missing/incorrect information and/or with invalid email Please do the QC before sharing the data – Important check points: Check if any information is missing – filter the blank cells and check/acquire the missing info Check all phone numbers for the proper format. Check ISD codes. Also please check if ISD codes are corresponding to country for e.g. if ISD
I want to hatch a closed drawings and get an image output that just fits the drawing. I will do batch conversion. Drawings are clean.
i need just simple one hour work for experts, fix rate whole work (2 to 10$ final) sorry for advance milestone or payment , payment after the approval of work by client. thanks
...an excel expert to work on an existing excel sheet. You must have an excellent knowledge of Excel VBA, Macros and add-ins. The sheet already contains a lot of existing code which has some bugs which need to be fixed. The main part of the project is to create an add-in for mapping. This need to be dynamic. It needs to map the values from cells on one
to write very easy and simple macro which search frases in data and shows average values asociated to them
The requirement is to create a macro on an excel data set. The macro should be able to do the following tasks: 1. Should do minor data corrections with the click of a button 2. Identify the trending of data 3. Generate graphs based on certain logic These are high level requirements. Details will be shared once confirmation received.
Need a developer to make an excel macro. The excel macro when run should do the following: 1. Download closing prices of a family of stocks (NSE/BSE India) from the internet 2. Update them in excel automatically 3. For each stock, perform exponential regression, calculate ATR, 100 day EMA, and if there is more than a 15% gap in prices in the past
...using VB net and JavaScript. The datatables must be editable inline with a single update call to an SQL Server database, each datatable will require select lists in certain cells which will be populated from an SQL Server database, each datatable must interact with each other with double click events and each datatable display must be grouped by date
Change country value by code value in 2 sheets and sure thanks to a 3th sheet with the matching between countries & codes. I put 2 sheets with the results example that i want. Easy easy ;)
Hi, could someone please provide me with a simple macro that detects if a particular webpage is currently FULLY loaded into IE and then prints YES or NO in a cell?
...this job. We have a MS Excel file, which is used as a reporting utility. This excel file uses a OCX/TLB file at VBA side to get the required data from some external sources. The buttons & some Excel sheet cells functions are used as a user interface. User can request for report data by providing some input to some predefined cells & then press execut...
I have a set of Excel spreadsheets that builds out graphs on stock market data, but a while back, Yahoo Finance cut off it's free download API and I am not able to get the stock market data. I just need someone to program the macro to: 1. Download the data for the symbol that I put in up to the maximum years back per the data vendor 2. Put the weekly
I am looking for help creating an excel document. My business sets exchange students up with host families for short term visits in the United States. On our website, we have a host family application where they put in various information about their family and home. The end result is just a list of the answers and not something we can give to our students
I have a requirement where i need to deal with Excel files such as Setting cell values in multiple cells in excel sheet using for loop.
I need a Macro which can extract specific data from a word file and then generate a User form with drop down having the data from the word file and finally generate a word template with the values selected from the drop down in the user form
When you click on the Region / State field on our opecart 3 store, it only displays '--please select-- and --none--'. Thanks
...two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other and vice versa. I need a macro/script to align all DATES and TIMES and delete the mismatched values in sheets up to 250k lines efficiently. I have uploaded one examples of raw data that need to be aligned
i have an excel out put from an app which i want to paste it into excel on one sheet and then have another sheet on the master file which pulls key data from the pasted file and then i want to click on a macro button to copy the new manipulated sheet and create a new sheet without the manipulator in it. i also want the new excel file to retain its
Task: after filling values into excel cells , I want these values automatically inserted into the first free line at the bottom. New values, next fee line and so on. Please find tempate attached
I have an excel sheet I need the formula and/or macro edited for.
I need Excel VBA/Macro expert to help with automating some process in Excel.
I need help with economics. Three projects to be finished in a timely manner. Masters in economics is preferred.
We have a financial modelling calculator that is having issues when transferring data in from an external source (CSV file). The original programmer is no longer available to trouble shoot. We are in need of a programmer going forward so there may be more work to follow if this task is completed to our satisfaction. ASAP Update: AUS/NZ preferred
I would like to automate a report based on a series of questions my empoyees fill out out. I need a way to auto generate a sample phrase into a word document based on a yes no question. So the employee checks of yes or no on a form. If it is no then then word will generate a response. If the employee checks yes they will have the options to check
i need a macro to read from excel file and to post listings on gumtree
Hi, I have a macro that was written for me some years back by a user, that scraped data from a website. It is now in need of updating as the website has updated/changed a little. basically i get sports results and fixtures from the website, usually 2 or 3 times per week. It was set up so that i could get a whole range of dates of results or fixtures
...Cloud Platform. Now, I would like to use the API of this model in a function written in Google Apps Script (in a Google Spreadsheet) to make predictions of text snippet in cells in this spreadsheet. I'd like to get help in the settings (like explained here: [login to view URL]) and with the Apps Script function
I need you to develop some software for me. I would like this software to be developed for Windows.
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other. I need a macro/script to delete those values and align all other entrys in mutiple sheets.
...automated process that will upload/append an excel spreadsheet to an existing table. There are more requiremnts to this uploading (like checking for duplicates first, opening the file maneger so the user can select the file, verifying the selected spreadsheet has a certain tab, there is data in the cells......) So READ the PowerPoint BEFORE you bid
I have two spreadsheets on the same google drive account. "Spreadsheet A" contains my shop orders, one order per row. Sometimes I will edit manually some of the cells for each order. I need a google apps script that automatically copies all the modifications on 4 columns of the "spreadsheet A" and apply the same modifications on "spreadsheet B".
Convert a Single Excel Macro VBA Calculator file with buttons and simple math formulas to an Android App to be used on Android Phones.
I have some work, in an Excel spreadsheet. I need to randomly pull 1 case among 14 account managers with different amounts of cases.
Create an excel spreadsheet "program" to reformat data from various cells in one sheet to another. Combine cell data based on other cell data.
...as in the current store www.wifi.sa. - Delete recent links at the bottom of the store. - On the registration page "Register on the mailing list" make it a default yes. - The cells located below the slide show are set to " 1- Place the technical support number below the store 0547426314. 2- Safe payment. 3- 14 days return money. 4- Two-year warranty.
I need someone to copy information from some websites.
I need somebody with experience with calendar / sche...[login to view URL]) does. I need this done within 8 hours. I need time displayed and updated as the user drags borders on the top and on the bottom. Events must display in their cells depending on what time it starts and stops. Include the phrase 'gui expert' if you read this description. Happy bidding!
need someone to make me a google chrome macro to post listings on a website
I have a very complex macro which takes a csv of all our orders and put it in a neat printable html format. It isnt doing one of the things its supposed to properly so I need that fixing and I also need to give it some extra functionality.
- Updating of pivot tables to ensure that numbers change when cells are updated - Advanced filtering - Having a data entry sheet and using VBA to transfer the new data to the bottom of the existing data set - Improve user experience by making future data entry convenient
Hi, What I need is probably really simple but I can’t figure it out. I have a bunch of tables in excel that I want to copy into word; with the appearance matching how it would look if I did the copy and paste manually. Each table is on its own worksheet and is a named range (local name... name is same on each sheet), each sheet also contains a named
I'm from Fossil Group (Bangalore), we need to develop a Macro program in Excel for the Allocation / Replenishment of stocks to the stores.
