Save this Search
     

All JobsVBA

 (93 results)  
Sort by:
  • Posted Date
Results for 'VBA'
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: 3h, 43m ago  |  Ends: 14d, 20h  |   5 Proposals
Need a document similar to attachment, but more complex. Images will be provided. Asset numbers will be provided. There will be changes so please quote hourly rate. Thanks, Bradley
Category: Other IT & Programming       
Skills: Microsoft Excel, Excel VBA       

m****rgy
 [?]
Sign in to view client's details.
| m****rgy
|    United States
Hourly Rate: Less than $10 / hr   |  Duration: 1-2 weeks  |  Posted: 4h, 25m ago  |  Ends: 14d, 19h  |   1 Proposal
Looking for someone who takes initiative and prides them-self on making sure their customers are truly happy with their service. We are looking for a true professional who will take it upon them-self to learn quickly. We are looking for those who also are extremely professional on the phone. With a You are not shy of the phone and will be required to spend at least 2 hours of the day on the phone. You should have a technical background understanding Excel Pivot Tables and customization. You should be process oriented and organized to ensure you are effective in help our customers.
Category: Technical Support       
Skills: Phone Support, Zoho CRM, Excel VBA       

B****ign
 [?]
Sign in to view client's details.
| B****ign
|    Canada
Fixed Price: Less than $500   |  Posted: 10h, 28m ago  |  Ends: 1d, 13h  |   5 Proposals
I have a Workbook which contains set of sheets with Data. The sheets has set of Columns - some are Mandatory & Non-Mandatory. I need to run Validations inside the workbook. The data sets across the workbook are linked with sheets. Set of Validations that need to be run - Check, Highlight & Report: - If any Mandatory fields has Blanks / Invalid Data - Valid Email addresses - If values of Country, Currency, UoM, Payment Terms, etc. exists in the Master Data sheet I'm attaching a Criteria Checklist based on which the checks would be performed. I'm attaching the template sheet and would request a Skype call to detail out any further information. thank you
Category: Data Analysis       
Skills: Microsoft Excel, VBA, Excel VBA       
Preferred Location: India

e****ics
 [?]
Sign in to view client's details.
| e****ics *
|    India
Hourly Rate: $15 - $20 / hr   |  Duration: 3-4 weeks  |  Posted: 19h, 55m ago  |  Ends: 29d, 4h  |   28 Proposals
I am looking for an excel / vba expert. We had someone build what we need but we did not know that he would use "stata" which we were not aware of. We need someone to take what he built using stata to vba. The project has 1 sheet with 15 tabs worth of dynamic data.
Category: Data Analysis       
Skills: Microsoft Excel, VBA, Excel VBA       

v****rix
 [?]
Sign in to view client's details.
| v****rix
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: May 03, 2015  |  Ends: 13d, 21h  |   6 Proposals
I have a Microsoft Excel Macros VBA I am looking to incorporate into a Javascript application I am developing> I am looking for someone who can work with our in house developers to convert this code. I have attached a partially completed spreadsheet. The 2D and 3D regularization codes can be found in the VBA editior. I have not created this code myself so there is also a website you can use as reference (included in VBA editor)
Category: Other IT & Programming       

T****ins
 [?]
Sign in to view client's details.
| T****ins
|    Australia
Fixed Price: $99,999 or less   |  Posted: May 03, 2015  |  Ends: 13d, 13h  |   8 Proposals
hi all, interesting optimization problem here. looking for a talented mathematician who is up for the challenge! please refer attached spreadsheet 'hedgeSample.xls' 1. high level explanation (context) a) there are 20 fights each week between a Horse, Dog and Alligator b) we ascribe probabilities to which animal will win each fight (columns B:D), then use ranking criteria to rank the fights c) we place an accumulator bet covering X fights (cell S2) attempting to guess the top Y-ranked fights (cell M1). The bet costs T2 and the payout is U2 d) the bet only pays out if we cover ALL of the top Y-ranked fights YOUR MISSION e) we wish to bet on any combination of individual fights (at fair odds based on probability) to optimally hedge our exposure from the above bet in c) 2. ranking criteria for the fights (implemented in column K) i. Dog > Alligator > Horse ii. if >1 fight has same winning animal, tiebreak ranks applied randomly (columns H:J) iii. if tiebreak criteria are a...
Category: Statistics       
Skills: Statistics, Mathematics, Algorithms, Excel VBA       

r****wan
 [?]
