Vba excel script jobs

Please Sign Up or Login to see details.

I am looking for a detail-oriented professional who can assist in copying and pasting data for my business, BD Company. Required tasks: - Copy data provided in Excel sheets. Ideal Skills: - Proficient in Microsoft Excel - High attention to detail - Strong data entry skills Apply only BD interested person.

I'm in need of a PostgreSQL script that will loop through my table and update certain columns of the rows that meet a specific static condition. The main functionalities of this script include: - Iterating through all the rows of a given table. - Checking each row to see if it meets a certain static condition. - If the condition is met, updating certain columns within that row. This script should be designed to handle the following requirements: - The script will be used to filter and update specific rows based on a static condition. This condition will remain unchanged. - The script needs to efficiently loop through the entire table and update only the rows that meet the specified condition. Ideal skills and experience for this job: - Proficient ...

I'm ...seeking an expert who can quickly create an interactive script intended for macOS Sonoma. This script should: - Ensure compliance with CIS (Centre for Internet Security) benchmarks, particularly focusing on system and information integrity. - Be capable of automating system configurations based on CIS benchmark suggestions, all of which are outlined in a comprehensive PDF I will provide. Ideal candidates will have: - Extensive experience in macOS, scripting, and automation. - Familiarity with CIS benchmarks, especially related to system and information integrity. - Ability to deliver the project ASAP, given its urgent nature. This is a great opportunity for freelancers with a solid background in security configurations and script automation, especiall...

I want a script that allows me to export a Zencart catalog () to CSV in real-time with the following fields: Title Short description Category (x, y, z) Description Image URLs (URL1, URL2, URL3) Price Stock

** Urgent Need ** I need 1 Script Description Content every day each one will be short 100-200 Words. Video Will be provided. Content Topic/Type Example: The Content should be like this type of topic and 100% unique and related to the subject. All the content should be well-researched and have accurate information. The budget is $10 Per Content. Newbies are highly welcomed.

The current problem is that the ghosting problem when deleting the dice information cannot be solved. If anyone can solve it, please contact me.。Still using the control script Telegram personal account, not a robot, ❶ Throw two dice A times, the script automatically recognizes that if the sum of the points of the two dice thrown by A exceeds 8 points, it will be retained; if the sum of the points is less than 8 points, the smaller point will be deleted and the larger point will be retained. ❷ If neither of the two dice thrown by A is deleted, and the sum of the points exceeds 8 points, then throw two dice B again, and keep the larger point. The sum of the points of the two dice thrown before must exceed 11 points. If A only throws one dice, B will automatically recognize whet...

I am looking for a developer who can design a data uploader for my website. The primary purpose of this tool is to allow me to upload different types of files such as Excel spreadsheets, CSV files and Text files into my website's backend. Key Requirements: - Support for multiple file types: The uploader should be able to accept a variety of file formats, including Excel spreadsheets, CSV files, and Text files. - Basic Data Validation: Before the data is uploaded, I need this tool to perform basic data validation. This would involve checking for field completeness to ensure that all necessary fields are populated before the upload is allowed. Ideal Skills and Experience: - Proficiency in web development: The ideal candidate should have a strong background in web develo...

I'm looking for an google sheets / excel guru who can construct an advanced drop-down lookup system for my entire sheet. This system should include multiple variables that will inform the price from the database. Currently looking up values manually in a series of tables, tables may need reformatting to allow for efficient searching Key skills and experience: - Proficient in MS Excel Advanced Functions - Experience with both numerical and text data - Knowledge of creating drop-down lookups for entire sheets The final product should streamline our decision-making process by providing agile, accurate prices based on the selected variables. Your comprehensive understanding and application of numerical and text data within an Excel environment will be key to the s...

I'm seeking a meticulous data entry professional who can convert physical documents filled with text data into an Excel spreadsheet. Key Requirements: - Conversion of physical text data documents into an Excel spreadsheet - High level of accuracy and attention to detail to ensure the data is entered correctly - Ability to maintain data confidentiality - Must be able to meet deadlines Ideal Skills: - Proficient in data entry and managing data using Excel - Excellent attention to detail to ensure the accuracy of the entered data - Previous experience in handling sensitive or confidential information - Ability to meet deadlines and ensure timely delivery of the project - Strong communication skills to provide updates on the progress of the project

I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.

Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.

