Excel vba lock sheet user scriptроботи

I need python expert for optmization my code Start your bid with OPT to be considered

DONT USE AI TO WRITE COVER LETTER. I WILL NOT HIRE BOTS. Write briefly if you can work under budget and can start immediately. Enter Excel file with recent projects I have completed, well organized, and categorised for future use and portfolio reference. My profile: https://www.freelancer.in/u/Ansaf1

We are developing Trademark management software. For that we needed data of all trademark applications filed on Indian trademark website of government of India. But due to lack of time, we bought data of 67.50 trademark applications filed and updated that in our software. Now, we want you to develop scrapper: i. that can update data and documents of existing 6.75 million trademark stored on aws server, and ii. that can scrap all data and document of newly filed trademark application, which are not in our database. Watch for understanding. --------------------------------------------------------------------------------------------------------------------------- For your knowledge: 1. Our SaaS is hosted on EC2 server of AWS 2. Data is hosted on RDS server of AWS, 3. Documents are stored ...

I'm loo...skilled developer to create a comprehensive Roblox executor for me. It should be fully equipped with the following features: - Script execution: Ability to execute custom scripts seamlessly. - User interface customization: Highly customizable UI to meet diverse user preferences. - Anti-ban features: Robust measures to prevent account bans. This executor should be exclusively compatible with Windows. It must cater to super advanced users, so intricate and sophisticated functionalities are a must. Ideal candidates for this project should have extensive experience in game development, particularly with Roblox, and possess a deep understanding of creating high-level user interfaces and anti-ban systems. Prior work on creating executors or similar to...

...scanning a QR code with their device's camera. A default user will be provided and other users will be pulled from a specified Excel file on the device. 2. Matching Activity: Users will scan three different QR codes, which the system will match. Each QR code has 4 fields, which the shall be processed and match logically. Add a container to add additional QR codes when a field does not match. once all matches, The user can press a button to save the record as an Excel file. There will be a Photo container that will lookup jpg file in device local folder, if one of the field from QR code is entered . 3. Report Activity: A simple list format for viewing saved data. Data Logged: The application will save user details and QR code data to Excel...

I'm seeking an experienced Excel professional to customize a workbook for tracking sales leads. The workbook should be user-friendly, as leads will be entered manually. Key Requirements: - Create a comprehensive and intuitive workbook for logging sales leads. - Incorporate advanced Excel functions to enhance tracking and lead management. Skills & Experience: - Proficient in Microsoft Excel with a strong understanding of its advanced functions. - Experience in developing and customizing Excel workbooks for lead tracking. - Previous experience in sales or lead management is a plus. Please note, the project does not require automating follow-ups or importing leads from other systems. The focus is on creating a tailored workbook for manual data ...

...scanning a QR code with their device's camera. A default user will be provided and other users will be pulled from a specified Excel file on the device. 2. Matching Activity: Users will scan three different QR codes, which the system will match. Each QR code has 4 fields, which the shall be processed and match logically. Add a container to add additional QR codes when a field does not match. once all matches, The user can press a button to save the record as an Excel file. There will be a Photo container that will lookup jpg file in device local folder, if one of the field from QR code is entered . 3. Report Activity: A simple list format for viewing saved data. Data Logged: The application will save user details and QR code data to Excel...

...a country's sustainability indicators. Key Requirements: - Proficiency in Tableau with experience in creating interactive dashboards. - Ability to visualize economic data in an understandable manner. Please note that while I have not specified the primary indicators to visualize, All of the data, how I want it to be visualized and structured on the page will be given. I will send the expert excel sheets, data and instructions on where each data set should be inserted and how different data sets might link to each other. All I need is a somebody who can do the visualization part of the project and provide with a clean looking and presentable interactive dashboard ideally on Tableau, but any other tool would do for the sake of a better result. The primary purpose of this ...

I'm looking for a freelancer who can assist me with data entry. The specifics of the data entry tasks are not yet defined. I may need help with manual data entry, data extraction, and data cleaning. Ideal candidates should have: - Experience with different types of data entry - Proficient in using Excel and other data management tools - Attention to detail for data cleaning tasks Please note, the source of the data and the final format are yet to be determined. Therefore, flexibility and willingness to adapt to changing requirements are essential.

I require assistance with manual data entry from my digital files, predominantly Excel and Word. The data is mixed, encompassing both text and numeric components. Ideal Skills and Experience: - Proficiency in Excel and Word - Excellent attention to detail - Prior experience in manual data entry - Ability to handle mixed data (text and numeric) - Strong organizational skills

