Excel vba withdela

I am in need of a professional who can remove duplicates from two columns in an Excel sheet, based on numbers within a third column. I'd like this task to be completed within four hours. Here are the details: - Target Columns: I need duplicates removed from columns B and C in the spreadsheet. - Duplicate Criterion: The duplicates should be determined based on the numbers present in column A. - Urgency: The task needs to be completed within a span of four hours, so time efficiency is crucial. For projects #s in column A with the same #, delete the duplicate email addresses in column B. Independently of Column B: For projects #s in column A with the same #, delete duplicate email addresses in column C. For example in Column A if there are four identical project #...

I'm seeking a skilled Excel VBA macro programmer to automate a particular repetitive task: data entry. Don't worry about what kind of data, that won't be necessary for your task. Your Mission: - Automate repetitive data entry tasks with the VBA Macro Ideal Candidate: - Proficient in Excel and VBA Macro programming - Experience in user interface design and interaction - Ability to understand and complete task efficiently - Experience with automation of similar tasks Please provide your timeline for completion when discussing your proposal.

Looking for a professional service to handle deliveries of small and lightwei...to handle deliveries of small and lightweight packages. The role involves delivery duties with an emphasis on customer service and safety compliance. Key Responsibilities: - Handle delivery of small and lightweight packages - Follow all special handling instructions provided - Accomplish deliveries within the stipulated time frame Ideal Candidate: - Proven experience in a similar role - Excellent understanding of customer service protocols - The ability to handle sensitive items with care This role is perfect for individuals with previous courier, package handling or similar experience who are meticulous, responsible, and service-oriented. Apply now if you believe you have what it take...

...extension that can aptly validate data found in an Excel document and then generate a JSON response. Ideally, the freelancer should have prior experience in Chrome extension development and working with Excel and JSON data formats. Requirements: - The extension should accept Excel xlsx files as input. - Data checks need to be done including validation for data types and required fields. - The extension should be able to validate GST data in terms of its number, CGST, SGST, and IGST rules. - The generated JSON response from this validation should be formatted as an array of objects, ready to be uploaded to the server. From all the above, it is clear that the ideal candidate must be highly skilled in Chrome extension development with deep know...

I am looking for an experienced HR freelancer to take on a multitude of HR-related tasks. If you are someone with a 2-5 years experience in the field, this may be the perfect project for you. No formal certification is required, so long as you've got the hands-on experience and knowledge. Responsibilities: - Employee Recruitment: Identifying talent and hiring employees that will be a great fit for my organization. - Performance Evaluations: Assessing employee performance and providing feedback to help them improve and excel. - HR Policies and Procedures: Assisting in the creation and implementation of HR policies, ensuring they are fair, compliant and beneficial to the overall work environment. Ideal skills: - Solid understanding of HR practices and labor legislation...

I'm in urgent need of an Excel macro to bulk update and reset certain parts of a file path to links in my .xlsx (Excel Workbook) files. The parts of the file path that require modification includes the file name, folder name and also the drive letter. The macro should be able to identify the relevant parts of the file path using case sensitivity. Ideal Skills and Experience: • Proficiency in Excel Macros and VBA • Ability to implement case-sensitive text operations • Experience with file operations in EXCEL, especially with .xlsx files Job Description: • Create an Excel macro for .xlsx files • The macro must reset file name, folder name and drive letter of file paths • Use case sensitivi...

I need an accurate and proficient data entry expert to help me with numeric data entry. - Your task will be to input large volumes of numeric data into spreadsheets - This role requires 98% accuracy as it is critical for my work - Experience in using Excel or similar software is a must - Strong attention to detail will be extremely beneficial - A proven track record in numeric data entry will be highly regarded Your role will be important in ensuring that all data is correctly and accurately captured. I am looking forward to your proposal for this project.

Hi Ahmed H., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I'm in need of an experienced Excel specialist to create a user-friendly contract tracking system. This system is required to have the following functions: • Automated alerts and notifications: The tracking system should automatically alert the user about important details and updates related to the contracts. • Report generation: It should have the capability to generate concise reports to provide clear and precise insights regarding the contracts. For creating and fine-tuning this system, the successful freelancer should possess: • Mastery with formulas and functions: A strong grasp and understanding of excel formulas and functions is essential to ensure the tasks are automated efficiently. • Display proficiency in pivot tables and data ...

