Macro vba jobs
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...
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
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: GET_VAT_TRANSACTION_DATA. Save result to CSDF sheet "VAT-Transaction-Report". Be sure it is complete and no duplicates. Initially lo...
I have source excel file,using this excel file ,i want to create a new PPT from scratch. (Sample PPT is attached).Approximately there are 32 elements which is to be taken from excel and fitted in the new PPT slide (in the prescribed format). Most i...source excel file,using this excel file ,i want to create a new PPT from scratch. (Sample PPT is attached).Approximately there are 32 elements which is to be taken from excel and fitted in the new PPT slide (in the prescribed format). Most importantly,the VBA program has to create a graph in the PPT (not as just image).should be editable. The source for the graph also will be available in the graph. I want the excel vba programm along with source codes. I want the sample PPT which i shared is to be completely reproduced by th...
I need a word macro built. When the macro is pressed it need create "<<>>" with the cursor in the middle of the greater less than signs and the greater less sign and anything typed in the middle of the signs will be set as hidden text. I may need the text font entered in between the greater less than signs to be changed from default.
VBA programming in GSA software. Please place bid if you can start as soon as possible.
VBA Programming in GSA Software. Please place bid if you are available today. Thanks
Our client looking to hire someone to help with an Excel automation project. Excel sheet is needed for a computer application. It will need knowledge of VBA, excel formulas. The details have been provided here
Looking for someone who can do vba programming in GSA software. Should be available today
I am looking for an experienced Excel VBA and Google Sheet with GAS expert to help me with my project. I need someone who can help me create automated processes and features, such as visualizations/dashboards, for a medium-sized project. The expected deliverables may include automated processes, dashboards, reports, etc. The ideal freelancer for this job should have a strong understanding of both Excel VBA and Google Sheets with GAS, so they can help me create a comprehensive and user-friendly solution. Please include details of any similar projects you have completed in the past.
I am looking for a VBA expert to complete a simple automation task today/tomorrow. I need it to be done as soon as possible with a flexible timeline. Specifically, I require an Excel Sheet output. I am looking for an experienced VBA expert who is capable of understanding the needs of the task quickly and efficiently and can make sure the job is completed on time. The automation process should be reliable, stable, and accurate. The right person should have a proven track record of successful VBA automation projects.
Note: budget not more 10$ macro automation desktop app that works with ChatGPT and ocr and image recognition APIs. The app will allow users to perform various actions using natural language commands, and the app will automate these actions by performing mouse and keyboard movements on the computer. To create this app, the developer will need to integrate ChatGPT API with computer vision/image recognition APIs, which will enable the app to understand and interpret user commands. The computer vision API will be used to analyze images in real-time and recognize the objects, scenes, and text within them. This information will then be passed to ChatGPT, which will interpret the user's commands and generate the appropriate mouse and keyboard movements. The user interface of the ap...
I WANT TO EASY ME REPETITIVE TASK BY PRESSING A SINGLE BUTTON OR COMMAND
create a budget and investment tracker with excel. VBA Work. I have the file that explains exactly what you need to know. Let me know if you would like to look at it
Data Processing & Modeling using VBA. User will import raw data a VBA program will process, do some calculation, Modeling & export the data.
i have excel file i want to improve it by adding some specifications and some of dynamic things i need someone professional to do it no vba
run 16 file sets on two part macro. I'm thinking we can just pass the macro back and forth.
Example files provided: I need a looping macro or subroutine(s) to examine the second column of string text entries in an Excel table of 7 columns and 1009 rows and, if the sixth column entry in the row being tested = 0 (meaning untested), then test each string text row entry in the second column for the first occurrence only of an identical string text in the body of text of a separate Word document. The text tested in the Word document should only include font sizes of 10 or 12 and have an initial font color of all black characters. Additional columns in the table of significance for this subroutine are the string text in column 5 which identifies related row entries for possible exclusion from testing, columns 6 and column 7 which track and use number codes to define status of...
I'm looking for a freelancer to help me with a project involving a raw xls file. The freelancer will need to create a new theme/style using macro, VBA and export automatically to a PDF, so I can produce reports.
I'm seeking a skilled graphic designer to create an updated logo for my website, Python & VBA (). The current logo needs improvement, and I'm looking for a fresh, modern design. Logo Requirements: - Incorporate the cute monster (image attached) - Include the title: Python & VBA - Add the tagline: Become an Office Superhero - Use the primary color: #3772a3 - Match the website's design style Feel free to add your unique twist and creativity to the design. However, feel free to incorporate your own twist and design ideas.
I am looking to hire a talented freelancer to develop a macro software for Macbook devices. The macro software should support MacOS 10.15 and the scope of the project involves creating a macro software that will record your actions. You should be able to set custom macros.. The language for the macro software will be TBD. The successful candidate must have strong coding experience, knowledge of both Apple , as well as up-to-date knowledge of macOS 10.15. The expected outcome is a functional macro software that fulfills the requirements mentioned above. It will mimic the same features of a macro software on Windows.
