Excel Vba Jobs

177 were found based on your criteria {{ paging.total|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Fixed-Price - Expert ($$$) - Est. Budget: $300 - Posted
Looking for an excel guru to modify and existing spreadsheet. We would like to have a button within the spreadsheet that when pressed emails certain one of two worksheets within the workbook to an email address in one of the fields. The subject of the email and message would also be included in excel fields. Let me know if you can help with this.
Skills: Excel VBA Microsoft Excel
Fixed-Price - Expert ($$$) - Est. Budget: $20 - Posted
I need to write a macro in Excel (2016 for Mac) that can submit by email as a pdf a portion of a spreadsheet (outlook for Mac) I'm creating a process to submit a form for approval and all sales staff work on Mac. I have the Excel sheet and I need to send the part of the sheet (B7:J57) as a pdf to 2 or 3 email addresses. I'm attaching the file I need you to work on. The sheet is named "Calculator". The simpler the code, the better. Thanks,
Skills: Excel VBA
Hourly - Expert ($$$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
I use an online share brokerage firm that produces live share data for the FTSE 350, NYSE and NASDAQ stock exchanges in real time. Unfortunately, this live data does not extend to the share graphs they produce which has a 15 minute delay. The data I am specifically after that needs a line graph for each entry is the "top risers" for these exchanges which consists of the top 20 stocks for each exchange. As previously stated, this data reflects the live share price but the graphs they produce do not. Here is an example : http://www.hl.co.uk/shares/stock-market-summary/ftse-350/risers This information is best stored in an excel document that can be manually refreshed when needed. The type of graph format is a line graph format similar to what the above site has. Any questions let me know
Skills: Excel VBA Microsoft Excel Microsoft Excel PowerPivot
Hourly - Intermediate ($$) - Est. Time: More than 6 months, 30+ hrs/week - Posted
Hi, We are a company looking to hire a few virtual assistants to help with the day to the day activities of our company. The job is light work that can be done from home. Please take the tests below prior to the interview, they will only take a 2 minutes, thanks! Additional skills that are helpful but not required include Microsoft Excel, PHP, Javascript, and CakePHP knowledge.
Skills: Excel VBA CakePHP Microsoft Excel PHP
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
Must have experience implementing an https API into excel. Read more here: https://www.smsbroadcast.com.au/Advanced%20HTTP%20API.pdf Essentially, I need the spreadsheet to do the following: 1) User selects option a, b, c, d or e (from drop down list) in cell B5 on Sheet1 [a/b/c/d/e corresponds to a respective list of cell phone numbers in Sheet5] 2) User writes message D5 in Sheet1 4) User writes message delay time in minutes D6 Sheet1 5) User clicks button in cell E5 on Sheet1 with runs the following macro: IF option a/b/c/d or e is selected, the corresponding list of numbers is sent the contents of cell D5 with the delay time of D6 via the following HTTPS command that looks similar to: https://api.smsbroadcast.com.au/api-adv.php?username=username&password=pass&to=[Cellphone no.1 ,Cellphone no.2, Cellphone no.3&from=MyCompany&message="D5"&maxsplit=5&delay="D6"
Skills: Excel VBA API Development PHP
Fixed-Price - Intermediate ($$) - Est. Budget: $100 - Posted
Background: We previously hired someone on Upwork to fix our database. The person we previously hired was unable to continue working for us, so we have a half completed project. We have a large e-commerce product database that we are working on building new SKUs for. Previously, identical styles were named with varying names. For example, the shoe named “New Balance 777” might be named 1. New Balance 777 2. 777 NB 3. 777 New Balance This was our biggest problem in joining these different style names into one SKU. I have done the work of making a excel file with each of these names next to what it SHOULD be, (“New Balance 777”), which is how it is in Product/Style Information sheet. One column consists of the old style names, and the column next to it has the new style names (all represented in the Product Data sheet). 1. Raw Data Sheet 2. Product/Style Information 3. Style Numbers and Color Numbers 4. Old Style Names/New Style names (This sheet will be eliminated) 1. Raw Data Sheet Contains all of our data on the Linnworks software. This is all of our ecommerce data. 2. Product/Style Information Each style is a unique row with its own data. This sheet will merge into sheet #1. 3. Style Numbers and Color Numbers Each unique style name in sheet #2 & sheet #1 (should be identical) is given a number. 4. Old Style Names/New Style Name This sheet contains all of the names from the original data that we want to replace with our new data. ————————————————————————— The end goal of this project was to restructure our SKUs based on style name. Our expectations are to have these three sheets work in unison, allow for the modification of style data (sheet #2) which will then be placed into the primary data sheet (sheet #1). Much of this work is already done — the formulas, SKUs, and so forth. We need someone to clean up our Excel file, ensure that the style names are registered to unique values, reduce loading time for calculations (if possible), and to finish this project. I would estimate that over 75% of this project is already completed. Upon completion of this work we have a project that directly involves this exact data. The next step of this project is to upload this file to Linnworks, our inventory database system. I look forward to speaking with you and potentially working together.
Skills: Excel VBA Microsoft Excel
Fixed-Price - Intermediate ($$) - Est. Budget: $250 - Posted
Hi, We have done some analysis manually in the healthcare space - basically exploratory to understand types of drugs used etc. I am looking to create a tool that automates the analysis. I will provide clear instructions and relevant data. Looking for someone that is excellent in excel VBA, tool design, data visualization and aesthetic sense.
Skills: Excel VBA Data Analytics Graphic design