I am looking for a professional with strong data entry skills to assist in transferring text data from digital documents into an excel sheet. The successful candidate should possess: - Reliable accuracy in typing - Fast typing speed (numeric keypad advantageous) - Proficiency in Excel (VLOOKUP, SUMIFS, Pivot Tables, etc.) - Able to interpret written information swiftly - Excellent attention to detail for proofreading entered data. This task will require someone with experience in handling large volumes of data entry, with absolute prioritization on maintaining the integrity and accuracy of the inputted data. Any previous involvement in similar projects handling text data is highly desirable. Understanding of and/or a background in just managing digital document data will...

I'm in need of a proficient Javascript developer to create a script capable of automating multiple task types. The script won't require interaction with external systems or APIs. The successful freelancer should possess: - Proficiency in Javascript is a must - Experience in scripting for automation of tasks such as: * Data extraction * File conversion * Automated data entry Although I didn't specifically outline the tasks, ideally the script should have the flexibility and functionality to handle the tasks mentioned above. Further clarification and details will be given once we're in dialogue. Freelancers to bid are required to have prior experience and demonstrate competency in task automation scripts. Please provide examples of similar w...

I need a proficient PHP coder who can write a script for me that will print images (in JPEG format) and QR codes on a thermal printer. The images are our company logo and the QR codes are meant for conducting reviews. This PHP script will be used online on a cloud platform. Ideal skills for this job are: • Strong expertise in PHP • Familiarity with JPEG images and QR codes • Experience in creating scripts for printing needs, specifically on thermal printers • Understanding of cloud platform workings. Your primary task will be the creation of a script that can accurately print images and QR codes on our thermal printer, effectively facilitating bill printing for our operations. Deliver a clean, efficient code that can be effortlessly integrated a...

Need to recount the stock quantity based on approve order (Write script to run it) Able to work with ftp. Laravel work. Start immediately.

I need an experienced Node.js developer to create an automation script for my server deployment. - Automation Task: The script should automate routine server deployments, keeping my operations efficient and consistent. - Server Deployment Activities: The core function of the automation is to handle financial transactions, particularly trading activities. Proficiency in financial systems and trading platforms is necessary. - Financial Transactions: The successful candidate should also have experience with the handling of financial transactions within Node.js applications. The ideal candidate should have brilliant knowledge with Node.js, experience in automating server deployments, and a strong understanding of financial trading systems. Looking to kickstart this ASAP.

I need someone with specialized skills in password recovery to restore a forgotten password for an Microsoft Excel worksheet. This task requires a professional password hacker. I require one spreadsheet opened and password recovered and removed. Skills and Experience required: • Proficiency in programming languages, particularly those relevant to password recovery. • Expertise in methods of password recovery for Microsoft Excel worksheet xlsx files. • Strong ethics - the information on this spreadsheet must stay confidential. • Can deliver results within 7 days. • Will pay on successful confirmed completion only.

Hi, I am looking for a developer strong in HTML and Java script. I need interactive HTML pages with sound and navigations.

I require a proficient freelancer to design a distinctive Excel file that will be used for web form completion. Once the Excel file is uploaded, the system should automatically read and fill the corresponding fields. These may be a composition of dropdowns, text or checkboxes with comprehensive validation, such as numbers-only constraints, email format requirements, date format validation, dropdown list checks, value ranges among others. Ideal Skills: -Qualified in Excel -Understanding of data validation Experience: -Web development -Scripting in Excel -Web form design -Experience designing similar projects Please note that while the specific dropdown fields were not detailed, anticipate flexibility and adaptability in the code to conform to possible changes...

...an intuitive application. This app is intended to utilize LangChain and OpenAI's language model in categorizing PDF files into different groups; namely invoices, HR-contracts, or MOUs and then under go different ways for each document catagory: A. in case of invoice: - extract the data inside invoice (invoice number, date, buyer name, total amount sold, and total due amount) and save them in an Excel file. B. In case of HR-contract: - simply move the file from the existing location to the HR-contract folder. C. In case of MOU: - simply move the MOU from the existing location to the MOU folder. Details: - Your responsibility is to build a desktop application that processes and accurately categorizes data from complete PDF files. - You are required to utilize LangChain for...

I require a proficient Excel expert with strong skills in data analysis and organization. The primary tasks you will handle include: - Analyzing business-related data - Organizing the analyzed data in an easy-to-understand format The purpose of these tasks is to help streamline business reporting processes. You must be adept at dissecting large volumes of data and summarizing key points to help inform business decisions. The final deliverable should be a standard Excel file that details the organized and analysed data. Relevant skills needed include data analysis, Excel proficiency, and a keen understanding of business data interpretation.