Sign in to view client's details.
| r****wan
|    Hong Kong SAR, PRC
Fixed Price: Not Sure   |  Posted: May 02, 2015  |  Ends: 13d, 1h  |   16 Proposals
Hello We would like to automate a couple of our manual processes. We would like to start with the client database. based on the client master screen in our excel file we will need 1. form to fill in all the details. 2. database to store all the details. 3. screen to see the records, sort records based on name, city, zip, country, etc We need the database / form to be accessible by multiple users at the same time. we currently use OPEN OFFICE on our MAC machines. if you feel that this wont work with Open Office, we will install MS OFFICE. awaiting your reply and a quote and time line only for this. once this is done we will proceed to other modules.
Category: Software Application       
Skills: Excel VBA       

p****tin
 [?]
Sign in to view client's details.
| p****tin
|    India
Fixed Price: Not Sure   |  Posted: May 02, 2015  |  Ends: 12d, 23h  |   19 Proposals
What I need is an excel spreadsheet that I can import a bunch of contact information into one sheet. As I attempt sales calls to each, the row of contact data will move to a specified sheet related to the status of that contact. I would also need it to integrate with another spreadsheet that tracks performance ratios. I can explain in greater detail about this later.
Category: Data Engineering       
Skills: Microsoft Excel, Sales, Excel VBA       

j****_12
 [?]
Sign in to view client's details.
| j****_12
|    United States
Fixed Price: Less than $500   |  Posted: May 02, 2015  |  Ends: 12d, 2h  |   18 Proposals
its a workbook where you put in all your information about the company that you work for including all rates of pay and inc early start money and nights out etc. then there is a daily input page for start time end time etc and your daily wages are calculated etc also a VDO pages where you put in your tacho information. i do have a partly working workbook already but i just need it finishing. im new to programming and ive run out of time to complete this myself and need to hire someone to finish this project for me. i do have a file for viewing if required.
Category: Financial Reporting       
Skills: Microsoft Excel, Excel VBA       

F****011
 [?]
Sign in to view client's details.
| F****011
|    United Kingdom
Fixed Price: Not Sure   |  Posted: May 01, 2015  |  Ends: 12d, 1h  |   24 Proposals
Looking for someone to create and Excel VBA script for me. Basiclly, it will be a file lister (folder & subfolders). All filetype are tiff. Some are 1-Bit and some 24-bit. The macro will list (show) only the 24 bit then change the file extensions to jpg (replacing the tiff in the same folder). If it could use multiple threads to preform this and increase the speed, that would be awesome. Must be a functioning excel not just the script.
Category: Other IT & Programming       
Skills: Excel VBA       

a****ley
 [?]
Sign in to view client's details.
| a****ley
|    United States
Fixed Price: Less than $500   |  Posted: May 01, 2015  |  Ends: 11d, 17h  |   7 Proposals
Depending on how quickly this can be finished, I'm willing to pay $100-200. I will even pay you if you find a version online that has already been completed. Preferably I'd like it done by tomorrow, no later than Sunday evening. If you are skilled at VBA this project should be straight forward and easy to complete. Project #43 on this website:   [obscured]  /excel2/ProjectsManual.html
Category: Other IT & Programming       
Skills: Microsoft Excel, VBA, Visual Basic, Excel VBA       

S****Sam
 [?]
Sign in to view client's details.
| S****Sam
|    United States
Fixed Price: Less than $500   |  Posted: May 01, 2015  |  Ends: 11d, 17h  |   7 Proposals
Do you have experience creating DAX calculations in PowerPivot? If so, I might need your assistance to write one calculation for me. I have the number of daily applications, but I need a calculation to show an aggregation of the total of applications up to specific dates. As an example, look at the attachment. 2/22/2011 had 35 applications, 2/23/2011 had 28 applications, 2/24/2011 had 21 applications. The formula will show the aggregation, in this example: 2/22/11 would be 35, 2/23/2011 is 35+28, and 2/24/2011 would be 35+28+21. I can explain in more details if you have any questions. This could lead to more projects. I hope you can help!
Category: Business Intelligence       

g****nce
 [?]
