Excel data validation list from another worksheet 2010 jobs

I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our w...

...principles, particularly as they apply to construction projects. - **Price Comparison:** You'll be required to create a template that allows me to compare prices for different construction-related products and services. - **Task Scheduling:** This is a key feature that the template should have. It should make it easy for me to schedule different tasks and track their progress. - **Budget Tracking:** Another essential feature. The template should have the capability to track my budget as I enter costs for different services and products. Given the complexity of construction projects and the need for accurate cost comparison, the ideal candidate should have: - Previous experience in construction project management - Strong project management software skills - Experience i...

I need someone to help locate electronic waste sources, with a focus on finding Pentium Computer motherboards and Gold Ceramic CPUs. The project involves: - Medium-scale collection: I'm looking for someone to focus on regional collections from various sources - Target locations: The primary focus will be on commercial and business areas, as well as educational institutions. The ideal freelancer for this project would have: - Experience with electronic waste collection or recycling - Knowledge or network within the IT sector to locate and secure Pentium Computer motherboards and Gold Ceramic CPUs - Strong communication and negotiation skills to engage with different sources - Ability to independently manage and organize the collection process.

I'm looking for a data sourcing and CRM expert to help me build a targeted lead list for prospecting. The ideal candidate will have experience in: • Identifying relevant data sources for lead generation based on an Ideal Customer Profile (ICP). • Sourcing high-quality contact information (emails, phone numbers) for 100-200 potential customers. • Data cleansing and validation to ensure accuracy. • Uploading the cleaned data into HubSpot CRM. Project Goals The goal of this project is to establish a foundation for targeted email marketing campaigns. This will be achieved by: • Creating a targeted lead list based on my ICP. • Uploading the lead list into HubSpot for easy campaign management. Your Respons...

...professional who can assist me in enhancing the script. Requirements: - The script should be able to validate the existence of email mailboxes without freezing when processing a large volume of emails. - Email verification must be accurate and reliable, and the script should be able to handle a large list of emails efficiently. Key points for the project include: - Implementing a more efficient algorithm to handle large email lists without freezing. - Ensuring that the script provides accurate validation of email mailbox existence. Ideal Skills: - Strong proficiency in Node.js and email verification techniques. - Experience in optimizing scripts to handle large datasets without performance issues. - Good understanding of efficient algorithms and their implementation in...

...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to...

I have an existing Excel macro that is predominantly used for handling formatting tasks within the Excel file. However, I need an expert who can assess and modify it to ensure compatibility with Excel for Mac 2019 or later. Key Requirements: - The existing macro primarily deals with formatting tasks within the Excel file. - The data in the Excel file is stored in both text and numerical formats. - The main change required is to update the formulas in the macro to ensure it functions smoothly on Excel for Mac 2019 or later. The ideal freelancer for this job would have prior experience with: - Excel macros and VBA - Formatting tasks in Excel - Updating or creating cross-platform Excel macros This project requires a me...

...create comprehensive test plans for this new product. This includes both hardware and software testing. Experience in creating test plans for electronics, would be highly beneficial. - Final Testing & Validation: Once the PCBs are produced and the test plans are in place, I would need a professional who can assist me in the final testing and validation of this new product. This includes making sure it meets the necessary standards for industrial use. Ideal Skills & Experience: - PCB design and manufacturing - Test plan creation, specifically for power electronic devices - Final testing and validation of electronic devices - Familiarity with industrial use standards for electronic devices Please feel free to reach out if you have the necessary experience ...

I need a visit visa sponsored letter from someone who is in Austria or an Austrian national. Or spain. AusThe primary goal for obtaining this letter is to explore business opportunities in the tourism and hospitality industry. The sponsorship letter would ideally help facilitate my visit to Austria and convey my intentions of exploring potential collaborations or partnerships in the tourism and hospitality sector. The letter should be signed in front of local lawyers and approved by embassy.

We are looking for freelancer for technological catalogues redesign and build in adobe indesign. Freelancer should be expert in adobe indesign, photoshop, ilustrator. We provide example project templates in adobe indesign, source data in pdf and excel. Based on source data our catalogue should be created and redesigned as template project. Project should be done in adobe indesign for printing and web

...over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be ...