...We are seeking an experienced image processing specialist to develop a robust solution that can transform images of rugs on a transparent background into perfect rectangles. The rugs have wavy, squiggly edges, and some include fringes, adding complexity to the task. The goal is to standardize these images for better presentation and further processing. Responsibilities: Develop an algorithm or script using Python and OpenCV (or similar libraries) that can accurately detect the edges of rugs in images where the rugs are on a transparent background. Transform these images so that the rugs are reshaped into perfect rectangles, despite the presence of natural waves, curves, and optional fringes. Ensure that the transformation maintains the integrity and quality of the rug design, e...

I recently purchased the Lavarel Hyip Pro Script on Codecanyon. I'm looking for a skilled developer who has experience with this specific script to help me with some customizations. Your main tasks will include: - Adding specific conditions to the Investment Plans section, including the creation of different conditions like F1, F2, etc. - Implementing a ranking system on the platform. - Associating a rate exchange bonus to point and saving it to the database. The ideal freelancer will: - Have prior experience with Lavarel Hyip Pro Script. - Possess a strong understanding of scripting languages as well as database management. - Be able to deliver results quickly, as I'm looking for this project to be completed as soon as possible. Looking forward to rece...

I'm seeking a computer science tutor to guide me through QuickBooks and Excel. - Topics include QuickBooks, Excel, data structures, algorithms and programming languages. - Primarily need help with data entry and organization in QuickBooks and Excel. - Additionally, assistance with Formulas and Functions in Excel is required. Ideal candidate should have: - Proficiency in QuickBooks, Excel and knowledge of data structures and algorithms. - Strong background in programming languages. - Experience in tutoring or teaching will be a plus. Please note that the volume of entries or rows of data is minimal, less than 100. Looking forward to your proposals!

I'm in need of a skilled and creative screenplay writer with experience in drama. Your primary task will be to author a compelling script for a movie that falls within the drama genre. Key Project Details: - Genre & Setting: The movie is a drama set in a modern city. The primary setting and genre of the movie will require you to craft a narrative that is both engaging and realistic. - Target Audience: The script is intended for a family audience. This means that the content should be appropriate for viewers of all ages. Skills and Experience: - Proven experience in writing compelling drama storylines. - Understanding of family-friendly content. - Ability to craft realistic and engaging modern city settings. - Proficiency in creating scripts that resonate with a wid...

Are you looking to master SQL, Excel, or Python? Look no further! With years of experience in data analysis and programming, I offer comprehensive tutoring services tailored to your learning needs. **What I Offer:** 1. **SQL Mastery:** From basic queries to advanced database management, I'll guide you through understanding SQL syntax, optimizing queries, and database design. 2. **Excel Expertise:** Whether you're a beginner or looking to enhance your Excel skills, I'll cover everything from formulas and functions to data visualization and automation. 3. **Python Proficiency:** Dive into the world of Python programming with personalized lessons covering fundamental concepts, data manipulation, scripting, and more. **Why Choose Me?** - **Tailored App...

Here's some information on how the API calls on how the "idToken" is received. Step 1 ...POST API call to "" which uses the "APPSESSID" cookie mentioned above. 2. The response of this API call should return "idToken" as one of the field Here are the Acceptance Criteria's (AC) that need to be met for this project to be considered successful: AC1: Script should be written in python AC2: Script should automate the steps mentioned above to reach the outcome of returning "idToken" value AC3: Script should be able to consistently do this on an hourly basis without failing. AC4: clean coding and good documentation of the code Your bid is seen as the final offer for the delivery. There will be no additional negoti...

I'm looking for a capable designer who can create a modern style title card for a jukebox. Key Requirements: - The design must be modern in style - The final deliverable should be in a word or excel format to allow for editing Content: - The title card should include the song title and artist in the right portion - A photo element should also be incorporated for visual appeal in the left portion. I'd like a card similar to the one you see here. It's exactly 18cm wide x 12cm high. However, the photo portion should be smaller, as the text does not contain the Artist, which I need. I have attached some examples here. Photos # 4 5 and 6 are from my actual machine. I need to edit and make 100 of these. There should be 22 columns on the right side for the Numbe...

can you help me with just need to customise "batch number" as "not required" field in products and purchase and sale sections, you can see that

...not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft SQL Server Management Studio, and my system operates on Windows. You would be working an 8hr paid day i...

