Save this Search
     

All JobsVBAPosted: Within 7 days

 (31 results)  
Sort by:
  • Posted Date
Posted: Within 7 days
Fixed Price: $150 - $550   |  Posted: 19 minutes ago  |  Ends: 14d, 23h  |   0 Proposals
Create a functionality in excel to send sms using excel formulas.For example, if new row found send sms. If value reached specified amount send sms. The sms recieved should include specified columns, hyperlink to the file. Develop a common android and windows application that collects and sorts excel sms with a check mark (completed) option. The app should be tied to another android app CER (for setting reminders on phone)   [obscured]  /store/apps/details?id=de.foobarsoft.calendareventreminder&hl=en
Category: Other IT & Programming       

C****unG
 [?]
Sign in to view client's details.
| C****unG
|    India
Fixed Price: $100 or less   |  Posted: 43 minutes ago  |  Ends: 14d, 23h  |   3 Proposals
Schedule excel file using windows task scheduler to open, update formulas, save and close using windows task scheduler. Use Vbscript or vba if needed.
Category: Other IT & Programming       
Skills: Microsoft Excel, VBScript, Excel VBA       

C****unG
 [?]
Sign in to view client's details.
| C****unG
|    India
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: 1h, 3m ago  |  Ends: 14d, 22h  |   4 Proposals
Small reporting database - was developed i MS Access 2003. Now need to use it in Access 2010 or 2013 . Getting some vba errors, Need a vba programmer famliar with MSAccess to fox the VBA errors.
Category: Database Development       

d****rim
 [?]
Sign in to view client's details.
| d****rim
|    Canada
Fixed Price: Not Sure   |  Posted: 4h, 16m ago  |  Ends: 14d, 19h  |   11 Proposals
I am looking for a VBA expert to join my team! I would prefer someone that also knows how to design spreadsheets so that they look good/beautiful.
Category: Data Analysis       
Skills: VBA       

u****013
 [?]
Sign in to view client's details.
| u****013
|    United States
Fixed Price: Not Sure   |  Posted: 5h, 54m ago  |  Ends: 14d, 18h  |   12 Proposals
I need an expert to edit an existing Excel macro so that it will more finely parse the data from a text file. Specifics: I am downloading daily text files that contain a lot of information, including names, case numbers, addresses and so on. I have an Excel macro that will parse the text file into an Excel file that is suitable to use as a mailing list. But I want to parse the data more finely. For example, the Excel macro will give an address as: Joe Smith 123 Main Street San Antonio, TX 78211. I need separate fields for: 1) first name; 2) last name; 3) street; 4) city; 5) state; and 6) zip code. The actual job will be more complex than the example because there is more information involved. Also, I may want to have the expert tweak the Excel macro from time to time to 'tune' our results. Ultimately, I want to come up with a highly automated mailing list that is sorted on specific criteria. I will also want to be able to import the data into a database ...
Category: Database Development       
Skills: Excel VBA       

r****man
 [?]
Sign in to view client's details.
| r****man
|    United States
Fixed Price: $150 - $558   |  Posted: 6h, 46m ago  |  Ends: 14d, 17h  |   2 Proposals
CER is Calendar event reminder application for android which sets up nagging reminders for events created in cer syncable across google and phone calendar.   [obscured]  /store/apps/details?id=de.foobarsoft.calendareventreminder&hl=en I want a functionality to send sms from an excel file using excel formulas only.(IF, VLookup, etc). For example, if new row uploaded send sms. If value reached specified amount send sms. Days before a date , send sms. The smss should be automatically collected and arranged in an application made on android platform and a widows application, for this purpose. The sms should contain specified columns from the row, hyperlink to the excel file(Editable for specifying different file), CER option(to deploy cer app) All the sms s should be collected in the application. The interface should include the specified columns from the row, hyperlink to the excel file(editable for specifying different file),checkmark option, CER option, date sms reciv...
Category: Mobile Applications       
Skills: Microsoft Excel, Android, Java, Excel VBA       

C****unG
 [?]
Sign in to view client's details.
| C****unG
|    India
Fixed Price: Less than $500   |  Posted: 6h, 55m ago  |  Ends: 14d, 17h  |   10 Proposals
I am needing questions already populated in an Excel Spreadsheet organized into a Macro survey I can use on an iPad. After each person takes the survey, I need the data collected from each survey placed into a general database to be sorted by answers/questions/etc. later. I also need the survey to reset so the next person can answer the survey. This survey will be verbally administered during a product demonstration. I will supply questions as well as multiple choice and/or drop down box answers to be formatted within survey. Needing survey complete and ready to use by June 6, 2015
Category: Database Development       

J****ddy
 [?]
Sign in to view client's details.
| J****ddy
|    United States
Fixed Price: Not Sure   |  Posted: 19h, 33m ago  |  Ends: 89d, 4h  |   2 Proposals
I would like to build a small module that can parse an incoming document (in RTF, DOC, or DOCX formats) and give me some basic formatting information for that document such as: 1. Margin settings (right, left, top, bottom) 2. Orientation (landscape, portrait) 3. Header Information. 4. Footer information. 5. Different sections inside document. 6. Font styling information etc. The extracted data will have to be saved in the DB (SQL Azure), which will be provided by me. I will share document and other requirements with you once we begin interacting with each other. There should be a total of about 30+ formatting information that will need to be extracted. I would need this as an application that can be run out of a Windows server sitting on Microsoft Azure cloud, so your development language of choice should be compatible with Microsoft Azure cloud services.
Category: Software Application       

