Excel vbaemplois

I'm currently in need of a Python developer with a specialization in CV2 (OpenCV) for the following task: Make a website plugin of a jewellery try on using Python. When the user clicks an image of themselves and chooses a jewellery pr...Strong background in algorithms related to image processing and object detection. - Ability to work independently on complex data analysis tasks. **What I'm Looking For:** A developer who can deliver efficient code with clear documentation. The ideal candidate should also be able to provide insights and suggestions for best practices in image-based data analysis. This project is for those who excel in translating complex image data into actionable insights. If you’re ready to tackle challenging problems with creative solutions, I&rs...

I am looking for a freelancer who can help me with converting an Excel file into a SQL SharePoint database. The purpose of the database is to track inventory. We are looking to put into a web based format which can be searched, and have links to each category, as well as export results to excel and pdf. Each item will be able to be edited, and deleted. - Ideal Skills and Experience: - Proficiency in Excel, SharePoint, and SQL - Experience with SharePoint and database management - Strong attention to detail and ability to accurately convert data - Knowledge of inventory tracking systems is a plus SEE ATTACHED The database should have a specific structure or format as per my requirements. I have a clear idea of what I want, and I need someone who can create i...

...initially as a simple Excel format. I'm looking to start basic and then turn it into a comprehensive cloud-based CRM system over time. Key Features: CRM system where we can store customer information, identify their circumstances where we can help them with our wide variety of products. Product details insurance, Tax saving products, Real estate, Relocation - Contact Management: Efficiently store and manage customer information. - Sales Tracking: Monitor and record sales transactions. - Task Management: Keep an eye on various tasks and their progress. Design and Layout: I prefer a simple and minimalist layout that is easy to navigate. Reporting Capabilities: Initially, the system should generate task progress reports. Skills and Experience: - Proven experience in crea...

I need a competent professional to transform a PDF into an Excel file. Key requirements of this project include: - Extracting images from the PDF - Placing these images inline with the relevant text in the Excel file - Keeping images in their original size You should be skilled at not just converting text, but also images from a PDF document into an Excel file. An eye for aesthetic arrangement and managing formats would be highly advantageous for this project. Knowledge and experience with both PDF and Excel platforms are vital for the successful completion of this task.

I'm looking for a highly skilled Excel macro specialist to elevate my project to the next level with a focus on data entry automation, sophisticated formula and function integration, and detailed error management. The right freelancer will bring a blend of technical expertise, attention to detail, and problem-solving skills. **Key Tasks:** - Develop an Excel macro that automates data entry, reducing manual efforts. - Integrate complex formulas and functions to manage and analyze data seamlessly within Excel. - Implement an error handling mechanism that logs details of any unexpected inputs for later review, ensuring data integrity and accuracy. **Ideal Skills and Experience:** - Profound knowledge of Excel and VBA (Visual Basic for Applications). -...

I'm seeking an Excel expert who can revamp an existing pricing spreadsheet, making it more visually appealing and functional for our estimators. The ideal freelancer for this project will have a strong background in Excel interface design and formula creation. **Key Improvements Desired:** - **Improved Color Scheme:** The spreadsheet should utilize a coherent and appealing set of colors, making it easier to navigate and use. - **Clearer Formatting:** I need the current layout to be reorganized for clarity. This means better alignment of fields, more intuitive positioning of sections, and clearer demarcation between different areas of the spreadsheet. - **Enhanced User Interface:** The overall user interaction with the spreadsheet should be straightforward and efficient....

I'm seeking a VBA expert to streamline my document handling process. This project will involve developing a script to automate the extraction of specific keywords from PDF files and then reorganize these files based on references found in an external document. Key Requirements: - Deep understanding of VBA programming, specifically for file and text manipulation. - Experience with PDF file structure to ensure accurate keyword extraction. - Proficiency in reading data from external documents (e.g., Excel or CSV) to use as references for file organization. Ideal Skills and Experience: - Proven track record of automating tasks within Windows environments using VBA. - Ability to parse and extract text from PDFs efficiently. - Experience in handling file opera...

I excel in Google Sheets and Script, crafting a dynamic report maker for financial, survey, and inventory data. My expertise ensures real-time interval calculations, updating every 5 minutes. With a focus on user-friendly design and seamless auto-refresh, your project gains precision and efficiency in data management. Thanks

