Hi, I am after a simple excel macro to run on the latest MS 365 excel (2016?). I want a macro where I can easily click on an icon in the excel program.. it then allows me to go to any website/software.. and draw a highlight box (see picture attached). It will then extract all the numeric values into a column view in excel. But I want to be able
i have a java code that needs to be improved Little and fix some few bugs. I want the code to read/copy and excel sheet from a template Workbook and past/update the sheet/ into several Worksheets that are already existing. Let me know
Requirements for 2 kinds of desktop tool/Macro: 1.Open different csv files in the same folder. Using desktop tool/ macro to copy to one Excel [log masuk untuk melihat 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 sor...
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 [log masuk untuk melihat 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
...big living moving shape) (the device must detect moving shapes during the night too!) ->when a big animal is detected, get the date, get the time, capture a photo, set the filename as datetime (for example for this day, at this time, it would be : 2018y11m18d11h09m30s), save the photo on an external disk (sd disk or usb disk ?) (the device must capture
...IMPORTANT1: The logo is still a Letter D with layered elements, but with the thematic elements from https://www.freelancer.com/fs/download-api.php?type=contest&id=1448033&filename=Style-Elements.jpeg IMPORTANT: The style-elements image attached is a perfect reference to the type of elements that should be looking like, and used. Eyes, Roses, Lotus
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.
...erence/v3.2/object/comments) comments edge of the Graph API. The names of the files will be the message string. The source (multipart/form-data) will be the actual jpeg filename on the hard drive. You create a test Group (Buy and Sell type) on Facebook and add me as an Admin (possibly my virtual assistant as well) so we can work in a sandbox dev/test
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
I have drawn up some HTML available here ([log masuk untuk melihat URL]) I need to fix the text and button image so that it overlays properly within a normal email. Right now the overlay text and button image show up on the next line. Also if anything can be done to make the template look better that is a bonus. Must
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 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
...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
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 a/b for an answer and that will generate an answe...
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.
Convert a Single Excel Macro VBA Calculator file with buttons and simple math formulas to an Android App to be used on Android Phones.
...path will be: “/vacations/germany/berlin/[log masuk untuk melihat URL]” 5. Each upload consists of three actions Call the API to get an upload link GET /api/GetUploadLink?AccountName=developer&FileName=%2Fberlin%[log masuk untuk melihat URL] Upload by making a PUT call to that URL with the file content Call another API method to indicate the upload was completed POST /ap...
...choose to record (1) Video (with audio); or (2) Audio alone as an MP3. The video and audio should be transcribed using Amazon Transcribe... then saved in Amazon S3 with the filename, transcription and metadata (such as duration) stored in my MySQL database. Formats: - Video files should be MP4 H.264 and audio with AAC - Audio files should be MP3 (24kHz
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
Hi, I am in the first steps development a downloadable excel calculator. The interface and calculations are confirmed and tested. To improve the usability of the tool, we will need the excel spreadsheet to host a number of specific VBA's to improve usability and functionality. I need a VBA programmer for approximately one week with proven VBA credentials
...json file in an AWS S3 Bucket. - A method to easily query/index S3 Bucket contents. Some buckets will have millions of files. We need to be able to quickly determine if a filename exists (CloudSearch?) Considerations: - You will have to create AWS API Gateway and simply the process for passing querystring parameters for each URL (example: zip = 24018
MOZ, SEOProfiler and Siteliner all claim I have duplicate home pages that will negatively affect my rank. On my end, in Adobe muse, I only have one home page, with a filename of “index” I am trying hard to do SEO myself, but I am troubled with the duplicate pages. I upload my site to godaddy form adobe muse. I did recently change my site from www