Save this Search
     

All JobsExcel VBA

 (79 results)  
Sort by:
  • Posted Date
Results for 'Excel VBA'
Hourly Rate: $15 - $20 / hr   |  Duration: 1-2 weeks  |  Posted: 8h, 44m ago  |  Ends: 14d, 15h  |   4 Proposals
I require a design minded person to convert excel spreadsheets to in design that has already been designed. The designer needs to be able to simply copy and paste the excel spreadsheet tabs and paste into the designed template. There are approximately 40 pages/tabs for each level. There are four levels; Beginner, Intermediate, Advanced and Pro which all have approximately 40 programs for each level. There are a total of four courses; 1) Lean & Mean (I have attached Lean & Mean - Beginner as a guide to show you what needs to be copied and pasted into the Indesign Template. 2) Farmhard 3) Fightweight 4) Straight Up Its a simple copy and I need an efficient person to complete the job within reasonable time frame.
Category: Project Management       

s****ner
 [?]
Sign in to view client's details.
| s****ner
|    Australia
Fixed Price: Less than $500   |  Posted: 8h, 53m ago  |  Ends: 2d, 15h  |   7 Proposals
We use an Excel spreadsheet that includes several worksheets, one of which is named "Inv. Sum.". We are looking for a developer to create an Add In to allow a user to right-click on any worksheet tab and in the right-click menu, and have an item available that reads "Move Summary before this sheet". When the user selects this option, the code would move the "Inv. Sum." worksheet before the selected sheet. We use Microsoft Excel 2013, and would require the solution to be provided as both an install package and the source code file in .Net compatible with the Visual Studio Express software.
Category: Software Application       

m****ion
 [?]
Sign in to view client's details.
| m****ion
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: 20h, 10m ago  |  Ends: 14d, 3h  |   4 Proposals
I am trying to put together a program in Excel that displays all of the compressors that fit a specific flow and pressure that a customer would specify. I have data on all of the different compressors for our company and two of our competitors. I would like an "X" to appear on a graph for the customer's input, and then area charts of all the compressors that can meet the specification. For each compressor's area chart, I would like there to be an easy way to distinguish one from the other. Lastly, I would like the display to be easily printable for our salesmen out in the field to show customers which of our compressors can meet their needs. An example of the type of area chart we're looking for is on page 2 of the attached sales leaflet.
Category: Data Analysis       
Skills: Database Programming, Data Mining, Excel VBA       

b****123
 [?]
Sign in to view client's details.
| b****123
|    United States
Hourly Rate: More than $50 / hr   |  Duration: 4-6 months  |  Posted: 21h, 19m ago  |  Ends: 14d, 2h  |   19 Proposals
The ClearPoint Data Analyst is responsible for providing guidance, quantitative analysis, and expertise in the interpretation of multiple data sets. He/she will be asked to build reproducible reports and dashboards ? for one of our new product lines ? as we work towards proving our initial hypothesis. The ideal candidate will have a desire to grow the position, improve our data gathering efforts, and standardize our approach to analytics. This person will also be asked to assist in R&D efforts by developing data models and seeking correlation between multiple data sets, potentially even assisting with the development of corollary algorithms. Responsibilities: ? Extract and manipulate data from multiple systems internally and externally ? from client's systems ? to create statistical reports and dashboard visualizations. ? Utilize a Business Intelligence tool to generate and distribute scheduled reports and dashboards. ? Review raw data from training assessments & surveys and...
Category: Data Analysis       

B****235
 [?]
Sign in to view client's details.
| B****235
|    United States
Fixed Price: Less than $500   |  Posted: 22h, 57m ago  |  Ends: 14d, 1h  |   27 Proposals
EDIT: by database I am referring to a simple Excel list Hi everyone, I am looking for a skilled VBA professional to develop an automation macro for a database. Following is an overview of the end-result: We have a database A, with a list of different types: O, P, Q, which all have different characteristics: height, weight, age. All characteristics are written on the same row as the type, inside the neighbouring columns. Also, we have database B, with identical layout as database A, where there are different instances of those database A types: O-1, O-2, P-1, P-2, Q-1, Q-2. All instances of the same letter have the same charateristics, as declared in database A. Since the charateristics (height, weight, age) change over time, I need a macro which connects these databases i.e. if something in database A is changed it will, by the click of a button, update all the instances in database B. To add: It will also automatically identify which types have changed and will offer you checkb...
Category: Database Development       
Skills: Microsoft Excel, Excel VBA       

k****und
 [?]
Sign in to view client's details.
| k****und
|    Canada
Fixed Price: Not Sure   |  Posted: May 04, 2015  |  Ends: 13d, 16h  |   3 Proposals
Hi, Im am looking for anyone who is familiar with the models below: ? Model VaR ? Simple Linear Regression ? Random Walk Model (RW) ? Random Walk with Drift Model (RWD) ? Deterministic Linear Trend Model (LT) ? Deterministic Quadratic Trend Model (QT) Also, fully understand the use of appropriate software. Urgent work. Hope to hear from you soon! Best regards.
Category: Data Analysis       
Skills: Excel VBA       

Y****rng
 [?]
Sign in to view client's details.
| Y****rng
|    Malaysia
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: May 04, 2015  |  Ends: 13d, 12h  |   19 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: May 04, 2015  |  Ends: 13d, 11h  |   4 Proposals
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: May 04, 2015  |  Ends: 5h, 25m  |   10 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: May 04, 2015  |  Ends: 27d, 19h  |   33 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: 12d, 13h  |   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 completed works sheet of what I am looking to replicate through Javascript. The 2Dregularization function which can be found in module 1 of the VBA editor is the key function which needs to be replicated. The logic behind this code can be found at the following website:   [obscured]  /2013/02/13/regularizedata2d-the-excel-spreadsheet-function-for-regularizing-2d-data-part-1-of-2/ I am looking for a fixed price proposal, so please submit this based on the completed excel worksheet.
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: 12d, 5h  |   10 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: 11d, 16h  |   17 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: 11d, 14h  |   24 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: 10d, 18h  |   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: 10d, 17h  |   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: 10d, 9h  |   8 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: 10d, 9h  |   8 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: 10d, 9h  |   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: $15 - $20 / hr   |  Duration: 1-2 weeks  |  Posted: May 01, 2015  |  Ends: 9d, 20h  |   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: 9d, 10h  |   34 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: 9d, 10h  |   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: 9d, 7h  |   5 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: 9d, 7h  |   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
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