Macro vba jobs
I want someone to teach me how to scrape data from both static and dynamic webpages. From DOM inspection to manipulating URLs, techniques and methods used to access data on websites. By the time we're finished, I want to have a firm grasp on how to use Excel VBA to scrape data from any web page,.
I'm looking to create an automatic report from QuickBooks and other databases that displays a comprehensive Deal Analysis, including Profit & Loss analysis, claims analysis, payments analysis, cost & sales analysis, etc. The data should be formatted into an Excel spreadsheet in order to easily sort, analyze and track business performance trends. Automation is required for t...efficient and effective as possible. The mentioned expert needs to know about Accounting, QB programming, and Excel, and needs to able to create improvements and solutions in order to achieve what the project requires. If you cannot satisfy this requirement please do not apply since it is crucial to us for developing the automation of this report. On extra observation is that the report cannot use VBA...
I am looking for an Excel VBA coder to automate tasks for me. The main purpose of the VBA code is to automate tasks. The task or process that needs to be automated is of intermediate complexity. I can provide details on the specific task that needs to be automated. I am looking for someone with the following skills and experience: - Proficient in Excel VBA coding - Experience in automating tasks of intermediate complexity - Strong problem-solving skills - Attention to detail - Good communication skills If you have the skills and experience I am looking for, please apply for this project. Note: Need to develop EXCEL VBA package of Genetic Algorithm for Engineering Optimization Problem Solving. It should be user friendly and provide as many iterations as entere...
out of the given data dump prepare interactive excel dashboard using macros and VBA for lead time analysis
...through multiple Chrome browser windows and selecting from menu options. I would like to automate this task using a stream deck and software such as Macro Deck. Responsibilities: Create a custom macro using Macro Deck to automate the necessary clicks and selections in Chrome browser windows Assign the macro to a button on the stream deck for easy execution with a single click Test and debug the automation to ensure it is reliable and functional Provide documentation and training to enable me to maintain and update the automation in the future if necessary Requirements: Experience with stream deck automation and software such as Macro Deck Familiarity with Chrome browser and its menu options Attention to detail and ability to debug and tr...
There are 21 fields in the database, and there are 21 fields in the template that need to be populated. I want all of the rose in the database to populate the appropriate fields in the template Rows. Each row represents a potential client. If a cell is currently populated with a fake phone number, leave it blank, but I still need the telephone format. To the right of the “dd” Is the contents of the drop-down
I am looking for a freelancer who can develop an Excel automation script for me. The main purpose of the script is data entry automation. I need the script to handle conditional copy-paste. Input and output files will be in both CSV and XLSX format. The ideal candidate should have experience in Excel VBA programming and should be able to create complex formulas and macros. The script should be able to handle a large amount of data and should be easy to use.
Hi there Need help with a excel vba code using selenium web driver to access a nested shadow dom element from web page and perform activities like click, add text etc.
As a user I have a requirement to paste copied text from Windows clipboard to a Microsoft form field which I select using the computer mouse. The pasted text should have all double spaces, useless double spaces, line breaks, unwanted spaces removed i.e. the text should have a single space between them; wrapped. I wish to run the procedure as a Marco that I can run from a command button and using a shortkey key with the Access database.
Automate Repetitive Actions on a Website using Macros I am looking for a skilled developer to create a program that will automate repetitive actions on a website using macros. The ideal candidate will have experience in creating macros and automating tasks. Task Details: - The task we want to automate is repetitive actions on a website. - The frequency of the task is as needed. - The macro should work specifically on Google Chrome. Required Skills: - Experience in creating macros to automate tasks. - Knowledge of Google Chrome automation. If you are interested in this project, please provide examples of similar projects you have completed in the past.
We offer online seminars for the following subjects: - Introduction into sql (Oracle, MySQL, Postgresql, SQL Server, MS Access) - Administration of RDBMS (Oracle, MySQL, Postgresql, SQL Server,) - Performance & Tuning of RDBMS (Oracle, MySQL, Postgresql, SQL Server,) - Learning Programming (Visual Basic, VBA, Python, C++, Powershell) If you are a german speaker (B2 Minimum) you may apply.
I have a file which will have stocks information such as price, estimated value and ranking. The VBA program will ingest the data and generate a comprehensive list that includes each sector along with its corresponding column values, which are derived based on the provided Logic as shared with the document. This is just a starting and few more will be provided whom I select for final project. Please read through the file and quote accordingly.
Hello, my name is [Client Name]. I am looking for an experienced freelancer who is skilled in VBA coding to provide me with a quality project. I do not have any specific application in mind, but I am not open to suggestions. The scope of the project can either be short, medium, or long term. I am hoping to find someone who is reliable, organized, and detail oriented. I’m looking for someone who demonstrates the ability to understand technical requirements, understands different coding methods, has excellent communication skills, and can be creative in their work. The successful freelancer should be able to suggest solutions for improvement if needed and be able to offer insight into current trends. If you feel like you are the perfect candidate for this project, let’s...
I'm looking for help with coding in Excel. Specifically, I need someone who understands VBA and can create custom functions to help me with data manipulation. The task at hand involves taking the data that I provide and using the correct formulas and VBA to create meaningful insights about the data. I'm looking for an expert in Excel coding who can complete the task to the highest standards. If you believe you have the necessary skills and experience to complete this project, please get in touch. I look forward to hearing from you! whenever I type the « Stockist code », when clickting on "update stockist list", the codes helps me to fetch all these data and show them in this same table (file "IMG_1959"). Now what I need is...
I need a macro that will take a 5 digit number from column A and inbed it into formulas referencing file locations in three columns. This needs to repeat for all row with a number inputted. The formulas will be different in each column and therefore the macro will need to find the number string and replace it for every row. It should only act when a 5 digit number has been inputted. Some rows in column A wont have a number and therefore currently this is account for in the formulas. It needs to unprotect and reprotect the worksheet. An example file has been attached.
Hi Sir, Hope you are satisfying with my work. Request you to please release the payment and also share your feedback on my profile to get motivation and I will do my best for future projects.
I am in need of an experienced Excel VBA programmer to help with a project. The project requires the usage of a VBA script that will be used to model and simulate . The ideal candidate would have expert knowledge of coding in Excel and must have experience in automated reporting. If you have the skills required for this task and are interested in this project, please contact me so we can discuss the project further!
Creating a copy paste script that avoids repeating cells. The ideal candidate should have experience in programming languages such as Python, JavaScript, or VBA. The purpose of the script is for data entry automation or spreadsheet manipulation, and it will be used on platforms such as Microsoft Excel or Google Sheets. The script should efficiently copy and paste data without repeating cells.
When i run macro in sheet 3 in excel, data is not getting generated in JSON,blank data is coming Wanted someone to rectify the macro error so that able to generate the file in JSON format
I am looking for a freelancer who can create an Excel macro that will help me with data formatting. Specifically, I need the macro to delete content between empty rows, and then delete the empty rows themselves. The project requires the following: - A macro that can identify and delete content between empty rows - The ability to delete the remaining empty rows - The macro should be compatible with Excel 2016 or later Ideal skills and experience for this project include: - Strong experience in creating macros for Excel - Knowledge of Excel data formatting and cleaning techniques - Familiarity with Excel 2016 or later Please see attached file for example. If you have any questions or suggestions regarding this project, please do not hesitate to contact me.
We are seeking an experienced Excel VBA/Google Sheets expert to develop a progress monitoring dashboard. The dashboard will be used to monitor progress on various projects and tasks and provide key stakeholders with real-time updates. The ideal candidate will have extensive experience with Excel VBA or Google Sheets and be able to design and develop complex spreadsheets and dashboards. Key Responsibilities: Design and develop a progress monitoring dashboard using Excel VBA or Google Sheets Work with stakeholders to identify key metrics and develop data visualization tools to display progress Automate data collection and analysis to ensure real-time updates on project progress Develop macros and scripts to streamline data entry and analysis Collaborate with other depa...
We are seeking an experienced Excel VBA/Google Sheets expert to develop a progress monitoring dashboard. The dashboard will be used to monitor progress on various projects and tasks and provide key stakeholders with real-time updates. The ideal candidate will have extensive experience with Excel VBA or Google Sheets and be able to design and develop complex spreadsheets and dashboards. Key Responsibilities: Design and develop a progress monitoring dashboard using Excel VBA or Google Sheets Work with stakeholders to identify key metrics and develop data visualization tools to display progress Automate data collection and analysis to ensure real-time updates on project progress Develop macros and scripts to streamline data entry and analysis Collaborate with other dep...
VBA programming to compile all tabs and apply other updates as discussed.
I am creating a form (yes /no) where the answers determine what other questions to show or hide.I am using form buttons (option buttons and checkboxes). I am able to program all of excel as i want it, but i cannot hide the form buttons, resulting in them floating on the sheet when the data around them is hidden. I need to know how to hide them.
I have .xlsm file with Macros. It is working fine in Windows but not in MAC. I don't have code for this. I need someone who can help me to work it in Macbook Air.
I am looking for a talented and experienced expert in VBA coding to assist with a project. I require assistance with writing macros, debugging existing code, and performing data analysis. The complexity of the VBA code required is expected to be intermediate at a minimum. I do not currently have an existing code that needs debugging, but this may change in the future. I need an experienced professional who can understand and develop advanced VBA scripting in a structured format. If you think you have the skills and experience necessary to complete this project successfully, please get in touch!
Upcoming project, we are looking for Excel Macro Developer 2 to 3 years of Experience
I'm seeking experienced help to create Excel VBA Macros to help me accomplish a task. I have no experience with VBA, but I need someone to create macros that can bulk-add images from a folder to an excel sheet in the corresponding cells. The level of complexity is intermediate. Someone with experience in creating Excel VBA Macros would be great. If you think you can help me with this project, please let me know! Thanks.
I have a 3 storey office mock project where I need to show compliance to regulations. I am currently drafting this project to be part of a portfolio for my registration with VBA. I would like to hire a building surveying to check my work.
Run a macro according to the request. (Run total 5 blue colors tab, starting from 2012-2018 tab or whichever that is earliest one in the excel. Click on All Sim Model Button. Excel macro will run, and just leave it until the simulation is completed.) Deadline is indicative and may be earlier or later depending on the macro and the amount of data.
Hi Everbody, please create a Excel-sheet and VBA Modules (programm-file). We need the following fuctions: 1. separate Sheet with credentials in programm-file. As we got serveral Clients, the credentials have to be organized in rows per client. column 2 shows the client-specific-data-file (csdf) name in the same folder as program file 2. authorize at Amazon with Selling Partner API 3. get the GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE from Amazon 4. save the result to csdf sheet "settlementreport" 5. ensure not report are duplicates. ensure we got all report in the timeline, not timeperiod is missing same for a VAT-Report from AMAZON. Report name willl be delivered later to you. Save result to CSDF sheet "VAT-Transaction-Report". Be sure it is complete and no dup...
Looking for a skilled freelancer to create a Microsoft Word Micro that can perform specific tasks. The main task is prepare a MS Word micro that should be able to automate repetitive tasks. Ideal skills for this project include experience with Microsoft Word macros. Only apply if you have advanced Microsoft Macro skills.
Scope of work is to finalize and help commercialize a PowerPoint COM add-in. Experience in PowerPoint Add-In and the Office Object model is essential. 1) Review and clean up my code (I have around 25 custom features in VB.NET) and translate some code from VBA to VB.NET 2) Finalize building a task pane that allows users to search and insert images, icons, templates. This works almost as needed, apart from slide templates and some final touches on the user experience. Need API experience for this 3) Help prepare for commercialization, incl. support with digital signature (e.g. Sectigo), install packager (e.g. WiX), and a license model with free trial Include the word pineapple in your proposal
I have an excel doc - as the User updates a UserForm (from Developer) the content of the document change. When he submits the userform the excel save as PDF (done with Vba). I want to send the file to the user without him knowing it is an excel file...so I basically need some sort of interface. Working in Excel but not looking like excel.
We pull monthly excel sheets with phone numbers that have a ton of different formatting. So every month we manually search and replace ( , ) , + , + , - , and finally a space. We replace them with nothing so then all phone numbers in the column look like this 8554347483 instead of (855)-434-7483. Would like to speed up this process.
I'm copying and pasting data into a spreadsheet that I need to change the layout of. The Data is in the form of question and answers. It starts with everything in one column in an identifiable pattern. What I need is for each Question and matching answer to be on a row. I am manually editing, but it is taking too long. The spreadsheet attached shows clearly what I need. It starts as "Copied and pasted" and what I need is "Transformed". The key here for a speedy turnaround, otherwise I might as well carry on doing it manually! By way of explanation: The format is: Question#, Q, {question], A, {answer} 7 Q Is osmosis passive or active? A Passive 8 Q Define active transport A The movement of molecules from an area of low concentration of that molecule to an ar...
I am looking for a freelancer who can help me with an Excel Automation project. The ideal candidate will have experience with automating basic tasks in Excel. Tasks: - Automating data input from different sources - Automating formatting and sorting of data - Automating basic calculations and formulas Skills: - Advanced knowledge of Excel - Proficiency in VBA and macros - Experience with data manipulation and analysis If you are interested in this project, please provide examples of previous Excel Automation work you have done.
I am seeking a freelancer with expertise in VBA to create an automated report generator for data analysis purposes using Microsoft Excel. The ideal candidate should have experience in statistical analysis and be able to integrate custom formulas as needed. The report generator should be compatible with Microsoft Excel and must be user-friendly for non-technical individuals.
Hi there! Do you have experince good sheet scripts. Thanks
I am looking for an expert in Visual Basic for Applications (VBA) scripting to help me with a project. I already have the data set to work with and it is relatively small with less than 500 rows. I need Help designing macros and performing data analysis with macros utilizing VBA scripting. The ideal freelancer would be someone with experience in creating macros and working with spreadsheet applications like Excel and Google Sheets, who can apply their knowledge to help execute sophisticated functions with the data set I am working with. This should be a relatively straightforward and fast-paced project, so please get in touch if you think you are up to the task!
As a personal project, I'm looking for a talented individual to create a basketball simulator using VBA in excel. The primary purpose of this project is to be able to calculate performance analytics. This requires that the simulator be able to accurately track player stats and generate visuals such as graphs and data tables to aid in analysis. The project must be completed and delivered by April 13, 11 PM.
extract , paste, verify, copy data from one file to another basing on various conditions. Needs to accept user sceen input for choice of cell action, cell and file location.
Need to create a VBA that does the below. Excel macro knowledge must As per the dimension in the Excel packing list, it automatically creates boxes in the AutoCAD LT application. Also adds descriptions inside the boxes from the Excel cell.
Need Images and Videos of Bespoke Tailoring Cinematic videos. Images need in high resolution files. Examples.