I need my sales data cleaned and sorted. The data is currently stored in Excel/CSV files and contains duplicates, inconsistent formats, and missing values. Ideal skills and experience: - Proficiency in Excel and data management - Experience with data cleaning and sorting - Attention to detail to identify and rectify data issues - Ability to work with large datasets

...build a custom tool that connects with public APIs from platforms such as Meta, TikTok, Craigslist, and others. The tool will extract a specific dataset, compile the results, and deliver them via email on a daily schedule. Key Responsibilities: • Design and develop a custom script or tool to connect with public APIs of multiple platforms (Meta, TikTok, Craigslist, etc.). • Implement webhooks or scheduled tasks to fetch data once daily. • Process and compile the collected data into a structured format (e.g., CSV, Excel, or PDF). • Automate email delivery of the dataset to a specified email address. • Provide clear documentation for the tool, including setup and maintenance instructions. • Ensure data accuracy, error handling, and logging for t...

...Easy for Techs who work remotely to access • We can design excel template for the timesheets which can then easily be cut and pasted into Xero (our accounting package which also does our payroll). • The documents are live However, we are unsure as to whether Google Docs will allow us to do the following: • Have 1 x Google Doc with individual tabs which can be quarantined/separated so that Techs can only view their own (and not other Techs) time sheets/tabs? • Allow 2 x payroll staff working at separate locations to edit the time sheets (individual tabs?) submitted by Techs and also make comments that are visible to payroll staff only and not to Techs. Please advise if you think you can assist and set up something for us with an excel template that we...

I need an experienced developer to set up an automation script on AWS Fargate for me and create documentation so our developer can implement it. Ideal skills and experience: - Extensive knowledge of AWS Fargate in phython - Prior experience with writing automation scripts - Strong problem-solving skills for service orchestration and resource scaling - Ability to provide expert suggestions on potential automation tasks Functionality will enable,: Run scripts continuously (no 60-second Lambda limitation) via Fargate Monitor database events in real-time Key Tasks Expected to be completed - Validate whether Fargate/Lambda switching is possible in single template or requires separation - Update Container to have the ability to run as a worker - Enhance deployment scripts to includ...

...our business needs. Key Responsibilities: - Develop a Tableau dashboard from Excel file (refer Google drive link) that shows the correlation between different sales and revenue influencing factors. - Create relevant new columns as needed. - Ensure the dashboard is interactive and dynamic. Business Analysis: - Interpret the results to derive at least 3-5 compelling business stories that could benefit our operations. Please note, you can find the specific factors influencing sales and revenue at the following link: Ideal Skills: - Proficient in Tableau - Strong analytical skills - Excellent storytelling capabilities - Experience with Excel/CSV data sources - Ability to create dynamic and interactive dashboards. You

...Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont ...

I'm seeking a seasoned data analyst with over 5 years of experience, particularly in SQL Server and Tableau. The task involves joining two tables using an Inner Join, wit...Inner Join, with a focus on displaying how many employees each supervisor has, as well as the supervisor's supervisor. Key requirements: - Proficiency in SQL Server and Tableau - Over 5 years of relevant experience - Ability to clean and prepare CSV data for analysis The initial data source is CSV files. Prior to joining the tables, some data transformation and cleaning will be necessary using Excel. While the specific visualization for the supervisors and their employees has yet to be determined, I am open to suggestions based on your expertise. Please include examples of your previous work with ...

I need an expert who can convert an Excel CSV file into an XML file based on a given XSD schema. The primary use of the generated XML file will be for data interchange. Key details: - The source of the CSV file is exported from a system, not manually created. - The XSD schema provided includes strict data validation rules, so attention to detail and adherence to these rules is crucial. - The XML needs to be created to facilitate smooth and accurate data interchange. Ideal skills for this job: - Proficiency in XML and XSD - Strong experience in data conversion - Excellent attention to detail and adherence to strict rules. Deliverables: - Define the fields I will require in the CSV file (based on the XSD schema information) - I will then deliver a CSV file with the required fields...

...seeking assistance to update an Excel sheet with shift details based on my handwritten notes. The task involves searching for the employee code in the Excel sheet as mentioned in the handwritten notes and updating the corresponding shift (A/B/C) for the specified date. If an employee worked multiple shifts on the same date, a new column should be added to record the additional shift. If the employee code from the notes is not found in the Excel sheet, a new row must be created to include the employee code, name, and the shift details for the specified date. Key details: - The handwritten notes are in photographs - The employee codes and names are consistent between the notes and the Excel sheet - The dates are formatted as DD/MM/Y...

