Lookup vba excel 2007 jobs

I need a family budget spreadsheet tailored for a couple. Its primary function is to track income and expenses. The spreadsheet should be able to monitor various types of expenses including monthly bills, daily spending, and unexpected expenses. This project is ideal for someone with experience in creating budget spreadsheets, preferably for couples or families. Excel or Google Sheets expert is a must. It would be beneficial if you can incorporate features that enable easy tracking and analysis of our financial habits. Include charts to visualize the data. Include a feature to track and visualize progress towards savings goals. example:

I'm seeking a seasoned professional to help automate processes related to our 'pinkfish' website project. Key focus areas include: - Data entry: Streamlining input processes to save time and reduce errors. - Email responses: Automatin...processes related to our 'pinkfish' website project. Key focus areas include: - Data entry: Streamlining input processes to save time and reduce errors. - Email responses: Automating customer interactions to ensure consistent and timely replies. - File management: Ensuring all files are organized and accessible, with minimal manual intervention. The ideal candidate will have experience with Excel/Google Sheets, as well as CRM systems and project management software. Skills in web development and knowledge of e-commerce p...

I'm looking for a freelancer who can independently manage and accurately transfer information from various sources into an Excel spreadsheet. The specific sources will include paper documents, spreadsheets, and online forms. The ideal candidate should have experience with data entry, attention to detail, and proficiency in Excel. Key Skills Required: - Data entry - Excel proficiency - Attention to detail

The task involves manually drawing and recording polygons for specific rivers and canals. Each polygon must precisely represent the full course a...water surface of each river or canal. • The focus is on 25-30 rivers and canals, (global Importance). • The polygons should be manually drawn using GIS software and then exported as WKT strings. • Ensure the data is topologically correct and corresponds precisely to the actual river boundaries. • The final output should be an Excel file with two columns: • “Name”: The name of the river or canal • “WKT”: The corresponding WKT polygon Deliverables: 1. Excel file () with two columns: • Name (river/canal name) • WKT (polygon geometry in WKT format) or other f...

...devices and screen sizes. - Implement a comprehensive user role and permissions management system. - Integrate third-party APIs for extended functionalities such as shipment tracking. - Implement advanced security measures to protect against vulnerabilities. - UpDATE custom reporting features for detailed insights and analytics. - Update the ability to import/export/update product data via Excel, etc. A detailed task list with over 30 points to fix is available on Trello, and the project is hosted on GitHub. The estimated time to complete this task is about 4-5 weeks. Ideal Skills: - Proficient in PHP and Laravel - Experience with POS and Inventory systems - Familiarity with GitHub and Trello - Knowledge in implementing multi-language support and currency upd...

I'm seeking an Excel professional who can assist with modifying a file and selecting specific data. The task involves saving images in bulk from local files and requires some specific data formatting. Key Requirements: - Data Modifications: Save images in bulk from local files. - Data Formatting: Primarily involves cell merging and alignment. Ideal Skills: - Proficiency in Excel - Experience in data cleaning and formatting - Familiarity with bulk image saving techniques - Attention to detail

...registration and quote request system. The objective is to create a seamless integration between a website, Zoho CRM, and Zoho FSM. Key responsibilities include: Key Responsibilities: 1. Product Registration System: • Design and implement a registration page on our website where customers can input their personal details and register the products they’ve purchased. • Include a serial number lookup field to validate the product and ensure it’s registered correctly. • Allow customers to upload images related to their purchase (e.g., proof of purchase or product images). • Ensure all customer and product data is accurately captured and integrated into Zoho FSM and Zoho CRM. 2. Quote Request Form: • Set up a quote request form on the websi...

I'm looking for an Excel expert who can assist with data analysis and report generation. The task involves working with large datasets, creating dynamic reports, and ensuring data accuracy. You will primarily be working with financial data. Your tasks will include: - Analyzing and cleaning up large data sets in Excel. - Developing and automating custom reports using advanced Excel functions. - Creating Pivot Tables, Charts, and Graphs to visualize data. - Developing macros for repetitive tasks and data automation. - Working with VLOOKUP, INDEX MATCH, and other advanced Excel formulas. - Ensuring the data integrity and accuracy of reports. - Providing clear and concise documentation of the work performed. The ideal freelancer should be proficient in advan...

