Macro script insert cells excel jobs

I'm intending to create an Excel roster to effectively manage the allocation of shifts, roles and skills within my organization. Key details I aim to competently track include: Example-if i select a product we are making that day it automatically populates how many people required for that product and when box is clicked it shows the names of people available that day. The names we can enter and remove has needed if employees leave or new employees arrive. - Employee Names: I want to record the names of each staff member in my organization. - Shift Management: I want to assure every shift for specific products has appropriate manning. Ideal Candidate: A freelancer who has experience with HR data management and Excel roster creation would be ideal for this task. They...

• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book of Transfer_[Date of extraction from the portal]". • Automate the process of c...

For my expanding fashion business, I'm on the hunt for inspired and skilled fashion designers -- those who excel in creating both underwear, swimwear, and sleepwear for Womens. But, the real cherry on top would be a knack for lingrie designs. Key Requirements: - Ability to create unique, innovative designs that target different audiences - Proficiency in both trendy and classic styles. We value versatility! - Expertise in working within a monochrome and neutral color scheme Desired Skills: - Expert knowledge of fashion trends in underwear, swimwear and sleepwear - Exceptional creativity and innovation - Strong sketching skills with attention to detail With your help, we can revolutionize the market by producing designs that encapsulate both the traditional classics and...

I'm seeking a competent developer experienced in Python programming and automation processes. Although I primarily need the script for automation tasks, the specific role areas it needs to navigate are currently undefined, hence the developer needs to showcase flexibility. Key Requirements: - Profound Python script programming knowledge. - Experience with diverse automation processes. - Capability to complete tasks urgently. This is an ASAP task, and I need a committed and quick worker who can deliver efficiently. If you possess these skills and can engage immediately, do not hesitate to apply.

I'm seeking a meticulous data entry operator capable of transferring data from digital documents to an Excel sheet. This task involves: - Taking solely textual data from digital documents. - Conducting minor internet research and using ChatGPT when necessary to fully understand the instructions. - Accurately entering the required information on the provided Excel sheet. The ideal candidate for this job is one who is proficient in the use of Excel spreadsheets and has excellent attention to detail. Previous work experience in a similar data entry role is advantageous. This work is specifically in the context of creating content for product listings in e-commerce sites. So if you have specific experience in this area, that would be an additional bonus.

I require a freelancer proficient in excel to assist with data cleaning and sorting tasks for a range of diverse digital files. Your expertise in managing and optimising Excel spreadsheets will be invaluable and greatly appreciated. Key tasks will include: - Using Excel functions to clean datasets, removing discrepancies and inaccuracies - Sorting data into relevant fields and categories for easier access and analysis The optimal freelancer will have: - A meticulous eye for detail to ensure data accuracy - An understanding of Excel formulae and functions - Proven data cleaning and sorting experience - The ability to meet tight deadlines without compromising quality. Your primary role will be to untangle and streamline my Excel spreadsheets, making t...

I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail will be crucial for successful output.

I am in need of an expert in bash scripting with a solid understanding of Google Drive integrations. My current bash script, which is supposed to download "zip" and "tar gz" files from Google Drive, isn't functioning as it should. Here’s a rundown of my issues: - The script is not downloading any files whatsoever. - When a download attempt is made, there are subsequent error messages indicating failure. I require a professional who can: - Evaluate these error messages - Resolve these issues in a time-efficient manner It's critical that all downloads only consist of "zip" and "tar gz" file types from Google Drive. I expect clear communication and updates throughout the progress of this job. The ideal freelancer...

As discussed I have completed the template for Home Team Workbook.

I'm seeking a home-based freelancer proficient in Microsoft Word, Excel, PowerPoint, Outlook, and Tally ERP 9 for a variety of tasks. Key Responsibilities: - Data Entry: Accurate, timely, and efficient data entry support is a core requirement. - Document Formatting: Assistance with formatting a range of documents, ensuring a professional and consistent appearance. Ideal Skills & Experience: - Proficiency in Microsoft Office Suite: You should have a strong command of Word, Excel, PowerPoint, and Outlook. - Data Entry: A proven track record in data entry, with a focus on maintaining a high level of accuracy and meeting deadlines. - Tally ERP 9: Experience in using Tally ERP 9 is preferred, but training can also be provided. - Organizational Skills: Ability to manag...