r****dar
 [?]
Sign in to view client's details.
| r****dar *
|    India
Fixed Price: Less than $500   |  Posted: 22h, 22m ago  |  Ends: 14d, 1h  |   5 Proposals
Seeking a self contain program with VBA front end and SQL back end. The ability to create various add-on module and security levels.
Category: Database Development       
Skills: MySQL Administration, PHP, VBA       

d****001
 [?]
Sign in to view client's details.
| d****001
Fixed Price: Less than $500   |  Posted: May 24, 2015  |  Ends: 13d, 21h  |   6 Proposals
I want to get real-time market data from Etrade into spreadsheet. Etrade has an API but the authorization process using HTML get commands and OAuth is too complicated for me to figure out. Would like this to be created in Excel Power Query (preferred) or Excel VBA.
Category: Software Application       
Skills: Excel VBA, Excel Power Query       

D****etM
 [?]
Sign in to view client's details.
| D****etM
|    United States
Hourly Rate: Less than $10 / hr   |  Duration: Not Sure  |  Posted: May 23, 2015  |  Ends: 12d, 20h  |   16 Proposals
We need someone with experience with creating and updating databases for eBay (FileExchange), Amazon, and osCommerce in excel. We have thousands of products that need to be updated and maintained. We also are constantly adding new products. This person should have experience with VBA and excel macros in order to automate as much as possible.
Category: Product Management       

m****t_0
 [?]
Sign in to view client's details.
| m****t_0
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: May 23, 2015  |  Ends: 12d, 10h  |   10 Proposals
You are to successfully implement this algorithm in Visual Basic Excel (VBA) code. You are to strictly follow the simple guidelines of the algorithm and implement it without any unnecessary improvements. You are to develop a simple electronic ticket ordering system: 'This function is the starting point of the program. 'It welcomes the user, and asks which package they want (after displaying a menu of options). 'Once they enter a valid package it uses getQuantity to get the number of each type of ticket '(adult, child and concession) and then finds the total cost using calcTotalCost. 'If the total cost is over 100 then it uses getDiscount to see if they get a 20% discount, 'and tells the user if they get it. Finally it prints the total cost and ends. Sub main() 'display welcome to user and ask which package they want 'get package from user, convert it to uppercase 'while package is not 'B', or 'P', or 'E' ' Print Error; Message ' get package from user, convert it to uppercase 'adult...
Category: Blog Programming       

g****893
 [?]
Sign in to view client's details.
| g****893
|    Australia
Fixed Price: Not Sure   |  Posted: May 22, 2015  |  Ends: 12d, 0h  |   40 Proposals
Hi everyone I will write the steps that I want the VBA program(s) to accomplish and then you can estimate how long it will take. *Main idea* I want the program to copy certain dynamic cells/ranges from a "master" sheet to multiple sheets in the same workbook generated by the press of a button. The sheets are generated according to certain restrictions that depend on 9 columns in the master sheet. The first column is a "name" column. The names of the new sheets should copy the names from the name column. After the certain ranges have been copied, all cells in the generated sheets are locked except for a certain row. Cells in this row can be changed/edited. After changing a certain cell, the numbers in the sheets depending on this cell update (hence, the dynamic cell copying). There are also some layout details that I would like to be implemented, but I can elaborate on this in a pm. I hope this give you an idea of the VBA program that I want to be created. Pa...
Category: Other IT & Programming       

s****nku
 [?]
Sign in to view client's details.
| s****nku
|    Denmark
Fixed Price: Less than $500   |  Posted: May 22, 2015  |  Ends: 11d, 20h  |   15 Proposals
Dear SuperStar We are seeking an Excel and/or VBA expert to develop a system for us that would integrate many excel files to help with Amazon listing, order processing, accounting and overall management. Please send all certifications and reply with am your superstar. Good English skills is a must as it can get complex and experience with QuickBooks and bookkeeping will be helpful. Let me know. Dan.
Category: Other IT & Programming       

B****ght
 [?]
Sign in to view client's details.
| B****ght
|    United Kingdom
Fixed Price: $45 or less   |  Posted: May 22, 2015  |  Ends: 11d, 19h  |   5 Proposals
I am looking for a macro for a word document. I would like the macro to be able to insert any number of pictures in to the report at the same time. Currently I am using a small macro that when I use "alt" "n" "p" all together I am able to insert 1 picture at a time. The photographs need to go in to the report the same way up so there is no need to rotate them once they are inside the document. Also they need to be the same size so they need to fit nicely in the page, I have seen one previously, which inserts 10 pictures per page 5 on the left and 5 in the right with nice spacing inbetween. I look forward to hearing from you as soon as possible. Thank you in advance.
Category: Other IT & Programming       
Skills: HTML, PHP, VBA       

