Excel Vba Jobs

155 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 - Entry Level ($) - Est. Budget: $5 - Posted
Hello, This is a simple job you can bid 1$ and if you do it right away I will award it to the first one that does it ( the file source code is attached to this job posting ) I have a source code to an application that compile files in microsoft visual studio excel for excels files. Right now the way it compile is it does an average of the row the problem is that it doesnt include 0 cells in it so if I have 5 cells and one of the cell is 2 and the others are 0 my average result is 2 but it should include 0 to make a true average so the result would be lower
Skills: Excel VBA Microsoft Visual Studio
Hourly - Entry Level ($) - Est. Time: Less than 1 month, 30+ hrs/week - Posted
Looking for a VBA expert to work with us on a short term engagement. You need to demonstrate excellent VBA programming skills. Do not send your cover letter.
Skills: Excel VBA Microsoft Excel
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
Looking for an experienced and careful coder/data analyst to recode survey data across three large survey data sets and manage the data for a 1-3 day project. The person will work with a team of international researchers, but, given the size and scope of the project, the person should be able to work independently. This contract could lead to more such (or larger) projects, since the researchers are working on multiple projects individually and collectively. Must be experienced in Stata (and Excel). We have specifications available for applicants to review upon request.
Skills: Excel VBA Stata
Fixed-Price - Expert ($$$) - Est. Budget: $20 - Posted
Job Description: **WHAT WE HAVE** We are an ecommerce company and we have multiple excel files to help sellers list their products on our portal. Each of these excel files have a similar format (sample attached), i.e. 1. A ‘Data Guidelines’ sheet. (Irrelevant for this Job) 2. An ‘Accepted Values’ sheet which contains data in columnar format (All Field Labels in the first row, Data below), and 3. One or more sheet for data entry used by sellers for Product Listing. Now, few of the fields in each data entry sheet (named in the sample file as: Accessories, Protective Gear & Clothing, and Security) will be filled up using a dropdown list (Data Validation). **WHAT WE NEED** 1. A VBA script that generates dropdown list. 2. The script should generate dropdown lists only below those Field Labels whose field label has matched those provided in the ‘Accepted Values’ sheet. Rest of the fields will permit free text to be entered, hence should be left untouched. 3. The source of the dropdown list is to be fetched from the ‘Accepted Values’ sheet. Data appearing below the field label will naturally become the options in the list. 4. If the new values are added to the sheet, i.e. Field Label and / or data below the field labels, the list should reflect the new data or the new dropdown list. 4. Since we have multiple excel files, we would expect this script to work on files with a similar format. You can suggest us how we will be able to do that. We are ready to make small changes(using find and replace) file to file to make it work. 5. The file should retain data upon saving and re-opening the file. 6. The dropdown should appear on 200 rows below. **WHAT YOU NEED TO DO** 1. Make an excel VBA as per above requirement. 2. Test the script if it performs as per requirements. 3. Demonstrate how we will be able to use this script on other files (we’ll send you another sample file). You’ll have to show us how to make such changes. We would prefer you use a screen recording software for this demo, but you are free to suggest other methods of your choice. **WHAT WE ARE OFFERING** 1. We’ll pay a fixed price for the project. Send us your bid. We’ll accept if we find your bid to be genuine, or negotiate if we really like your profile. 2. Immediate payment. Once we receive and test the script, we’ll quickly release the amount. Interested freelancers, please apply mentioning the below details: 1. Experience in Excel VBA programming. (Newbs are cool too!) 2. Estimated time duration to complete this project. 3. Your fees. (Please mention the amount we will be required to make a payment of.) Only applications with the above details will be considered – this is to make sure you’ve read the application. If you wish to clarify any doubts about this project, please send a mail on Cheers!
Skills: Excel VBA Microsoft Excel VBA VBScript
Hourly - Intermediate ($$) - Est. Time: More than 6 months, 10-30 hrs/week - Posted
Excel Wiz to do work as required. Some is complicated and some is quite basic. Applicant must: * Be online on Skype during Australian business hours * Speak fluent english and be confident with voice skype conversations * Have adequate internet connection to have a clear skype voice call * Have an adequate headset in order to have clear skype voice call
Skills: Excel VBA Microsoft Excel
Fixed-Price - Entry Level ($) - Est. Budget: $30 - Posted
See the tabs in the attached excel at the bottom . I need to convert all the data into 1 staging table from each tab based (total ten tabs). based on the quarter and year. Look at the excel. Column A, B,C is needed and from Column D till BO or CE or depending on the excel tab we have Cash and Adjustment amounts based on the dates. For some Tab the data is less for some data is more for ADJ /CASH. Based on dates the cash and Adj amount needs to be put in the respective bucket. Other columns needed Cash Field, Cash Date , Adjust field ,Adjusted Date as there might be changes only adjusted amount is there without cash field value , Balance and year Qtr Total Fields: MGR code A, Company B Invoiced_Amt C Adjustment_Amt D till whatever before Balance Column (Make this column data to Row data ) will put in add the record only if data is present Adjust_Amt_DT ROw 1 Value from D column till whatever before Balance Column (Make this column data to Row data ) will put in add the record only if data is present Cash_Amt D till whatever before Balance Column (Make this column data to Row data ) will put in add the record only if data is present Cash_Amt_DT ROw 1 Value from D column till whatever before Balance Column (Make this column data to Row data ) will put in add the record only if data is present Balance YearQtr Hard coded based on the Tab year ex: 20041,20042 etcc.. We need to make the column wise data of Date column, Adjust_Amt_DT , Cash_Amt to ROW wise. (so we will have multiple records for the same MFR with diff dates and with respective adj, cash amount) We need something like above attached screen shot DOC table. I am not sure about various ways but this is one method I thought of. Tried PLSQL but couldn't do. Infact the above excel is well formatted. Initial format they sent me was horrible with additional columns, headers, footers etcc.... I modified them this morning to simpler way. Create macro that can accept Columns Start and end ?(I guess). (opltional) and put the results on to another new sheet. Loop through the records and validated/ selected records will be shown in new excel to come to the above screenshot idea. Make sure column data if null we are not putting those values on to new sheet. EX: COlumn D and E if got data needs to be added in 2 records like this with 4 fields data. IF they are null ignore. I hope I explained clearly. Screenshots will help. 06/30/98 06/30/98 7/31/1998 7/31/1998 8/31/1998 8/31/1998 ADJ CASH ADJ CASH ADJ CASH 3124 -17828 -900 300 Change the above data TO ROW DATA LIKE BELOW Adj Adj Date Cash Cash Date 3124 06/30/98 -17828 06/30/98 -900 7/31/1998 300 8/31/1998
Skills: Excel VBA
Fixed-Price - Intermediate ($$) - Est. Budget: $450 - Posted
In my business I run engagement surveys and need to be able to take the data from engagement surveys and generate reports based on aggregated averaged data from the results of a group of people. Currently I have an excel csv file which I extract from the engagement survey software program. I upload this data into a macro enabled excel file which is used to populate a macro enabled word document. The current survey is constructed on the basis of demographic data (age, gender, length of service, professional category, industrial classification etc), 49 different work aspects which each have scores for importance and scores for satisfaction. The likert scale used is between 1-7 with an option for an NA answer (which has to be discounted). These 49 aspects are randomly arranged (grouped) into 7 clusters of statements. They then factor together into seven different motivational areas. Average scores are calculated for each of the seven motivational areas and an overall value provided for that average (high, mod or low). The averaged results for these 49 aspects of work are also shown in a bar chart. The third part of the survey has questions for 24 engagement measures and enablers. The measures are used to calculate a bar chart graph for engagement and also an overall average engagement number produced on the report. I currently import this csv file into a complex calculations file which enables me to calculate averages of data and classifies values of data. I did have something developed for me a few years back using excel and word macro files. This could be used as a start and modified or otherwise if easier to start from the beginning. If this chart is being used some of the worksheets will need to be developed for the new version. The current version of what has been created is enclosed. Password is because. There are three files - the calculations spreadsheet has the raw data and all of the calculations. See worksheet on first file for instructions on what is required. The group chart was constructed to be able to prepare charts and the word macro enabled document generates the report. The work I need is as follows.... I have now changed the engagement survey, Instead of 49 work aspects there are now 36. Instead of seven clusters of 7 work aspects each there are now six clusters of six work aspects. I have updated the excel calculations file to re-calculate all of the required formula. What I do need however is someone to adjust this calculations spreadsheet and prepare: 1. Chart outputs - graphs and bar charts 2. Fields which allow me to populate information in the word document 3. Macro enabled word document take these calculation outputs and prepare graphs, charts, data tables and then what is required to convert to reports. In other words I need a new report generated with new tables, graphs, charts and it needs to be linked to the calculations file. What I need is for someone to be able to take this data and be able to write macros which can create reports which has demographic data, averaged data, data values and so on. I also need to be able to edit the report once produced. Ideally I would also like this program to run on Apple Mac as well as a PC based system. I prefer to be able to explain my new requirements via Skype, phone call so really need someone who has a good command of English language to do this work. I also want someone who is prepared to put some time in front to really understand my requirements and for me to make sure I am confident they can deliver on this work in desired time-frame.
Skills: Excel VBA Microsoft Excel Microsoft Word
Hourly - Entry Level ($) - Est. Time: 1 to 3 months, Less than 10 hrs/week - Posted
I need someone who is quick to input all the customer reviews from Facebook, Google, and Yelp (if available). You will need to go through all the reviews and input it into a shared google Sheets. There are about 8,000 reviews in total. Additional task would be to read through each one and determine a few characteristics about the review. Decent to excellent command of English necessary.
Skills: Excel VBA Data Entry Google Docs Internet research
Hourly - Intermediate ($$) - Est. Time: Less than 1 month, 30+ hrs/week - Posted
Summary: Create Excel tool for tracking and summarizing portfolio of loans made to non-for-profit organizations to be run by a group of Admins with moderate Excel skills. Billable Scope: 30 - 50 Hours Deliverables: -Make existing excel tool more stable and user friendly -Create thorough instructions / user documentation for on-boarding admins with only moderate Excel skills Responsibilities: -Collaborate with Project Lead to design improvement of existing Excel Solution. -Managing Development and Implementation of improved Excel Solution -Support Data Migration and QA -Participate in creation of User Documentation Requirements: -Familiarity with Tables, Named Ranges, Conditional Formatting, and most formulas -Excel VBA -Capacity to explain solution to Project Lead and participate in creation of Documentation
Skills: Excel VBA Microsoft Excel