I'm seeking a skilled professional to create a web application which automates the extraction of simple tables from word documents and the transfer of this data into a macro-enabled Excel sheet. Key Requirements: - Extraction of simple tables from Word documents - Transferring the extracted table data directly to a macro-enabled Excel sheet - Ensuring the data transfer is accurate and error-free Ideal Skills & Experience: - Proficiency in Web App Development - Strong experience in data extraction and manipulation - Proficiency in working with Word and Excel documents - Familiarity with macro-enabled Excel sheets - Attention to detail to ensure data accuracy and error-free transfer The final product should be a user-friendly, eff...

We have our own ERP...in both scanned image and digital (text-based) formats. - The extracted data from these invoices must be: - Directly integrated into Sales and Purchase Invoice Module for further processing - Exported to Excel/CSV files - Directly integrated into accounting software Ideal Skills and Experience: - Proficiency in OCR technology - Strong background in invoice processing and automation - Experience with integrating software systems, particularly accounting and invoicing modules - Ability to work with both scanned image and digital PDFs - Proficient in data export to Excel/CSV files If you have a track record of successfully implementing OCR-based automation solutions and you're confident in your ability to handle these tasks, I would ...

I'm looking for a writer who can help me with scriptwriting for a 12 episodes anime. I want them to recap that whole anime. Key Requirements: - Past Work: Please share your past work in scriptwriting, particularly if you have experience with entertainment or anime-related content.

... and we're seeking a talented designer to bring our brand to life through a distinctive logo. Design Requirements: The logo should consist of a unique icon accompanied by our agency name or initials. We envision the icon as a visual representation of our agency's focus on creativity, innovation, and strategic branding solutions. The color scheme should incorporate our specific brand colors: [insert specific colors here]. The design should be versatile enough to use across various platforms and mediums, including digital and print. We prefer a clean, modern design that stands out and leaves a lasting impression. Incorporating elements related to branding, such as typography, colors, and visual symbols, would be highly appreciated. We're open to creative interpreta...

I need a system that can take data from the existing Excel files and convert them into customized PDF reports. Key Points: - The primary data source is existing Excel files. This means you need to have the ability to efficiently extract and interpret data from these files. - The PDF reports need to be customized with personalized data fields. So, you should be able to dynamically merge data from Excel into the PDF reports. - Proficiency in PDF generation tools and Excel data manipulation is essential. Your responsibilities will include: - Developing a system that can accurately generate customized PDF reports using data from Excel files. - Ensuring that the system is user-friendly and can be easily adopted by non-technical team members. - Working with...

I want to build anything which enables me to send customized whatsapp message as well as images from excel sheets

I want to get a extension which can send messages and images from whatsapp web using numbers and other data from excel sheet

I would like a script, where i take entries from my customers based on their choices and preference and their budget and then i allocate a salesman to the customer, I would like to automate the process by writing a script in google sheet which will check for various variables from past 1 month and then allocate the sales which did best for that customer requirement.

Here is a list of 35000 phone numbers. I need the american country code, +1, added to each entry. There is a way on excel to do this pretty quickly, I just dont know if, hoping you do.

I have an Excel data set that encompasses 5-10 sheets. I need support in: - Data entry: Entering new information into the existing sheets. - Data cleaning: Checking and correcting any errors in the data, removing redundancies. - Data analysis: Conducting basic analysis of data. Ideal applicants should have beginner proficiency in these tasks. Your experience working with Excel data files, especially handling entry, cleaning, and analysis tasks, will greatly benefit this project.

I'm looking for an intermediate Excel expert to create a user-friendly database system for managing contacts and tracking outgoing information. Key Requirements: - Develop a simple yet effective database system within Excel. - Design a user interface that is intuitive and user-friendly. - Ensure the system is structured to manage contacts efficiently. - Implement a feature to track when and what information is sent to each contact. What I'm looking for: - A freelancer with a proven experience in working with Excel and developing databases. - An intermediate level of proficiency in Excel. Advanced skills are not necessary, but a basic understanding won't suffice. - Ideally, I'd like the freelancer to have experience in designing user interfa...

...Password Protect the site * pre configure services * pre cofnigure suggested price, can change price if needed * e-mail clients & myself (pre configured) * Save estimate & Invoice as PDF * Process payment using stripe using API * SQL Database to store client info for repeat customers * Search client up by name, phone, address, or e-mail * Ability to move database & php script to other domain if needed * Ability to Backup Script & DB with a click Desired Programming Language: PHP * I'm looking for the best deal possible, please be very competitive. * Milestone release upon completion of the project & is bug-free. * Need Source Code when Job is Complete, After any Bug fixes, and Updates ⭐⭐⭐⭐⭐ Please post "I've read everything" when ...

