Save this Search
     

All JobsVBA

 (75 results)  
Sort by:
  • Posted Date
Results for 'VBA'
Hourly Rate: $10 - $15 / hr   |  Duration: 3-4 weeks  |  Posted: 2h, 27m ago  |  Ends: 14d, 21h  |   6 Proposals
1) Making the Product codes match Column "C" Bigcommerce "Code" with Column "B" Agiliron "Poduct code". 2) Making the Categories match Column "Z" Bigcommerce "Category Details" with Column "D" Agiliron "Product Category". 3) Making the Manufacturers match Column "E" Bigcommerce "Brand" with Agiliron Column "E" "Manufacturer" 4) Placing the prices from Bigcommerce (calculated price in column "J") into ("Online Prices" column "AM") of Agiliron File(s) For the categories in Agiliron there is a spec sheet that the support team at Agiliron sent me which is: To create category hierarchy in Agiliron: The format to provide in the Agiliron spreadsheet is "Hardware::USB::USB Drives" as an example - here USB category is child of Hardware and USB Drives is a child of USB, the :: implies parent child relationship. If a product...
Category: Web Programming       
Skills: BigCommerce, Excel VBA       

c****lon
 [?]
Sign in to view client's details.
| c****lon
|    United States
Fixed Price: Not Sure   |  Posted: 4h, 9m ago  |  Ends: 6d, 19h  |   5 Proposals
Seeking a web scraping expert who has knowledge of building custom solutions to web scrape problems. I'm new to doing web scraping and I am looking for someone who can guide me in building a basic custom web scraper and then a more complex scraper. I have a rudimentary knowledge of programming with VBA but I am not limited to VBA.
Category: Web Programming       
Skills: HTML, PHP, Web scraping       

m****woo
 [?]
Sign in to view client's details.
| m****woo
|    United Kingdom
Fixed Price: $500 - $1,000   |  Posted: 6h, 27m ago  |  Ends: 14d, 17h  |   10 Proposals
Simple website with specific login info for different partners to enter customer data for loan approval. When the data is entered an approval generated from an excel spreadsheet will give the dealer partners a deal structure for a loan. Also need to track workflow of approvals , deals , verification , funding, completed deals.
Category: Business Intelligence       
Skills: API Development, Excel VBA       

C****ggs
 [?]
Sign in to view client's details.
| C****ggs
|    United States
Fixed Price: Less than $500   |  Posted: 9h, 27m ago  |  Ends: 14d, 14h  |   24 Proposals
Hi there, I need an excel expert to assist please. I have a financial forecast and need to incorporate the correct pricing methodology. I need some sophistication and automation to capture the correct sales methodology in the model - here is the job; We are a SaaS software, selling a project based product to customers. We have 2 types of customers - small companies and large companies. We sell our products on a rollout/waterfall approach; Small company; When they take up our product they pay for an onboarding fee (one off) $X First 4 months they pay $Y/month Then the next 4 months their monthly cost increases (upgrade) to $Z/month Thereafter their monthly cost increases to $XX/month Large Company When they take up our product they pay for an onboarding fee (one off) $X First 4 months they pay $Y/month Then the next 4 months their monthly cost increases (upgrade) to $Z/month Thereafter their monthly cost increases to $XX/month What I would like to be able to do is have any ne...
Category: Data Analysis       
Skills: Microsoft Excel, Excel VBA       

A****ght
 [?]
Sign in to view client's details.
| A****ght
|    New Zealand
Fixed Price: $100 or less   |  Posted: 17h, 4m ago  |  Ends: 14d, 6h  |   5 Proposals
I'm looking for a VBA function (to be used in Microsoft Access/Excel) that I can pass an IP address to for an SSL enabled site, have the code do an http request, and return all the details about the certificate (i.e. who issued it, the hostname, expiration date, etc). I've been looking at wininet.dll and winhttp.dll but haven't been able to get the code to work.
Category: Software Application       
Skills: VBA, Microsoft Access Programming, Excel VBA       