I need you to search the internet (NOT any website in particular, but the internet (the worldwide web) in general), get data, and put it in an Excel sheet I will provide the Excel sheet

...of my daily tasks. However, I am unable to spare as much time as I'd like for this work. Thus, I need a freelancer with strong skills and experience with Excel to complete some data entry tasks. The spreadsheet I will provide is moderately complex with multiple columns and entries. However, the specifics of what software needs to be utilized were not mentioned. This project could include Excel, Google Sheets, or OpenOffice Calc, but the choice will be based on the freelancer's tool accessibility and proficiency. Primary skills and experience needed: * Advanced knowledge of spreadsheet software (not necessarily limited to Microsoft Excel) * Prior experience in spreadsheet data entry, specifically handling multiple columns and entries. * Strong attention ...

We are seeking a skilled Quantity Surveyor to ...surveyors to maximize efficiency and productivity. - Adhere to predetermined project requirements and specifications. Requirements: - Advanced Excel skills and ability to understand how excel spread sheets work. - Advanced Blue Beam Skills - Proven experience as a Quantity Surveyor or similar role in the construction industry. - Proficiency in quantity surveying software and tools. - Strong attention to detail and accuracy. - Excellent time management and organizational skills. - Ability to work collaboratively in a team environment. If you are a dedicated Quantity Surveyor looking for an opportunity to contribute to dynamic projects and excel in a collaborative environment, we encourage you to apply and become a valu...

I need help with an ...converting these questions into a very specific Excel format suitable for bulk uploaded questions / answers in the Flexiquiz website, which will be a mix of different formats as each question paper differs. - Ensuring the extracted data aligns perfectly with the Flexiquiz interface for a seamless upload and functioning as quizzes. Given the urgency of the task, freelancers with a quick turnaround time are preferred. Essential skills for the job include: - Quality of work, ensuring all Qs, the choices and answers are extracted correctly in the specific Excel format I will provide from FlexiQuiz Completion of the project is needed ASAP. Proven experience in similar projects will be a plus. I have done 2 questions from a sample question paper in the ...

i need help with IF function - line graph not dropping to 0 like other lines

...toward generating comprehensive property inspection reports. This app is tailored specifically for iOS devices, aiming to streamline various inspection processes by offering detailed and easily customizable performance reports. Key Features Required: - Customizable inspection templates. - Capture and integrate photos and notes into reports. - Generate and export reports in multiple formats (PDF, Excel, etc.). - User authentication and role-based access control. Ideal Skills and Experiences: - Proficiency in iOS app development (Swift/Objective-C). - Experience in creating data-driven applications. - Strong UI/UX design capabilities, focused on ease of use. - Knowledge of integrating with external APIs and databases. - Previous work on apps dealing with data collection and rep...

...implement an Excel-based reporting system that provides daily updates. - Ensure reports are clear, concise, and offer actionable insights. **Ideal Skills and Experience:** - Strong expertise in Excel, including advanced functions, formulas, and pivot tables. - Proven experience in data analysis and reporting, particularly with financial and sales data. - Ability to interpret complex datasets to provide clear, actionable insights. - Experience in automating Excel reports is a significant plus. - Excellent communication skills to translate data findings into understandable documents. This project demands attention to detail and a deep understanding of data analysis within Excel. If you have a background in finance or sales data analysis and are proficient in ...

I'm looking for an expert in data entry who is proficient at typing information from images into an Excel spreadsheet. Here is an overview of the project: - Task: Read and extract both text information and numbers from a collection of 155 images. - Create a structured Excel sheet that captures the extracted data accurately. - Apply appropriate data cleaning and formatting as you work. The ideal freelancer for this project should possess strong attention to detail to ensure accuracy, and preferably have some background in data analysis. Prior experience in similar tasks will be considered a strong plus. I trust you are up to the task, and I'm looking forward to your bid. Detail: These 155 images have an average of about 4 transactions per image. On each,...

Description: We are seeking a detail-oriented freelancer to help complete an Excel sheet containing approximately 2000 cricket player names. The current list includes partial or abbreviated names, and your task will be to research and fill in each player's full name accurately. Objectives: Use Google search or any reliable cricket database to find the full names of cricket players listed in the provided Excel sheet. Ensure the accuracy and completeness of each name. Update the Excel sheet with the full names in the designated column.

