Vba excel insert sheet jobs

I'm looking for an Excel expert who can help me with applying logical functions (IF, AND, OR, etc.) primarily for data validation across multiple ranges. Key tasks: - Assisting in the use of logical functions for data validation - Implementing these across multiple ranges Ideal skills and experience: - Proficient in Excel, particularly in logical functions - Experience with data validation in Excel - Able to apply skills across multiple ranges

For this job, the client requests the transcription of a song into guitar trablatures and conventional sheet music. My job will be to deliver the harmony and melody of the song in the required formats so that you can play it in the most efficient way possible.

**Freelance Project: Creating Indian Biodata in Hindi and English** **Project Overview:** We are seeking ...Ability to understand and incorporate cultural nuances specific to Indian biodata formats. - Attention to detail and aesthetic presentation of the final document. **Deliverables:** - A professionally designed biodata in Hindi. - A professionally designed biodata in English. - Both documents must adhere to standard Indian biodata formats. **Timeline:** The project should be completed within [insert deadline here]. **Budget:** Please provide your rates along with samples of previous work. **How to Apply:** Interested candidates are requested to submit their proposals, including relevant work samples and estimated timelines. Feel free to modify any sections to better fit y...

I'm seeking assistance with my Power Automate system. Currently, I am performing data entry from a single sheet Excel file into a web platform, specifically filling in text fields. I've encountered some hurdles while trying to automate this process. Ideal skills and experience for this job include: - Proficiency in Power Automate - Experience in automating web data entry - Familiarity with Excel, particularly with single sheet data organization Your expertise could save me a lot of time and frustration. Looking forward to your bids.

I'm seeking an expert in Excel to create a comprehensive dashboard that focuses on project management. The primary use of this dashboard is to monitor resource allocation, specifically equipment, for various tasks within a project. Ideal Skills and Experience: - Proficient in advanced Excel functions and features - Experience in project management - Understanding of resource allocation and tracking - Ability to create user-friendly and visually appealing dashboards

I'm looking for a professional to improve the user interface of an Excel-based governance document. This document is used to track initiatives and actions from a strategic plan. Key Focus Areas: - Navigation and layout: The document needs to be more intuitive and user-friendly. - Form input and validation: Streamlining the process of data entry and ensuring accuracy is crucial. - Color scheme and styling: Aesthetic improvements are needed to make the document visually appealing. No specific design guidelines are in place, so creativity and adherence to general best practices will be appreciated. Ideal candidates should have a strong background in UI design, particularly in Excel, and be able to deliver a document that balances functionality with an enhanced user experi...

I'm in need of a custom Excel worksheet for tracking business card orders. The worksheet has specific requirements and needs to be completed today. Please see the details below. - The worksheet needs to be separated by name, title, address, phone, fax, cell and email address, and quantity. - The first sheet should be named 'AIM', the second 'CC', the third 'TT', and the fourth 'ACT'. - I will provide the names, but you need to format the Excel sheet according to these specifications. - The quantities for each type of business card should be recorded in separate columns. Ideal skills for this job include: - Proficiency in Excel - Attention to detail - Ability to work under tight deadlines.

I'm seeking a professional to scrape my WordPress website for 1100 entries related to our different offices. The data needs to be exported into an Excel file, without any specific filters or sorting. In addition to data scraping, I need a thorough code review of my WordPress site. This should encompass: - Documentation and review of custom code - Optimization where necessary - Plugin review for updates - Recommendations for optimization This project requires a deep understanding of PHP, as well as experience with WordPress and data scraping. The ideal freelancer will have a strong background in website code review and optimization.

I am seeking to hire an excellent Compliance and Administrative member to join my team. Skills Required: * Confident on the phone * Speaks & communicates clearly by phone * Excellent written communication skills * Proficient in Microsoft Excel, Word and Power Point * Can multi-task and complete projects on time * Must be able to learn on the go and figure out solutions to problems * Is an excellent self-learner * Finish projects in a timely manner, doesn't procrastinate * Proficient with Adobe Acrobat in creating forms and documents * Proficient with DocuSign. Understand how to send out documents for signature * Excellent with follow-up. If you promise something to a client or team member follow-through * Understand how to use DropBox and grant/deny access to users * Excel...

I am in need of a freelancer who can assist me in extracting data f...extract insights. Further specifics will be provided upon acceptance of the job. Key Requirements: - Proficiency in Google Forms and Google Sheets. - Experience with data cleaning, organization, and analysis. - Attention to detail and ability to deliver accurate results. - Familiarity with creating charts or summary dashboards in Google Sheets is a plus. Deliverables: - A clean, organized Google Sheet with extracted survey data. - Basic analysis and simple visualizations based on the data. Ideal Skills and Experience: - Previous experience with similar projects. - Strong analytical skills. - Ability to meet deadlines. Please note that the expected completion date is Thursday, January 30th, with a budget of $30...