Sign in to view client's details.
| g****nce
|    United States
Fixed Price: Less than $500   |  Posted: May 01, 2015  |  Ends: 11d, 17h  |   5 Proposals
Do you have experience creating DAX calculations in PowerPivot? If so, I might need your assistance to write one calculation for me. I have the number of daily applications, but I need a calculation to show an aggregation of the total of applications up to specific dates. As an example, look at the attachment. 2/22/2011 had 35 applications, 2/23/2011 had 28 applications, 2/24/2011 had 21 applications. The formula will show the aggregation, in this example: 2/22/11 would be 35, 2/23/2011 is 35+28, and 2/24/2011 would be 35+28+21. I can explain in more details if you have any questions. This could lead to more projects. I hope you can help!
Category: Business Intelligence       

g****nce
 [?]
Sign in to view client's details.
| g****nce
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: May 01, 2015  |  Ends: 1d, 10h  |   5 Proposals
We're looking for someone with experience on the new Excel 2013 Power BI tools and VBA to assist in developing links to a DB2 data warehouse, as well as to streamline existing reporting processes. Knowledge of IBM Domino would also be beneficial.
Category: Business Intelligence       
Skills: VBA, Microsoft Excel PowerPivot       

t****ene
 [?]
Sign in to view client's details.
| t****ene
|    Australia
Hourly Rate: $15 - $20 / hr   |  Duration: 1-2 weeks  |  Posted: May 01, 2015  |  Ends: 11d, 4h  |   24 Proposals
Hi we are caterers with a simple excel spreadsheet that tells us what to pack ( food & equipment) when we go to functions and cater. e.g. it will tell us (among many other things)how much meat to take dependent on excel pull down menus Over time though our menu has changed but the spreadsheet has not been updated we need this fixed I am hoping I can employ somebody to fix the problems ( or create a new version ) whatever is easiest) and then after we have finished this part add more features on an ongoing basis but not each week, just when we change our menu, here and there. I don't know if it is 2 hrs or 10 hrs work, I would prefer to employ someone on an hourly rate so we can keep track of achievement of goals easily. Thanks
Category: Data Engineering       
Skills: Excel VBA       

f****oks
 [?]
Sign in to view client's details.
| f****oks
|    Australia
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 30, 2015  |  Ends: 10d, 18h  |   33 Proposals
When filling out a button on the excel form the triggered macros displays an error. This was written by another employee that is no longer with the company. We have copied the files to our system.
Category: Software Application       
Skills: .NET Framework, PHP, VBA, IMacros, Excel VBA       

D****tra
 [?]
Sign in to view client's details.
| D****tra
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 30, 2015  |  Ends: 10d, 18h  |   17 Proposals
Want to have some dashboards in EXCEL developed. Please respond with some sample of your work. Thanks
Category: Data Analysis       
Skills: Excel VBA       

e****anc
 [?]
Sign in to view client's details.
| e****anc
|    United States
Hourly Rate: $3 - $5 / hr   |  Duration: Not Sure  |  Posted: Apr 30, 2015  |  Ends: 10d, 15h  |   4 Proposals
We are looking for an expert who can help us to convert our excel based dashboard to web based. as we regularly send excel dashboard to our internal customers. It takes a lot of time to emailing them. We want this dashboard as user based so that we can share the relevant information to respective customer. We would like to atomize this process. Thanks.
Category: Web Programming       

M****_IT
 [?]
Sign in to view client's details.
| M****_IT
|    Pakistan
Fixed Price: $50 or less   |  Posted: Apr 30, 2015  |  Ends: 10d, 15h  |   2 Proposals
Manufacturing process capacity analysis tool. I have created an excel sheet that will analyze single processes (see attachment). I would like to create a tool whereby I can analyze many processes quickly. The tool I am looking for can analyze upto qty 40 processes steps on individual tabs The tools should contain a summary tab with a basic 'op load' diagram. I should be able to upload the predicted demand for each part number. I should be able to configure or upload the processes used by each part number. Note: this is a mixed model cell whereby different part numbers can go through different process sequences (combinations)
Category: Database Development       

D****Kir
 [?]
Sign in to view client's details.
| D****Kir
|    Ireland
Fixed Price: Not Sure   |  Posted: Apr 30, 2015  |  Ends: 10d, 13h  |   4 Proposals
I am looking for someone skilled with Excel and Google Sheets to redesign and update a template. Knowledge of HootSuite and social media posting is also a plus, but not strictly necessary as long as you can do the work. The template will be used for creating and posting on social media using HootSuite. This task will involve: 1) A single document with multiple sheets that must be easily accessed and edited. For reference, here is the starting document:   [obscured]  /spreadsheets/d/1rK_F7I8MknJ3fFj1O8IAFatlB5BRGQt1wIUhwGTAKNg/edit?usp=sharing 2) Integrating a calendar into a sheet (the fields of which, when entered, automatically fill into the main document) 3) Automatic conversion to .csv friendly format which can be downloaded directly from Google Sheets (the formating occurs in the current template but is lost when you try to download from the sheet directly) 4) If possible, integrating automatic URL shortening using   [obscured]   5) Some alteration to the design ...
Category: Other IT & Programming       

