Excel vba lock sheet user scriptcông việc
I am seeking a skilled developer to redesign the user interface of my Open Cart platform. The new UI should be crafted with a professional and corporate aesthetic in mind, combining style with functionality. Key Requirements: - Redesign the user interface of the Open Cart platform to provide a professional and corporate look - Ensure the new design is not only visually appealing but also enhances user experience and functionality The ideal candidate for this project should have: - Proven experience in UI/UX design within E-commerce platforms, specifically Open Cart - A strong portfolio demonstrating a professional and corporate design style - An understanding of user experience principles and best practices in E-commerce Please share your portfolio showcasing...
I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.
As the project owner, I am looking for a talented individual who can handle two crucial tasks in Excel: 1. Adding advanced functionality with IF, VLOOKUP, and INDEX MATCH formulas. 2. Implementing conditional formatting. To be successful in this project, you should have: • Proficiency in Excel's advanced functions and calculations • Experience with customizing Excel using conditional formatting • Attention to detail and the ability to execute tasks accurately. Your primary task will be to help me improve Excel's current functionality by implementing the advanced functions mentioned and customizing my Excel using conditional formatting. Your deep understanding of Excel will be crucial to successfully carrying out these tasks...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfac...
I'm looking for a talented web designer to help improve user experience on my website by introducing a new header/hero navigation style. The ideal candidate will: - Have experience in web design with a focus on enhancing user experience - The ability to create a design that's both functional and visually appealing Please note, while I didn't specify which elements should be included or how exactly the header/hero navigation should be displayed, I am open to your creative ideas and suggestions. Your portfolio should demonstrate your ability to make these decisions aimed at improving user experience. Present your strategies for a new header/hero navigation style that does not inhibit the user's interaction with the web page but rather augments it. ...
...work with me to achieve great rankings. If I say something needs tweaked a bit, I expect the team to listen to my desires as long as those desires will reach the end goal. While working on the main keywords, I expect additional keyword phrases to be used in Chat GDP blog and wiki articles that would benefit the website. That way not all backlinks will be from the list of 20. We can use our excel sheet from previous projects for this. I should see a drastic increase in DA and PA of the website. Post the phrase #seoGuru so I know you read and understand and agree to these terms. Post the sentence "I agree to the terms and conditions posted in your project description. I understand not following the terms will be grounds for termination and cancellation of the projec...
Looking for a savvy surveyor who can get to the crux of the ready mix concrete market in Varanasi, India immediately. I need an in-depth study on: - Current market size & its growth trends - Rival firms & their market share Key requirements include: - Compile a detailed report, covering your analysis & proposing actionable strategies. - Provide raw data in Excel or CSV format in addition to the report. Prior experience in market surveying and a knowledge of the construction industry are big pluses. Your ability to work fast while maintaining accuracy is paramount. Let's revolutionize the Varanasi concrete market, one data point at a time!
one refernce site ____________________________________ content is in googkesheet right English sheet image design layout, make the margin spacing similar want this layout page to be designed in elementor the content is mentioned in docs I have read the docs 1. Layout of docs to be designed in Elementor 2. margin scheme is sheet image design layout, make the margin spacing similar 2-1. the content and images which you have provided in the docs file that images need to be created in canva...... some images in docs file. you can make in canve. just similar layout design . . ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
I'm in need of an app designer for my iOS/Android app. The app is a simple kids education app, aimed at children aged 6-13. The core feature of the app is the quiz questions part and should be interactive. In total i need 1 - starting page UI - 2 setting UI - 3 - help page UI - 4 quiz page UI. Its a minimalistic app and user friendly. I have a drawn a sketch and will give you idea examples. I trust you expertise and you can choose the right colors and theme. You should have experience in designing educational apps, especially for children. An understanding of child psychology and what makes an app appealing to this age group is highly desirable. A portfolio that showcases a similar type of project would be a huge plus.
I need help with simple copying and pasting tasks from online directories. The data needs to be organized by category. The primary task includes: - Copying data from various online directories - Pasting the data into an Excel/CSV file - Organizing the data by categories Ideal skills: - Excellent attention to detail - Proficiency in data entry and Excel/CSV - Understanding of data categorization The task is straightforward and doesn't require any complex skills. I am looking for someone who can deliver accurate results in a timely fashion.
Retrieves the client's IP address. Checks whether the script should run based on a time limit.(5 minute) Retrieves the client's IP details (region and city) using an IP geolocation API. Retrieves a job feed from the specified URL. Filters the job listings based on the client's location (city and region) and excludes certain isp's from been redirected( google/i, amazon/i, Cloudfare/i...) Randomly selects a job listing from the filtered jobs and redirects the user to the selected job listing URL.
...seeking a skilled Python developer to create a script that automates the segmentation of videos based on subtitle changes. The script will take a video file and a JSON file (output from the Google Vision API) as input and generate video segments whenever the subtitles change. Responsibilities: Develop a Python script that reads a video file and a JSON file (Google Vision API output) as input. Parse the JSON file to extract subtitle information and their corresponding timestamps. Use the subtitle timestamps to segment the video whenever the subtitles change. Save the segmented video clips with a naming convention: segment_[index]_[text].mp4, where [index] is a sequential number and [text] is the corresponding subtitle text. Ensure the script is well-document...
Preciso transportar dados de uma pesquisa do google formulário para gráficos gerados em Excel, para serem adicionados em trabalho acadêmico.
Live price reflect at top header with all gold karat Price changes according currency and units in miner’s dashboard Sell gold values comes according miners decided to sell units of gold and sell lock price working with lock bidding value. Download statement on the history page of the minor is not working. Take out silver and platinum from the drop down list as of now. The bidding value will be 1% more than the real time price-Admin fees (2.5%) (This will be functional once the live streaming will start working). So as such no extra work is needed in it. The locking period is 3 working days. It can be checked on the admin as it is already functional. (Just need to check) The sales amount to be transferred to the miner’s bank account manually and once the payment...
I have excel table with project tasks by dates start and end and duration. I want to change it to project table. Preferred microsoft format.
I urgently need a professional who can input textual data onto an Excel sheet in a visually appealing and easy-to-understand way. Key Responsibilities: - Representing textual data in a clean and organized manner within an Excel sheet. Ideal Candidates Should Have: - Proficiency in Excel, particularly in handling and presenting textual data. - Strong attention to detail, ensuring that all data is correctly input. - Ability to work quickly and efficiently, as the project has a tight deadline. If you have experience with data representation and can work fast, please apply.
I'm looking for a skilled WordPress developer with an eye for user-friendly design. I want to improve the user experience on my existing website, aiming for a more intuitive, effortless approach. However, I have not recognized specific current issues with the site's user experience. I expect an expert to analyze my site and implement necessary improvements. I require this to be completed within a month. - Expertise in WordPress - Proficient in UI/UX design - Able to complete within a month - Able to identify and resolve non-specific user experience issues
I'm seeking an expert in Excel who can help me with three key areas. Tasks include: - Data entry: I have an Excel spreadsheet with around 100-1000 rows and columns that require data input. - Data analysis: Extracting meaningful insights and patterns from the data provided. - Spreadsheet formatting: Ensuring the data is presented in a clear, professional manner which is easy to interpret. Specific functions and formulas required include: - Basic operations like Sum, Average, and Count. - Conditional formatting, to highlight key data points. - Pivot Tables, to present the data in a clear and organized manner. The ideal candidate should have a strong track record in data handling, analysis, and visualization using Excel. Great attention to detail and the abil...
I need an expert in web scraping, either in Python or by utilizing Google Chrome extension, to extract text data from a particular website. Should be delivered within 3 hours. The scraping is a one-time task, not requiring routine updates, and the extracted data needs to be saved in an Excel file (or CSV). This will be hidden behind a login wall - so I suggest that the Python script will go to the website and then wait one minute, where I will manually log in. Ideal Skills and Experiences: - Proficiency in Python for web scraping - Experience with scraping text specifically - Ability to deliver the required output in a CSV format
Development and Enhancement of Excel VBA Project Tracker.
I require the expertise of a skilled data scraper who can quickly retrieve text data from a specified website. The site in question is I need the following specific information delivered in Microsoft Excel Format: - Country Name - Grand Lodge Name - Website address - Email address - Phone - Address - Grand Master name (if available) The ideal freelancer for this project would have significant experience in data scraping, particularly text data, and an understanding of the website's structure to retrieve the desired information effectively. Speed and efficiency are of the essence. Your ability to deliver this project promptly without compromising accuracy will win you this bid.
Ich bekomme von einem Lieferanten mehrfach täglich eine Textdatei mit Rechnungsinformationen zugesendet. Diese Informationen möchte ich in einer CSV-Datei aufbereitet haben. Pro Vorgang soll eine Zeile erstellt werden. Idealerweise sollte die Programmierung mit Powershell erstellt werden, damit ich das Script über den Aufgabenplaner regelmäßig ausführen kann. In der angehängten Beispieldatei ist erkennbar, dass die einzelnen Vorgänge jeweils mit Header beginnen.
To give you a br...from USDA. I'm seeking a Python expert who can give me 100% accurate "mapped" data without duplicates or missing information. YOU WILL BE REQUIRED TO WRITE/SEARCH NEW script to modify my data in Excel sheets - I have 3 Excel files having a total of 50000 rows, These are ingredients from recipes, I need you to do the following tasks - (A) - Assign a new ingredient ID number to all non-duplicate Ingredients. (B) - Replace "Name of ingredients" with the newly assigned number in the whole file (C) - For all ingredients - search, get the FDC ID from USDA Food Central and save this info in a separate file. Outcomes - 1. My Excel files - with names replaced with ID (non-duplicate) 2. 1 New file ie. the list of ALL ingredi...
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...
I am in need of a Python script that can extract Amazon's official keywords and search terms, and update this information on a daily basis. This data includes keyword search volume, keyword competition, and top ranking keywords. Key requirements and responsibilities include: - Developing a Python script to extract Amazon's official keywords and search terms - Ensuring the script is capable of updating this data on a daily basis - Retrieving keyword search volume, keyword competition, and top ranking keywords - Aiming for improved product visibility, enhanced product listings, and optimized PPC campaigns The ideal freelancer for this project should have: - Proficiency in Python - Familiarity with web scraping and data extraction - Experience with Amazon...
I have an existing Python script that automates data processing tasks. Unfortunately, I'm encountering a runtime error when running it. I need an experienced Python developer who can help me troubleshoot and fix this issue so that the script runs smoothly again. Key Responsibilities: - Identify the source of the runtime error and fix it without impacting the functionality of the script. - Ensure the script can successfully automate the data processing tasks as intended. Ideal Candidate: - Proficient in Python programming with experience in debugging and troubleshooting. - Familiar with automating tasks in Python. - Strong understanding of data processing. Your help is crucial to keep my workflow efficient and error-free. Looking forward to working with...
...focused on identifying Effluent Treatment Plant (ETP) and Sewerage Treatment Plant (STP) manufacturers, as well as wastewater treatment plant suppliers in Maharashtra. As a freelancer, your task would involve comprehensive research to compile a database of relevant companies operating in the field of wastewater treatment across Maharashtra state. The information gathered will be organized into an Excel sheet, including but not limited to: Company Name Email Address Website Address Location and Address Contact Number The scope of the research will cover suppliers located in major industrial estates and towns across Maharashtra. This includes but is not limited to areas such as Mumbai, Pune, Nashik, Aurangabad, Nagpur, and others with significant industrial presence. You...
...engaging 2D cartoon animation. Key Details: - The animation will be an explainer video with voice-over aimed at educating and informing viewers about a change in company structure - The preferred style of animation is 2D cartoon. Requirements: - A proven track record in creating educational explainer videos. - Experience in producing 2D cartoon animations. - Ability to conceptualize and develop a script based on my rough idea for the voice-over. This project has the potential to be a recurring job if the initial video is successful. A collaborative mindset and excellent communication skills are highly valued. Looking forward to working with a creative professional who can bring my concept to life through a captivating animation. as a reference something similar to this
I need an graphic designer who can create 2D perforated sheet images for industrial use. - The images need to be simple in nature with basic hole patterns and spacing. - The final deliverable should be in JPEG format. Ideal Skills: Graphic design, Industrial design, 2D design. I am attaching two images for reference.
I'm working on an army game in Roblox and need a script that displays ranks on top of the player and shows in leaderboard . The script should allow me to change ranks and add and it comes with a command like .promote (user) which makes the user got 1 rank up and can only be executed by people who are the rank that will be changable or above. Key Requirements: - Displaying Ranks: The ranks should be displayed both above the player in-game and on the player's tab. - Customization: I want to be able to customize the ranks and add new ones easily. The customization process should be straightforward and intuitive. Ideal Skills and Experience: - Proficient in Lua and Roblox Studio. - Prior experience with creating robust rank management systems in Roblox ...
I'm in need o...aspect is producing a visually appealing and convincing video. Ideal Skills and Experience: * Experience in video production and editing. * Fluency in Dutch. * Proficiency in creating real-life footage videos. * Understanding of persuasive techniques to appeal to business owners. I encourage anyone with the relevant skills to make their pitch, and I look forward to reviewing your proposals. Script: Wil jij een passief inkomen opbouwen in de marketing? Wij hebben een supergave marketingtool, die jij in whitelabel kan aanbieden aan jouw klanten. Je bepaalt zelf jouw verdienmodel en wij gaan jou helpen om hiermee jouw passieve inkomen te realiseren. We zijn in jouw regio op zoek naar een partner, dus klik snel op onderstaande button en kijk of jij geschikt be...
...an experienced freelancer who can effectively perform data entry tasks involving financial data. While the specific type of data has not been specified -- it could range from invoices and expense reports to bank statements -- the chosen professional should exhibit versatility and aptitude in working with various forms of financial data. Key Requirements: - Proficiency in Excel: You'll need to be well-versed in using Excel for data entry tasks. - Background in Finance Data Entry: Experience or relevant knowledge in finance data entry is crucial. This ensures you can deliver accurate results. To apply, offer a detailed approach on how you would tackle this project. Also, provide evidence of your past work as well as your experience in the field. This will assure me of...
...highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the required ski...
Create a form in Excel following the pre-determined options. The results of the answers must be recorded in a second tab
Hi, I can complete your work as you shared me in the document. Thanks
Hello, I have a WP blog site, which is I want to rank in the top 5-6 google results on average for the following keyword phrases kwikset smart lock shark robot vacuum ninja coffee maker powerxl air fryer There is a single blog for each keytword. All keywords have difficulty level below 10. Target Country is USA The ranking must hold for 1 month at least. Based on result I may continue working with you to sustain the ranking. You need to look at the site, tell what modifications I can do for better results. Before starting you must let me know your plan of action. Then you start working and provide me weekly reports on what you are doing. Only white hat methods may be used. If black hat methods are found to be used, then the project will be immediately
updated excel file let discuss more in chat
I'm seeking a Pine Script expert to assist with debugging simple indicators within the next 8 hours. Key Requirements: - Proficiency in Pine Script: Prior experience with the language is essential. - Debugging Skills: Ability to troubleshoot and rectify issues in a timely manner. - Time Sensitivity: Must be able to work within an 8-hour deadline. Your main task will be to identify and correct any issues in our basic Pine Script indicators. This will involve a systematic approach to pinpointing and rectifying any errors or inconsistencies within the script. The urgency of this task means effective communication and prompt delivery are paramount. Your expertise in Pine Script, particularly in debugging simple scripts, will be highly beneficial in e...
I intend to streamline the process of document submission and verification in relation to EDPMS entry and BRC, with a focus on customs or trade-related documents. The ideal candidate will ensure proper documentation is submitted and will run stringent checks for validati...trade-related documents. The ideal candidate will ensure proper documentation is submitted and will run stringent checks for validation purpose. Key Responsibilities: - Submission and verification of customs or trade-related documents - Verification and correction of any errors found in the documents Experience & Skills: - Experience in the customs or trade sector is essential - Proficient in Excel/CSV - Strong attention to detail and high accuracy in document handling - Previous exposure to EDPMS and BRC is...
I've already done most ...the key piece of work. - Comprehensive Review: It's important that you review my analysis comprehensively and suggest corrections or improvements where necessary. - Final Financial Year Analysis: The analysis should cover multiple financial years, ensuring a comprehensive assessment of my trading performance. Ideal Skills and Experience: - Proficiency in Excel: The data prepared to do is in an Excel spreadsheet format, so advanced Excel skills are essential. However I also have a full list of my trades that is only in pdf. - Financial Analysis: A solid background in financial analysis and portfolio management is necessary for this project. The ideal candidate will have a keen eye for detail and the ability to provide reliable, acc...
As your assistant for this project, my job will be to type data into an Excel spreadsheet. However, I currently don't have specific information on what type of data (text, numbers, dates) you require. Additionally, I need clarification on whether you have any specific formatting needs for the data and if any calculations or formulas will need to be applied. Ideal Skills: - Proficient in Microsoft Excel - Precise and quick typing ability - Understanding of Excel formulas (just in case) Your prompt response to these questions will help ensure successful completion of your project. Looking forward to working with you!
...a mechanism to trigger notifications in real-time whenever a new entry is made in the Google Sheet through AppSheet. Create customizable message templates to populate WhatsApp messages with data from the newly entered form. Ensure secure and reliable communication between AppSheet and WhatsApp Business API. Implement error handling mechanisms to address any potential issues during data transfer and messaging. Technical Approach: Utilize the WhatsApp Business API to establish a communication channel between AppSheet and WhatsApp. Implement webhooks in AppSheet to detect new data entries in the connected Google Sheet. Develop a message parsing mechanism to extract relevant data from the Google Sheet entry and populate predefined message templates. Ensure proper aut...
I'm seeking a professional with expert knowledge in precision analog design. Goal of the project is a small prototype board to measure K type thermocouple elements - with two different approaches. Additiona...ADC proposition the project comprisis of a full circuit and PCB creation. Additionaly also the needed firmware for the respective communication (over SPI) shall be properly implemented (well structured and with readable comments). Finally also testing should take please for measure the achievable performance of the proposed and implemented solutions. Please read carefully the attached project sheet with even more details. Looking forward to work together with an experienced engineer in the analog design and embedded domain. Feel free posing any questions before bidding f...
...architectural drawings in an impressive and articulate format. So, if you've got strong knowledge of residential architecture and experience with these software tools, you could be the perfect fit for this project. Your expertise is paramount for the success of my architectural drafts and interior designs. Individuals with a detailed-oriented mindset and the ability to think outside the box will excel in this project....
I'm looking for a skilled professional to help create a webinar script and presentation, focusing on parenting for 0-2 year old baby parents. The webinar should emphasize 'Activities to Unlock their potential'. Ideal candidates should have experience in: - Scriptwriting for webinars - Designing engaging presentations - Knowledge of parenting, child development - Ability to make complex ideas accessible
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...
...integrate my Google Sheet board into my WordPress website. To make it simple I want to do the same as this plugin without using this plugin: Key Project Details: - **Data Types**: I need to display text content, numerical data, and images from the Google Sheet. - **Update Frequency**: I would like the data to be updated on the website in real-time, so it should be refreshed every time there's a change in the Google Sheet. - **Design**: I already have a specific design in mind for how this data should be displayed. Ideal Skills and Experience: - **Google Sheets API**: You should be familiar with the Google Sheets API and how to fetch data from a Google Sheet. - **WordPress Development**:
• 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]". &bul...
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...
