We have a s...and we are looking to customise a costing excel sheet with certain formula's which can calculate package cost and print the package in word or note file. We have designed an excel sheet ourself but want to rebuild the excel sheet with more functionality added. Need a expert in excel who can rebuild the excel sheet as per our requirement.
I have a Python script which basically runs an Excel macro, but it is giving me a Runtime Error 1004. the macro basically refreshes Bloomberg formulas in the sheet. The macro runs fine within Excel but gives the above error when calling from Python.
We have a suspect macro document and need to understand what will happen when it is opened on windows 7 or 10 with Office 2010. Apply only if you have such system available to test and can do it very shortly after the bid is awarded. Your participation is to: 1) download malwarebytes freeware and run it to verify you have clean system 2) open the attachment
I need someone who can create a macro which will find duplicated events in Outlook calendar. The macro must search by these parameters: - Start - End - Length of event - Attachment - Body text - If name includes "Copy :"
There are about 6 sheets and we need to pick certain information from those sheets and make a summary sheet. This project is in the google sheet. This is a simple project and total project cost is10 USD only. Please check the project here [ログインしてURLを表示]
There are about 6 sheets and we need to pick certain information from those sheets and make a summary sheet. This project is in the google sheet. This is a simple project and total project cost is 600 Rupees only
Hi We have a small scraping macro written in VBA which takes [ログインしてURLを表示] game ID from column D and scrapes data to Excel for respective cells (so for example for ID 1402510 it will scrape data from [ログインしてURLを表示]) However there are some minor issues with this macro. One of them is scraping data when betting market was
I have an Excel spreadsheet that use to generate Pricing. Pricing consists of select Products and Services. Need help with 2 things: 1. Based on Product selected, display instructions/comments that assist user in selecting the appropriate Services. These would be displayed like a comment upon mousing over a cell, but the content of the comments about
I need a framework, software, guidance or similar to ensure that no macros I install include virus. Also need a way to check if a existing file contain a macro virus or other infection.
I am after a automatic macro where if more than "X" (lets say 20) emails from the same domains are received then outlook will compile all in a new folder (company name) then, whenever new emails from this domain is received all emails are moved to this folder automatically?
...needs to do a search and replace. File name 0001-hello [ログインしてURLを表示] >SC00001WHT-SC01-hello [ログインしてURLを表示] File that I needs to be processed can be from a txt file or csv,excel etc. I got a list of before/after names, the program needs to search for before (ie. 0001) and replace it with after (SC00001WHT-SC01) File that I would give you: OLD
Macro to Manipulate Data in a MS-Word Table This is a request for a macro to run on Microsoft Word and to make some changes to a table and to the cells within the table. You will need experience in writing MS-Word macros and table management. PowerPoint can export a Word document which contains images of the PPT slides in a table. The table
We have an excel macro that copies data from one worksheet then creates a pivot table on said data. For some reason, as the quantity of data has increased, some of the data being copied is lost. I know which row the data stops at. It seems some of the VBA or Formula's are incorrect. The data seems to stop at SheetA: Row: 13880
This is the Macro Im having trouble with. It adds the name and address and a job number to the file name. I am getting a save failed msg and a Run-time error 1004 Sub SvFile() [ログインしてURLを表示] Filename:= _ "Z:Black Forest Hardwood FloorsBLACK FOREST HARDWOODS" & Range("FORMULAS!b26") & " Contracts" & Range("FORMULAS!A62")...
I need a few lines of VBA code that will import 3 x CSV files into an Excel sheet. There are 3 reports, and the latest dated report of each report should be opened, copied and pasted in the tabs provided. The CSV files should then be closed.
Produce a Excel Macro (2016) that can deliver 100s of online valuations with a single button click. You will query our online valuation API. Full details attached. Please apply through Freelancer.com only.
I need a person to work and try and finish the work in next three hours. Its a slightly Complicated and need some one Expert in Excel. More Details in Chat Condition: Duration: The work Needs to be finished in 12 hours maximum but if you can finish it in 3 hours, you will get bonus Payment: $20. It will only be done after work is complete. No
I have been given this Excel test to complete. It wants data from one sheet copied to 4 other sheets and sorted by macro (as per the instructions on the sheet). It looks quite simple but my knowledge of macros and logical functions is not up to it. I need someone to do this, saving the 4 macros on the workbook, I need an explanation of how it was done
we are a construction company that is looking to hire a freelancer for a short period of time to assist to build and implement a user friendly form for our employees. the application should be intuitive and user friendly. users will key in data and the form should be able to churn out quotations, invoices and a P&L budget sheet for projects with our company's letter head, etc. office ma...
We are a beds and mattresses retailer and looking for a logo for our company. Logo should be delivered the message that we are a beds and mattresses retailer. Preferred colors for the logo are Blue and Metallic silver. Please see the attachment for the similar ideas.
I have an excel macro that takes data from an excel workbook, and generates multiple outlook email messages from the data in the excel workbook. This code works right now in windows excel, but not with mac excel. I need to make this code compatible with mac excel.
Hello Freelancers, I need macro for my excel file. Macro need to open a .pdf file and read data and input it to my excel tables. In .pdf file are images som .jpeg so you need to use OCR to read text from images. Details and files in PM
Hello, I'm trying to enter data I fill in from Sheet 1, in Workbook1, into multiple sheets, workbooks, other xlsx files, etc. I'm totally open to suggestion on how to improve my process to make the process itself go more smoothly. As is, I'm trying to do it now, but it's taking forever. A few things to consider: 1. The data entered by me in the source sheet will be in...
I have two excel files, one which has first names, Last Names, address, and ID the other file doesnt have the ID, so I want to import the Id into the other file where it matches first, last and address
I need a macro VBA. In the file attached, i have two tables, both with ID NUMBER, a date and a Type. On the red Column "OLD ID"from the left table, i need to find a value "old ID" from the right table that has the same type and the inv. date has to be previous from the date on the left "del. date" . This are the conditions: Same type and del. date
This project will require VBA Excel coding. The attached file consists of the following tabs: Raw Data Name List Pivot Table Email Template The macro will: 1- go to the name list 2- filter the pivot by the name 3- copy the filtered pivot 4- open an email 5- include the email template 6- update the name in the email 7- paste in the
i have xls wanted it open in excel file with groups and with sub totals and with design
I need you to develop some macro for me. I would like this macro to be developed with 3 logics We have a pick up trip sheet for passengers The drop sheet prepared will be dynamic in nature but will consist same passengers that we picked up We need to apply logic for drop saying which cab did pick them by using pick sheet. And a bit more logics there
I need a macro created so it calculates the Sale Price & Shipping Price of our products so that we make 20%. The profit calculation is as followed; Profit ($)= ((Sale Price + Shipping Price)*.85) - ODT Cost Profit (%)= (((Sale Price + Shipping Price)*.85)- ODT Cost)/ODT Cost Again I need the following Sale Price & Shipping Price. Rules:
Need to convert data contained in array into tabular format. 1st row is the header row and in the output date colu...the integer values would come under a column called Hours. Integer value would move to row corresponding to date. See Raw to Clean tabs in file attached. Desire VBA macro solution for excel to convert unlimited rows and columns of data.
I need a simple excel vba macro to automate turning excel file flat for access import.
Microsoft Outlook We would like the ability to SEND ALL emails that are in our DRAFT folder. We have multiple email accounts within Microsoft Out...have multiple email accounts within Microsoft Outlook so we would like to be able to specifically nominate the draft folder to SEND ALL. We believe this may be best via a Macro. Can you help?