I need a professional who can extract and compile the dimensions of all the girders from my Tekla Structures model of a Foot over Bridge. The necessary details include the length, width, and height of each girder, as well as its material type. The final output should be an Excel spreadsheet containing these details for every girder in the model. Ideal skills and experience for the job: - Proficiency in Tekla Structures - Excellent data extraction and organization abilities - Proficient in creating and managing Excel spreadsheets - Understanding of civil engineering concepts related to bridge construction - Strong knowledge of structural steel components and their properties

I need a skilled Excel expert to help me with my formulas. I'm specifically working with mathematical and text functions. My main goal is to enhance my data analysis capabilities. Ideal Skills and Experience: - Proficient with Excel - Strong understanding of mathematical and text functions - Experience with data analysis

MAGENTO 2 EXPERT MAGENTO 2 ATTRIBUTES EXPERT MAGENTO 2 "ATTRIBUTE SET" EXPERT MAGENTO 2 PRICE RULE EXPERT PRODUCTS IMPORT EXPERT EXCEL EXPERT Please do not bid if you're not a genuine expert that can import thousands of products every week. Tasks and Responsibilities: - Be super organized. We will be sending you documents: please sort them in a way that will make it easy for you to revert to these documents whenever needed. We use Office 365 / OneDrive to organize our documents. - You will be importing using excel or CSV or, if you're a true expert: you may even use XML. You will need to maintain these files. If we find out that an attribute was not defined, we want to make sure it will be easy for you to add the attribute and reimport the pro...

Need to split a line break in a column into own rows without overwriting other data. So it needs to be inserted in between current rows. It is three documents with today approximately 60 000+ rows each. Where it is inserted, the other column needs to be filled with the same value as above.

I'm looking for a skilled professional to create a Power Automate workflow for me. Key Requirements: - The workflow should run daily. - It will pull data from an Excel spreadsheet and update/add rows in another table based on a primary key column. - If a primary key from the source table does not exist in the target table, a new row should be added. If it does exist, the corresponding row should be updated. Ideal Skills and Experience: - Proficiency in Microsoft Power Automate. - Strong experience working with Excel. - Ability to work with primary key columns and understanding of their usage in data synchronization. Please bid if you're capable of delivering this project efficiently.