I'm i...need of a freelancer who can expertly design a payroll system in Excel, ensuring it has the capacity to print payslips. Any potential freelancer should ensure the system includes: - Employee information - Payroll calculations - Tax deductions Additionally, the following calculations need to be embedded into the system: - Gross salary calculation - Tax deductions calculation - Net salary calculation - Taxable Pay Year-To-Date (YTD) - Pay As You Earn (PAYE) Year-To-Date (YTD) Finally, the system should have the ability to accumulate leave days without affecting the salary. A template of the desired payslip will be provided later for reference. Skills and experience in Excel development, payroll system setup, and familiarity with tax calculation formula...

Automate the following process with Uipath, powerautomate or similar like tool: High level 1 Use an excel file as a settings file, which file to open and for Sharepoint folder location (settings file) 2 Open three excel files which is specified in the 3 For each of the excel files go in excel to the tab Data> and click Refresh all. After that go to the specified tabs in the file for that file and right click on the pivot table to refresh the pivot table 4 Step #3 should be done per file, but the actions performed for the first file should be finished first before starting with the second and third file 5 Go to the specified Sharepoint link (in the settings file), and click on the in the specified excel file and select open in app....

Looking for a large list of investors who have worked in or showed interest in various entertainment industries provide data in excel: name | company | industry | location | email address

I am currently seeking an experienced Excel and Visual Basic (VB) Automation Professional who is proficient in SAP Security. Key responsibilities will include: - Developing and automating report generation and analysis within the SAP Security module. - Automating workflows to enhance efficiency and accuracy. - Leveraging Excel and VB scripting skills to facilitate these automations within SAP. Additionally, localities in Pune are preferred due to the specifics of the project. The ideal candidate will demonstrate a strong understanding of SAP modules, particularly SAP Security, and be adept with Excel and VB scripting. Prior experience with SAP reporting and workflow automations will be highly beneficial for this project.

I'm seeking a skilled data entry specialist to assist in cleaning and formatting a substantial volume of data - more than 1000 entries. This crucial task will involve converting raw data into a more readable and user-friendly format in an Excel spreadsheet. Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail and accuracy - Experience in data cleaning and formatting - Ability to handle large volumes of data Reliability, efficiency, and confidentiality are expected in handling this task. Prior experience in similar projects is highly desirable. Looking forward to your proposals.

As a Python specialist, your mission involves enhancing an existing Llama2 program to operate on Excel files within Google Colab. This project requires just a few hours of work, and a bit of the code is already completed. Key Tasks: - Implement Llama2 for data cleaning operations. Specifically, your role will include: - Applying given formulas to data - Sorting and filtering data according to set parameters Skills and Experience: - Proficient in Python programming language - Familiar with Llama2 - Experience working with Excel file manipulation in Google Colab is advantageous.

I am currently looking for an Excel expert to provide support with certain tasks. These include: • Data Analysis • Spreadsheet formatting • Creation and manipulation of formulas and functions Regarding the data analysis, I am open to suggestions on the best way to present the data. Whether that be through graphs, charts, pivot tables, or summary reports. Your task will be to work with just one spreadsheet that requires this assistance. Ideal Skills: • Expertise in Excel • Strong knowledge in data analysis, spreadsheet formatting and manipulating formulas and functions • Creativity in displaying data analysis Having a high-level understanding of Excel and the ability to display complex data in a simplified, understandab...

I'm seeking a brilliant Excel expert who can help with my moderately-sized project. The perfect candidate should possess: - Experience in data cleaning and formatting. My Excel dataset, consisting of between 1,000-10,000 rows, needs to be professionally cleaned and formatted, ensuring all data is structured immaculately. - Proficiency in data visualization and charting. With the cleaned and formatted data, I would need alluring, easy-to-understand charts and visualizations. An eye for aesthetics and layout would greatly benefit this deliverable. - Advanced statistical analysis and modeling skills - the final stage of the project would involve insightful statistical analysis and sophisticated modelling. A solid grasp of Excel's analysis functions and a...

