Vba with jobs

Financial market sector rotation Excel spreadsheet needs a bit of tweaking. VBA code for regression analysis algorithm needs editing to correct some assumptions currently leading to incorrect allocations to new sectors.

I am looking for an experienced VBA/Powershell programmer to automate the creation of a PowerPoint slideshow using various data sources including excel, ppt, web scraping/api.

I need several excel documents coded (or code repaired/modified) so they can compete some different functions. Most of the documents code used to work before they were stored on OneDrive. Mostly what is needed is mail merge code to an already ready word template. This project requires you to have pretty good VBA coding skills.

I need someone knowledgeable and expert with Excel VBA and Reports Creation What I need is a report from a matrix file that contains the data, then those data would be interpreted into reports with graphs, charts, etc. There are also certain conditions based on filters that you would also setup in the report. Further details would be explained via call. Talk to you soon!

I am looking for full time VBA programmer who can work on different projects from Mon to Sat, 10 AM to 6 PM EST time. Your English should be very good, Verbal and written both. Its a full time job and ongoing. If you only want to work just 1-2 months, please dont bid. I am only looking for someone who can work with me couple of years. I am not accepting part time freelancers. Only need to work in given timeframe. Place your bid for a month. Write FULL TIME POSITION at the starting of your proposal. Only bid if you fulfill all requirements.

For our ppt-decks we use references with links to different slides – therefore, we show only the slide (e.g., p. 10) number as actual link to the referred slides. Now, for our ppt-template we would like to have an automatic update of "text to display" references for slides in a summary of a ppt-deck. This should also work in case of new slides without manual adjustment of the slides number. So far we haven’t found any solution offered by ppt so might think that an extra/plug-in VBA solution is required.

...2. For each Row with data in Column I (Application No.), the parser script goes to the URL https://tsdr.uspto.gov/#caseNumber=[Application No.]&caseSearchType=US_APPLICATION&caseType=DEFAULT&searchType=statusSearch For example, in Row 2, the parser would scrape from https://tsdr.uspto.gov/#caseNumber=79262491&caseSearchType=US_APPLICATION&caseType=DEFAULT&searchType=statusSearch Please see PDF for the 3x fields to be scraped, Column J (Trademark No.), Column K (International No.), Column L (Mark), and Column L (RegDate in yyyy-MM-dd). Note that the USPTO website blocks bulk parsing. So if possible, please add a time delay and random user agents between scraping each URL. SCRIPT2 - GOOGLE CALENDAR Script2 is already in Код.gs. If Script1 and Script3 do ...

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.

NEED THE MACRO WITH SPEED OUTPUT

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 program...

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 orde...

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.

I have two list on two separate tabs. I am trying to run through the second tab and delete any row that does not have the same part number that is listed on the first tab. As you can see I have code that kind of does this. The problem with this code is that it is deleting the part if it’s duplicated (on more than one row / listed more then once). I don’t want it to do that. If for example I have part number 123-TEST listed on my first tab, I want the code to run through the second tab and delete any row that does not have Part Number 123-TEST. If Part Number 123-TEST is listed twice in two separate rows, I want to keep both Rows. For some reason I cannot figure out; the code below only keeps one row. The project is to revise this code so that it keeps duplica...

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

Deal tracking workflow tool with VBA userform

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

...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 an effective team member by supporting colleagues and contributing in the delivery and achievement of overall team and business objectives • Liaise with relevant areas and groups within the company and the group as appropriate for the role &...

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)...of my items based on the calculation of the both values. Eg. item "emailing" has a high impact (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...

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

Need a VBA coder for a email task

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.