p****zls
 [?]
Sign in to view client's details.
| p****zls
|    United States
Hourly Rate: $5 - $10 / hr   |  Duration: Not Sure  |  Posted: 21h, 56m ago  |  Ends: 14d, 2h  |   8 Proposals
Create proofs of concept user-interface mock-ups & similar tools for the product manager. Produce technical documentation for proposed or developed solutions including flowcharts layouts diagrams charts code comments. Participate in the design development of new dashboards, reports, and report requests. Ensure the integrity of data, including extraction, processing, storage, manipulation analysis. Responsible for managing assigned projects, tasks multiple priorities. Proficiency with MS Excel and Access; an expert in V-Lookups, and Formulas. Must be English speaking. Respond with some more involved data basis that you have developed. Preferred but not required: Must be solid in database structure and development. Must have intermediate to advanced knowledge in VBA , MACROS and look up functions. If you think that you qualify with all or some of these skills sets please apply and let me see what you have to offer.
Category: Database Development       

K****are
 [?]
Sign in to view client's details.
| K****are
Hourly Rate: $5 - $10 / hr   |  Duration: Not Sure  |  Posted: 22h, 55m ago  |  Ends: 14d, 1h  |   4 Proposals
Create proofs of concept user-interface mock-ups & similar tools for the product manager. Develop queries & stored procedures in support of ongoing project work application support. Create, test, and also support data models, structures, and also processes for reporting analysis. Produce technical documentation for proposed or developed solutions including flowcharts layouts diagrams charts code comments. Participate in the design development of new dashboards, reports, and report requests. Ensure the integrity of data, including extraction, processing, storage, manipulation analysis. Responsible for managing assigned projects, tasks multiple priorities. Must be English speaking. Respond with some more involved data basis that you have developed. Preferred but not required: Must be solid in database structure and development. Must have intermediate to advanced knowledge in VBA , MACROS and look up functions. If you think that you qualify with all or some of these skills set...
Category: Database Development       

K****are
 [?]
Sign in to view client's details.
| K****are
Hourly Rate: Less than $10 / hr   |  Duration: 1-2 weeks  |  Posted: Jul 02, 2015  |  Ends: 13d, 19h  |   9 Proposals
hi it should pull data from website everyday and save it . live data should be compared with a month back data. programmers who know stock market futures and options and did trading in indian stock market only contact for detail.
Category: Data Analysis       
Skills: VBA, Excel VBA       

n****kar
 [?]
Sign in to view client's details.
| n****kar
Hourly Rate: Less than $10 / hr   |  Duration: Not Sure  |  Posted: Jul 02, 2015  |  Ends: 13d, 16h  |   8 Proposals
We have to Download an Excel File from a SAP system automatically. SAP system is not Browser based but TI based (am not even sure what is TI Based SAP software). All this has to be done in Excel . Am uploading a video which shows what is the manual process. Please quote accordingly and also showcase any previous SAP based projects completed by you (looking for experienced freelancers).
Category: Software Application       

a****hit
 [?]
Sign in to view client's details.
| a****hit
|    United Kingdom
Hourly Rate: $30 - $40 / hr   |  Duration: 3-4 weeks  |  Posted: Jul 02, 2015  |  Ends: 13d, 16h  |   30 Proposals
We are currently using an Excel 2013 workbook with macros to do revenue forecasting at the resource level for our consulting firm. We were building in house but our team has maxed out both on skill and available time to finish the project. We need help with simplifying the macro process and reporting so that it easier to execute and our data entry has less risk of user error.
Category: Data Analysis       
Skills: Data Entry, Excel VBA       
Preferred Location: United States

a****ida
 [?]