I need an online web application where our customers can sign up by providing their name, contact number, and email ID. Upon signup, a unique customer ID will be generated, and they will use this ID along with a password for subsequent sign-ins. Once signed in, they should be able to upload Excel files into the application, and the data should be automatically saved into our database will have one internal database table for customer sign-ups and another for the actual information from Excel files that they will upload into the database. The number of tables can vary, and you will decide the designing of databse tables as per the available data , backups, security, indexes . The design must be accurate and flexible, allowing for future scope expansion. Note - Only r...

...this desktop app is to import quiz content (questions and 3 possible answers each) from an Excel spreadsheet and transfer it to Powerpoint. Key Features: Excel to PowerPoint Integration: Seamless importation of quiz content (questions and three answers) from Excel to PowerPoint. Bulk Transfer Capability: Ability to bulk transfer quiz questions and answers at once. User-Friendly Interface: Simple and intuitive UI/UX that requires minimal technical expertise to navigate. Compatibility: Must be compatible with Microsoft Excel and PowerPoint 2016 or later, and Windows 10/11. Error Handling: The application should be able to identify and alert the user to any import errors or formatting issues in the Excel file. Project Requirements: Function...

I'm experiencing various difficulties with my Excel spreadsheet. The problems include formula malfunctions, formatting inaccuracies, and missing or corrupted data. The spreadsheet was created using Microsoft 365 apps for business version 2402. I need someone with advanced understanding of this Excel version to resolve these issues. Key Issues to Address: - Correct misbehaving formulas - Fix formatting inconsistencies - Recover or reconstruct missing/corrupted data Excel functions that need to be recalibrated include VLOOKUP or HLOOKUP where I'm currently receiving 'value not available' errors. Ideal freelancers for this task will have proven experience in advanced Excel troubleshooting, including work with VLOOKUP...

I require a detailed-oriented individual with expertise in data entry to create a comprehensive master file. The task: - Extracting specific fields from provided data sources, namely Excel files and PDF documents. Some files to large drop into upload. - The data to be extracted is unstructured and includes product codes, descriptions, pricing, Wels ratings, and EAN numbers. Ideal Candidate: - Experience with data entry from various sources into a singular master file. - Great attention to detail in order to accurately capture all necessary information. - Familiarity working with Excel and PDF data extraction. - Understanding product related data (codes, descriptions, pricing, Wels ratings, EAN numbers) can be an added advantage. Your ability to ...

...seeking an Excel expert who can skillfully handle formulas and functions. Besides, a crucial part of this task requires dealing with intricate aspects of data visualization to provide me with the best outcomes. Key responsibilities: - Applying complex formulas and functions to optimize the usage of my existing data. - Utilizing your expertise to provide complex formatting for data visualization. Ideal Skills: - Expertise in Excel with a solid understanding of formulas and functions. - Solid experience in handling intricate data visualization in Excel. Experience Required: - Proven experience in utilizing pivot tables for data visualization in Excel. Please apply only if you are confident in your ability to deliver these requirem...

I need a data analyst to thoroughly assess my sales data. The information is stored in Excel and needs to be analyzed urgently to determine key metrics that will enable me to make informed decisions with regards to our vending machines. The most critical details to extract include: - Product sales: Identifying which items sell more than others - Most popular products: Discovering the specific products customers prefer - Sales volume: Understanding our overall sales output The ideal freelancer should be proficient in Excel and data analysis. Previous experience working with sales data would also be advantageous. Time is of essence for this project and would require immediate prioritization.

...requirement for an Excel expert who can modify and add functionalities to my existing macro file. Key Requirements: - You must have a strong understanding of Excel 2016 or higher and its macro functionalities, ideally with previous experience in modification and functionality creation of macros. - Tasks will involve modifying current macro functions and developing new functionalities in line with my requirements. Detailed requirements will be shared with the chosen freelancer. - Time is of the essence in this project. Hence, please bid only if you could commit and deliver the project as soon as possible. If you tick all these boxes, I look forward to hearing from you. Your immediate availability and prompt action are highly appreciated. Let’s...