I've imported data into my Google Sheet and need someone to help me identify and manually highlight exact duplicates across all columns.

Our business currently uses the following applications: 1) Microsoft 365 (Outlook, Teams, Word, Excel, Power Automate, etc.) 2) Egnyte Cloud Server 3) 4) ChatGPT for Teams 5) Zapier Using Power Automate and/or Zapier, we want to create various cloud flows that directly integrate our different applications with ChatGPT. For example, when an e-mail is received to a shared mailbox, have ChatGPT analyze the e-mail and then automatically perform the following actions based on ChatGPT's analysis: 1) Move the e-mail to the appropriate Outlook folder 2) If there are attachments, then save each attachment to the appropriate subfolder located in Egnyte, using our file naming protocol 3) Add all relevant tasks and/or events to 4) Sync the MyCase events with Outlook Calendar

...I’d love to hear your input! What I Need: • A printable sheet with a mix of: o Circles containing only the Yankees logo. o Circles featuring individual photos of my son alongside or creatively integrated with the Yankees logo (but keeping both elements distinct and visible). • All designs sized precisely at 2.5 inches in diameter and ready for cutting. I’m seeking creative submissions for custom cupcake toppers that feature my son’s picture alongside the New York Yankees logo. The toppers should be designed for printing on cardstock paper and sized precisely at 2.5 inches. Details: Photos: I’ve attached several photos of my son to give you options. Please use the one that works best for resolution and quality. Design: The sheet should...

I need assistance with entering mixed data (both text and numerical) into Excel. This data will need to be input manually, so attention to detail and accuracy are crucial. If you have experience with data entry and are proficient with Excel, I'd love to hear from you.

I need a Tampermonkey script designed for Google Chrome that will assist me in automating certain tasks. Key Requirements: - The script should automate Open Folder Of My book mark automaticly , and then close the browser after xx second i uploaded a video to what excat i need from Tampermonkey to do in my browser Ideal Skills: - Proficiency in JavaScript, as Tampermonkey scripts are written in this language. - Experience with Tampermonkey or similar browser automation tools. - Familiarity with Google Chrome's functionalities and bookmark handling. Please note that the script's functionality should be triggered by opening a specific folder bookmark in Google Chrome.

I'm in need of an Excel expert to create a detailed spreadsheet for auditing my payslips. The spreadsheet should focus on: - Comparing hours worked versus money paid under incorrect penalty rates (as per pay award) - Identifying discrepancies against the amount paid versus the hourly rate with the correct penalty rate applied (As per pay award) - Tracking standard hours worked and the corresponding rate - Provide a total for the entire amount underpaid due to the incorrect penalty rates being applied In terms of functionalities, the spreadsheet should include: - Automated alerts for any incorrect payments - Colour coding with key Ideal skills for this job include advanced proficiency in Excel, experience in payroll auditing, and a strong understanding of penalty rat...

I need assistance with data entry from digital files into an Excel spreadsheet. The data is purely text-based and is sourced from digital files. The ideal freelancer for this project should have: - Excellent attention to detail to ensure accurate data entry - Proficiency in Excel to handle the data effectively - Experience with data entry from digital files to maintain confidentiality and data integrity.

I need an experienced developer to convert an Excel workbook, used for financial modeling in the renewable energy sector, into a web-based SaaS tool. The tool should have: - A framework for user maintenance and fees - A form-based graphical user interface (GUI) - Capabilities for new and modified projects - Tabular output - AI 'coaching' The tool is intended for two user roles: Admin and Basic User. I have started using AWS and Python for this project, but it's proving too challenging. I'm looking for a professional with: - Strong experience in web-based SaaS development - Understanding of financial modeling - Familiarity with the renewable energy industry - Proficiency in AWS and Python Please refer to my site ...

My Selenium-based Excel tool is giving an error message upon starting it, asking to retry. I am looking for someone who can fix this for me. Runtime error 91 object varialbe or with block variable not set. I would also like this person to be the one to make future updates to the tool. - Error Message: The user did not specify what the error message is, as they skipped the first question. Therefore, the freelancer would need to investigate the error upon accessing the tool. - Selenium Version: The user is not sure which version of Selenium they are using. - Browser: The tool is configured to work with Chrome. Ideal skills for the job include: - Proficiency in Python and Selenium - Experience with Excel automation - Strong problem-solving skills - Familiarity ...

I need help with data entry from various online databases. The data is a mix of text and numeric, and should be compiled into an Excel spreadsheet. Ideal Skills: - Proficient in Excel - Attention to detail - Experience with data entry - Ability to work with both text and numeric data - Familiarity with online databases