I'm in need of a person or team with sophisticated scraping technology and experience to extract data from the IP India website. My needs are specific and time-sensitive: - Data Needed: I require full name, contact details, and the registration status of active registered members. Inactive members are not necessary. - Output Format: The resulting dataset should be provided in an Excel spreadsheet, with appropriately labeled columns for each piece of data. - Timing: This project is of the utmost importance and needs to be done as soon as possible. Ideal candidates for this job will have experience in web scraping, data extraction, and data organization. Familiarity with the IP India website would be an added advantage. I look forward to seeing your prompt bids.

I am looking for a freelancer to use my excel spreadsheet to search for the company/agency homepage URL and Facebook site URL and paste it into the specified columns, there are approx 110 unique companies that need the website locating.

I'm looking for a talented freelancer to create a custom random number generator for me. Here's what I need: - **Development in Matlab or Excel**: - **Whole Number Generation**: It should exclusively generate whole numbers. - **Specified Range**: Numbers generated must fall within a specific range that I will provide. - **User-Friendly Interface**: While the backend is complex, I'd appreciate a simple, user-friendly interface for initiating the generation process and viewing results. **Ideal Skills and Experience**: - Proficiency in Matlab or Excel is mandatory. - Experienced in developing custom functions and formulas in Excel. - Skilled in building user-friendly interfaces. - Understanding of random number generation algorithms and their implementat...

I require a proficient Excel user who can apply conditional formatting to detect duplicate content within two rows. The task specifically demands: - The experience in working with data manipulation and condition-based functions in Excel. - Highlight duplicate content using a change in background color. - The color should be red to highlight any duplicated content. The ideal freelancer should possess a strong proficiency in Excel and look out for accurate and detail-oriented work. Please see attached example. As you can see the content in D6 and E6 match with another row, D7 and E7 should change colour to Red. In the example E13 does not change colour as the contents in D13 does not match any other cell in column D.

I'm looking for an experienced freelancer to help in analyzing a dataset and to provide clear, concise insights through descriptive statistics. The analysis should be comprehensive and cater to my project requirements. Here's what I need: 1. **Data Understanding and Cleaning**: The data is currently in a spreadsheet format (Excel, Google Sheets). I expect you to have experience in handling and cleaning data from spreadsheets to ensure accuracy in analysis. 2. **Descriptive Statistics**: Perform detailed descriptive statistics to summarize the dataset's main characteristics. Your expertise in using statistical tools and interpreting results is crucial here. 3. **Visualization**: Creation of charts and graphs is required to depict the findings visually. These visua...

I am looking for a PowerBI expert who can integrate Excel spreadsheet and visualize sales data with a quarter on quarter analysis approach in an interactive and easy-to-understand way. - The main source of data is Excel spreadsheets, specifically sales data. The ideal candidate should be capable of handling, cleaning, and organizing this data effectively within PowerBI. - The ultimate goal is to have a dashboard that would effectively present the sales data trends analyzed on a quarter on quarter basis. I am expecting the output to be in a detailed, clear and easy-to-comprehend manner. - Capabilities in PowerBI, Excel, data modeling, and establishing relationships between multiple data sets will be essential for this role. - Prior expertise in data visualization, and ...

I'm searching for a competent web scraper adept in utilizing Python, JavaScript, or Ruby for my project. The main object...Category (niche) - Company Name - Address - Email Address (if available) - Phone - Website - City - State - Post Code - Latitude (optional) - Longitude (optional) - Map Link etc. Feel free to share your previous experiences or techniques that set you apart. The winner will not only receive recognition but also have the opportunity for future collaboration. Submit your entry, and let's see who can excel in this web scraping challenge! Note: this is a paid contest test with the possibility for a long-term role and work to join team collecting data across websites and directories’s tell me what sites you can scrape data from I need all of the abo...

...create a subscription-based Excel add-in focused on automating repetitive tasks, enhancing productivity for users across various industries. This add-in needs to be backward compatible, functioning seamlessly across all versions of Excel, including Excel 2016, Excel 2013, and newer versions. **Core Requirements:** - Devise an add-in compatible with all Excel versions, providing a robust solution to automate repetitive tasks within Excel sheets. - Implement a subscription-based model for users to access this add-in. - Ensure high performance and reliability across a broad range of Excel versions without compromising functionality. - Prioritize user-friendly interfaces to facilitate ease of use for non-technical users. **Ideal Skills and...