Prosimo, vpišite se ali se prijavite za več podrobnosti.

...project essentially revolves around data entry into an Excel spreadsheet. ***A list of 275 companies will be provided in an excel spreadsheet and the freelancer needs to find the website and refer to the websites of the companies one-by-one and add their email addresses, name of manager, phone number of the company and the manager. *** The responsibilities primarily involve: - Efficiently entering textual data provided by me into the designated Excel sheet. - Maintaining an organized and understandable layout for the entered information. - Ensuring accuracy in all entered data, with minimal to no errors. Candidates should have a solid background in administrative work, specifically with data entry tasks. Proficiency in the use of Excel is a ...

I'm in need of an adept freelancer who will create an Excel sheet using the logical formulas provided in a PDF file. Here are the key qualifications for this project: - Skilled in translating formulas provided in PDF format into Excel. - Expert in building and debugging logical formulas in Excel. - Experience in applying Excel's capabilities for efficient use of formulas is highly preferred. While the specific pay rates for this project were not mentioned, it's crucial for the freelancer to provide their reasonable rate. Your bid should include your proposed hourly rate, the estimated time needed to complete the task, and any additional costs.

I am seeking a skilled individual to assist in managing my project. The role will be part-time, which will be two to three times weekly and comprises approximately 5 to 6 hours each day. The rol...ensure everything runs smoothly and on time. - Creating Reports: Regular reporting to track progress. - Managing Email Correspondence: Monitor and manage emails, ensuring effective and timely communications. - Assisting with Scheduling: Help in setting up meetings and managing the project calendar. The candidate should have experience in project administration, data entry, and general office tasks. Excellent organization and communication skills are needed. Proficiency in Microsoft Office suite especially MS Excel is preferred. Detail-oriented and can work independently with...

...Microsoft Excel expert to assist in automating two excel worksheets. The goal of this form of automation is to facilitate the calculation of my workers' money balance. The task primarily involves setting up formulas to perform subtraction given that data is well categorized across different worksheets. While the task doesn't require highly advanced functions, it necessitates a good understanding of Excel's simple mathematical operations. Key responsibilities for this project include: * Creating formulas for automating subtraction between two worksheets * Adhering to the set arrangement of the data to maintain order * Ensuring accuracy in the customization of formulas according to the set data fields The ideal candidate should possess: * Solid experience ...

I am looking forward to having a personalized Excel-based attendance and salary system created. This project is for personal use, and I have a specific layout in mind that I'd like to implement. Key Requirements: - The system is to accurately track daily attendance and overtime with a user-friendly interface that allows for easy data input. - In addition, the system will calculate salaries based on the daily attendance and overtime records. It's crucial that it's accurate and efficient to avoid mistakes in pay calculations. - The layout should be simple but effective, making it easy to understand the data presented. Ideal freelancer for this project: - Excellent skills in Excel (including formulas, pivot tables, and spreadsheet management) to ensure ...

I'm in need of a proficient freelancer who can develop Excel sales dashboard updating on a daily basis. The chosen freelancer needs to be capable of tracking: - Total sales - Sales by region - New customers acquisition - Returning customers - Daily, weekly, monthly, and yearly sales - Sales comparison to the previous year - Top 10 accounts by turnover _what visual charts as well for sales Apart from this, I would like the dashboard to be configured to compare current sales data for the day, week, month, and year-to-date with the corresponding periods from the last year. Ideal Skills: - Excel skills - Experience in a similar project - Understanding of sales metrics - Strong communications skills High accuracy and attention to detail are paramount in...

...I require an Excel expert who can create a dynamic salary and attendance sheet for my employees. This sheet should have a feature for tracking employee attendance, and calculating individual salaries based on their hourly rate. Here are the key functions I would like the sheet to perform: 1. Track Employee Attendance: - The ability to record dates and the corresponding employee names. 2. Salary Calculation: - I would like this to be done based on the hourly rate of each individual. 3. Calculate Overtime: - The system should also have an option for calculating overtime. The ideal candidate for this project should have strong Excel skills, outstanding attention to detail, and a clear understanding of payroll calculation methods. Prior experience in developing ...