I'm in need of a Python script that will streamline my process of placing Buy orders on the Binance P2P platform. The script should be able to authenticate and execute these orders securely using my API key and secret key. Key Features: - Triggered by: A combination of specific rate and quantity thresholds. - Integration: Seamless with Binance's relevant API for efficient and precise order placement. Ideal Skills and Experience: - Proficient in Python and familiar with Binance API. - Previous experience in developing trading scripts. - Understanding of P2P order placement. - Ability to ensure secure and efficient script execution. This script should save me time and increase my buying efficiency on the platform

I'm looking for a creative radio professional to help me produce a debate on sports. The main goal is to inform the public about the benefits of sports. The format will be individual presentations, so I need someone who can help me script and structure the debate in an engaging way. Ideal Skills: - Excellent understanding of sports and its benefits - Strong scripting and structuring skills - Experience in radio production - Creative thinking to make the debate engaging.

Hi there, this is the indicator I need to create. 1. I am looking to first write the indicator that applies my strategy on any ticker using TradingView 
2. Automate the strategy using a bot that trades over my broker. See Pdf attached in files

I'm looking for a skilled Ninja Trader programmer to create a script for me that will handle automated trading. Key Requirements: - Expert-level understanding of Ninja Trader. - Proficient in script writing for automated trading. - Previous experience in developing trading scripts. Please note that the specific assets or markets the script will trade on, as well as the trading strategy to be implemented, are currently undecided. Therefore, the script should be flexible and adaptable to various trading scenarios.

I'm seeking an Excel whiz to assist with moving and reorganizing data on a spreadsheet. Key Responsibilities: - Copying and pasting data from one spreadsheet to another - Reorganizing data according to specific categories or columns, with a focus on financial data Ideal Skills: - Proficiency in Excel - Strong data entry and organizational skills - Experience working with financial data

I'm in need of a seasoned animator who specializes in either 2D or 3D animation to help bring my music video to life. - Theme: The video's theme is comedy, with elements that are controversial, simple, and quirky. - Storyboard and Script: I have both a storyboard and a script ready to guide the animation process. The ideal candidate for this project should be proficient in 2D or 3D animation, have a good understanding of comedic timing and visual storytelling, and be able to interpret and animate according to a provided storyboard and script. Experience with creating animated music videos is a plus.

I'm in need of a bot that can take info from an Excel spreadsheet and cross-reference it with another spreadsheet to calculate job pricing. The bot needs to handle: - Mixed data: The spreadsheets will contain both numeric and text data. The bot should notify me by: - Directly updating a new spreadsheet with the calculated job pricing. The bot should perform the tasks: - On-demand: I should be able to trigger the calculations whenever needed. Ideal skills for the job include: - Proficiency in Excel and understanding of spreadsheet functions. - Experience in creating automation bots for Excel. - Programming skills, preferably in Python or VBA.

I'm seeking a skilled AI developer to create a bot that can streamline my pricing process. The bot's primary role will be to analyze sales data from an Excel file and calculate prices for individual items. Key Tasks: - Price Calculation: The AI bot will need to assess sales data and determine prices for individual items. - Data Extraction: While the main task is price calculation, a basic ability to pull relevant data from the Excel file is necessary. Ideal candidates will have experience in AI development, Excel data manipulation, and pricing strategy. Please include examples of similar projects you've completed in your bid.

...creative and skilled UI/UX designers to design a Point-of-Sale (POS) system user interface. This project includes designing up to 15 screens, starting with the main POS screen. Your First Task: Design the main POS screen to showcase your talent and vision. This screen will serve as the foundation for the complete UI design. What We Are Looking For: Main POS Screen Requirements: Product Display: Show products with images, names, and prices. Order Summary: Display the current cart/order summary. Checkout Section: Include payment methods and options. Quick Action Buttons: Features like discounts, void, etc. Navigation: Easy access to other screens like reports, settings, etc. Modern Aesthetics: Sleek, professional, and user-friendly design. Device Compatibility: Adaptable ...

Project Description: We are seeking a skilled WordPress developer to create a clean, simple, and professional page on our WordPress site that enables users to upload and share their own audio files. Submissions will require moderation before being publicly visible. We’re open to using existing plugins or custom solutions to achieve an efficient and user-friendly experience. This page will be part of a website that we already have, that is made on WordPress with Elementor Pro. Key Features: Frontend Audio Upload Form - Users can upload audio files (MP3, AAC, etc.) along with metadata (e.g., title, description). - Validation for acceptable file types and size limits (e.g., 10MB max). - Option to notify users upon successful submission and approval/rejection. Moderation Sys...