Sign in to view client's details.
| a****ida
|    United States
Hourly Rate: Less than $10 / hr   |  Duration: 1-2 weeks  |  Posted: Jul 01, 2015  |  Ends: 13d, 11h  |   2 Proposals
take charts/grafics information front stock charts , used the price values of bars H,L,O,C values into at x>y , if true=1 , if not =0 . also take values front indicatores in the chart/grafics and be able to aplicate same logic , result will be transfer to BINARY CALCULATOR , sample grafic used 6 variable fpga calculator has to be able to aplicate x>y=? and plot result into at excel page and . others detail will be sumit later
Category: Data Analysis       
Skills: Microsoft Excel, Excel VBA       

f****dia
 [?]
Sign in to view client's details.
| f****dia
|    United States
Fixed Price: Less than $500   |  Posted: Jul 01, 2015  |  Ends: 13d, 6h  |   20 Proposals
I am in the process of getting quotes from venues for my wedding. The issue is there's so many options and prices can change based off those options. I would like someone to create me a spread that would not only show me the total price based off the options and quotes my venues give me but always make it excel live so they can compete with pricing off each other. Obviously we can get into details. I will provide 10 pdf that contain pricing and options and like someone to help me organize this in a way that can give me costs based off my selections for each venue
Category: Database Development       
Skills: Microsoft Excel, .NET Remoting, Excel VBA       

C****rio
 [?]
Sign in to view client's details.
| C****rio
|    United States
Hourly Rate: $15 - $20 / hr   |  Duration: 1-2 weeks  |  Posted: Jul 01, 2015  |  Ends: 13d, 3h  |   4 Proposals
Hello Freelancer. I want to transter excel sheet data from excel to Quickbase through VBA/SQL query without using ODBC driver. One more question: VBA Code/SQL Query should be able to send excel sheet cell image to quickbase API table. Please bid only if you have extensive experience and sure about sending data from excel to quickbase table without using any ODBC driver. I'm looking without any installer based connection(ODBC, QDBC), If you aware about quick book SDK for vba then that 's fine for me. Excel Reference and library are accepted.
Category: Data Analysis       

k****lak
 [?]
Sign in to view client's details.
| k****lak
|    India
Fixed Price: Not Sure   |  Posted: Jul 01, 2015  |  Ends: 28d, 0h  |   6 Proposals
Hi, I'm am an experienced excel user and throughout the time I've been developing codes/macros and buying add-ins to improve my productivity. My problem is that now my excel is completely full of tabs in the ribbon given the number of different add-ins I have bought and I don't use more than 30-50% of each add-in. At the moment I completely lack the time to develop the project myself and for that reason I'd like to hire someone with proved Excel/VBA and related programming experience to develop a customized add-in to organize the tools I use most frequently. Very Important: 1 - Source codes must be provided and not distributed to other clients (I want to have the rights of the application) 2 - The add-in must have a good visual interface as well as functionality (using custom ribbons probably) 3 - ATTENTION: Copyrighted add-ins / applications I have bought won't be provided to avoid copyright law infringements so make sure you have the capability of developing the add-in from s...
Category: Software Application       

l****osa
 [?]
Sign in to view client's details.
| l****osa
|    United States
Fixed Price: $45 - $50   |  Posted: Jul 01, 2015  |  Ends: 27d, 23h  |   11 Proposals
Need an expert in creating a dynamic dashboard. Should expertise in Advance Excel, complex formulas and VBA coding. It would be a dashboard used by 100+ users. Contact me for further info..
Category: Data Analysis       
Skills: Excel VBA       

s****rth
 [?]
Sign in to view client's details.
| s****rth
|    Australia
Fixed Price: $30 - $50   |  Posted: Jul 01, 2015  |  Ends: 12d, 15h  |   19 Proposals
hi, We want a invoice generator through Macro and VB program using sales data from Excel. The invoice template we will provide you for a sample. We will share the project details to selective applicants. Please apply only if you can finish the project within a day. Regards,
Category: Technical Support       
Skills: HTML, Visual Basic, Excel VBA       