I'm seeking a skilled freelancer to design a comprehensive MS Excel test, aimed at evaluating candidates' proficiency in Excel. This test is intended to cover three critical areas of Excel proficiency: - Formulas and Functions: Candidates should be tested on their ability to apply and understand Excel formulas and functions effectively. - Data Analysis and Visualization: This section will assess candidates' skills in analyzing data and creating meaningful visualizations. - Pivot Tables and Charts: The test should measure aptitude in creating and managing pivot tables and developing insightful charts. The exam will consist of 25 questions, blending different types to ensure a thorough assessment: multiple-choice, true or false, and possibly...

...requirement is to extract a specific data table containing employee information and have this data presented in an Excel spreadsheet format. This task is to be done as a one-time project. **Key Requirements:** - **Data Extraction:** Retrieve employee information from the Oracle R12 HR system. - **Format Requirements:** Organize and present the retrieved data in a clear, structured Excel spreadsheet format. - **Project Timeline:** This is a one-time task, expected to be completed with efficiency and accuracy. **Ideal Skills and Experience:** - Proven experience working with Oracle R12 HR systems. - Strong proficiency in data extraction and manipulation. - Expertise in Excel, including formatting and data presentation. - Attention to detail to ensure data accuracy...

Excel VBA Expert needed : Not for beginners. Need to do tasks with following features, 1. Finding lengthy cell 2. creating columns dynamically, based on given value 3. applying formulae I will give tasks one after another, I can't explain all the tasks at once, so you don't bid and ask for list of tasks. Please bid, only if you can accept award and start project without asking about the tasks. Note: All tasks can be achieved in VBA, you can always skip the tasks which you couldn't do.

I need someone skilled in Microsoft Excel 2019 to assist me with converting a basic Word table into Excel format. I have a table with a number of rows and columns in Word with pictures and need this transfered to Excel. The pictures in excel need to hide with the row when you filter data

I am seeking an highly experienced indivi...extract both questions and answers data, where the exact website will be disclosed upon selection of the suitable freelancer. The ideal candidate for this project shall possess: - Relevant background and experience in web scraping - Capability to deliver meticulous and accurate results - Efficiency in handling multiple tasks under minimal supervision Deliverables to Include: - A comprehensive Excel document showcasing the scraped Q&A data - Assurances that the scraped data is complete and reliable I would appreciate freelancers to include their experience in their applications. I'm keen to collaborate with a seasoned freelancer who has an eye for detail and quality, and can maintain the utmost discretion regarding this task and...

I need someone skilled in Microsoft Excel 2019 to assist me with converting a basic Word table into Excel format. I have a table with a number of rows and columns in Word with pictures and need this transfered to Excel. The pictures in excel need to hide with the row when you filter data

More details: What format is your dataset currently in? Excel How do you want the final dataset to be delivered? In the same Excel format Do you require any specific analysis to be performed on the dataset? Statistical analysis, Visualization of data

our company a leading firm in the construction and real estate sector, is seeking a highly organized a... Ideal Candidate: You are detail-oriented, with excellent organizational skills. You have strong communication abilities and are comfortable working with multiple stakeholders. You possess basic technical skills, including familiarity with WordPress and workspace management systems. You are looking for an opportunity to grow and take on new challenges. If you believe you have what it takes to excel in this role and are excited about the prospect of growing with Skywide Construction, please reach out to us. Send a message expressing your interest, and we will provide you with further details regarding the interview process. We look forward to discovering how you can contribute t...

...database. Here’s a breakdown of what I need: - **Speed Optimization:** My current Python application is functional yet sluggish. The core objective is to reduce execution time without sacrificing functionality. Expertise in algorithm optimization, efficient data structures, and multi-threading is essential. - **Database Integration:** The application requires seamless communication with an excel database. This involves both optimizing existing database interactions for speed and potentially re-architecting the way data is stored and retrieved to improve performance. **Ideal Skills and Experience:** - Proficiency in Python, with a strong grasp of its nuances and best practices for performance enhancement. - Extensive experience in database integration with Python applic...