I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.

I'm in need of a professional proficient in Excel and data entry to support two key tasks: data analysis and spreadsheet management. Here are the tasks in detail: - Data Analysis & Visualization: I've collected customer feedback data which need to be efficiently analysed and visualized. - Spreadsheet Creation & Management: The data mentioned above should be incorporated into comprehensible spreadsheets. In terms of analysis, the focus should be on customer segmentation. Ideal candidates should have: - Advanced proficiency in Excel for data analysis and visualization - Strong understanding of data cleaning and formatting to ensure accurate analysis - Experience with customer segmentation based on feedback data.

I'm looking for an experienced developer with in-depth knowledge of creating and tweaking cookies. Key Tasks and Requirements: - Design and write a single-page script. - The script must efficiently add and modify cookie values. - Ensure compatibility across multiple web browsers, including Google Chrome, Mozilla Firefox, Safari, Opera, and Edge. Skills and Experience Needed: - Proficiency in writing and optimizing scripts. - Solid understanding of cookies and how they work across various browsers. - Ability to work without the need for specific instructions or criteria for adding or modifying cookie values. This project does not require the creation of any specific criteria for cookie alterations. However, a keen eye for detail and robust testing across different...

I'm looking for an experienced data analyst who possesses expert skills in Excel and/or Google Sheets and a proficient understanding of Football, Basketball, and Baseball data. Ideally, someone who is skillful with analyzing and interpreting commercial level sports data into the form a betting model that understands, quantifies, and predicts based on specific metrics. The key characteristics of the models are: - Focus on the following sports: Football, Basketball, Baseball - Analyze the following data: Team performance, Player statistics and Game score projections to forecast point spread, totals, and moneyline bets. I have historical data ready to be applied to these models. This is a project where being communicative, organized, and knowledgeable in sports data ana...

as per communication, transfer data from DPF to excel.

I'm in need of an expert in SQL and VBA who can assist with a one-time project. The job will entail: - Writing complex SQL queries - Automating tasks in Excel using VBA - Conducting data analysis and generating reports This will be performed on Microsoft SQL Server. As such, considerable experience with this DBMS is a requisite. Primary skills and experience for the role include: - Expert level proficiency in SQL and VBA - Extensive experience with Microsoft SQL Server - Familiarity with automating Excel tasks and data analysis - Previous experience in report generation This is a one-off project with the possibility of future collaborations for similar tasks. If you have the necessary skills and experience, I'd like to hear from you.

...from Excel sheet to What's app Number (At certain condition and without opening the internet browser). Ideal Candidate: - Strong experience in integrating Excel with external systems. - Proficiency in WhatsApp and Excel automation. - Ability to create a reliable and efficient sync process. - Understanding of data processing security and privacy. So, If you're able to send notifications into my what's app number from excel sheet, Then; You're welcome and this contest is for you. Details: I'm engineer, Working for an industrial company and really want to handle the spare parts with the inventory and purchasing managements for assuring that all spare parts available with certain quantities all the time. Requirements: **Data Synchroni...

I am looking for an experienced Pine Script developer to create a script for the TradingView platform. This project involves indicators, alerts, and backtesting functionalities tailored specifically for cryptocurrency trading. Key Responsibilities: - Develop a Pine Script compatible with TradingView. - Incorporate indicators, alerts, and backtesting functionalities. Required Skills: - Proven experience in Pine Script development. - Expertise in TradingView platform. - Strong knowledge and experience in cryptocurrency trading tools. An understanding of different indicators, alerts, and backtesting strategies in the context of cryptocurrency trading will be vital for this project. A successful delivery of this project opens the door to potential future collab...

I'm looking for a skilled freelancer who can create an automated Excel spreadsheet calculation for me. I need this spreadsheet to perform calculations based on cumulative data, specifically organized by date. You will need to be adept at Excel and have experience in creating automated spreadsheets. Knowledge of data organization and basic statistics would be a plus. I'm looking for a quick turnaround on this project. Please watch my videos for more details on what exactly is required.

I'm in need of a script that emulates the functionality of established affiliate network programs such as tradetracker, awin, or commission junction. Not looking for person to create from scratch. You should already have or know a script that fulfills these requirements. If you do not have or have not created such a script, then your ability to find one is what I am looking for not software developer Questions or comments are welcome. Please do not contact me to discuss on how to design the script from scratch.