We would like you to find emails of everyone in this sheet (2 tabs on bottom)

I'm in need of a professional and detail-oriented writer who can compose structured daily reports for our company. The ideal candidate should have: - Experience in business writing - Excellent attention to detail - The ability to present information clearly and professionally Please note that the specifics of the reports, their primary purpose, and...professionally Please note that the specifics of the reports, their primary purpose, and the preferred format have not yet been determined. Therefore, flexibility and adaptability are key. Skills and experience that would be beneficial for this job include: - Prior experience in corporate communication or report writing - Strong understanding of business terminology - Proficiency in Microsoft Word and Excel - Ability to meet ...

I've got a Net Cost Calculator in Excel that needs to be embedded into my WordPress site, built with Elementor. This calculator is quite straightforward; it primarily employs simple arithmetic. Key Requirements: - The calculator will require users to manually input data. - It needs to be styled to match the theme of the rest of the site, rather than a simple and clean look or a completely custom design. - The calculations performed by the calculator are all simple arithmetic, not complex formulas or financial projections. Ideal Skills and Experience: - Proficiency in WordPress, particularly with Elementor. - Strong understanding of Excel, especially in terms of transferring content to a different platform. - Good eye for design to ensure the calculator matches the sit...

We are looking for an experienced developer to create a web-based Financial Requisitions Management System. The system will manage various requisitions (e.g., services, transportation, raw materials) with role-based access for users, appro...English, translation-ready). Functional Requirements: Role-based access: Users: Create, view, and edit their requisitions. Approvers: Approve/reject requisitions with feedback. Admins: Configure workflows and override locked fields. Configurable approval workflows (e.g., CEO approval mandatory). Integration with existing SQL Server data for financial records via the backend. Additional Info: Sample Excel structure and queries will be provided. Responsive design required for both desktop and mobile. Post-deployment support expected for minor ad...

I'm seeking an Excel expert who can compile and analyze the income statement for Woolworths Group Limited over the past three years. The report should include sales, expenses, and profit, as well as charts to visualize the data. Ideal Skills: - Proficient in Excel - Financial analysis experience - Data visualization skills Please note, while I've left the specific expense categories open-ended, the comprehensive nature of your analysis will be appreciated. Your ability to deliver a clear, insightful report is key. Deadline in 28 hours

I'm looking for a freelancer who can assist me with my sales data. The tasks primarily involve data entry, data cleaning, and data analysis. The dataset is relatively small, with less than 1,000 rows. Ideal skills for this project: - Proficient in Microsoft Excel - Experience in data entry - Strong data cleaning skills - Capable of performing data analysis Please bid if you have the required skills and experience. Thank you!

I'm seeking an Excel expert to help me compose a mailing list. The ideal freelancer should have experience with data handling and Excel's various functions. Key requirements: - Create a comprehensive mailing list in Excel, including names and addresses. - Potentially assist with data analysis and visualization using Excel's tools. - Prior experience with similar tasks will be highly beneficial.

I'm seeking a Microsoft Excel professional to create a comprehensive spreadsheet for my retail and service-based business. The goal is to meticulously track all expenses and personal payments. Key Components of the Spreadsheet: - Record and categorize various expenses: Office supplies, Travel expenses, Utilities, Gas, Rent, Professional Development, Flights, Hotels, Credit Card fees, Business registration fees. - Monitor different income sources: Product sales, Service fees, Consulting fees. Ideal Skills: - Proficient in Microsoft Excel - Experience in creating business tracking spreadsheets - Understanding of retail and service-based business expenses - Ability to categorize and track diverse income sources. Your expertise will help me maintain a clear overview of ...

Description: We are launching an exclusive premium coaching service designed to help candidates excel in the CFA (Chartered Financial Analyst) exams. Recognized as some of the most challenging professional exams in the world, CFA preparation requires tailored support and strategies that go beyond the traditional offerings. To ensure our service delivers maximum value, we’re seeking CFA candidates and charterholders to provide critical feedback and suggestions before our April 2025 launch. Your insights will play a pivotal role in shaping this transformative service for future candidates. Project Objectives: > Review: Participate in an online video call to review our planned offering. > Feedback: Provide constructive insights on all aspects of the service, identi...

