Macro vbaemplois
...reorder items, we bring additional data into the “starting file” so that all the data helps us determine how many items to order. See “final file” to see what additional data is brought in. Goal: currently we are bringing data into the “starting file" manually and it is time consuming, we want to automate the process as much as possible. Mechanism: We are open to the way to do this, it could be a macro, it could be a script etc, the solution needs to be robust as there are hundreds of rows involved. We would need some type of User Interface screen that will let the user select variables such as file locations, opt out of file, date range etc…see example of UI screen at the end of the document. All files are in this folder
I am looking for an engineering assistan...assist with an advanced design. You should have experience in the following areas: - Mechanical engineering - Electrical integration design - PDM /PLM work - Standard library creation - Proficient in CAD software - Templates creation Optional : routing / piping experience C# and VBA knowledge The project requires a highly skilled engineer with experience in advanced design. Design is done with Solidworks , PDM and Solidworks electrical. Multidisciplinary skills are greatly appreciated ( code , c# and VBA developement , macros , etc ) The ideal candidate should be able to work independently and have good communication skills. Please provide a short experience description and relevant experience , otherwise your profile might...
I am looking for someone to write a VBA code for Excel that would get data from different sheets (Source Tab: DETAILED PROGRAMME LIST & MARSHAL LIST 1 & MARSHAL LIST 2)of the sample Excel file I provide and come out with a new result sheet (Sample Tab: MARSHAL LIST (ACTUAL)). The code should be developed on the basis of a sample Excel file I already have. The data entry process involves entering less than 10 fields. I expect the project to be completed in a timely manner and to work with my existing system without any issues.
Attached please find a page in indd. This page has many text-elements. They are in Layers. I need a script that - changes the appliedLanguage in each text-element inside the Layer "Deutsch" to "German: 2006 Reform" ("de_DE_2006") - changes the appliedLanguage in each text-element inside the Layer "Französisch" to "French" ("French") - changes the appliedLa...the Layer "Französisch" to "French" ("French") - changes the appliedLanguage in each text-element inside the Layer "Englisch" to "English: UK" ("English: UK") - changes the appliedLanguage in each text-element inside the Layer "Russisch" to "Russian" ("IDX_Russian") Attached ...
I am looking for a VBA expert to help me automate data entry tasks in my Excel schedule template. My specific data entry requirements are basic in nature and I need the VBA code to automate the data entry process. The VBA code should be able to automate data entry and some formatting. The ideal candidate should have experience in VBA coding and Excel automation, and be able to work efficiently and accurately.
I am looking for a freelancer who can create an Excel macro for me. The main purpose of the macro is to automate data entry. I would like an excel macro file to add various excel file and the added file will be rearranged. from 1 table, i need 2 output table. input file contains all data, but i need 2 output (sheet) - Proficiency in Excel and VBA - Experience in creating Excel macros and templates
Excel sheet (form) add button when executed to save data in different sheet and calculate for monthly statistics
I am looking for a freelancer who can create a macro for me that checks if a specific process is running on my Windows operating system every 5 minutes. The process name that needs to be checked has been provided and is correct. Ideal skills and experience for this project include: - Proficiency in creating macros for Windows operating systems - Knowledge of process monitoring and management - Experience in automating repetitive tasks - Strong attention to detail and ability to troubleshoot any issues that may arise The macro should be set up to perform the following actions: - Check if the specified process is running - If the process is not running, perform a set of clicks to open and start the process - If the process is already running, do not perform any actions ...
Developing simple macros Modifying Word ribbon for particular macros so they can be accessed immediately as an Icon or drop down menu Creating a Global word ribbon so all users are working from same ribbon Creating a Global menu so all users using one Possible development of docs through VBA
I am in need of a freelancer who can give me VBA or Python Program with a Chrome to Excel data scraping project. The project involves scraping data from . Skills: - Proficiency in Chrome to Excel data scraping - Knowledge of data scraping - Attention to detail - Ability to deliver timely results The specific data that needs to be scraped is a list of trades. The freelancer should be able to scrape this data accurately in excel file in given format. If you think you have the skills and experience required for this project, please get in touch.
I am in need of a freelancer who can give me VBA or Python Program with a Chrome to Excel data scraping project. The project involves scraping data from . Skills: - Proficiency in Chrome to Excel data scraping - Knowledge of data scraping - Attention to detail - Ability to deliver timely results The specific data that needs to be scraped is a list of trades. The freelancer should be able to scrape this data accurately in excel file in given format. If you think you have the skills and experience required for this project, please get in touch.
...skilled freelancer to develop an Excel macro tool for our existing business. The project involves sending bulk emails using a specific email service provider that we have in mind. The most important feature for us is email personalization, which should allow us to customize each email with recipient-specific information. In addition, we would like the macro tool to support scheduling emails and attachment support. The ideal candidate for this project should have the following skills and experience: - Proficient in Excel macro development - Experience with email marketing and bulk email sending - Familiarity with the specific email service provider we have in mind - Ability to integrate email personalization, scheduling, and attachment support into the macro...
I'm looking to make minor changes to an existing Excel VBA program. The change required is to update some code since the importing CSV file have changed. I have all the necessary documents and code needed for this change. The preferred delivery method is an on-site visit by the freelancer. The freelancer will have full access to the source code and any other necessary documents. I'm looking for someone who has experience in Excel VBA and can make quick, accurate changes.
I am looking for a freelancer to help me out with a project. I am upgrading my MS Access application to Windows 11 and need assistance in changing the application icon. I already have an existing icon selected that needs to be replaced. However, I will need assistance from someone familiar with VBA code to make this change. So, if you have experience with VBA coding and have worked with Windows 11 applications before, then this might be the perfect project for you! I'm using the following version of access: Microsoft® Access® for Microsoft 365 MSO (Version 2301 Build 16.0.16026.20002) 64-bit. I'm currently using this code, but the Access icon is still displayed in the main window on windows 11: "AppIcon", & "myicon
I need a VBA tracker in Microsoft Excel that can track my employees' work hours. The ideal freelancer for this project should have experience in VBA programming and should be familiar with Microsoft Excel. Key requirements: - The VBA tracker should be designed to track work hours only. - The tracker should be built using Microsoft Excel. - The level of customization required is intermediate. Details shared in excel file. If you're interested in this project, please submit your proposal including your experience in VBA programming and examples of previous work. Need urgently.
We are looking for a freelance Excel VBA developer to help automate our sales analysis process. The ideal candidate will have experience in developing Excel macros and VBA scripts, and be able to analyze growth degrowth of each article on the basis of sales data. Responsibilities: Develop Excel VBA macros to automate the sales analysis process. Analyze one month's sales data, assign a monthly grade based on the assigned threshold value, and compare it with the previously assigned static grades. Develop a system to track sales performance and generate reports. Requirements: Proven experience in process automation and workflow management. Proficiency in Advance Excel & VBA. If you are interested in this job, please provide examples of your past work and...
I am looking for a VBA expert to create an Employee Tracker that can track both attendance and productivity. The data should be presented in a combination of charts/graphs and tables/lists. Additionally, I require weekly reporting for this project. Ideal skills and experience for this job include: - Proficiency in VBA programming - Experience in data tracking and reporting - Ability to create visually appealing charts and graphs - Strong attention to detail and accuracy - Excellent communication skills for project updates and feedback.
Hi .. I am looking to fetch financial data from a property management system (pms) with open api .. possibly pull this data to excel or xero (accounting software)
I need someone, who can help me. I changed an existing VBA Programm. I have a Form and when I click on a Button of this Form I want to execute a Makro. It starts the makro, but if i want to get access to a special sheet on the workbook it always tells it out of range. I tested several things: (Window non modal, activate workbook with path&name, select sheet nothing works) I dont know why
Hello! I am searching for a freelancer who can help me out with my project – fixing macros on an excel built tool. The macros that I need fixed are VBA code and they have already been tested and are not frozen or not updating. I am looking for somebody who is highly skilled in excel macros and VBA code who can help fix the problem without running into any further delays. If you think you have the right skills, I am looking forward to hearing from you soon!
I am looking for a Macro Excel Expert who can help me with my data analysis. Specifically, I need someone who is experienced in using advanced formulas to analyze medium-sized datasets (1,000-10,000 rows). The ideal candidate will have experience in the following areas: - Advanced Excel Formulas - Data Analysis Techniques - Report Creation - Data Visualization (Charts/Graphs) The tasks involved in this project will include: - Analyzing the dataset using advanced formulas - Creating custom reports based on the data analysis - Automating repetitive tasks using macros - Creating visualizations to clearly communicate the insights from the data analysis If you have previous experience with this type of project, please submit your proposal.
Make a VBA program to be executed from Microsoft Access 64 bit version with following requirements - See file "VBA_requirements"
I would like to build a quotation tracking system where we would enter A. The details of the quotations when it is generated B. Update the status and changes when it is modified C. Captu...to build a quotation tracking system where we would enter A. The details of the quotations when it is generated B. Update the status and changes when it is modified C. Capture the customer name and details D. Generate report for the quotes with its status E. Update the quote status when it is won Lost or discarded and the win percentage changes solutuon should be in MS acess and VBA as we cannot install any third party application F. The copy of the quote or equipment list shall be added in quote , so that we can generate a report of materail in demand by looking at all live ...
Buscamos un desarrollador de software Fullstack (Frontend y Backend) en .NET Entorno de trabajo: Net Framework (No requerido obligatoriamente) Software: AspNet; VBA; SQL o MySQL Conocimiento basico en gestion de servicios windows.
I am looking for a VBA Scraping Macro Excel expert to help me scrape data from I need the following specific data scraped: Team names, result , weather , details of game as shown in attached files The attached screenshots are very clear, if you write me you must have first looked at them, i will ignore robotic offers without telling me if they can do this job.
I need to convert a CSV file into a XLS file with aesthetic changes such as grid lines I have put the CSV file that I get from my system and the dollied up version as well. Some challenges, thes...the same columns, but the number of rows for each job number may change and also line items be different. I think tho that one can send the software to the heading, box what is beneath, and then see the next heading bold it and box what is beneath. There is a key where we want certain things coloured if they change their status. The file needs to be opened, saved as an XLS document and the macro run or vice versa, but what would also be good is if the xls sheet once modified can be locked and nothing can be done to change it. (people can change dates for delivery which would be b...
Hello, I need someone can help me to automate excel macro, and click on "run" and select folder Thanks
Need to create excel sheet, all data already exists in another excel. You need to copy evrything in new macro enabled sheet.
Need to create a tool where it can verify the data from 2 CSV files with same heading and identify the difference.
I am looking for an Excel expert with knowledge in sports betting to help me with a project. I need assistance with data analysis, spreadsheet organization and macro creation for a specific sports betting data set. The ideal candidate should have extensive experience in using Excel and have knowledge of various aspects of sports betting. If you feel confident that you can complete this project to the highest standard, then I would love to hear from you. Seeking an expert Excel modeler with deep understanding of sports betting odds and strategies to help us create advanced simulation models for our betting strategies. The ideal candidate will be proficient in Excel and thoroughly understand sports betting odds, mechanics, and various types of bets. Objective: Our objective is to de...
I am looking for a VBA Selenium developer who can help me with a shadow-root problem. I have attempted to solve it but still need assistance with clicking a button and downloading a document within the shadow-root. The ideal candidate should have experience with VBA and knowledge of shadow-root. Its a simple function that clicks on a button and downloads a document. I can write most of the code myself, but need help with this shadow-root. I already have some code but stuck at clicking the button as its layered in two shadow-roots. The job has to be done via remote desktop as its on a password-protected page that I can't share. Steps: 1. Connect remotely (anydesk/ultraviewer) 2. Fix the code so it can click the button and download the document within the shadow-root 3...
I am looking for a VBA Selenium developer who can help me with a shadow-root problem. I have attempted to solve it but still need assistance with clicking a button and downloading a document within the shadow-root. The ideal candidate should have experience with VBA and knowledge of shadow-root. Its a simple function that clicks on a button and downloads a document. I can write most of the code myself, but need help with this shadow-root. I already have some code but stuck at clicking the button as its layered in two shadow-roots. The job has to be done via remote desktop as its on a password-protected page that I can't share. Steps: 1. Connect remotely (anydesk/ultraviewer) 2. Fix the code so it can click the button and download the document within the shadow-root 3...
Please write a macro to automatically merge the content of different excel files with the same format into a single ‘Master’ file. The specified format is provided in the attached excel sheet. The macro should be able to do the following: • Delete existing data in the ‘Master’ sheet and renew this with the latest date from the original files. • Source file names and locations to be included as open variables to be specified by client (max 8). • Range of columns as per the example file with an option to expand by client (please specify where). • Copy of data should include the source file formatting (e.g. font color). • As a requirement the code should be open to allow us to make any adjustments when necessary If possible...
I am looking for assistance to convert various existing Macro enabled Excel salary calculators (contract rates/gross salary, to net retention) to Zoho, via either Zoho Creator or Deluge. Zoho Creator has been chosen as the destination platform for the calculator and the data will be sourced from a CSV upload, or as you deem fit. The calculator requires user input, so I need someone with experience in the Zoho Suite and specifically with working with calculators/advanced Excel. I am looking for someone who has a good understanding of how Zoho Creator and Deluge work, along with knowledge of setup flows, writing scripts and end-user experience. The desired outcome is for the calculator to be imported into either Zoho Creator or Deluge and be made available to use as soon as po...
Busco una persona que tenga experiencia en el uso de VBA para Excel y SQlite (i.e. generacion de graficos en excel usando VBA, macros, realizar operaciones en SQlite...). Actualmente estoy trabajando un en un proyecto de investigacion y necesito una persona que me ayude a completar una serie de macros en excel usando VBA y SQlite.
I'm looking for a talented programmer to help me build a program using VBA macros. I have a specific set of requirements that must be met, and I'm confident the build shouldn't take too long - only a few hours. If you're someone who specializes in VBA macros and is willing to work on this short project with me, let's connect! This Project will involve generation of cost sheet based on requirements of clients using VBA macros(detailed description in attached documents). These documents in turn will be used to generate MIS reports and hence need to be formatted in a similar fashion
I speedrun Minecraft and a part of the run requires you to line up your crosshair in a very specific spot. If you are on a standard resolution like 1920x1080 then you can easily set up a zoom to view the pixel easier. Because macs are retina some have weird resolutions (also if you don’t have 2 monitors you can’t do the zoom I was talking about above). This messes up with the alignment. So there is other tools the zoom/stretch your window to make alignment easier. The problem is they don’t work on macOS. I want something to zoom/stretch my window after the press of a key that works on macOS. Maybe an apple script, maybe an application, java program. I don’t know. I will attach some photos of the zoom/stretch I want. One photo is no zoom, another is stretched a lot a...
VBA expert required who can find the error in code and correct it. . We need the things done within an hour.
I am looking for an experienced Excel expert who can assist me with advanced formulas for my specific project dataset. The ideal candidate should have a strong background in Excel and be able to create macros and perform...experienced Excel expert who can assist me with advanced formulas for my specific project dataset. The ideal candidate should have a strong background in Excel and be able to create macros and perform data analysis. Tasks: - Assist with advanced formulas for project dataset - Create macros for data organization and analysis Requirements: - Strong background in Excel - Experience with macro creation Communication: - Email communication for discussing the project. If you have the necessary skills and experience, please submit your proposal for cons...
I'm looking for a freelancer to help adjust some errors on my VBA Excel macro. the type of error that needs adjusting or the amount of time needed to complete the project, however it is urgent. If you think you can help, please bid.
I am seeking a skilled Excel expert who can fix the errors in my advanced macro workbook, while maintaining the overall quality of the workbook. Additionally, I would like to add some new functions to the workbook to improve its functionality. Ideal Skills and Experience: - Advanced proficiency in Excel and VBA programming - Strong knowledge of formulas and macros - Experience in troubleshooting and resolving errors in complex workbooks - Ability to create visually appealing and user-friendly interfaces - Familiarity with data analysis and visualization - Attention to detail and ability to maintain high-quality standards Key Deliverables: - Error-free macro workbook with improved functionality - New functions added to the workbook - Consistent formatting ...
I am looking for an Excel expert to create a custom macro and import data from an XLSX file. I will provide the specific format and layout for the imported data. The primary goal of the Excel macro is to automate reporting. Ideal skills and experience: - Proficient in Excel macro and data import - Strong understanding of automated reporting - Experience in manipulating and analyzing data - Attention to detail and ability to follow specific formatting requirements
I am looking for a skilled freelancer to help me edit a Google Sheet via an Excel userform. I have a Google sheet. I want a Vba form to view/edit/update data on Google sheets using vba form.
Exact requirement is program should read each row of txt data and when it matches the name we require it copies the value of data from column B of the text file. and then it paste that data to a required cell in the Excel file.
Select data from Attendance Report and create ERP data for payroll
I would like to automat an email on outlook. Body of email needs to have the following: text from cell A2 cut and paste image : VegetableImage text from cell A4 cut and paste image : MeatImage Text from cell A6 cut and paste image : BreadImage Text from cell A8 I would like to refence sheetcodename and image (shape) name. and cut and paste it..or if it's easier for you we can also do copy range and paste as image in the body of email WIll pay $20 upon successful code implementation.
I am a beginner in VBA and have created a form that already has some code in it. However, I need it to execute other functions which I cannot do due to my initial knowledge. So I need someone to develop the codes solving and put the comments inside the code so I can learn
Api automation with vba. This is for trading strategy automation
...specific criteria to a randomize filter generating monthly sheets. No use of collections or helper sheets. See link for more info: The criteria that have been correctly included so far (prework): - row 4 shorts are filtered from table columns "Full revision" and "Overwork" - row 4 shorts are only used once a week - rows 5 and 6 are filtered from table columns "Translation" and "Overwork" The criteria still to include: - row 4 shorts can only be used maximum twice a month (with the current vba code this is not the case: see shorts highlighted in orange on the attached image of an automatically generated month sheet) - per day, the shorts in rows 4, 5 and 6 have to