I'm in need of a script that emulates the functionality of established affiliate network programs such as tradetracker, awin, or commission junction. Not looking for person to create from scratch. You should already have or know a script that fulfills these requirements. Questions or comments are welcome. Please do not contact me to discuss on how to design the script from scratch.

...understand what the data says about our operations and ultimately enable us to make strategic project decisions. Details - The task involves analyzing complex financial data associated with our road construction projects. - We need to focus on key financial metrics, including project costs, ROI, profit margins and forecasting future financial scenarios. Skills and Experience - Proficiency in Excel at an advanced level - Background in finance, ideally with a focus in project finance. - Experience in construction sector would be an advantage. - Ability to analyze and interpret complex financial data and present in an understandable format. - Knowledge of financial forecasting and prediction methodologies. This project would demand a keen eye for detail, analytical acumen, and ...

I'm looking for an Excel expert to automate various tasks relating to our tracking system and create an intuitive dashboard. The tasks will involve automation of formula calculations and report generation, to streamline our data processing workflow, and reduce human error. Key tasks include: - Automate formula calculations: Efficiently automate intricate excel formula calculations. - Automatic report generation: Create a mechanism for generating immediate, error-free reports that highlight key aspects. - Dashboard creation: Design a user-friendly dashboard displaying information based on Automatic report Generation. The ideal freelancer for this job should have: - A deep understanding of Excel's advanced features; - Previous experience with automations and ...

Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 2 Hours not more then this, i had the excel to work on just make this on new sheet

I'm seeking a seasoned Hindi script writer with a flair for engaging, conversational narratives within the personal development niche. Your role will include: - Scriptwriting for a YouTube channel dedicated to self-improvement. - Pioneering the creation of original content, employing a conversational tone. - Building scripts that align with a format centered on detailed narration. Ideal skills for the job: - Demonstrated excellence in Hindi scriptwriting. - Great understanding of personal development topics. - Prior experience in creating conversational yet effective content. - Strong narrative skills. I welcome anyone aligning with the mentioned skills and ready to bring original content to life, inspiring personal improvement for our viewers.

My .csv file needs some serious help. Here’s the deal: - Columns aren't properly aligned - I’m finding incorrect entries in certain columns - There's frustratingly missing data in some cells This mess stands between me and importing the data successfully into my database. If you can efficienty wield the tools of data cleaning and if you excel at attention to detail, this could be the job for you. Skills and Experience: - Proficient in csv files management - Highly skilled in data editing, cleansing and validation Please note, I haven’t determined which software I'll use to import the .csv file. Your input on this area will be valuable! I'm open to MySQL, Oracle or MS SQL Server. Let's make things right!

...well-versed in the sidereal time system to create an Excel sheet that provides the planetary positions in Vedic Astrology of Sun, Moon, Mercury, Venus, Mars, Jupiter, Saturn, Rahu, and Ketu. The final deliverable should have the planetary positions presented in degrees, minutes, and seconds format and zodiac placement of planet and if the planet is retrograde or not. Successful applicants should provide examples of their past work in Vedic astrology, especially on planetary positioning. A detailed project proposal would also be well appreciated. Ideal skills and experience for the job include: - Programming skills of C, C++, Python or Java and a bit of Vedic astrology knowledge, particularly on planetary positions - Proficiency in Excel - Experience in presenting comp...

I have printed documents that need to be typed into an Excel sheet. The final spreadsheet must also be formatted according to specific requirements. Ideal Skills and Experience: - Proficiency in data entry with high accuracy - Strong understanding of Excel, including: - Use of formulas - Conditional formatting - Data sorting and filtering - Attention to detail to ensure accurate data entry and formatting

Hi there. I'm pretty good with Paypal API and PHP, but I don't have time and need a quick script in PHP + MySQL that allows Customers to subscribe (via Paypal) and somehow stores the transaction into a MySQL table - and somehow allows the Customer to Cancel their Subscription. If you could store a cancel link with each transaction in whatever table stores the successful transactions then that would be great. I basically will quickly integrate whatever MySQL table(s) you use into my core php project and then maybe pass my own User's IDs or Emails into your subscription script so I can track which user subscribed. Then that would allow me to display a Cancel button or link in each of their Edit Account pages. (ie. if I store/bind the Paypal Transaction with the...