l****014
 [?]
Sign in to view client's details.
| l****014
|    United Kingdom
Hourly Rate: $15 - $20 / hr   |  Duration: 1-2 weeks  |  Posted: May 22, 2015  |  Ends: 11d, 18h  |   15 Proposals
I am looking for a way to import an important PDF that has 24 pages into an Excel worksheet. The standard ways can only show the first page or a link to the file. This won't work for me as I need all the pages of the full PDF to be imported into the Excel project. See attached for the PDF I need to import. There are several others, but this is the first one to start with. Let me know if you think you can solve this problem. Thanks.
Category: Software Application       

s****323
 [?]
Sign in to view client's details.
| s****323
|    United States
Hourly Rate: More than $50 / hr   |  Duration: 1-2 weeks  |  Posted: May 22, 2015  |  Ends: 11d, 12h  |   8 Proposals
Our Company need to construct in Microsoft "Power BI" a series of Template Report (all need to be Interactive) that can be built using 'Data Sets' in Excel. This Peron would need to work closely with the Senior Management team to design, Build and develop these Reporting Models. Have a detailed knowledge of Microsoft "Power BI" and its related component's is essential.
Category: Business Intelligence       
Skills: SQL, Excel VBA       
Preferred Location: North America, Western Europe, Eastern Europe, India/Southern Asia

E****SUK
 [?]
Sign in to view client's details.
| E****SUK
|    Ireland
Fixed Price: Less than $500   |  Posted: May 21, 2015  |  Ends: 10d, 17h  |   55 Proposals
I need an excel expert who can edit multiple large worksheets with medical payment data. At times it could be up to 40,000 records. We are looking for a summary of the data to be produced in excel which would look like the following: Average - 585 Unique Medical Providers Charges $ 259.82 60th Percentile - line 351 $ $250.00 80th Percentile - 469 $377.00 Range - Low (Excludes Bottom 10%) - line 59 $79.62 Range - High (Excludes Top 10%) - line 527 $525.00 I've attached the summary for your review.
Category: Data Analysis       
Skills: Microsoft Excel, Excel VBA       

c****535
 [?]
Sign in to view client's details.
| c****535
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: May 20, 2015  |  Ends: 9d, 20h  |   3 Proposals
Strong skills in BPM - Business Process Modeling, Datawarehouse, Relational and Multi-Dimensional Modeling Structures; SOA implementations with Business Oriented Models; Very strong experience in downsizing - IBM mainframe systems (COBOL) into distributed platforms - client server and object oriented models. ? MBA - Information Technology ? Project Management ? ORACLE Developer PL / SQL ? Hyperion Essbase 6.0 Developer ? Programmer in Visual Basic, Excel VBA and Delphi.
Category: Project Management       

C****esi
 [?]
Sign in to view client's details.
| C****esi
Fixed Price: Less than $500   |  Posted: May 20, 2015  |  Ends: 1d, 18h  |   6 Proposals
My organization is collecting information using Google forms, which is automatically sent to Google spreadsheets. However, we need to take this further, and want the following to happen each time a new response is collected (each time a new row in the Google spreadsheet is created): 1. Automatically create a new Excel file based on an existing template. The template is an Excel file stored on our network drive. 2. Populate the new Excel file with the information entered in the Google form (spreadsheet) 3. Save the populated Excel file in a specific location on our network drive, with a specific name (customer number_customer name_Overview document). The customer number and name should be derived from the information populated to the Excel file. The scripts developed should be easily understandable, well-documented, and easy to develop further should it be necessary. It might not be that all of this is feasible, so please provide as much input as possible in your proposal. Do...
Category: Other IT & Programming       

L****oHa
 [?]
Sign in to view client's details.
| L****oHa
|    Norway
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: May 20, 2015  |  Ends: 9d, 15h  |   21 Proposals
We need to be able to do the following, which I presume will involve VBA and Excel. 1. Download .CSV file from an FTP address (user input) 2. The CSV file includes a lot of data, but only four columns matter for this project: (i) supplier name, (ii) product name, (iii) supplier email and (iv) cases required 3. An email is sent to each supplier to their email address with the products that are stocked by that supplier. 4. Must-have features: (i) ability to set the time when the email would be sent (ideally by supplier name, otherwise can be a universal time for all suppliers) 5. Nice-to-have features: (i) ability to combine information from two spreadsheets. That is, it would add case numbers from two spreadsheets for same products. (ii) ability to apply a formula to 'cases required' above. For example, to round up 4.75 cases to 5 cases.
Category: Data Analysis       
Skills: Microsoft Excel, VBA, Email       

f****ity
 [?]
Sign in to view client's details.
| f****ity
|    Croatia (Hrvatska)
Fixed Price: Less than $500   |  Posted: May 20, 2015  |  Ends: 9d, 10h  |   29 Proposals
Hello Freelancer, I need an expert Excel VBA expert. I have 5 excel file which contain more than 10000 row data each file. I need rearrange depends on some value. Happy Bidding
Category: Data Science       
Skills: Microsoft Excel, Excel VBA       

t****995
 [?]
Sign in to view client's details.
| t****995
|    Bangladesh
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