In vbapekerjaan

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

...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 an effective team member by supporting colleagues and contributing ...

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...have a dynamic ranking 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 only if you...

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

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)

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.

Project Excel Vba as discussed

Sila Dafter atau Log masuk untuk melihat butiran.

Boa tarde, Pretende-se obter um ficheiro de registo de vendas relativo a cada cliente, com gestão de stocks de entrada e saída conforme cada encomenda, bem como o controlo do fluxo de caixa, registo de clientes e outras situações. Um ficheiro simples prático para ser usado como base de dados e controlo de gestão de vendas.

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"

...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:FA2658" results. "TYPE" and "COND" filters should be dropdown menus where I ca...

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. after i copy the price into the 2nd excel file's table, i wi...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 direc...

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.

Database sheet, either in excel VBA of access

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.

Benutzen eine Applikation, die aus einem Access Frontend und einem Backend aus einer AccessDB bestand. Das Backend wurde nun auf ein SQL Server verschoben, dadurch funktioniert aber ein VBA Skript nicht mehr. Ich denke, dass liegt daran, dass eine SQL Datenbank anders angesteuert werden muss, als eine Access Datenbank. Ich bräuchte daher jemanden, der das umschreiben kann. Das Skript ist nur sehr kurz und macht nichts anderes als einen Datensatz von einer Tabelle in eine andere zu kopieren, sowie Felder wieder zu leeren.

I am looking for an excel vba expert. Small task

A MS Access database (table relationship design, forms, macros/vba) with functioning logic (but no nice formatting needed): - Activities tracking (activity description, internal-contributors, external-contributors, external-companies) - Activities can have multiple "internal-contributors" and multiple "external-contributors" - "external contributors" work for "external-companies" - Database user can create/edit activities and add/remove multiple "internal-contributors" and multiple "external-contributors" - Database user can also create/edit activities and add/remove multiple "internal-contributors" and multiple "external-companies" (without specifying which "external-contributors"). - Database...

...25) based on a given product database. This database includes EAN Code, Manufacturer Code and SKU. In case the information is not found by using the EAN Code, the scraper should try using the Manufacturer Code. In case the information is not found by using the EAN Code and the EAN Code starts with "0", the scraper should try using the EAN Code without "0", if it still doesn't work, use Manufacturer Code. The price scraper should be able to run from Excel or Google Sheets and managed by an user with intermediate Excel VBA experience. The user should be able to update the product database (add/eliminate products and update their information), webpages, and understand how to change the code in case new webpages were added. The progr...

VBA Project Revisions/Updates Customized for my computer Excel, Outlook, and Word versions, add my digital signature, debugs fixed, add spell/grammar check, allow preview and spelling/grammar checks to be completed before sending, add DocuSign or AdobeSign for confirmed receipt of the document, and available space to enter data increased to unlimited. Request for recommendations for a smoother transaction. Create a form that collects the data needed for the excel document. Entering the information from side to side can be challenging. Design: Would like to improve the look of the Word RN Progress Note to deliver a medical report feel; it is a very fill-in-the-blank type of look.

I require to simply copy entire data of 5 sheets to new workbook and rename the workbook as per a cell reference, post which to save to a location as per a cell location specified

I need VBA Developer from Ahmedabad, Gujarat for a few projects who have knowledge of SAP integration.

...OneDrive. I have created sample UI just for reference on how I require the app to look. I have also included a sample dataset Screen 1 - I would require an on screen number pad for the user to fill out the work order. Once the work order is filled out the user would press "enter". If the work order is not in the dataset then a popup would display "Not Found". If the work order is in the dataset then it would go to the next screen. The app will then reference the "Stages" columns in the dataset to figure out how many buttons to display. For example: if the user enters the work order "1002", then only stage 3,4,5 buttons are displayed. (Check data image for reference). Screen 2 - Would display at the top; the work order ...