e****nod
 [?]
Sign in to view client's details.
| e****nod
|    United Kingdom
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 29, 2015  |  Ends: 10d, 1h  |   8 Proposals
I have a need for a REST API programmer to in ?effect "upload" an excel sheet of information into insidesales.com, by taking the information provided on the excel and 'addcase' into insidesales.com   [obscured]  /lmp/products/lmp/apis/ don't worry to much about the excel piece, I can create a VBA that will take whatever the user enters, validate it and export it into a file format you can use, but the end goal is to be able to add a bunch of 'case objects' into our site on insidesales.com.
Category: Other IT & Programming       
Skills: API Development       

s****n32
 [?]
Sign in to view client's details.
| s****n32
|    United States
Hourly Rate: $10 - $15 / hr   |  Duration: 1-2 weeks  |  Posted: Apr 29, 2015  |  Ends: 9d, 15h  |   5 Proposals
Requesting Excel/Macro application experts. I need to have one activity automatically produced. I'm using a SAAS based solution software. I need to have my reports from the cloud application automatically exported to excel and formatted correctly. Please let me know if you can automate this task. Thank you
Category: Data Analysis       
Skills: IMacros, Excel VBA       

j****pla
 [?]
Sign in to view client's details.
| j****pla
|    United States
Fixed Price: Less than $500   |  Posted: Apr 29, 2015  |  Ends: 9d, 15h  |   15 Proposals
I have created a basic outline of two workbooks that need to be created. 1. Create template workbook from associate summary1 'create books' sheet for each name listed in name field when create workbook button is pressed for corresponding field. Save workbook as name field in folder listed in file path field on same page. Template Workbook: 2. On 'dashboard' sheet, clicking on the add to funnel button adds the fields listed above in red are added to corresponding columns in the 'funnel' sheet in same workbook. 3. Fields listed with an asterisk (*) are required to input for macro to work. (pop up error optional). 4. Fields with validation are to have drop down selection boxes. 4.a. For lead source, validation drop box items to be validated from input sources (in green) in Associate Summary1 workbook 'store dashboard' sheet. 4.b. Probability validation has drop down selection of 25%, 50%, 75% and 95%. 4.c. Apt. Made? validation has drop down selection of yes or no. 5. When fi...
Category: Other IT & Programming       
Skills: Excel VBA       

C****tor
 [?]
Sign in to view client's details.
| C****tor
|    United States
Fixed Price: Not Sure   |  Posted: Apr 29, 2015  |  Ends: 9d, 15h  |   15 Proposals
I have a moderately complex VBA/Access application (~95 forms) with a decent amount of code that i want ~9-15 enhancements, predominately around updating the look and feel (style, logo's, etc). Probably best to upgrade as well (currently Access 2007). Uses Sagekey for security and the access deployment. One contractor selection is made, i can provide more detailed requirements.
Category: Database Development       
Skills: VBA, Microsoft Access Programming       

m****l10
 [?]
Sign in to view client's details.
| m****l10
|    United States
Fixed Price: Not Sure   |  Posted: Apr 29, 2015  |  Ends: 9d, 11h  |   18 Proposals
Our company is a producer and collector of economic data. We are looking for a programmer to develop an application to upload data from our propretary Excel files into an existing SQL Database. The application will be developed as an MS Excel add-in to be placed in the Excel ribbon. In the attachment you will instructions describing the ideal setting of the application and the functions that it should comply. The application will allow for instant upload of specific type of Excel files but also for ad-hoc uploads. Key to the success of the application is precision and speed of upload. Upload must be instant. We handle lots of data requests over the course of our daily work and any slight delay in the ability to access data can add bottlenecks to our production process. Further ideas for development may be communicated over the course of the development of the application.
Category: Software Application       

F****sEc
 [?]
Sign in to view client's details.
| F****sEc
|    Spain
Symbol Key
Payment method not yet verified
Payment verified
Purchased $1-$500
Purchased $500-$5,000
Purchased more than $5,000
You have already submitted a
proposal to this job