Project Title: Excel Macro-Based Inventory Management System for Diamond Trading Project Description: I am looking for an experienced Excel VBA (macro) developer to create a comprehensive inventory management system tailored for my diamond trading business. The system should be user-friendly, efficient, and capable of handling dynamic data with automated calculations. Key Requirements: 1. Modules: - Cash balance -Purchase and Sales records -Upcoming receivables and payables - 2. Automation Features: - Automated calculations for inventory updates based on parcel changes. - Dynamic addition and deletion of rows with real-time data updates. - Scrollable history for easy tracking of past transactions. - Backup and restore functionalities (preferab...

I need an Excel spreadsheet generated from my access machine which includes user details, sorted by department. Details to be included: - Name - Department - The ideal freelancer for this task should have: - Proficiency in Excel - Experience with data extraction from access control systems - Ability to sort and organize data effectively Please ensure the final output is user-friendly and ready for printing.

I'm looking for an Excel & Office 365 expert to help me with Running Macros. I got Excel file link shared through Onedrive and i open it through Excel Desktop app but am unable to run macros. I tried enabling trust center settings dose not work. I wont be able to share file you need to explain me how to do this over a call.. Please note, this is a straightforward task with a budget of $10.

More details: What type of data do you need to extract from your private website? Text data What format do you need the extracted data to be in? Excel Do you need any specific data processing or cleaning before the data is saved? Yes, advanced data processing

Need a form where the customer can pick options to build a quote for renovating residential rental inventory

I need this done right now Entered numbers not adding up My Excel file has issues where manually entered data is not updating. There are no error messages appearing, but this problem is causing significant inconvenience.

I'm looking for an Excel script that can automate the checking of my SKUs against a consolidated list that includes URLs and titles. The script will need to perform the following tasks: - Check against a consolidated list with URLs and titles - Download images - Rename files according to the SKU The SKU list is located in an Excel file and the consolidated list with URLs and titles is also provided in an Excel file. Ideal skills and experience for this job include: - Proficiency in Excel and Excel scripting - Ability to create scripts that can automate repetitive tasks

I'm an advanced Excel user looking to deepen my expertise with an in-person tutor. I want to focus on: - Macros and VBA - Data Analysis and Pivot Tables - Complex Formulas and Functions Ideal candidates should have a profound knowledge of these topics, combined with excellent teaching skills. Experience in creating customized lesson plans and real-world examples will be a plus. The tutoring sessions should be 4-5 hours per week. The tutoring sessions will take place at my home. The preferred duration of the tutoring engagement is 1-3 months. Tutoring sessions should be scheduled on weekends. The tutor should provide a personal laptop during the sessions. I prefer individual tutoring sessions. Tutoring sessions should be scheduled on weekend afternoons. A focus on stat...

I'm looking for a seasoned data specialist to help me clean and standardize a c...consistency, and standardization based on predefined rules - Provide a cleaned derived outcome - Deliver a fully functional Python script or other dependencies used for data cleaning The data will be provided in Excel format. We have a detailed document outlining our specific rules for data cleaning. The primary focus during the data standardization process will be on maintaining consistency. Ideal Skills and Experience: - Proficiency in data cleaning and standardization - Strong background in handling data and textual data wrangling - Advanced Python programming skills - Experience with Excel - Ability to adhere to predefined rules and guidelines Please note, attention to detail is cru...

I'm looking for a skilled Data Analyst with expertise in Google Data Studio to create dashboards from Google Sheets data. Key Requirements: - Analysis of performance metrics - Use of Excel/CSV files as data sources - Creation of interactive components in dashboards - Incorporation of custom date range filters - Integration of multiple data sources beyond Excel/CSV - Development of custom report templates - Dashboards/Data visualization Ideal Skills: - Proficiency in Google Data Studio - Strong data analysis capabilities - Experience with Excel/CSV files - Understanding of performance metrics

I am seeking an expert in Microsoft Excel to create a simple yet effective spreadsheet for tracking sales. The spreadsheet should allow me to monitor: - Sales by date - Salesperson (Client names) - Goal percentage in relation to team sales goals The ideal freelancer for this project should have extensive experience in Microsoft Excel, and be able to create a user-friendly, intuitive spreadsheet that meets my requirements. Please, be prepared to demonstrate your prior work in Excel.

...coding. no paid theme, app or like. 17. The project will include full support and ongoing maintenance after the website, for 2 months after the launch. 18. The website should be integrated with all payment gates including PayPal and Stripe for payment processing. 19. The project should be completed within 10 Calander days. 20. The client will provide only the product, product details, price in excel format only. 6000 products in many categories....

I need an expert in Excel to set up a comprehensive spreadsheet that tracks my retail product inventory, wholesale and shipping costs, sales prices and profits. Key Requirements: - Design an Excel spreadsheet to monitor: - Retail product inventory - Wholesale costs and shipping costs - Sales prices and profits - Implement a functionality to import order data from Faire, my wholesale provider, on a monthly basis. - Create automatic monthly sales and profit reports utilizing the imported order data from Faire. Ideal Skills: - Proficiency in Excel - Experience in designing inventory tracking systems - Familiarity with data import functionalities - Understanding of retail and wholesale cost tracking Please bid if you have the relevant experience.

Automated Pricing Model for CNC & Fabrication – Excel & ERP Integration Project Overview Impress Group is a precision engineering company supplying components globally. We specialize in laser cutting, bending, milling, turning, powder coating, welding, and fabrication and need a fully automated, accurate, and structured pricing model to improve efficiency and consistency in job costing. This project, called Project Alpha, aims to develop a dynamic, rules-based Excel pricing tool that: - Automates the quoting process using simple user inputs from technical drawings - Prevents incorrect quoting by restricting users from quoting parts beyond our manufacturing capabilities - Calculates accurate process pricing for all services - Generates time decimals f...

I need an excel sheet for my chemical inventory. The sheet should have the following columns: - Item/description - Item # - Quantity - Reorder status (some automated cell that when the quantity on hand matches the min quantity then it turns red?) - Vendor - Expiration date - Methods the chemicals are used for - order status and/or Comments The ideal candidate will have experience with chemical inventory management. Please include advanced search and filter options for better usability. I do have an example of an excel sheet we’ve been using that I can share, it’s not organized at all but it’ll give an idea of what information we’ve been tracking.

I'm looking for a professional with profound expertise in Excel and data handling to assist me with hashing and encrypting mixed data (text and numbers) within the software. Key responsibilities include: - Hashing and encrypting mixed data using AES (Advanced Encryption Standard) - Ensuring the primary purpose of data encryption revolves around maintaining data integrity Ideal skills and experience for the job: - Mastery in Excel with a strong background in data handling - Proven experience with AES encryption - Strong understanding and capability in ensuring data integrity through encryption Please provide your relevant experience and examples of similar projects you have completed in your proposal.

I'm looking for an experienced Power BI specialist to revamp my current dashboard. The primary purpose of this dashboard is to facilitate reporting and analysis. Key Requirements: - Proficient in Power BI - Experience with data visualization - Ability to create engaging charts, graphs, maps, and tables Current Data Sources: - Excel files - SQL databases - APIs Your Role: - Enhance the current dashboard for better reporting and analysis - Connect and visualize data from the specified sources Ideal Skills and Experience: - Expertise in Power BI - Strong background in data analysis and visualization - Ability to create user-friendly and informative dashboards

I'm in need of a proficient Excel spreadsheet for quoting mechanical engineering parts. The spreadsheet should include automated calculations to streamline the quoting process. Ideal skills for this project include: - Advanced Excel capabilities - Understanding of mechanical engineering parts - Experience in creating quotation spreadsheets. - Ability to create and troubleshoot complex Excel formulas. Please ensure that your bid reflects your expertise and previous work in this area.

I need assistance reviewing a 900-page PDF document to extract and summarize project milestones into a high-level summary. The milestones need to be organized in chronological order by specific dates found within the document. Your task will include: - Identifying key project milestones from the document. - Creating a high-level summary of these milestones in excel spreadsheet format referencing the page numbers of documents into a contents column once documents rearranged into chronological order - Organizing the scanned documents chronologically according to the dates of the milestones found in the documents Ideal skills for this project include: - Proficient reading and comprehension skills. - Ability to distil complex information into concise summaries. - Experience with project...

I'm seeking a long-term Odoo developer, ideally a junior with 1-2 years of experience. The primary focus of this role will be on custom module development. Key Responsibilities: - Design and develop customized Odoo modules - Collaborate on various ongoing projects Ideal Skills: - Proficiency in Odoo - Experienc...experience. The primary focus of this role will be on custom module development. Key Responsibilities: - Design and develop customized Odoo modules - Collaborate on various ongoing projects Ideal Skills: - Proficiency in Odoo - Experience in custom module development - Problem-solving skills for bug fixing and maintenance - Understanding of system integration - experience on pos customization, excel reports , upgrading DB This is a long-term position with an hou...

I need a Windows computer fully configured and set up with the same software and settings as my existing one, at a different business location. Key Requirements: - Install and setup crucial software: Dropbox, Excel, Windows, Outlook - Replicate network configurations, user profiles, and preferences from the original computer Ideal Skills and Experience: - Proficiency in Windows computer setup - Experience with software installation and configuration - Knowledge of network setups and configurations - Understanding of user profile and preference replication

I'm looking for an Excel specialist who can automate generating reports with macros and integrate this process with Outlook. Skills Needed: - Advanced Excel proficiency, especially in macro automation. - Strong understanding of report generation. - Experience with Outlook integration. This is a crucial task for improving my productivity and streamlining my reporting process. Please provide examples of similar work you've done in the past.

I need a skilled WordPress developer with expertise in the Adifier theme. The primary focus will be enhancing the site's functionality...developer with expertise in the Adifier theme. The primary focus will be enhancing the site's functionality, particularly related to user profile features. The project involves transferring 29,000 members and 1,500 classified ads from our old PHP site to the new Adifier Wordpress site. Username, first name, last name, email address, phone number and city need to be transferred to new site from an excel spreadsheet. Ideal skills for this job include: - Expertise in WordPress and Adifier theme customization - Proficiency in PHP and MySQL for data transfer - Experience with user profile feature enhancement - Excellent problem-solving and tr...

I'm seeking a skilled professional for data migration, specifically moving product data from Excel to SQL. Key Requirements: - Proficient in Excel and SQL - Experience in data migration - Familiarity with handling product data - Able to ensure accuracy and integrity during the migration process

I'm looking for an Excel expert who can assist me with data analysis tasks. Key Responsibilities: - Perform data sorting and filtering tasks - Conduct data analysis to derive insights Ideal Skills: - Proficiency in Excel - Experience in data analysis - Attention to detail for sorting and filtering tasks

I'm looking for a data analyst who can interpret my sales data and visualize it effectively. The primary objective of this project is to compare performance across different time periods, regions, or products. Ideal skills and experience: - Proficiency in data analysis a...data and visualize it effectively. The primary objective of this project is to compare performance across different time periods, regions, or products. Ideal skills and experience: - Proficiency in data analysis and interpretation - Experience with sales data - Skills in creating clear, insightful visualizations - Ability to compare performance metrics effectively - Advanced skills in Microsoft Excel for data manipulation and analysis. - Experience with statistical analysis to identify trends and patterns...

...skills for various projects. Translation: Professional translation services for documents and content. Medical Writing: Assistance with healthcare-related content and research. Data Entry: Accurate and efficient data management. Diet & Public Health Research: Creating reports and articles related to diet and health. PowerPoint Presentations: Creating professional and engaging presentations. Excel Work: Data analysis, charts, and spreadsheet management. Requirements: Strong attention to detail. Relevant experience in any of the above-mentioned fields. Ability to meet deadlines. Deliverables: High-quality, error-free work. Submission within the agreed timeline. Budget: Flexible, depending on the project scope and quality. These projects are long-term, requirin...

I'm in need of a detailed research into undergraduate Economics programs across 25 colleges from the USA and UK. The data should be meticulously organized into an Excel sheet. I will give the list of colleges that I need this information for. Key aspects to focus on: - Admission Criteria: What these colleges look for in terms of marks/grades, SAT scores or other standardized tests, and any college-specific tests. Additionally, include information about required essays and subjects to be taken in school. - Program Details: Course curriculum details of the Economics programs offered by these colleges. - Tuition Fees: Detailed information on the tuition fees for the Economics programs at each college. After the initial research on the USA and UK, I plan to expand this project ...

I am seeking a skilled VBA/Excel programmer to develop an inventory program within excel that will allow the following: 1) allow me to add products into a components inventory database using a form Fields are: Vendor, SKU, UPC, Status, QTY STOCK, EXP DATE, Category, Brand, Component Name, Component Description, Size, DIMS, Gross Wt, Case Count, Case Cost, Unit Cost, Component URL, Product Image 2) Bundle Design Tool - a graphical design form that allows me to add different components to build a bundled product. Fields are: Bundle Name, Bundle Desc, SKU, Theme Category, Inspired By, QTY STOCK, STOCK STATUS, Target MSRP, Target Cost Website URL, Shipping Weight, Dimensions Components List/Cost Analysis: in the form there will be a list that will show the added...

