Vba hurst exponentJobs

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

...the radial attenuation function (lights only) The middle order term in the radial attenuation function (lights only) The highest order term in the radial attenuation function (lights only) The angle of the spotlight cone (spot lights only) in degrees; If theta = 0 or is not present, the light is a point light; Note that the C trig functions assume radians so you may need to do a conversion. The exponent in the angular attenuation function (spot lights only) The direction vector of the spot light (spot lights only) 1 If direction is not present, the light is a point light For objects, the properties from the last assignment should be supported in addition to: diffuse_color The diffuse color of the object (vector) specular_color The specular color of the object (vector)...

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.

Hi Techno Exponent, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

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

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.

I need advance excel and excel vba teacher

Fix working hours for an existing vba code

To create macro for me doing web scraping from 4 different website, searching based first name, last name and date of birth and if data match scrap the data to excel.

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.

There are 3 tiny Issues in Ms Word File VBA Coding; 1. There is a Signature Section, which is misaligned in a text box and in order to align it, I have to click inside Text Box and run a Macro specially made for it. But I need that it should be done without clicking manually in each signature Text box and running macro separately for each Signature Section. 2. There are 3- 6 extra spaces in different places in document between words, that needs to be removed through VBA. 3. As I convert my Ms Excel file to PDF & then to Ms Word File, Paragraphs/sections where Page breaks occurs in Ms Excel File, when converted to Ms Word gets divided and gets captiavted in Text Boxes. There has to be a VBA code in Ms Word to bring them out of text Box and make them one paragraph/s...

Hi Hafiz Umair N., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Copy paste variable down 10 rows, leave a space and loop thru data set doing the same, with the next variable until the last variable (note: the last variable is not defined and there can be as many variables possible). I have attached excel sheet showing the desired output.

VBA code based MIS For India's largest public sector bank - we are looking at a smart VBA developer who can create Excel based dashboard to analyze data, and share the outcomes through Outlook email.

we have a table and we require a macro which will provide output with specific format, not much difficult the only dynamic parameter is the data. Outpt and Input format attached

Please watch this video: Need an excel macro to send email with PDF attachment. The macro must send emails via outlook. I have an excel sheet with names and email addresses. The macro must send emails to each of these emails, with the name and content provided by me including a PDF attachment, at the click of a button. >>>>>> If you want to win this project, start your proposal with: "I can write the macro to send email using outlook for $___(fixed price) within ___ hours."

Please watch this video: >>>>>>>>>> If you understand the requirements, please write in your proposal: "I can write the macro to send email using outlook for $___ within ___ hours." Any proposal who bid without watching the video or without the above phrase will be ignored! Need an excel macro to send email with PDF attachment. The macro must send emails via outlook. I have an excel sheet with names and email addresses. The macro must send emails to each of these emails, with the name and content provided by me including a PDF attachment, at the click of a button. >>>>>> If you want to win this project, start your proposal with: "I can write the macro to send email using outlook for $___ within ___ hours."

I want to create a Excel VBA code for Outlook, in which I can share a new mail to my clients one by one single time and after 3-4 days I want to send them a follow up email in the same thread so that they can see that I’ve already shared them a mail couple days ago. If I get the revert on my first mail that would be great but if not then I have to send them a follow up email in the same email thread/loop. To cite an example today 10/07 I’ve shared a fresh mail to a new client and on 10/10. I want to share a follow up mail in the same email thread/loop with my company details in attachment along with my signature which contains a company logo as well.

I need to share the bulk mails from excel through outlook which contains signature with logo. Also once first mail shared if we get the revert from the mail then we’ll remove that email from the list and if we’ll not get the revert then again need to send a mail but that mail need to go with in the email thread/loop not a fresh new email with signature and loop.

I need a Freelancer who has good knowledge of excel VBA macros, to scrape some additional data from a sports website and add it to some addition columns in my workbook. The data will be live soccer matches including the scores for the home team and the away team and continue to refresh the data periodically. It will also include the decimal odds for the home, draw, away, over under goals and both teams to score. I have attached a screenshot of the current excel workbook and the soccer website oddsportal. I will send the file to the chosen freelancer.

Please create an Excel VBA to automate do the following work. Enter date data in excel cell A1.(ex:20220722,the year should be 2022-1911=111) Go to an url() and choose the Year and Month and select the bottom option.(See image 1.)(image B2 should be A1) Download the specified date csv file which is entered before at step 1.(cell A1).(See image 2.)NOTE：If cell A1 is empty, download the newest csv file in the url. Copy and paste the specified range data to excel cell B2.(See the specified range at image 3. and image 4.) There's no need to save the downloaded csv file after passing the data.(Do not create any new tab to scrape the data)