Vba project data jobs
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
Duration of Contract: 3 months, on a full-time basis Place of Work: Furness Insurance Services 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 ...
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.
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 p...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 em...
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)
We need excel and VBA programming expert for generating the automatic Project Bill of material along with costing, We have prepared the RFQ in details, need to discuss one to one for better understanding
I need Excel VBA expart with advanced skill and attractive presentation also Note:- Only bid serious with experience of Excel proposal please shate previous work experience .thank you
I want a tool made in VBA, lets connect and discusss the details. Email me if interested.
I am using a VBA script and running a rule through Microsoft outlook to save email attachments to a folder locally on my PC. I need a new VBA script to do as follows. When the attachment is saved to the target folder the file name need's to be changed and increment by 1 each time. e.g Email attachment is named "file" and when saves to target folder is incremented by 1. E.g "file1" "file2" "file3"
There are 3 files that currently work together to filter data and produce results. "v3Updated current " - Initial filter file. Results are produced in cells "EN195:FA2658" "" - Indicates which filters from the "v3Updated current " to filter "aapl " - Results from cells "EN195:FA2658" of the "v3Updated current " file are pasted to this file. Instead of pasting all of the results from "EN95:FA2658", I would like to be able to filter the results based on a secondary filter found in cells "EN4" ("TYPE"), "EO4" ("COND"), and "EP4" ("OCCUR") - total of 3 filters to be added. These 3 filters correspond to the same columns in the "EN195:FA265...
i have two excel files. one is product pricelist table. second is the excel table where i copy-paste the prices from first excel file....second is the excel table where i copy-paste the prices from first excel file. after i copy the price into the 2nd excel file's table, i will drag and highlight whole table & right-click copy. afterwards, i will paste that whole data into my e-commerce system, so the system will generate readable price by itself. now i want easier automation for the process i do (copy-paste price to another excel table). i want a loadable macro in my 1st excel file, so whenever i highlight the rows of price in excel file 1, and right-click copy, it will automatically re-formats the data into a table and apply it on my clipboard. so i can direct pas...
I need Modification on My Excel VBA Program
fix the issue as i have made every changes that is needed. Only i am not able to fix the error as the data is not pulling the candidate sheet
Write a VBA macro to clear the specific sheet range, and protect specific ranges.
I wanted a excel expert who can create an excel using VBA which can create or genrate appointment letters (200) and then crating a pdf and then mailing it to respective manager
I got variable row lengths with any numbers between 1 and 45 Eg 9 numbers in row 1, 12 numbers in row2 10 numbers in row 3 and so on. The number of rows vary as well could be any number of rows in a sheet. Each line must be crossed with all the lines in the sheet eg 10 lines will result in 45 crossed rows. The result of each crossed two rows must count the common numbers and only if the count in the duplicate numbers is 5 or 6 the those duplicate 5 or 6 numbers must be output on a new sheet. If the number of results is more than 500000 the results must continue to cells away from the first row result.
I want to create daily reports for my organisation. I have a table that contains data based on date. I am trying to create a report that fetches data from the table based on a single input of date. Just to give a little background, I have a manufacturing concern where I need to keep track of production at different locations.