Job Description: Excel Advanced Formula Specialist Job Overview: We are seeking an Excel Advanced Formula Specialist to join our team. The ideal candidate will have expertise in advanced Excel formulas, functions, data analysis, automation, and reporting. This role involves developing complex formulas, optimizing spreadsheets, and ensuring efficient data handling for business decision-making. Key Responsibilities: Develop and implement advanced Excel formulas (e.g., INDEX-MATCH, VLOOKUP, XLOOKUP, SUMIFS, COUNTIFS, IFERROR, INDIRECT, OFFSET, ARRAYFORMULA). Create and manage pivot tables, charts, and dashboards for data visualization. Automate tasks using Excel VBA (Macros) and Power Query to improve workflow efficiency. Clean, structure, and analyz...

I'm seeking help with automating my Excel spreadsheet. I've done considerable work already and have an instruction document to guide us. - Task: Spreadsheet automation - Software: Microsoft Excel - Assistance: Determining the type of automation needed (potentially macro creation, formulas and functions, or data import/export) Your expertise in Excel and experience with spreadsheet automation will be crucial. I'm open to a call if further clarification is needed. Please provide a time estimate and cost for this task in your proposal.

I need help with managing and analyzing Excel spreadsheets. The tasks will primarily involve data entry, analysis, and possibly creating charts or graphs to visually represent the data. Ideal skills and experience: - Proficient in Microsoft Excel - Experience with data analysis and visualization - Attention to detail - Good organizational skills