I'm looking for someone who can fix some simple issues with some ai generated code. It's a simple page which allows a user to quickly select items from a series of boxes. This data is then populated in an exportable Excel spreadsheet. Fix's - the code doesn't currently work properly I want a properly laid out spreadsheet, coloured and easy to read. See code attached.

Hi Lan, I'm keen to get you to do some more company research as discussed. I will need you to do about 8 hours worth of research work for me. I will send you through an excel spreadsheet with the research terms and criteria I am looking for and ask you to populate the appropriate field.

I would need excel table to calculate DDP cost from China. The cost per container and shipments port are variables and it will be changing for example: I would need to calculate transportation costs from Ningbo to for Sur Mer, other time is it is different port. So probably ports has to be in another excel sheet so I can update the transportation routes and costs, same for currency.

I'm in need of a proficient financial expert to assist with the execution of financial reporting and the preparation of financial statements. With your profound skills and background in financial analysis, you will effectively help me map out our financial status. Key Responsibilities: - Financial reporting: Your role will entail crafting comprehensive financial reports that accurately depict our financial standing. - Financial statement preparation: Creating reliable and succinct financial statements that reflect our financial position will be an integral part of your job. Skills & Tools: - Excel Proficiency: I prefer the use of Excel in executing the above tasks, hence an advanced understanding of Excel is necessary for making complex compu...

I'm seeking a skilled freelancer with proficiency in MS Access and VBA to assist with a specific task: building a user interface. The goal is to transition away from our current process, which involves manual input into a form, and towards a more streamlined and automated system. In particular, here's what I need: - Development of a user-friendly interface following a design layout that I have in mind. - The new system should support the simplification and automation of our data entry process to substitute the current manual data entry. The ideal freelancer for this job should have: - Proficiency in MS Access and VBA (Visual Basic for Applications). - An understanding of good UI/UX practices and the capability to implement them. - Previous experien...

...of an experienced Excel developer proficient in creating dynamic dashboards. My project will involve the creation of a dynamic, user-friendly Excel dashboard that maximizes the usability of my data. Here's what I'm looking for: Key Features: - Dynamic charts that adjust based on different variables - Automated data refresh from linked Excel spreadsheets Excel Spreadsheet Structure: Although I'm familiar with Excel, I don't have a specific structure for the dashboard in mind. I would be counting on your expertise to guide the creation of an effective, well-structured and user-friendly interface. Ideally, you should have: - Extensive experience with Excel dashboard creation - Proficiency in creating dynamic cha...

Prosimo, vpišite se ali se prijavite za več podrobnosti.

I need a skilled Excel macro developer to create a macro that adjusts hyperlinks disrupted by One Drive. - The existing issue: - The hyperlinks in my Excel document lead to the incorrect destinations. - The ideal solution: - After running the macro, links should direct to specific webpages or files that I provide. Having a background with similar hyperlink issues, as well as knowledge of One Drive and Excel macros, is crucial for this task. Please note the urgency of this project, it requires immediate attention.

I need a tailored Excel-based AR tracking system with specific features centered around tracking by invoice. The system should: - Enable the tracking of accounts receivable. - Include a detailed view of each invoice, highlighting key data such as the invoice amount and due date. The freelancer who takes on this project needs proficiency in Excel, with an in-depth understanding of invoice tracking and accounts receivable. Previous experience in creating similar systems will be a distinct advantage.

I am in need of a freelancer with proficient skills in online data entry. The work we have in mind involves using Microsoft Excel Online as an entry software. Key Responsibilities: - Perform Online Data entry using cloud-based software - Use Microsoft Excel Online as the preferred software - Ensure accuracy of all data input Ideal Candidate: - Should have exceptional knowledge of Microsoft Excel Online - Prior experience with online data entry - Good attention to detail - Must possess excellent typing speed - High commitment to meet deadlines To successfully carry out this project, a high level of accuracy and speed will be required. Hence, having prior experience doing similar tasks can be an added advantage. This role may lead to more assign...