...Open Portal, all within an easy-to-use Excel interface. Responsibilities: Download Listings: Create a system that can pull real estate listings data from sources such as Zillow, Redfin, StreetEasy, and other relevant platforms. Enable users to paste or upload property listing data into an Excel sheet for further processing. Data Extraction: Automate the extraction of zoning data for each property from Zola NYC and NYC Open Portal, including specific zoning codes and regulations. Extract the building structure type, size, number of stories, and the size of the lot for each property. Determine if the property is located on a wide street. Excel Integration: Ensure that all extracted data is neatly organized and formatted for easy access within Excel....

I just noticed an issue in this sheet that you did for me a few years ago. Column I is calculating the average price wrong when the value in E is more than 1 because column E shows the total qty sold and column D is the price of each, not the total for the qty listed. Column I for rows 4-8 should be 34.95 & rows 9-10 should be 29.89

...youth/caregiver for the contracted time allowed. We received purchase orders from localities to provide a maximum amount of time per the purchase order. In some cases, there is also a maximum time allowed per month and in a few cases per week along with the total amount of time. I've included a sheet I made that tracks time. I have three depending on if I only need to track total time, one if I need to track total time and monthly, and one if I need to track total, monthly and weekly time delivered. My sheet is clunky and the employees don't like it. The document needs to: - Have a header like the example provided - Record contact date, amount of time and associated notes - Have a summary like the example provided The data should be organized into separate sec...

I'm seeking a skilled Python programmer to automate the handling of mixed data inputs into an Excel spreadsheet. Historical trades will be used as a reference point to retrieve data based on a number of conditions and variables from various financial instruments utilising historical data from 2016 onwards. This process will need to be scheduled to complete on weekly and ad hoc basis utilising API connection for historical price capture. Once the above is completed the same datasets will be used to simulate and output data based on the conditions set out in the simulation. Some understanding of trading terminology and bar/candle charts would be useful as this will would make it easier to comprehend the conditions and variables but is not a pre-requisite. Key Requirements: - ...

I'm looking for a professional and corporate-style A4, double-sided, informational brochure, primarily focused on detailing my product/services. Key Responsibilities: - Design a clean, professional and corporate-style brochure that effectively communicates product/service details. - Ensure the design is suitable for both sides of an A4 sheet. - Make the brochure engaging, yet keeping it strictly informational. Ideal Skills and Experience: - Graphic Design with a focus on corporate branding. - Experience in designing brochures or similar promotional material. - Ability to distil complex information into clear, concise and visually appealing formats. ---------------------------------INFORMATION LOGO AND DESIGN IDEA ATTACHED **MageSense IoT: Transforming Water Management** ---...

...undo/reset, and save options. - Automatic Calculations: The app should perform totals, subtotals, and discounts, with real-time error detection. - Export/Save: The app should allow users to export corrected data to PDF/Excel or save it locally/cloud. - Optional Analytics: The app should provide expense summaries and visual insights, such as graphs. Requirements: - Proficiency in Flutter or React Native is a must. - Extensive experience with Tesseract OCR is required. - Knowledge of local databases, specifically SQLite, and familiarity with export formats like PDF and Excel is essential. The ideal candidate will have a strong portfolio of similar projects, with excellent problem-solving skills and attention to detail. Experience in developing cross-platform applications ...

I am seeking an Excel expert with extensive experience in spreadsheet automation. The ideal candidate will help me automate the following tasks: - Data entry - Generating reports - Data cleaning The Excel spreadsheet will need to interact with a database. Therefore, experience with database interactions in Excel is crucial. Skills and experience needed: - Advanced Excel knowledge - Expertise in spreadsheet automation - Proficiency in data manipulation and cleaning - Experience with generating reports in Excel - Familiarity with database interactions in Excel Please provide examples of similar projects you've completed in your bid. Thank you.

I need assistance in modifying an existing index in my Excel sheet. The goal is to enhance the accuracy of the index. Please help me make the index work better. Ideally, you should have a strong background in data analysis and Excel functions.

...recommendations on advertising campaigns. The agent should be able to interpret natural language messages, access data stored in Storj, process it via Akash, and respond in a clear and actionable way to users. Main Functionalities Integration with WhatsApp Configuring the WhatsApp Business or Twilio API. Sending and receiving messages. Support for text messages and sending simple files (such as PDF or Excel reports). Natural Language Processing (NLP) Understanding questions such as: "How is campaign X performing?" "Should I increase investment in campaign Y?" Interpreting intent and extracting key information. Data Access and Processing Storing campaign data in Storj. Processing and analysis in Akash for: Calculating ROI, CTR, engagement and othe...