Task at hand is to extract vocals from a highly distorted audio file OF APPROXIMATELY 8 MINUTES. I DO HAVE OTHER FILES I WOULD LIKE DONE AS WELL, IF EXTRACTION IS SUCCESSFUL. As a client, my ultimate target is related to: - Enhancing intelligibility within the dialogue to bring utmost clarity. - Identifying specific words or phrases that may prove crucial. - The file is from a criminal setup with the audio of a father setting up his son; thus every word could change the narrative. The audio clip has been intentionally distorted over crucial conversation. Do whatever it takes to make the conversation extremely clear irrespective of the overall audio quality. Those offering skills and experience in forensic audio analysis, audio software engineering will ideally match the ...

I need historical stock prices and income statement data, deliver python script to collect this data for an arbitrary stock from google finance.

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria fo...

I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge ...

Before you go further. I can only pay Indian Rupees of Rs.600 as another Rs.300 will be taken as commission. If you agree then proceed and apply to help. I am looking for a native female American English speaker to provide me with in-person lessons like a friend. This is a personal growth initiative, so I am interested in developing my overall comprehension in a relaxed, engaging environment. More specifically, I am keen on enhancing my conversation skills through real-time discussions, scenario-based conversations, and constructive feedback. Ideal candidates should have: - Teaching experience in English (American dialect) - Strong conversation skills - Ability to develop and adapt lesson plans to cater to my personal progress - Ability to hold in-person lessons regularly - Patie...

...initially built in HTML and now need to be replicated in Vue.js. The main functionality I need is interactive forms that integrate with CRM (Customer Relationship Management) systems. Key Details: - The main task is to convert the HTML forms to Vue.js, ensuring they are interactive and user-friendly. - These forms should be integrated into CRM systems, allowing for seamless data transfer and management. - Form validation should be handled client-side only. Ideal Skills for this Project: - Proficient in Vue.js and HTML - Experience with integrating forms into CRM systems - Strong knowledge of client-side form validations A successful freelancer for this project will be able to replicate the existing HTML forms in Vue.js while ensuring they seamlessly integrate with CRM ...

I need to design a tracker control unit for the 137 MHz band antenna system of the ground station receiving weather information from the NOAA spacecraft on Arduino. The project must be modeled at https://projecthub.arduino.cc. Need your idea and help how to implement it.

I'm looking for a Google Ads expert to review my Google Ads account focusing on campaign structure and target audience to enhance lead generation. Specifically, I'm looking for someone to review in comparison to another specified month where campaigns were much more successful. Key Areas: - **Campaign Structure**: Your task would be to evaluate and provide feedback on the overall structure of my existing campaigns. This includes the organization of ad groups, the relevance of keywords, and the alignment of ad creatives with the campaign goals. - **Target Audience**: I need a detailed examination of my target audience. This would involve assessing how well my current targeting aligns with the interests and behaviors of my ideal leads. You will be expected to offer recomme...

...AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifi...

Seeking a skilled web developer to improve and update our existing Django-based website. The project involves: Menu Bar: Update and ensure consistency with multilingual support (Swedish, Danish, English). Contact Form: Implement validation, translations, CAPTCHA, and backend management. Multilanguage Support: Set up inputs for Swedish, Danish, and English without auto-translation. Articles and Blogs: Improve layout, image handling, and formatting consistency. Search Function: Enhance search to include titles and body text. Main Picture: Add functionality to change the main picture with size guidelines. Home and About Pages: Ensure consistent formatting and editable content. DNS and Email Setup: Correct domain pointers and enable email functionality on server. Proven experience with...

I am looking for a proficient photo editor to help me with a project that involves the removal of single person figures from a variety of images with an urban background. The perfect fit for this role would have: - Proven experience in photo editing, ideally with complex scenarios - High proficiency utilizing software such as Adobe Photoshop to alter images in a natural and seamless manner. Ability to maintain consistency of the scene following object removal. - Strong attention to detail, to ensure the final images are free from irregularities or hints of alteration. Your task will specifically concentrate on: - Detecting and removing a single person from an image (see attached) - Ensuring the urban setting remains unchanged and looks natural after the removal. Pl...

I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.

