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
...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 sheet
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
...Explorer when it opens for the first 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
error >>> Invalid CSV Header: Missing headers Title. Please only if the work can really be about 35 excel sheets all this error only I send files you edit send back
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 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.
I have an already built VBA macro using UserForm. I need to do some cosmetic changes. I need the count of records in the Supply section and it needs to be a link, once clilcked, should display the same in an already existing listbox.
Bootstrap Theme CSV Data Import CSV Data Management CSV Data Export Like [login to view URL] with Special Funktions Repricing and Data Manipulation UPLOAD Amazon Automatic import from URL/FTP Automatic UPLOAD FTP and so on
I need a macro writing to perform the following function within the attached workbook. The example file shows my value odds for every horse in each of the day's races. imported from another file. When a horse becomes a non-runner I want to be able to delete the relevant full row of data, and have the ValueOdds_Probability (column G), and ValueOdds_BetfairFormat
We need a VBA developer that is experienced with Excel, VBA, and Jira. Need an Excel macro to connect to Jira query for Epics, stories, linked test cases, bugs found during testing. I have all of the JQL needed to find the issues in Jira.
I have a project that aims to fine-tune some existing Excel VBA Macro details (4 of them) and, more importantly, implement several new Powerpoint formats (project roadmaps, dashboards) based on data in an Excel source file. Attached is the complete Statement of Work and would appreciate if you could go through it before committing. Obviously the document
A very simple macro to compare data between two worksheets and produce the result in a third worksheet. Macro to be stored in the Excel Personal File. Detail: I have a workbook that contains two sheets. The first sheet is called "PRIMARY". This is a reference sheet. It contains item codes (in column A) their corresponding prices (Column L) tax codes
I need help to read the data from SQL and copy it to excel through macro or VBA
Looking for an Indian Micro and Macro economics expert who is masters in Economics. Attach your samples works before bidding Thanks
...several different people undertaking the cleaning process. Consequently, people have applied their own logic to the cleaning process, meaning that we often have been left with multiple derivatives of the same company name – this will have a negative impact on our marketing processes. We have identified this as a suitable time to try and undertake a major
Looking for a highly skilled Excel VBA developer to create Macros. It should not be very complex but specifically, bar charts should to change to display a different data set with the when selecting a drop down. Also, below the chart, there should be a display of the top 5 values and all the other columns of data associated with that value. Lastly, the sheet should be able to identify any chan...
I need help someone who have knowledge about wordpress and woocommerce to create and import csv file to import products. Products number is 60 items to import. To import csv, WP All Import Pro plugin will be used. [login to view URL] So if you have experience to use the plugin, it's best. I'm looking for freelancer who can start to work r...
I have an assembly that is generated from a design table. I need a macro to iterate through the configurations and save each one as a new assembly but also save the parts out with a new name so I have a file for every size part that was generated. The assembly is a 4 sided box with a base and open top. There are 3 real parts in the assembly, the base
1) Combine spreadsheets based on common fil...copy paste of pivot table data so that 3rd sheet is static, not pivot table dynamic. 4) A GUI interface is needed to allow the user to select input and out put folders. 5) Macro must retain directory path after each time user changes it so that input/output directory paths can be reused by user if desired.
...000-names-phone-numbers-in-under-20-minutes/ [login to view URL] SCRIPT?? API?? MACRO?? PYTHON?? <b>Need someone to write script/macro OR just get PHON# NUMB#RS for CSV files that have FIRST NAME/LAST NAME/CITY/STATE/ZIP - from [login to view URL] or [login to view URL] or anywhere else/any other source they