Please Sign Up or Login to see details.

...with the agreed-upon features. 2. Source code with proper documentation for future updates. 3. Step-by-step guide on how to install and use the bot. 4. A brief period of post-delivery support to fix any bugs or issues. Timeline: Please provide an estimated timeline for completion, including milestones. Budget: Provide your pricing for basic and advanced features. My approximate budget is [insert your range here, $100 to $500 but I’m open to negotiation. How to Apply: 1. Share examples of similar crypto trading bots you’ve built. 2. Briefly describe how you’d approach this project. 3. Provide your estimated cost and timeline. 4. Mention any ongoing support or updates you offer. Next Steps: I’ll review all proposals and schedule interviews wit...

I'm looking for an experienced WordPress developer to create a robust e-commerce website for selling physical products. We want to edit that theme as per our requirements, adding the catalog. (define a process to add via excel/csv) Cart management ( already in theme) Account management ( already in theme) Products listing as per the Subscription model pricing Theme backup and restore mechanism ( ONe time setup and doc to be provided) Payment gateways ( ONE TIME SETUP) Shipping and return management ( MANUAL FOR NOW as we are not taking the API from shipping company) - so to be handled manually by us Adding SUBSCRIPTION SYSTEM ( defined below)

Please Sign Up or Login to see details.

Working on converting 1200 images from PDF to Excel.

I am looking to extract product information from a website into an Excel sheet. I just need the product name, description, and price from the product listings on the site. Please let me know if you're experienced with web scraping and can finish this task. I just need an Excel Sheet and not a tool. Thank you!

I'm in need of a lead generation expert to extract emails and WhatsApp numbers from all interior and architecture companies in the UAE. Also all digital agencies consultant at dubai Key deliverables: - An Excel spreadsheet containing: - Company names - Contact persons - Company addresses - Email and WhatsApp numbers of owners - Locations -Sector Data Verification: - I prefer that the authenticity of the collected data is verified manually. Ideal skills and experience: - Familiarity with the interior and architecture sector in the UAE is a plus - Proficiency in Excel - Experience in lead generation - Strong attention to detail for manual verification tasks.

...functionality will streamline the process and make it more efficient. - Packing List Preparation: The system should have the capability to create prepared packing lists based on the inventory. - User Interface: The system's user interface will be based on Excel VBA. You will need to be proficient in creating an intuitive and user-friendly interface. - Database Management: An Access Database will be used in conjunction with Excel VBA. You should be skilled in using Access to manage and store data effectively. Ideal Skills: - Proficient in Excel VBA and Access Database. - Knowledge and experience with QR code scanning technology. - Ability to create and manage packing lists. - Fluent in German (preferred). If you have experience with QR cod...

I need assistance with removing a password from 1-3 specific sheets in my Excel workbook. The task involves accessing these password-protected sheets, so proficiency with Excel and experience dealing with password removal are essential. Ideal Skills: - Excel Proficiency - Experience in Password Removal - Attention to Detail

I'm seeking an Excel expert who can help me code a MACROS to automate a process in Excel. The task involves analyzing employee data and generating results related to loans and other similar data entries. Key Responsibilities: - Develop a MACROS script to automate data analysis on employee data. - The macro should be able to provide results for specific data entries related to loans and other similar metrics. Ideal Skills and Experience: - Proficient in Excel and VBA programming. - Prior experience in developing Excel MACROS for data analysis. - Understanding of employee data metrics. - Able to deliver efficient and effective solutions for data processing and analysis.

...bidding strategies. Requirements: • Educational Qualification: Bachelor’s degree in any field (preferably Business Administration, Commerce, or related domains). • Experience: Minimum 2 years of experience in tender management, with hands-on expertise in GEM portal operations. • Strong knowledge of hospital equipment and OT table specifications is preferred. • Proficiency in MS Office (Word, Excel) and GEM portal functionalities. • Excellent communication, organizational, and analytical skills. • Ability to work under tight deadlines and multitask efficiently. What We Offer: • Competitive salary and benefits. • Opportunity to work with a dynamic team in the healthcare equipment industry. • A supportive and growth-orien...

...cleaning up and automating my Excel data. I'm unsure if everything is possible to do, but maybe a few steps can be disregarded. The perfect scenario would be: Create a simple form to add 'ID number' to process and file name for the new file. The automation: Open designated file with info. Create columns (based on character lenght) Format columns (set length, add '0's eg '234' formated to '000234'. Get only rows where Column C matches the input 'ID number', and column B has fixed value. Insert row at top with column header titles. Save file (as excel 97-2003 format), with the input filename. If all works out well, I will have another project where similar things are needed. Ideal freelancers for this p...

I need a short Python program that can extract transaction details from my PDF bank statements into both CSV and Excel formats. All my statements are in the same format, so consistency won't be an issue. Ideal Skills: - Proficiency in Python - Experience with PDF data extraction - Knowledge of CSV and Excel programming This project is a great opportunity for a skilled Python developer with experience in data extraction and a keen eye for detail.

...proficiency in at least one vector design program (e.g., Adobe Illustrator, CorelDRAW, or similar). • Specialization in the design of any printed material such as logos, banners, or business cards. • Ability to work remotely with discipline. **Benefits** • No experience in printing or production is required. • Each area of expertise is evaluated separately, so you will only work on the areas you excel in. For example, a designer specialized in business cards will not be assigned packaging design tasks. • Workload is evenly distributed among multiple designers in the team. **Application Process** **Before applying, we recommend learning more about our company by searching “SignsAtelier” on Google and visiting our website.** • Plea...

I'm seeking a proficient Excel developer with strong skills in VBA and Macros. The job involves creating an automated workflow to transform data from a single Excel file into three separate files. Key Tasks: - Importing data from one Excel file - Creating three files using VBA and Macros - Data cleaning - Data merging - Data filtering The data filtering will involve: - Applying numerical ranges - Text matching - Date ranges Ideal candidates should have a robust understanding of data transformation processes and extensive experience with Excel VBA and Macros.

I need a professional to analyze some data from an Excel file. The project primarily involves numerical analysis with a focus on identifying trends and patterns in sales data. Ideal candidate should: - Have proven experience in data analysis, particularly with Excel. - Be skilled in identifying and summarizing key trends and patterns in numerical data. - Be able to present findings in a clear and concise manner. - Have a good understanding of sales trends.

...number of historical records in some of the data fields has proven to be impractical (tens of millions of records) to download using the API as it is simply too slow. I am open to alternative methods here though. There will be a limited number of transforms (calculated fields) based upon the existing data structure, perhaps 15-20. Ideally, once the database is set up, I'd like to create a system (Excel or custom) to connect to the database and run a series of statistical queries on it. That does not need to be part of the original scope of work, but if the same developer can assist with this part that would be great. A previous freelancer started this project. They set up the database and tried using the API to do the initial download. Most of the data tables were able to...

I'm looking for a professional visual style for an interactive schedule planner in Excel. This project will require some experience with the developer tab. Key Requirements: - The schedule planner should feature automatic updates, conditional formatting, and data validation. - It should have a polished, professional appearance. - User interaction will be primarily through selecting from drop-down lists. Ideal Skills: Provide ideas that will make the spreadsheet user-friendly - Advanced Excel skills including developer tab proficiency. - Excellent understanding of conditional formatting and data validation. - Strong design skills for creating a professional layout. - Experience with creating interactive Excel tools. Please provide examples of similar projects ...

I’m looking for someone to search for products on Amazon and list them in an Excel or Google Sheet. What you’ll do: Search for products in specific categories that I will provide. Record the product title and the link to the product page. Requirements: Basic knowledge of Excel or Google Sheets.

...examples for product pages (have a look at the well done vertical filters: and Setting up the following: - Setting up our Stripe account (billing, payment gateway, etc.) - B2C login, My account (registration, login, save product wish list, history orders, save delivery address, VAT ID insert field) - Infrastructure with the possibility to add B2B login in the future (different pricing and minimum order)? How complex is it? - Footer: Business terms, T&C, Follow us, Trusted shop, Privacy, Data protection, imprint, Contact us…Newsletter login - Blog page - Setting up filtering of attributes on the left - Setting up pages for GDPR compliance, T&M, - - - Warranty terms (I have them written)

I need a professional to set up an email notification system for my staff, using Excel and Outlook. Key requirements: - The system should send an email to each staff member whenever a cell related to them changes value. - The cells are populated with dropdown list values. - The emails should be simple text, not HTML or pre-designed templates. Ideal skills for this project include: - Advanced Excel skills - Proficiency with Outlook - Experience with setting up automated email systems - Good understanding of drop down lists in Excel This is an opportunity to help me streamline communication with my staff and ensure they are updated in real time.

I require assistance with cleaning up my Excel files. I have three Excel files, and I need duplicates in one specific column of the first file removed from all 2 files. The structure of all files is the same, with identical columns. Ideal skills for this project include: - Proficient with Excel - Attention to detail - Experience with data cleaning Please be prepared to delete identified duplicates from all files. Budget $5