Develop financial modelling in excel spreadsheets based on information supplied. This may lead to a long-term ongoing assignment(s) depending on your skill level and capabilities

I'm in need of a Chrome Extension developer who has experience working with Shadow Root. Key Project Details: - The extension will need to leverage Shadow Root for various purposes; specifically, for style, DOM, and event encapsulation. - The desired functionality includes accessing and...capture and handle events within the shadow root. Ideal Skills and Experience: - Strong experience in developing Chrome Extensions. - Proficient in working with Shadow DOM and specifically with Shadow Root. - Expertise in style, DOM, and event encapsulation using Shadow Root. - Ability to access, modify, and interact with elements and events within the shadow root. - Prior experience in content script injection, DOM manipulation, and user interface modification within Chrome Extensions can b...

I'm looking for a seasoned Python developer with specific experience in video analysis to create a script that can process a full mp4 video and identify the positions of a Color Checker card ( ). The idea is to scan each frame of the video, locate the Color Checker, and log its position. The final detection shall share the first frame, the intermediate frames and the last frame of ONE color checker card. Key Requirements: - The script should be able to read a video in mp4, mkv, mov format. - The library used for reading the video is not fixed. You can choose from libraries like (e.g. OpenCV, PyAV, or MoviePy, but the solution should be compatible with both Windows and Linux (and mac) - take a look here:

...changes at the property state associated with Rate Plans or Room Types mapped to wprentals, we will generate a changes message and send it to changes endpoint to wprentals via POST request.- a script to handle bookings from wprentals to Channex -Handle new Booking and pass to channex via wooocomerce complete order post booking to channex (works with woocommerce webhook, endpoint) whenever there is an order from woocomerce with status complete .. it will triggle the endpoint and post a new booking to chnanex. to request Full Sync from Channex to your side - create script that hande full sync PS: - API document are provided in channex website - code prefer PHP can be stand alone or wordpress plugin (will discuss what is the best option) notes: - for mapping we need ...

I currently have a working script using the 0x protocol. I frequently get out of gas error messages. I could have 50$ or 3$of ETH in my wallet when this happens so it is not a lack of funds. I believe this is an issue with the script not allocating enough gas. Here is an example of 2 of the TX that failed on Tenderly I need the following: 1. I need someone to fix the OUT of GAS ISSUE AND use the highest amount of GWEI so the TX is processed as fast as possible. 2. ON one of the last lines, the amount of GAS is output. I would like to out ut the TX fee in ETH if possible

I'm looking for an Excel expert to handle a set of 10 company accounts from 2014 to 2024. Key Responsibilities: - Data Entry and Organization: The successful freelancer will be responsible for ensuring that all company account data is correctly input into Excel. - Financial Analysis and Forecasting: I need someone with the ability to perform in-depth financial analysis and create accurate forecasts based on the data provided. - Data Visualization and Reporting: You should be able to create professional and easy-to-understand visualizations, graphs, and reports. - Audit and Dashboard: The final deliverables should include an audit of the accounts and a dashboard that provides a clear overview of the financial health of each company. The accounts are currently in digita...

I have a Python script that could use an upgrade with the 2Captcha API for solving FunCaptcha. I'm looking for a skilled Python developer who can enhance my existing script by integrating the 2Captcha API. The main task for the solver will be to successfully crack FunCaptcha. Key requirements: - Proficient in Python programming language - Experience working with API integration, particularly with 2Captcha - Ability to handle FunCaptcha You will be provided with all necessary API credentials and documentation for FunCaptcha solver. The ideal candidate should be able to work efficiently and be able to ensure that the solver works effectively as part of the script.

Zapier Email parser to read emails from a specific account. - Zap will read the email and parse its content. (complexity depends on the data) Zap Web hook - Calls the php file and sends parsed email content in the selected format (JSON) PHP Script to read the hook - Read the JSON and make the calculation. PHP Script to calculate and create report - Create a report – html format Zap email back report to the customer - Send email with the html report to the customer

I'm in need of an experienced developer or programmer who can create a modified bar graph for me. The project will require: - The modified bar graph should have basic text labels on the vertical axis. - The design should be clean and professional, ensuring a good user experience. Ideal applicants should have: - Proven experience in creating bar graphs. - Excellent knowledge of the technology needed to implement such a graph. - Strong attention to detail to ensure the labels are correctly aligned and clearly legible.