Vba Jobs

217 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}})
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 - Expert ($$$) - Est. Budget: $750 - Posted
Looking for a VBA and API developer. The objective is to upload a file (.doc, .pdf and .ppt) into a desktop software that can send these documents to Adobe Acrobat DC PRO to transform to (Editable Text) then once is edtitable the software should then send to Microsoft Word to perform a automatic word count with Microsoft Word OR send to Abby PDF Transformer Software if the document (.doc, .pdf or .ppt) is not editable in order to transform to editable automatically with ABBY via (API) to then perform a word count with Microsfot Word.
Skills: VBA PHP Windows App Development
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
-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
Hourly - Intermediate ($$) - Est. Time: 1 to 3 months, 10-30 hrs/week - Posted
Training would be during the weekday, after 6.30PM GMT They should have access to some training material, however some topics that I would be interested to learn included - What If Analysis: Scenario Manager, Goal Seeking, Data Tables - Advanced Formulas: Math, Statistical - Formula's - Database (SQL) Queries and Tables - Basic VBA
Skills: Excel VBA Microsoft Excel
Fixed-Price - Expert ($$$) - Est. Budget: $200 - Posted
We have an immediate requirement for a person experienced in Visual Studio/REST API development to create us a simple integration with Bullhorn CRM and 3CX Phone System. Full documentation and guides are provided: http://developer.bullhorn.com/documentation/oauthworkflow http://www.3cx.com/docs/oauth2-authentication/ https://visualstudiogallery.msdn.microsoft.com/c9757015-d7ab-4d56-aa28-0c3d985f8b1b
Skills: VBA Visual Basic Windows App Development
Fixed-Price - Intermediate ($$) - Est. Budget: $10 - Posted
The project is very easy. Please take a look at the file. Value of R2 = sum of values in the range 01.07.2016 Value of R3 = sum of values in the range 02.07.2016
Skills: Excel VBA VBA