I'm looking for an Excel expert who can design a custom spreadsheet and dashboard template for tracking the completed yearly contract requirements of approximately 1,200 healthcare providers. Currently, we track completion of quarterly training completions, submission of required quality reporting documents, and important contact information which is updated and confirmed quarterly. Key Requirements: - The spreadsheet will be used internally to monitor the completion of specific trainings and the submission of quarterly documents. - It must also track current contact information (email, phone, point of contact, etc.) for each provider. - The dashboard will need to be user-friendly for both internal team and external stakeholders. - Include data visualization features such as ...

We are looking for a skilled React.js developer to manage and enhance our existing analytics dashboard that processes revenue and expense data for mobile applications. Project Overview: - Dashboard processes CSV revenue files and Excel expense files - Combines data to gen erate comprehensive reports - Uses React.js with Material UI for frontend - Handles multiple file formats and data transformations Technical Requirements: 1. Strong experience with:   - React.js   - Material UI (MUI)   - Excel/CSV file processing (, Papa Parse)   - JavaScript/ES6+   - Git version control 2. Must be able to:   - Understand existing codebase   - Debug data processing issues   - Add new features   - Opt...

I'm looking for an Excel expert who can design a custom spreadsheet and dashboard template for tracking the completed yearly contract requirements of approximately 1,200 healthcare providers. Currently, we track completion of quarterly training completions, submission of required quality reporting documents, and important contact information which is updated and confirmed quarterly. Key Requirements: - The spreadsheet will be used internally to monitor the completion of specific trainings and the submission of quarterly documents. - It must also track current contact information (email, phone, point of contact, etc.) for each provider. - The dashboard will need to be user-friendly for both internal team and external stakeholders. - Include data visualization features such as ...

