Vba|cprogrammingvisualbasic jobs
...No.)]], issued from US Trademark Application No. [[Column I (Application No.)]] (relating to [[Column G (Title)]]). EMAIL SUBJECT TEMPLATE [[Column D (Client)]] [[Column E (Minder Ref.)]] [[Column F (Other Ref.)]] - Trademark Certificate EMAIL BODY TEMPLATE See TXT file. Candidates should confirm that they have Google Apps Scripts experience. This project should not be done using Python, VBA, or other scripts outside of Google Apps Scripts. Thank you. ...
A simple VBA macro project to calculate given address, between the cities in miles.
This is my original webscraper for the website. However, it is currently not working as the website interface has changed Budget: $80
I have a simple spreadsheet, but I need my dropdown lists to have multi select options. I cannot get the VBA editor open on my computer. 5 minute job. In Chef Database, I need columns C,D,E,F to all have the option of multiple selections. If possible, I would also like the list to populate from the top, not the bottom. Columns A and B are not multiple selections.
I have two scheduling reports and I need to copy data from one table format into another.I need a VBA expert to take a look at this task. Very urgent task, need someone to get started asap. Have a constant stream of work available in VBA for Client we are working with.
Dear freelancers, I would like to scrape historical stock prices from the website Specifically, I would like to insert a list of ISINs (stock IDs) and dates in an Excel and get the prices for those ISINs and dates automatically downloaded. Ideally I would like to integrate this process into a VBA macro, so that after I click a button the information gets downloaded and pasted into my spreadsheet. I am happy to get your qualified applications for the project and discuss the further details. Cheers Nenko
Hi There So I have a file that shows data on what jobs are running on different machines. They use a cylinder size - which we have limited sizes and a limited number of. I want the excel vba to show me whether there will be a clash (cylinder all ready on a job) based on whether the stop time is before the start time of the next job. There are multiple machines which could use the same cylinder. I would prefer the Cylinder Library to be on the same file. I would prefer the user to choose the downloaded file (Press Schedule Reports) The Press Schedule reports will change in length and number of days but the format (columns will stay the same) A MUST is that the file highlights and clashes easily by Press
Hi I want excel vba expert for record management using userform, save data and generate report from them. It is generally MIS work.
I have written a macro, but need to add loop to batch print from the customer list
Dear Excel VBA Experts I have to build a VBA that creates me output files based on several input files and formulas. I honestly think the task is quite easy and straight forward, however, I have currently no time to do it on my own. More details: Input Files: approx. 20 (all in same format - already existing) 1 file with all the calculations and data transformations (already existing) 1 file with additional calculations, carved out currently, as excel got too big (already existing) --> Goal: Take the 18 files, load them, do some "simple" calculations (formulas I already created) and then create about 5 output files (cvs) that follow a certain structure for the upload (structure already known). As said I think an experienced VBA programmer has done t...
I need an expert in excel and VBA. I have combobox in one sheet and the table of information in another sheet which users can choose among them. However i want that user can add their own item to the combobox if they can not find their desire item and therefore the list should be updated.
Project for a VBA Programmer Complete details will be provided to right freelancer.
Project for a VBA Programmer Complete details will be provided to right freelancer.
I have a VBA script that runs as a macro in Outlook I need the code to be fixed as microsoft seems to have changed the VBA formulas and now it gives an error.
I will try to explain the project in details so there are no confusions like I had with the last freelancer asking for additional money for every question I was asking - hence my previous project was cut short. So, the project is not complex in principle. I have three tabs of similar format and I want the data from those 3 tabs to be copied and pasted into one tab in a vertical order if they meet a certain criteria i.e. there will be a trigger - a cell marked with X if they should be copied or not. So, for example, the tab has multiple sub-sections and each sub-section will have a trigger there whether that data should be copied or not. So, if the sub-section (8 to 10 rows) has an X in Category 1, 2 or 3, then copy the rows and bring them to the main tab in ascending order. Furthermore...
Need assistance in creating a VBA macro using combination of excel and tab(delimited) files. Need a common macro for that.
I'm looking to be able to import/export data directly to Jama using VBA. I think it's possible via Jama REST API but I don't know how to do it. If you can do it, I can tell more specifics. Basically I just need the basic code for it and I can update it according to what we need.
...out; the code below only keeps one row. The project is to revise this code so that it keeps duplicates. You should be able to figure out everything from this description and the code below - without having to ask me any questions. If you cannot, this job is not for you and please do not bid on it or accept it. I will not be able to answer any questions. I need this today. If you know Excel VBA, this should be very easy. If you bid this and accept it and take more than two hours to complete and a working solution, I will dispute and not pay. Sub PartNumber_Parts() '***************************************************************************************************************** 'Based on the data listed on the "List" tab, remove any unmacthed Part Num...
I need a code for Excel VBA to be created that exports all sheets within the workbook to a specified file path on my computer. This should take place every 40 mins. This should run in the background and should not close or affect the current xlsm file.
I need a help with a simple task. Please see the attached excel file. I need cells A6 and B6 to disappear (get hidden), if the user chooses in cell B6 either "Individual" or "Group" from the list. In case the user chooses "Individual + Group", cells A6 and B6 should stay visible (unhidden).
we have many projects and need extra set of hands, we build advanced vba excel projects within construction sector (custom ribbons, custom menus, floating toolbars, event driven actions etc). If you have these skills pls join us.
these are some of the new customizations to existing excel vba add-in
Hi we need a solid VBA developer with good overall Excel skills including adodb as 1st task (of many) is to parse a excel file into a sql db which includes splitting single fields into multiple records (so you need to have basic db skills and understand db relationships)
Looking for a VBA excel programmer who can work full time, Mon to Sat, 10 AM to 6 PM Venezuelan time. Your English should very good. If your English is not good, then this position is not for you. Its an ongoing job, not for a single month. It can be for years for the right person. If you know MS access and Power BI, Tableau then would be a plus point.
I have a database in MySQL which is empty, with no tables. Now I have a CSV file in excel. I want to insert that into my database. I need to be able to edit and delete and add any new data via excel VBA and see the changes in the database.
26 Testing devices are run interchangeably over few months. Data is collected every 10mins. I have a raw dataset which I would like to summaries in a worksheet that shows the total run time for each testing device. I would like to create a vba code that would summaries my work more efficiently.
Conversion of a matrix files to Google sheet. (VBA to App Script) will require these files within 2 weeks or end of October 2022. Will need to work closely to ensure progress of this project is strictly adhered to.
This is my original webscraper for the website. However, it is currently not working as the website interface has changed Budget: $50
Automate the saving estimation, sending quote, and sending invoices process with VBA macros. 3 command buttons will be created for the purposes and the email body could be customed.
Please see the attached Project explanation with file. Also, please see accompanying files: BASIC MEDIAN Input sheet MEDIAN RESULTS Results sheet MEDIAN RESULTS
I have a web development project that I would like to develop but I need a mentor to guide me. I will do all of the code writing because I want to learn. I have some programming experience with python and VBA but I am new to web development. I need help to choose what I should learn (which language/framework etc.), to find learning resources, to help answer technical questions, and to help me stay on track with this project. We would need to have a call maybe once a week so please check your time availability with me. I am based in Berlin timezone and am available Monday/Wednesday 6-9pm, Sunday 9-5pm. The project is a metrics dashboard website/webapp that is hosted on a server and collects data from excel files saved in Subversion.
I want to send bulk whatsapp msg by excel so need to make excel by vba coding so i can send no of msg on wpp to my customers
The project is with one of India' largest consulting firms. The project would invove coding marcos in Excel for 2 weeks. The candidiate is expected to have hands-on experience of coding macros and automating processes like generating mails, applying filters, etc. The project required work from Mumbai office (transport from home to office would be arranged)
I am building a VBA code. So far it allows the user to click a button and select the appropriate file path. It then copies all of the rows and columns and copies and pastes them on a Sales Sheet. However, I now need my code to loop through and use conditions to determine what needs to be copied and pasted. I need the loop to check to see if AT or DC are the first two characters of the string. I then need to look between two hyphens "-" and "-" to determine if between them lies 4 or 8 numbers. If both conditions are met, I want the entire row up copied and pasted on my Sales sheet. For instance, if cell A1 contains AT8768-9879-OH I want that captured, but I do not want AT387-98OH-DC captured. Please help?
EXCEL VBA TO WORD AUTOMATION. I need each row in excel to like the format in word
...Head Office, City of London (EC3M) Reporting to: Principal Project Manager (PPM) Starting date: Immediately Duties and Responsibilities • Support the technology team in the next generation of insurance raters • Improve the raters’ functionalities • Maintain and enhance the existing raters Requirements • B2 level of Italian and English • Strong knowledge of Excel • Strong knowledge of VBA macros • Proven experience in creating and managing complex spreadsheets • Knowledge of offline and online forms and raters Desirable qualifications • Microsoft Advanced Excel Certification Additional requirements • Have high attention to detail, strong organizational skills and a flexible approach to work • Operate as...
I have excel files,i need solve my you are excel vba expert,bid here.i will share my problem files. Thank you
hi excel cracks i have a items which each has 2 value cells: first cell is "impact" (values 1-4, 1= low) and 2nd cell is "complexity" (values 1-4, 1 = low). Now i want to have a dynamic ranking of my items based on the calculation of the both values....(4) but it's low complex (1)= 5 score points. If another item would have a low impact (1) but it's high complex (4)= this item would also have 5 score points. but in terms of priority it's not comparable with the first item, as I want to prioritize items which have a high impact plus a low complexity. Expected output: dynamic sorting/ranking of the items with the associated ranking number NO: VBA, Scripts and similar, ONLY DYNAMIC FORMULA via =Rank( and similary. Propose only if you understand ...
Need vba code to copy value from differnet files on the the sharedrive and fill it into my template. In some casee there maybe if statement that i will need. The code needs to be user friendly and can be easily modified by me..as the input in the template grows Example of the template Id# location id. Periodyrmonth value. Status
i need a method to use firefox on automation using selenuim basic vba
I have created a VBA form the way i want it to look, it isn't yet functional as i dont know the code for when i click "submit" on the command button to drop it into the worksheet. I also need the VBA form to appear when i click Snag Form on the front page.
I need advance excel and excel vba teacher
Modification of ‘Business Plan template ’ provided to allow for the following functionality: On changes to Column J in “Projects” worksheet and Column I in “Services” worksheet, the cell reference(s), time/date of change and user’s name are recorded in a VBA variable On close of the workbook, all changes (saved into the above variable) are included and sent in an email to notify of all changes occurred with the variable cleared upon email being sent.
Modification of ‘Business Plan template ’ provided to allow for the following functionality: On changes to Column J in “Projects” worksheet and Column I in “Services” worksheet, the cell reference(s), time/date of change and user’s name are recorded in a VBA variable On close of the workbook, all changes (saved into the above variable) are included and sent in an email to notify of all changes occurred with the variable cleared upon email being sent.
I have a handful of excel projects, ranging from intermediate to advanced skill sets required. They include creating formulas / functions, and using VBA to develop automations with the click of a button. If everything goes well with the first project, then I’ll send you more work ongoing — possibly every week. Please include any samples or relevant work in your response that shows your experience with excel, thanks.