I need a skilled script editor to help me refine the plot structure of my short movie script, specifically focusing on enhancing character development. Key tasks include: - Assessing and altering character arcs to create a more engaging narrative - Suggesting improvements for character development throughout the script Ideal candidates will have: - Proven experience in script editing and screenwriting - A deep understanding of character development and plot structure - Excellent communication skills to articulate suggestions and changes

I'm looking for a skilled web developer to create an...via API. Key Features: - Utilization of a mapping service (specific service choice is flexible) - Display of markers for various points - Inclusion of info windows on markers - Application of a custom map layer - Implementation of a tip box with information that appears when hovering over a line The map should update with a slight delay, rather than in real-time, when data changes in the Google Sheet. Ideal skills and experience: - Proficiency in web development with a strong portfolio - Experience working with Google Maps API or similar mapping services - Familiarity with Google Sheets API - Ability to create interactive web elements - Knowledge of custom map layer implementation - Experience with designing info window...

Hiring Work-Nix Solutions to add reporting options to existing system.

I am looking for a minimalist logo that encapsulates the essence of Ridgeview Retreat. The logo should subtly convey a sense of relaxation and peace. Ideal Skills: - Proficiency in minimalist design - Strong understanding of conveying emotions through design - Experience in creating logos for retreats or similar establishment...and expertise will be key in creating a logo that not only represents Ridgeview Retreat, but also appeals to our target audience. Ridgeview Retreat is an Airbnb located in Karikari Peninsula. My web address is If you are chosen to design my logo, if you do a good job I will likely also use you to design my website better. And I may also use you to design logo for my sheet company and website for that. Please quote your price to make logo

...```python updated_qty[index + 10] = desired_qty[index] ``` - If `desired_qty[index] <= desired_qty[index - 1]`, then: ```python updated_qty[index + 5] = desired_qty[index] ``` - Ensure this is handled without using loops, `iterrows`, or `itertuples`. The entire process must be vectorized for performance. --- ### Deliverables: 1. A Python function/script implementing the vectorized solution using Pandas. 2. Verify correctness by ensuring the output matches the provided "before" and "after" CSV files. 3. Provide clean, well-documented, and maintainable code. --- ### Notes: - The solution **must not use loops** or row-based iteration functions like `iterrows` or `itertuples`. Efficiency is critical. - Use Panda...

...upcoming funerals. Key features include: - User roles: The website should support three user roles: Funeral directors, Site administrators, and Advertisers. - Search functionality: There should be a search box for users to find records easily. - Notification system: The site needs a mass notification system that sends out email and, if possible, WhatsApp notifications. Push notifications are also desirable. - Advertising sections: There should be segments on the site for advertising various services, specifically funeral-related products, grief counseling services, and memorial planning services. It should also include advertising for upcoming funerals and anniversaries. The initial target market for the site is Ireland, but it is important that the script is ada...

Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.

Update your old script . Thanks

I'm seeking an Excel expert who can create a comprehensive spreadsheet for tracking employee utilization and project projections for 2025. This spreadsheet needs to accommodate various employee details and provide quarterly projections. Key Requirements: - Include specific employee details: Name and ID, Department and Role, Experience Level - Track utilization on an individual employee basis - Input employee rates and hours on projects - Incorporate fringe benefits and PTO - Provide functionality for quarterly projections Ideal Skills and Experience: - Proficient in Excel with advanced spreadsheet skills - Experience in creating utilization and projection spreadsheets - Strong understanding of employee management metrics - Ability to deliver a clear, user-friend...

My Selenium-based Excel tool is giving an error message upon starting it, asking to retry. I am looking for someone who can fix this for me. Runtime error 91 object varialbe or with block variable not set. I would also like this person to be the one to make future updates to the tool. - Error Message: The user did not specify what the error message is, as they skipped the first question. Therefore, the freelancer would need to investigate the error upon accessing the tool. - Selenium Version: The user is not sure which version of Selenium they are using. - Browser: The tool is configured to work with Chrome. Ideal skills for the job include: - Proficiency in Python and Selenium - Experience with Excel automation - Strong problem-solving skills - Familiarity ...

I need a fix in my custom wordpress plugin. Main features are Autoregister of users through websites and User Autologin. Works as expected when websites are in a subdirectory structure, under the same domain/server. Fails when websites are in different domains or servers, specially if they have different configuration (OS version, PHP, mysql..). Plugin should work regardless of these setups. Experience with APIs related to user management is required. Please bid with tasks which could possibly be done to resolve issue.