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
...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
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.
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
some one to program my JiTBit Macro Recorder to 1. Wait for Image/message 2. Based on Image Macro to Respond e.g Yes/No 3. Only respond of corresponding perimeters are met e.g. (price level) 4. Wait for time to elapse before restarting the process. This is simply my repeating a task where I would have to be in front of my PC to monitor. Can be
Macro to be written in the Personal File First File is output from MYOB. Second file is output from Ordermentum. Compare the two files using invoice number is primary criteria. - If there is a discrepancy in the final amount or tax amount, highlight the relevant row of the first file in red (This includes cases where the item is not existing in
...necesita una macro para LibreOffice que vaya guardando a lo largo del día el trabajo realizado. Las particularidades del proyecto son: - La macro deberá guardar el archivo abierto de forma constante durante todo el horario laboral, es decir, de 8:00 am, a 17:30. O bien desde que se ejecute la macro, hasta que se cierre el archivo. - La macro deber&aacut...
...launch an Excel Macro every X seconds within a specific workbook. Please don't bid if: You are not sure how to handle the constraints listed below, You don't explain the basics of how you intend to build the script in your offer. The script must ensure that the following constraints are met: -Excel must be usable between each launch of the macro. The
I need code written to accomplish the following in Outlook Customer Manager and Tasks. Upon clicking a custom button in the contacts profile, a new series of 8 Outlook tasks are created over the following 8 weeks and associated with that name in Outlook Customer Manager. Each new task needs to be scheduled one week out from each other: When we click a custom button, a series of 8 new tasks need...
I need someone to create a very simple task automation process taking data via excel or other method Need to be done in 1 day. Open communication is a must to get this done
I have a spreadsheet that automati...time; this website stays open until a user closes it. I would like a macro that will simply copy a HTML element from the already open web page and paste it into a sheet in Excel, and leave the page open; this macro will run once every minute, as long as a certain value in the Excel sheet is set to "ACTIVE". Thanks
Hello, we are looking for an Excel expert to create a Macro(s) for our ecommerce orders spreadsheet. Our requirements are: 1. if sku column contains build-your-own-ps4, please shorten to BYOPS4 2. if sku column contains buildyourownxb1, please shorten to BYOXB1 3. if options column contains "Left Domin8or Button", please change "Left Domin8or Button"
in the Financial model as enclosed,I am not able to write a macro in this particular file, it says Compile Error. Syntax error. However I can write macros in a different excel file..not sure what is the problem in this file... Can you please help?? [removed by freelancer.com admin] Thanks
I have different Excel works. I will pay you hourly for the work.
Thu, Dec 6 Should be 2018-12-06 00:00 AM Thu, Dec 6 = 2018-12-06 00:00 AM Thu, Dec 6, 18:00 GMT = 2018-12-06 06:00 PM Thu, Dec 6, 18:15 GMT = 2018-12-06 06:15 PM Thu, Dec 6, 18:30 GMT = 2018-12-06 06:30 PM Thu, Dec 6, 19:00 GMT = 2018-12-06 07:00 PM Thu, Dec 6, 19:15 GMT = 2018-12-06 07:15 PM Thu, Dec 6 Thu, Dec 6 Thu, Dec 6 Thu, Dec 6 Thu, Dec 6 Fri, Dec 7, 14:00 EST Fri, Dec 7, 19...
...day entering the current day's figures by inserting a column in column B. Macro Task 1. Require the charts on sheets 3,4,5 to include column B that was inserted and display in the charts. So as a new column is inserted at Col B, the chart references always remain B:AO Macro Task 2. To email sheets 3,4,5 as per the details contained in sheet 2. The
NOTE: This macro must be written for the Excel Personal File. If you do not know what this means, please do not bid. My accounting system is MYOB. From this system, I intend to export a sales file covering a number of weeks. Usually 4 but can be more or less I have a spreadsheet that functions as a MASTER sheet. It contains item codes in the Rows
I frequently get large spreadsheets that need to be printed: 1. select only visible cells as the Print Area 2. Page Setup/Page set to landscape, fit t...earlier; rows to repeat, top row only; gridlines on; row and column headings on; page order does than over I would need clear instructions as to how I can integrate your macro into my workflow
We are seeking a programmer that can edit an existing algorithm developed in Image J software for image analysis. The deliverable would be a code that can utilize the tools within Image J (e.g., filters and operations) that can translate images of walnut kernels into continuous, quantitative color scores. Ideal candidate can work under a strict timeline, be organized, attend meetings, and have pat...
Hello: I would like a macro enabled book that will allow me to upload multiple excel reports and produces one report that is formatted with specific information from the reports uploaded. I have attached an example of a current report formatting macro.
Looking at creating and automated excel file with VBA and macros for a certain task which would ultimately be automated, save to PDF and .Doc and also enter into another database which will be automatically formed. More details to follow
...select data from my Access worksheet. I would like one macro that did that. Saved the data into a new worksheet that i can export to an excel spreadsheet. The data Base will be 1.3 million records. Examples select "Property Zip" and input a string of zip codes 77502,77503,77504,77505 ect. Run the macro and a new sheet is created. Data is never deleted from
Hi there, we need a VBA or a Macro to get specific datas from a form into excel sheets. The form is looking like the one in the first picture. We get the form for 6 different locations (nr. 1), so the data need to filled in 6 different sheets. We are working with Outlook.
NOTE: Must have experience with coding macros in the Excel PERSONAL file. If you don't know what this means then please do not bid. I have an existing Macro. The function of the macro is to read a sales data file and insert the sales quantities into cells of MASTER file. Task: Extract an Order Number from the data file, and paste into into Row
Hi, I have an excel spreadsheet that does some calculation for me and outputs 48 different data points (single row, 48 columms). I need to write a macro that can create 1000 runs of this so that I can get 1000 rows, 48 columns. This will be a quick job for someone who can turn it around in a couple of hours today. I know that this can be done
Please respond only if you know VBA. Copying and or summing cells content from a number of sheets into ...respond only if you know VBA. Copying and or summing cells content from a number of sheets into a new sheet using a macro. Straight forward request. As shown in the attached file, the macro will be populating the columns from separate excel files.