...• Landing Page URL • Date Range • Ad Type (Image, Video, Carousel, etc.) • Language • Country Key Features: 1. API Integration: Fetch real-time ad data from Facebook & TikTok Ads Libraries. 2. Dashboard UI: A clean, user-friendly interface to view and filter data. 3. Filtering System: Apply advanced filters to find specific ads. 4. Data Export: Ability to download filtered data in CSV/Excel. 5. Ad Preview: Show ad creatives, captions, and engagement metrics. 6. Login System: Secure access with user authentication. Tech Stack Preference: • Backend: Python (FastAPI) / Node.js • Frontend: React / Vue.js • Database: PostgreSQL / MongoDB • Hosting: AWS / DigitalOcean Deliverables: • Fully functional web-based dash...

I'm seeking a web scraping expert to extract data from the Accredia database and organize the results in an Excel file. Key tasks: - Scrape data on all Italian companies certified UNI/PdR 125:2022, categorized by region. - For each company, extract the following information: - Company name - VAT number - Region - Address - Number of employees, divided by gender if available - Certification date - Certifying body - The data needs to be sourced from: - The final Excel (XLSX) file should have a separate sheet for each region, with companies organized by number of employees. Requirements: - Proficiency in using Selenium for web scraping. - Ability to ensure data accuracy and quality through