...unfolds in the 20th century and encapsulates the essence of Australia's history and society. Key requirements for the script include: - Capturing the true essence of the historical events without fictionalizing them - Developing real-life characters that are relatable and intriguing - Conveying the cultural aspects of Australia during the 20th century - Weaving together a compelling narrative that does justice to the tragic nature of the story The ideal candidate for this job should have: - Experience in writing scripts for films or TV shows, especially in the drama genre - A keen interest in history and the ability to research and incorporate historical events into the script - The capacity to create deep, diverse and believable characters - A good understanding of...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

I acquired a PHP script from Codecanyon and seek a skilled developer to enhance its capabilities. The primary tasks involve implementing robust data validation mechanisms and integrating a specific condition for the calculator functionality. Project Requirements: Data Validation: Strengthen the script's data validation process to ensure accuracy and security in handling user inputs. Calculator Functionality Enhancement: Customize the existing calculator feature to include a specific condition, optimizing its performance and usability.

I am in need of an excellently crafted web form that can carry out addition calculations. The main purpose of this form is to accurately calculate the cost of chosen servi...system should be able to add up the costs of selected services. - Data entry: Your form would need to support product selection-based data entries. - User interface: the form should be easy to navigate, with clear instructions for inputting service choices. Ideal Candidate: - Proven experience in designing excel forms with integrated calculation logic. - Ability to design a user friendly interface. - Eye for detail, as the calculator must produce very accurate results. - Strong knowledge of Excel features and data calculation techniques. - Excellent communication skills to understand requirements and del...

I need a Google App script that can scan a specific folder on my Google Drive for files and process them. The processing should involve an api that will skip tracing by first name and last name, if that returns no results then by company name, or if that returns no results then by property address to find the email. Once the email is located append it to the row in column AW. Once completed, prefix “processed_” to the file name. Api to use: skip force Key Requirements: - The script should be able to scan a specified Google Drive folder for files. - When a file is found, the script should process it by skip tracing. This involves cross-referencing the information in the file with first names and last names, company names or property addresses. - The ...

I urgently require a model, of any gender and any age, to read a script on camera for an upcoming project. Key Information: - No specific physical appearance characteristics are preferred, the selection would be based entirely on capability and suitability for the role. - Though not mandatory, prior experience in script-reading or acting would be advantageous. - Presence in front of the camera, clarity of speech, and ability to deliver the script convincingly are vital skills needed. 20 video with same model This project offers a great opportunity for those seeking to add more visibility and experience to their portfolio. I look forward to your proposals and collaboration.

I'm seeking a proficient Excel expert who can assist me with enhancing my current study time tracker. I need the following features to be incorporated: - Auto-calculation of total study hours: I'd like for this to be automatically summed up based on the inputs provided. - Auto-calculation of average study hours per day: This should also be done automatically, providing me with a clear view of my daily commitment. - Study hours per subject: I require a part of the spreadsheet to allocate study hours to specific topics that I am learning. The spreadsheet will be utilized for tracking my study progress across different subjects. It should allow for easy input of study hours and materials covered. I will provide the current version of the spreadsheet to the chosen freelan...

I am in need of an experienced Laravel expert who can upgrade a food delivery PHP script, consisting of Laravel + React PWA Apps, from Laravel 5.8 to 6.20.44. This is a Codecanyon PHP Script that I have already purchased. - No feature changes are needed within the upgrade process. - Skills needed include Laravel, PHP, React and PWA Apps knowledge. - Hands-on experience in upgrading Laravel projects would be an added advantage. It is essential that you understand the intricacies of both versions to ensure the upgrade is seamless, with no bugs or errors. Prior experience with food delivery scripts will be highly regarded.

I have an Excel spreadsheet containing a list of data, from which I need specific email addresses extracted and organized. Key requirements: - Extract email addresses: You'll need to go through the spreadsheet and locate email addresses contained within the data. - Excel Organization: The extracted email addresses should be neatly and accurately organized in the Excel spreadsheet. Each email should be placed in a separate cell. Ideal Skills: - Proficient in Excel: Ability to efficiently navigate and manipulate data in Excel. - Data mining and extraction: Skilled in identifying and extracting specific data from larger datasets. - Attention to detail: Accurate organization of email addresses is crucial. - Time management: Ability to work efficiently ...

I have a requirement to develop a bespoke Microsoft Excel spreadsheet to calculate sales commissions. Let me share the specifics: - The variables: I want this spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined according to a custom formula that considers the Commission Percentage. - Data input: The spreadsheet should be easy to use, allowing me to manually input the data for calculation. The ideal freelancer for this project would be someone well-acquainted with the mechanics of Microsoft Excel and its formulas. Relevant experience in the field of sales calculations would be an asset. I am trusting that this tool will enhance efficient dete...