I need a skilled data entry professional to help me with a project. I have a large volume of text-based data that I need input from physical documents. The task involves organizing this data in a document. Key Responsibilities: - Transcribing text-based data from physical documents accurately - Ensuring the data is organized as required in the document Ideal Skills and Experience: - Proven experience in data entry - Strong attention to detail - Proficiency in handling text-based data - Familiarity with transcribing from physical documents - Ability to maintain confidentiality of sensitive information The successful candidate will be reliable, efficient, and able to deliver accurate work within the agreed timeframe.

...is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving ...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

I urgently need an experienced photo editor who can bring to life a deeply personal project. This revolves around creating a fitting tribute for a deceased classmate. The tasks involved in this project include: - Removing the current background from the photo - Adding a cap and gown to the person in the picture - Merging the modified photo with another one Please note that this project requires utmost attention to detail to ensure that the final product looks as natural as possible. As it carries emotional significance, it's paramount to handle this task sensitively and respectfully. Ideal candidates should have significant experience in advanced photo editing techniques such as object adding, background removal, and image merging. Please provide evidence of similar p...

is New York based Ecommerce company involved in processing of online print orders since 2010. Key Responsibilities - We are looking for AWS Linux Web Administrator to set up new and modify the existing AWS EC2 instance running Laravel application on Bitnami LAMP stack. Set up new dev server on AWS or Digital Ocean. Skills and Experience: - Minimum 3 years verifiable experience as Linux Web Administrator in creating and managing existing and new LAMP EC2 instance. Laravel application hosting experience preferred. Duration: Permanent: assignment and based on completed work items

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work...

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

...I have, creating a seamless transition. The desired outcome is a final product that smoothly flows from one song to another, maintaining the integrity and flow of each. Key Responsibilities: - Merging two songs into one cohesive MP3 file - Achieving a seamless transition without disrupting the original tracks Ideal Candidate: - Extensive experience in audio editing, particularly song merging - Proficient in relevant music production software - Creates high-quality MP3 formats - Strong attention to detail to maintain the integrity of the original songs - Evidence of previous similar work would be a significant advantage Please note, there's no need to emphasize any particular sections from either song. The focus here is on the seamless transition. Beautiful ...

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include...

I have a PES file that needs to be converted into a satin stitch. The original design is available in another format, so you can work from that. Key Requirements: - Convert PES file to satin stitch - Multiple size outputs are needed Ideal Skills and Experience: - Proficient in PES file format - Experience with converting designs to satin stitch - Able to handle multiple size outputs Please bid if you have the skills and experience necessary.

I'm looking to create an appealing short video commercial for our English Summer School that will be shared across social media. The aim of this video is to increase enrollment and, while doing so, provide some information on the specific attributes of each of our five branches. The successful freelancer should ideall...information is clear and easy to find. Variety: Showcase a variety of activities and age groups to appeal to a wider audience. With your keen eye for detail, craft the story in such a way that it caters to all our branches while highlighting the unique features of each one. If you're a video creator with a knack for educational promotions, we'd love to hear from you! (note that we are creating Arabic and English version of this video, as well as ...

I'm in need of a professional web developer to create a basic website for managing workplace shift schedules. It is enough that this project has the qualifications to do the job. I am leaving a few photos so that you can have general information about the project design. It is sufficient that at least the texts that will be seen in the UI be in Turkish. Key Features: - Employee login and registration - Comprehensive shift scheduling and management tools - Facility to view and edit shift details - User access restrictors based on roles The web platform should be designed with a professional and corporate aesthetic, ensuring it's not only functional but visually appealing to users. Ideal Skills and Qualifications: - Proficiency in web development, particularly with SpringBoot :...

I'm looking for someone who can create a WordPress plugin for scraping manga websites. Plugin Requirements: 1. Grab per chapter by link. 2. Grab full chapter by link. 3. Grab new manga by link. 4. Compatible with various manga themes. 5. Images from the scraped content should be uploaded to s3 storage. 6. Must have 10 sources for scraping (with a guarantee that if one source fails or the website goes down, it can switch to another source). Usage Flow: 1. I create a manga post and fill in the manga link in the metabox. 2. The plugin will automatically fill in the chapter links, scrape HTML images, and create posts. It will also automatically fill in the chapter number and the manga post ID number based on the manga link. Note: Speed during scraping is very important.

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