D****nij
 [?]
Sign in to view client's details.
| D****nij
|    Taiwan
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 01, 2015  |  Ends: 4d, 15h  |   26 Proposals
I'm looking for someone with Advanced Excel skills. The work is project based and part-time. It involves working with companies with various real estate holdings, trusts, estates and other assets. Must be creative, detail oriented, responsive and professional.
Category: Data Analysis       
Preferred Location: United States

C****sie
 [?]
Sign in to view client's details.
| C****sie
|    United States
Hourly Rate: Not Sure   |  Duration: 1-2 weeks  |  Posted: Jun 30, 2015  |  Ends: 12d, 14h  |   16 Proposals
I am looking for someone to clean up an Excel file (data dump from sales software) and run a few pivots and formulas on it. You should be familiar working w. formulas across different workbooks in one sheet and create beautiful graphs in a dashboard. The file should be formatted so I can just dump data into it each month and it will update the graphs over time. The outcome of the XLS file should be the following: 6 graphs should be in the dashboard: 1)# of gross leads over time 2) # of marketing leads over time 3) # of sales leads over time 4) Cost per lead over time 5) Cost per marketing lead over time 6) Cost per sales lead over time There will be more work later, but I want to get this done asap, Please do not apply if you are not a true Excel expert. If you apply please make sure you have some availability between 7am EST and 12pm on July 1st. I will pick the winner on July 1st between 6-7.30am, so apply fast.
Category: Data Analysis       
Skills: Microsoft Excel, Excel VBA       

w****ics
 [?]
Sign in to view client's details.
| w****ics
|    United States
Hourly Rate: Not Sure   |  Duration: 1-2 weeks  |  Posted: Jun 30, 2015  |  Ends: 12d, 2h  |   3 Proposals
We are an ETF Issuer. We have a fund on the market and would like to create a word or indesign template for an ETF fund fact card that is 1) Macro enabled to update data within the card on demand, linked to a SQL Database 2) consistent with our branding 3)well designed for ongoing use and frequent distribution. The tables and graphs would both be dynamic. This card will be linked to an excel file and have a "refresh" button which would pull the most up-to-date data and populate the tables and graphs. We have a SQL database where the excel file will pull the data from, experience with SQL would be helpful. A PDF version of the current fact card is attached as is a word document example (which is not stylistically what we want it to look like, but an example of the dynamic properties we are looking for in the final PDF). Thank you!
Category: Brochures       

R****nc1
 [?]
Sign in to view client's details.
| R****nc1
|    United States
Fixed Price: $20 - $30   |  Posted: Jun 30, 2015  |  Ends: 12d, 1h  |   32 Proposals
Macro adding row The purpose off this macro , add an extra row if there are more then 2 products with the same product IDs. If answer is yes then add an extra row and fill in collums with others values The double product ids are orange marked in the sheet Rows Copy a row from this product ID range (green marked) Make the following changes Add the lowest price of to the collumn price Add the lowest price to collumn lowest price within this product rang Add text FATHER to collumn CH-FA Add the price gap between the lowest price and normal price in collumn All other values are the same as from another row within this price range Collums to fill 1. CH-FA Add CHILD into collumn CH-FA Add FATHER into collumn CH-FA fort he new added row 2. Lowest price (red marked) Find the lowest price withhin the same product ID Range (red marked) 3. Price gap (purple marked) This ist he price between the lowest price and the price fort he sku in this row Add the lowest priceinto collumn lo...
Category: Data Engineering       
Skills: Microsoft Excel, Excel VBA       

M****ort
 [?]