I'm looking to synchronize my constantly updating Excel data with an Android app to display the numerical values in as it is. These are the specifics of my project, along with the qualifications and experiences ideal for the job. **Data Display:** - The main requirement is for numerical data from an Excel sheet, which updates every minute, to be displayed in table format within the Android app. This requires efficient and dynamic data handling to ensure real-time representation. **Data Synchronization:** - I prefer an automatic real-time database update mechanism to reflect Excel data changes instantly in the app. This process should be seamless, requiring no manual intervention for uploading or updating the Excel file. **Access Control:** - I need to as...

... It's crucial for the setup to be easily updatable by me or my team, as prices change. **Key Requirements:** - Proficiency in Microsoft Word, including the use of templates and advanced formatting. - Experience in creating easy-to-update documents. - Ability to design clear, user-friendly layouts that reflect our brand’s style. - Knowledge in integrating tables, and possibly links or embedded Excel sheets, for easy data updates. - Understand the importance of aligning the document with the company's existing branding and format guidelines to maintain consistency. -Please add graphics for each treatment option **Ideal Skills and Experience:** - Graphic design skills to ensure the price sheets are visually appealing. - Strong attention to detail to prevent any e...

I am seeking an expert to facilitate the development of an efficient Office 365 List for tracking project packages of work. The ideal freelancer will have strong experience in managing Office 365 Lists and a sound understanding of Excel. Key aspects of this project include: - Developing an Office 365 List as a tracker for project work packages, including information like who is assigned, timelines, descriptions, and current status. - Bridging Excel spreadsheets and Office 365 Lists, requiring expertise in data importing from Excel into the 365 Lists app. Working proficiency in handling these types of tasks is essential as correct execution is pivotal for our project's success. Experience in creating Gantt charts, Kanban boards, and task lists will be benefici...

I require a standalone MATLAB app that serves as a simulation tool. The tool should accurately simulate 3D face mapping, with a key emphasis on the ability to create a color map based on values imported from Excel. The skills required are MATLAB expertise and a strong understanding of 3D face mapping techniques. Experience with Excel data integration is useful. Understanding of color mapping is also essential.

...be due per the schedule in the detailed class schedule spreadsheet. These are noted in Camino as well. Each submission of the report must be on the due date. Late reports/documents may not be accepted. These are part of the practice exercise for Mike's Bikes. Each set of two Individual Rollover reports is worth 5 points for a total of 10 points. However...in addition... ...For students who excel in increasing their shareholder value by the 8th rollover, extra points will be awarded on the following scale: >/= $100/share: 15 points >/= $130/share: 30 points >/= $150/share: 60 points >/= $175/share: 90 points...

I'm looking for a creative and skilled videographer/editor to create a captivating, less than 1-minute video to promote a product/service. This fast-paced, engaging video should effectively communicate...- Experience creating promotional content for brands. - Ability to work with tight deadlines. To make your application stand out, please include: - Examples of past work, especially short promotional videos. - A brief description of your relevant experience. - A detailed project proposal outlining how you would approach this project. This project presents an exciting opportunity for those who excel in producing content that not only informs but also enthralls. I'm looking forward to seeing your creative approach to bringing our product/service to life in a concise yet po...

I am seeking a meticulous freelancer who can carry out my data entry project. Your task will be entering vital textual data, which encompasses both standardized and varied fields. The output should be delivered in an efficiently organized Excel spreadsheet. You will need strong attention to detail and proficient Excel skills. Familiarity with different data fields is paramount. Various spreadsheets will be provided. Read only access to a database will be provided. A spreadsheet will be provided with account numbers. The account number will be looked up using read only access to our software. From the software, will need to enter First Name, Last Name, Date of Birth, Gender, Account Number will need to be added to a second spreadsheet. Data one field from the source sprea...

I'm looking for a Microsoft Access expert who can design and implement a dynamic form for me. This creation should offer the ability to enter multiple records into a table whilst providing the functionality to update pre-existing records. The successful freelancer should have: - Profound understanding and competence in Microsoft Access and VBA - Experience in form designing in Microsoft Access - Skills in data validation procedures The form should be able to collect and validate the following details from users: - Name (required) - Email (required, and in valid email format) - Phone Number (required, and in correct phone number format) - Additional User Information (required) In addition, this form should have an update feature for previously entered records which primary ...