I am seeking an experienced freelancer actor who can collect and compile professional, scripted video testimonials. The success of this task will be dependent on your ability to effect...authentic and engaging. - Managing video editing to assure high quality final product. The ideal freelancer for this project should have: - Proven experience in video production and editing. - Exceptional communication skills for relationship management with clients. - Proficient in directing scripted testimonials. - A keen eye for detail, ensuring each testimonial aligns with the brand and the script provided. This provides a fantastic opportunity to showcase your abilities in content creation and client facilitation, and I encourage all those who are passionate about video testimonial producti...

I'm looking for a skilled video editor to help me create a top 10 video for YouTube. The script is already written. Key Points: - The video should be edited in a Montage style to keep it engaging and dynamic. - The tone of the video should be Informative, as it's aimed at an adult audience. - We are targeting adults, so I need the video to be polished and professional. Ideal Skills and Experience: - Proven experience in video editing, particularly in a Montage style. - Ability to convey information effectively and engagingly. - Understanding of YouTube trends and audience preferences. If you have a good eye for design and can also create a strong thumbnail to accompany the video, that would be a great advantage. Please include samples of your previous work in your bid.

Hi, I'm looking for someone who can write script to automate daily data importing from csv files into a google sheet. We use a new google sheet each week to calculate production for each day, see example here: We have two online platforms that we receive orders through, one for wholesale customers and another for retail customers. For wholesale we use Ordermentum - www.ordermentum.com. To access the production reports we have to: 1. Open the "orders" page 2. Select the relevant delivery date 3. Export the production report for that date This data needs to populate into the relevant date column of the "ORDERMENTUM" tab in the google sheet. See sample production report attached (produc

I'm seeking a skilled professional who can thoroughly make me understand and possibly modify if necessary, a Playwright automation script written in JavaScript. The prime responsibility of this script is conducting regression testing on a website. Key Tasks: - Understand the existing Playwright automation code. - Ability to modify the script for effective regression testing if required. Ideal Skills: - Profound knowledge in JavaScript. - Prior experience in working with Playwright automation. - Comprehensive understanding of functional testing for website. Your command over understanding and preferably modifying JavaScript based automation code will be essential for this task. Having previous experience in website functional testing is a strong advantage.

I have a substantial Excel spreadsheet that requires competent attention. I'm on the lookout for someone who's proficient in: - Data entry - Data cleaning Your role will primarily involve entering various types of data that's currently on an Excel spreadsheet. Despite the data being available, it's in a raw unclean format that needs some cleaning. The ideal freelancer is someone who's used to working with Excel and recognizing inconsistencies, errors, and redundancies. Additionally, anyone versed in: - Proficient in Excel usage - Strong attention to detail - Experience in data cleaning - Strong data entry skills would be extremely helpful in achieving the goals of this project.

I'm in need of a confident and capable actor, proficient in Standard Greek for a video showcasing talent. The style will consist of a speaking video with a script. Skills and Experiences: - Strong acting abilities in dramatic context - Proficiency in Standard Greek - Experience with script following and dedication to the role - Ability to professionally showcase talent I'm eager to collaborate and create a high-quality video that represents the passionate talent. Excited to work with someone ready to bring their best performance.

I need a proficient Excel specialist to develop a spreadsheet that will calculate gross pay based on clock in and clock out times. Some work-shifts will start on one calendar day and not clock out until the next calendar day (example- clock in May 1 at 3:30pm - clock out May 2 at 12:30am). It should also factor in specific overtime rules for the workplace, including: - Weekly overtime after 40 hours. -All hours on any given workday shall be paid at the straight time rate of pay unless forty (40) hours have already been worked at straight time. No matter the length of route: example- a driver's bid/scheduled route may be 10.8 hours, as long as the employee does not work any additional hours other than those bid/scheduled, they will be compensated at straight time rate of pay unl...

I need a Python developer who can create a script to scrape news in JSON format from moneycontrol at a specified interval and store it in a database. Key Requirements: - Develop a Python script to scrape news in JSON from moneycontrol - Automate the scraping process at a specified frequency - Ensure the scraped news is stored in a database Ideal Skills and Experience: - Proficiency in Python - Experience with web scraping using BeautifulSoup or Scrapy - Knowledge of working with JSON data - Familiarity with databases and data storage - Previous experience in similar projects would be a plus Please note: The project does not have specific requirements for news categories or keywords at the moment. The focus is on extracting news in JSON format and storing it in a database.

I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues related to duplication and missing entries in da...