Sign in to view client's details.
| M****ort
|    Netherlands
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jun 29, 2015  |  Ends: 11d, 12h  |   42 Proposals
Requires consistency, flexibility, great communication skills, and the ability to work well in different tasks. Sensitivity to confidential matters may be required. Currently, the skills required are internet research, data entry, and excel (using formulas, VBA programming is not required but is a plus). Job Description: I'm looking for someone to work with, to help me on variety of projects. I want to hire people for the long term, rather than just short jobs. The job demands will change over time. Your responsibilities: - Data analysis/entry into Excel, Word or other programs - Research using the Internet or other information databases - Email management - Other tasks that can be performed online - Must be able to comfortably speak English - Have Skype or voice chat program and a microphone Please put the phrase anywhere in your proposal: "better an unexpected result than no action" This is my first time hiring a virtual assistant, so this will be a learning experien...
Category: Virtual Assistant       

d****rwl
 [?]
Sign in to view client's details.
| d****rwl
Fixed Price: Less than $500   |  Posted: Jun 29, 2015  |  Ends: 11d, 12h  |   11 Proposals
I'm looking for a solution that can regularly upload opportunity line items to Salesforce also with PDF attachments that have automatically had a company logo attached to them. 1. We will have a CSV file that contains the opportunity line items from a piece of software called VRPRO (kitchen design software), 2. This CSV file contains products that are already listed in my Salesforce database, their price is already in the standard pricebook (also currently in the salesforce database) 3. User experience should look like this: I need the user to input a customer name and opportunity name into Excel (probably an opportunity already created on Salesforce, but not necessarily) I need the user to be able to select the CSV output file (described above) from the local machine, which will provide the opportunity line items to be uploaded I also need the user to be able to add several PDF's (which should automatically have a company logo added to the same position on each pa...
Category: Software Application       

j****nar
 [?]
Sign in to view client's details.
| j****nar
|    United Kingdom
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jun 29, 2015  |  Ends: 11d, 11h  |   3 Proposals
I need an excel macro that will run a set of formulas and create the output in a new sheet. formulas are already created so that saves some time. I'll also need to evaluate the workbook to optimize performance. thanks
Category: Technical Support       
Skills: Microsoft Excel, Excel VBA       

s****mar
 [?]
Sign in to view client's details.
| s****mar
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jun 29, 2015  |  Ends: 11d, 5h  |   27 Proposals
My firm (an alternate asset manager) intends to get on-board on a long term basis a developer with 5 to 7 years' experience in Microsoft technologies to assist with application development and maintenance. The role requires the following, 1. Excellent working experience in developing Windows forms and web applications in Visual Studio 2012; Expert level .net development skills (e.g. C# or VB.NET,ASP.NET, .NET framework 4.0 and above). 2. Expert level working knowledge of SQL server 2005 or higher, fully hands on in writing stored procedures, functions, triggers; well verse in data modeling, table design, data types, table relationships, indexes and code performance tuning. 3. Working knowledge of Excel Macro programming (VBA) is desirable. 4. Good communications skills, strong aptitude in learning new systems and technologies, prior experience of dealing with direct business users is a big plus. 5. Ability to write technical documentation to articulate technical design and implementati...
Category: Software Application       
Preferred Location: United States

c****l74
 [?]
Sign in to view client's details.
| c****l74
|    United States
Fixed Price: $1,000 - $5,000   |  Posted: Jun 29, 2015  |  Ends: 10d, 16h  |   39 Proposals
We wish to port existing Excel VBA implementation to database driven web (including mobile) application. We wish to have the application developed for not more than 20 users. Browser based secure access, output and controls will be accessible through workstations and mobile devices and pads. A DB imports on request pricing data through API from a range of data sources such as Bloomberg. Periodicity of the data ranges from 1 hour to 1 month, and data is in the form of Open, High, Low and Close. A range of simple analytics are applied to this data on request (for example simple moving average), and the resulting time series are being stored alongside the raw pricing data. Charts are being generated and displayed on the basis of stored pricing and analytics data; subject to discretionary control, certain analytics will be recalculated and redrawn.
Category: Database Development       

m****ke1
 [?]
Sign in to view client's details.
| m****ke1
|    Switzerland
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