I need an extensive research conducted, seeking for job postings of Chief Revenue Officer(CRO) or SVP of Sales, SVP of Business Development for software companies located remot...of job boards like LinkedIn, Glassdoor or Indeed. No specific companies are targeted, revealing broad perspective is the key. IDEAL SKILLS: - Excellent Web Research capabilities - Strong understanding of job searching - Proficient in Data Entry and interpretation - Experience in HR, specifically in software industry. REQUIREMENTS: - All job links should be current and active - Submission in Excel format detailing the Company Name, Job Link and Location. - Confidential and respectful handling of the project. This task is perfect for someone knowledgeable about job market trends and has proficiency in web...

Creacion de una herramienta en Excel (VBA) para la generacion de reporte de comisiones y ventas por vendedor.

I'm seeking a proficient individual to transfer data from physical documents into an Excel spreadsheet. The data consists predominantly of names and addresses alongside survey responses and results. Organizational skills, attention to detail, and familiarity with Excel are key. The ideal candidate should have: - Proven experience in data entry and knowledge of Microsoft Excel. - The ability to maintain accuracy, even when dealing with large volumes of data. - Excellent organizational skills to manage and categorize this data in a logical and accessible manner. If you have relevant experience and are ready to start immediately, please apply.

I am looking for a data entry specialist with a knack for numbers and attention to detail. You'll be entrusted with entering numeric data in Excel without a specific format or template provided. Your required skills and experience: - Excel proficiency - Fast and accurate data entry - Experience with numerical data The data inputted will be used for generating reports, so an understanding of report generation would be beneficial. Accuracy and precision are paramount to ensure the correctness of the reports. Let's get those numbers crunching!

I am seeking assistance with the update of a spreadsheet to reflect current year assets and liabilities under ASC 842, the Right of Use. The spreadsheet is complete for 2022, and I need it updated for 2023. To succeed in this project, you should be: - Familiar with ASC 842, Right of Use. - Proficient with Excel, especially in data organization. - Detail-oriented and accurate about financial data. Your mission will be to: - Update the current year (2023) assets and liabilities. - Specifically, the asset values need to be updated. Your expertise in accounting standards, precision with numbers, and proficiency in Advanced Excel would come in extremely handy. Show me your previous work relating to ASC 842, Right of Use, to boost your chances of se...

HR freelancer We are looking for an HR expert to help us locate and recruit talents as per requirement of the project This is a part time, work from home opportunity for candidates looking for a challenging and vibrant career and to grow in the reputed networks in Europe. Eligibility 1. Strong communication skills 2. Ability to travel wi...HR expert to help us locate and recruit talents as per requirement of the project This is a part time, work from home opportunity for candidates looking for a challenging and vibrant career and to grow in the reputed networks in Europe. Eligibility 1. Strong communication skills 2. Ability to travel within Schengen area 3. Soft skills in online research, excel, presentations 4. Quick grasping and learning abilities 5. Confident with g...

I am in need of an expert in the data entry field who will assist me in converting my PDF document into Excel format. Essentially, your responsibility shall be to conduct the following tasks: - Convert a PDF file into an excel worksheet - Organize the transferred data by categorizing business structural information. The ideal candidate will have prior experience in data entry and conversion, including knowledge of both PDF and Excel platforms. High attention to detail and a solid understanding of business structural data are crucial for effective sorting of information by category in the Excel sheet. Your previous experience in handling business structural data will be highly beneficial for this job. Punctuality as well as delivering accurate and quality wor...

...someone proficient in extracting data from tables within JPEG images and digitizing this data into Excel. I have more than 20 images that need this service. The tables are moderately complex, with several columns and rows. The project requires: - Advanced skill in data extraction and digitization - Proficiency in data entry into Excel - Experience with reading JPEG images is a plus - High level of detail and precision Your role will involve, but not be limited to: - Reading and understanding the data in the JPEG images - Extracting this data accurately - Organizing and entering this data in Excel I would appreciate a timely completion of this task, with each table accurately represented in Excel. It's critical that all the detai...