I'm in need of a talented audio professional to help me clean up a series of speech-based audio files. These files suffer from significant background noise, specifically static or electronic noise. This noise needs to be removed, without compromising the speech content. Key responsibilities: - Identify and isolate the static or electronic noise. - Employ appropriate tools and techniques to clean the audio. - Deliver high-quality audio files free of noise. Ideal candidate: - can use AI - Proficient in audio editing software such as Audacity, Adobe Audition, etc. - Previous experience in cleaning audio files, especially speech. - Strong attention to detail. - Able to work efficiently and meet deadlines.

I have an excel file, need add product categorie on a column - budget 100€

Hello, Looking for someone to create video ads from a mobile game, you will need to play the game, get footage from and then give me 5 horizontal video and 5 vertical ads each video needs to be between 15-30 seconds long If you understand that you need to create everything from scratch and can do it in a short time frame please type GREEN at the beginning of your proposal. Proposals without it will be ignored.

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analy...

...person that is patient and is willing to slowly prove that they are better, more capable and "hungrier" than the people we currently are using. We have grown from one, to many locations in two years, and we need to upgrade the team with competence. Marketing wise, we rely over 90% on inbound calls from Google. We want to increase our platforms to include Bing, Yelp Trip Advisor, and so on... We also want to work closely to get really high ranked backlinks (preferably not a birdwatcher's blog from Siberia with 2 followers). Everything we post is authentic, including pictures, AI and videos. We never want to see a cross-post on another website anywhere in the world of the same picture, no stock photos, only unique pictures and contents. We, as...

Hello, I need complet the Amazon categories catalogue excel in french

I'm in need of a talented animator to create a moderately complex lottie animation for my app. The animation should embody a dancing movement and will be primarily used for loading screens within the app. We want to create two different lottie animations using this set of characters. One animation where they are all dancing around, and another where they all dance accross the screen in sequence. Key Requirements: - Dancing Animation: The animation should feature a dance movement, providing an engaging and lively loading experience. - Moderately Complex: While I'm not looking for a highly intricate animation, I do want the work to be more than just simple and minimalistic. The balance between complexity and performance is crucial. - Loading Screen Usage: The animation wi...

Hello, I am looking for a skilled Shopify developer to customize the "Wookie" theme on my Shopify store. I have created a 'trustbar' using the icon banners functionality, which looks great on desktop. However, on mobile devices, the icons stack on top of each other and do not display well. Requirements: Mobile Customization: Transform the current trustbar into a carousel that slides horizontally on mobile devices only. Desktop Integrity: Ensure the trustbar remains unchanged and looks great on desktop. Responsiveness: The carousel should be fully responsive and maintain the visual appeal of the icons. Cross-Browser Compatibility: Ensure the carousel works seamlessly across all major browsers on mobile devices. Clean Code: Write clean, well-documented code that does n...

I need a professional who can extract data from a website on a daily basis. Key Responsibilities: - Extracting data from a specified website - Ensuring the data is accurate and up to date - Delivering the data in a specified format Skills and Experience: - Proficient in web scraping and data extraction - Experience in automating data extraction processes - Ability to maintain data accuracy and consistency - Knowledge of relevant data formats for delivery - Strong attention to detail and reliability This is an ongoing project, and I need someone who can commit to daily extractions. Be sure to include relevant experience in your bid.

I'm seeking a WHMCS module that facilitates direct connection between my .in domain registry and WHMCS. It's built on the Neustar toolkit for registrars. For reference, I've included a link to an existing module developed by another party: I'm looking for a similar module without licensing restrictions and at a more affordable rate than the one listed.

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

...someone who can use their industry knowledge and connections to secure the most competitive air freight rates while maintaining the quality of delivery services. The air-shipping rate we’re looking for is $5 per 1 kilogram. - Air-Shipping Time Duration: We’re looking for air-shipping time duration between 1-14 days. - Final Destinations: To make sure the shipping company can deliver the product from China till our clients doorsteps in GCC countries. - Efficient Handling Of Electronics & Clothes: You should be well-versed in handling electronic goods and clothes to ensure they reach their destination in optimal condition. - In-Depth Knowledge Of GCC Customs Regulations: You should be familiar with the customs regulations of Saudi Arabia, United Arab Emirates, B...