Project Duration: 2.5 Hours Project Type: WordPress Data Entry Data Entry Type: Copy & Paste Project Difficulty: Easy Number of Pages: 110 Project Workflow - Login as WordPress admin - Visit our excel sheet - Open the webpage url in column D - Press the “Edit Page” button on the top admin bar & the page will open in admin mode - Go to the last paragraph on the page. - If the last paragraph includes the term “software”, putt “YES” in column E of the spreadsheet - Copy ONE promotional passage from Google Doc 1 & paste it above the first paragraph in the WordPress Editor - Underneath the passage you have just paste, write the following text in Heading 2 styling: “Frequently - Asked Questions” - Find & copy the relevant ...

I'm on the hunt for a proficient Excel guru to help me build a comprehensive workflow sheet. The pivotal feature is seamless auto-population from one sheet to another, instigated by specific triggers. This should not only expedite our data entry process but also significantly reduce manual discrepancies and boost our efficiency. Skills and experience required: - Advanced knowledge of Excel, especially in utilizing complex functions such as Index Match and Array Formulas. - Demonstrated professionalism and skillset in data management. - An ability to creatively solve problems, ensuring the Excel workflow is dynamic, user-friendly and efficient. Your application will stand out if you include your experience with similar projects and how you have used Excel's ...

...and integration Experience: - Minimum of 3 years experience with backend development - Proven track record of delivering high quality backend systems - Experience with low load optimization - Strong problem solving and analytical skills Requirements - Email should trigger with confirmation of reciving request once user click on contact us. - if user is uploading documents (pdf, Excel and images) in contact us template then it needs to be stored in S3 with limited access to these files according to roles. - ability to chat/comment through ticket between end-user and support team. - notification framework for realtime notifications for support agent roles for assigned services/tickets updates. And notifications for end user for updates on creates services - Ope...

the customer name and address u add in first tab and click the button, it will be added to both other tabs with sorted order, where u can then add notes or Mark

In need of a freelancer experienced in Microsoft Excel for creating an efficient spreadsheet specifically designed for handling text. No formulas or calculation required. They need to be created from Scanned documents. I have four in total with 6 scanned pages. it can be one workbook with four tabs or four separate books I don't mind. Key Highlights: - Software to use: Microsoft Excel - Type of data: Textual data - Additional Requirement: No requirement for any formulas or computations. Ideal candidates would be those who have a comprehensive understanding of data formatting in Excel, to replicate the scanned documents. Previous work with textual data is a plus.

...acquiring comprehensive details about various universities to populate an existing Excel spreadsheet. The task requires meticulous entry of data into predefined columns, ensuring accuracy and completeness within a tight deadline. **Key Requirements:** - **Data Collection**: Efficiently gather information regarding university names, admission details, application deadlines, program start dates, and tuition fees. - **Precision and Accuracy**: Ensure data entered is correct and aligns with the specific format of the spreadsheet. - **Timeliness**: Complete the project within a month, adhering to the given timeframe without compromising on the quality of work. **Ideal Skills and Experience:** - Proficient in Excel with a keen eye for detail to avoid any errors during data...

I'm in need of a freelancer who can skillfully manage Excel data entry tasks with a focus on financial records and inventory lists, which require a moderate understanding of complex data structures. My project involves not only simple data entry but also the application of intermediate to advanced Excel functions to organize and analyze the data effectively. Key Requirements: - Strong experience with Excel data entry, specifically with intermediate data such as financial records and inventory lists. - Proficiency in using and applying intermediate formulas (e.g., VLOOKUP, INDEX/MATCH) to real-world data sets. - Ability to create and manipulate PivotTables for data analysis and visual presentation. - Experience with Data Analysis Toolpak is a plus, for more in-de...

I'm in need of a meticulous freelancer to perform a data entry task. Please read the task description carefully I have an excel spreadsheet containing a list of songs (song name and artist name) and corresponding youtube video URLs. The problem is youtube often has many different versions of the same song The previous freelancer did not always do a good job choosing I need you to go through the list in that excel file, and, for each song, click on the url to load the youtube video. First step is to determine if the excel url is a video of a live/concert version (where you can see people performing the song). If it is, and only if it is, try to find another version, by searching youtube using the song name and artist name as search keywords. A good version is ...