Excel macro data cell jobs

...Description: I am looking for a skilled developer to create a JavaScript/jQuery function that enhances a DataTables table by adding custom filter buttons to each column header. These buttons should open modals styled similarly to Excel filters, providing advanced filtering and sorting capabilities. Requirements: 1. General Functionality: • The function should accept the ID or selector of a DataTables table as a parameter. • Each column header should include a button with an appealing format. 2. Filter Modal Features: • Sorting capability for the column data. • Filters based on: • Text/Number Columns: Input field for filtering values. • Date Columns: Two input fields (for “From” and “To” dates). • If only...

Excel VBA Macro for Data Capture & Email **Job Title:** Excel VBA Developer Needed for Automated Screenshot and Email Generation Task **Description:** We are seeking an experienced Excel VBA developer to create a macro that automates the following tasks: 1. **Country-Based Data Selection**: - Read a country name selected in one sheet (e.g., "CountrySelection" sheet). - Locate the corresponding row in another sheet (e.g., "Data" sheet) where the country is listed. 2. **Dynamic Data Range Capture**: - Identify the relevant row and its associated columns dynamically. - Capture this data as a screenshot or export it as an image. 3. **Email Integration**: - ...

I need assistance in importing my bank transactions into Tally. Details of the project: - The transactions are exclusively from my bank - The data is in an Excel file - The file includes the following details: date, amount, description, category, and balance Ideal Skills: - Proficiency in Tally - Excel data handling and manipulation - Understanding of accounting principles - Experience with Tally's import functionality I look forward to your bids.

I'm looking for a professional with exceptional Excel skills to create visual representations of my sales data using bar charts. Key requirements include: - Transforming complex sales data into easy-to-understand charts - Customizing the bar charts with specific colors and data labels Ideal skills and experience: - Proficient in Microsoft Excel, particularly in chart creation - Prior experience with sales data would be beneficial - Ability to customize charts as per specific requirements I have a rudimentary column stacked that is as far as I could get. I think someone can glean here I'm going with it. One issue is that logarithmic scales cannot show negative numbers. Also I would like month totals to show.

...have a knack for sourcing potential leads from Google and filling in an Excel template with pertinent details. Job Responsibilities: - For each assigned project, collect total 500 email addresses from Google for 5 designated countries (100 e-mail addresses from each country). - Adhere to provided guidelines using relevant and useful keywords. - Utilize a shared Google Drive Excel template to fill in 5 important fields for each company: Company Name, Country, Website URL, Email Address, and Telephone Number. The selected candidate will have a video call session, if necessary, to thoroughly explain the requirements. Ideal Skills and Experience: - Proficient in using Google for sourcing leads. - Comfortable using Excel and Google Drive. - Experience in lead compila...

I need assistance with filling earnings data in an Excel sheet from Screener.in. The data pertains to 693 companies. You have to make an ID on > search each company > go to profit of loss > copy paste Mar 22 EPS into excel> go to quarters > copy paste from Dec 22 to Jun 24 EPS into excel File in which data is to be uploaded is attached

I need assistance updating over 500 product details in an Excel spreadsheet. Key Responsibilities: - Update pricing information - Revise product descriptions - Adjust inventory counts I will provide the updated information in a CSV file. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry and product management

I need this report summarized into 6 or so pages As always please recreate the charts and embed excel files Once completed please upload backup excel files

I am looking for an expert to help me automate my lead tracking and follow-ups. Currently, I am primarily working with contact information stored in Excel. Key Requirements: - Experience with lead data management - Proficiency in Excel - Skills in automation tools and scripts The ideal freelancer for this project should be able to streamline my lead management process, making it more efficient and less time-consuming. Prior experience with CRM software is a plus, though not a necessity. Your understanding of tracking systems and automation will be crucial for the success of this project.

Recreate pages 3,6,7,8,9,10,11,12,16,18,20,21,33,34,35,36 33,34,35,36 Charts need to be in excel Use new poerpoint template Thanks!

I'm in need of an experienced Google Sheets or Excel developer who can create complex data transformation formulas for my financial models. Key Requirements: - Expertise in creating complex data transformation formulas in Google Sheets or Excel. - Ability to develop comprehensive financial models that include cash flow projections, profit and loss statements, and balance sheets. Ideal Skills: - Proficient in data analysis and automating tasks with scripts. - Deep understanding of financial modeling and statistical analysis. - Excellent problem-solving skills and attention to detail. Please only apply if you have extensive experience in creating complex formulas and financial models.

I'm looking for a freelancer who can create a detailed, category-wise breakdown of my monthly expenses from my Excel data. Key Requirements: - The report should be organized employee-wise - A clear, concise, and professional presentation of the data Ideal Skills: - Proficiency in Excel and AI - Attention to detail - Ability to present data in a clear and concise manner

I'm seeking assistance in compiling data for my SEO agency's prospecting lists. Requirements: - Gather company names and their respective contact details. - Specifically, I need: Email addresses, First Name, Company name, and Monthly Website Traffic. - Organize the data into an Excel spreadsheet. Ideal skills: - Proficient in data entry. - Familiarity with SEO metrics is a plus. - Excellent attention to detail.

I'm seeking assistance in compiling data for my SEO agency's prospecting lists. Requirements: - Gather company names and their respective contact details. - Specifically, I need: Email addresses, First Name, Company name, and Monthly Website Traffic. - Organize the data into an Excel spreadsheet. Ideal skills: - Proficient in data entry. - Familiarity with SEO metrics is a plus. - Excellent attention to detail.

...requirement then I have an immediate larger job, for millions of rows of data collection with a budget greater than $500.00 for you. 2) You will collect a total of 750,000 contact information from the following a) US and b) International university websites or from any of the online sources. Also collect contact info from V.P. of external affairs or Alumni or dean of entrepreneurship or Research. 3) It is not possible to do this job manually. You will have to automate it by writing and running web scraping script or using 3rd party App or platform. 4) Do not use chatGPT’s fake email address and phone numbers it spit out. Those are not correct. I will randomly pick some data and call them to verify the quality of your data collection. 5) No duplicate contact is...

I'm experiencing various issues with approximately 5 short Microsoft Power Automate flows. These flows primarily handle file processing and management for PDF, Excel, and Word files. Key Requirements: - Troubleshoot and fix various issues with the flows - Ensure accurate and efficient file processing Ideal Skills and Experience: - Expertise in Microsoft Power Automate - Proficient in handling PDF, Excel, and Word files - Strong problem-solving skills to identify and rectify errors in the flows

I require a configurable trigger in MacroDroid to delete all my macros on a specific date and time. Example:- - The macros will be installed on January 1st and need to be deleted on January 3rd onwards. - The deletion should occur whenever a user tries to run or enable a macro, followed by displaying an error message. - The delete date must be changeable. Skills in MacroDroid and understanding of app-triggered automation are crucial for this project.

I have an Excel file containing 7000 client information, and I need assistance in restructuring this data into a more organized format. Key Tasks: - Splitting the complete address field into separate components: Street Address, City, State, and ZIP Code. - Extracting and restructuring additional data fields including Phone numbers, Email addresses, and Customer names. - Ensuring all data is organized and presented in a clear and concise manner within an Excel file. - Ensuring there is no duplicate data Ideal Skills and Experience: - Proficiency in Excel with extensive experience in data manipulation. - Attention to detail to ensure data is accurately split and reorganized. - Strong understanding of data structuring an...

I am looking for a data entry expert who can help me transfer mixed data from my scanned documents into an Excel spreadsheet. Key responsibilities: - Accurately inputting mixed data (both text and numerical) from scanned documents into an Excel spreadsheet - Ensuring the data is organised and formatted correctly in the spreadsheet Ideal skills and experience: - Proficiency in Excel - Previous experience in data entry - High attention to detail to ensure accuracy - Ability to work with mixed data types - Experience working with scanned documents

...creating detailed categories for different types of income and expenses related to house rentals. - Full financial analysis with projections. The spreadsheet should be able to project future income, expenses and profits based on past data. - Tracking of specific financial metrics. I want to monitor my net profit margin and cash flow using this spreadsheet. Input data will be manually entered, so the spreadsheet needs to be user-friendly and simple to update. Ideal skills and experience for this job include: - Advanced spreadsheet skills, particularly in Excel or Google Sheets. - Previous experience in creating financial analysis spreadsheets. - Knowledge of real estate income and expense categories. I am looking for a freelancer who can deliver a high-quality, d...

I'm seeking an experienced Excel professional to create a comprehensive balance sheet for tracking my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required at this moment, the ability to easily incorporate them in the future would be a significant advantage. Please ensure the design is user-friendly and intuitive. Excel VBA skills could be beneficial for automating some parts of the sheet.

...50 municipalities (by population) to see if each website has a business directory. c) If a municipality website does have a business directory, scrape/download the business directory for businesses’ contact details. As an example, the City of Mississauga in the province of Ontario has an online directory that lists 14,481 businesses in Mississauga, and allows users to download the list as an Excel file (I have already downloaded info for all of these businesses): Note: some municipality websites don’t have business directories. That’s fine - I just want you to check the top 50 municipality websites and determine which ones do have business directories. So to summarize the

I'm looking for a VBA expert to create a macro that connects data fields from Tab 1 (blue-shaded) to corresponding row columns in Tab 2. The two tabs share the same column/field headers where relevant. Key Requirements: - Create a single button macro that generates a new row in Tab 2, based on inputs from Tab 1. - The macro should prompt for confirmation before updating Tab 2. - All fields in Tab 1 should be completed before the update. - The macro should not overwrite existing rows in Tab 2. Ideal Skills: - Proficient in VBA programming. - Excellent understanding of Excel macros. - Able to create intuitive and user-friendly macros. This project necessitates a professional who can write clean, efficient code and ensure seamless operation of...

Hello I need an experienced WordPress developer who can assist me with importing custom attribute variations into my WP site using the WP All Import plugin. I have a standardized Excel file ready, but I am struggling with mapping the data to the appropriate WP All Import fields. Key Requirements: - Extensive experience with WordPress and WP All Import plugin - Proficiency in mapping Excel data to WP All Import fields - Ability to work under tight deadlines I would like to have this issue resolved as soon as possible, preferably today or tomorrow. Your quick response and expertise will be highly appreciated. I have later more Projects similiar to that. Thank You

I require assistance in scraping specific financial reports from various websites. This task will involve gathering Sec 10q and 10k reports for 80 companies for 12 years Ideal skills for this project: - Proficiency in web scraping tools and software - Experience in gathering financial data - Ability to compile data into a clear and usable format - Attention to detail and strong analytical skills Pull the reports and save them as is in three formats HTML Excel Pdf For example Apache company: I will give the list of companies and the freelancer can get the reports back and mark them on a spread sheet. Please specify the budget you are looking at. I will go with the best skills and best price The work can be

I need an excel worksheet created for use below is needs for the project -Current Excel and Useable in 365 - Formulated, Formatted, Automated Use of the Workbook- Project Management Request, Project and Task Tracking , Master Log for ease of viewing all project details Job Posting: Excel Workbook Developer for Project Management & Task Tracking Project Overview: We need an experienced Excel developer to create a workbook for managing projects, tasks, and work orders, with automation features like email notifications and dynamic dashboards. The workbook should be easy to use and compatible with Excel 365 for sharing and collaboration. Key Features: 1. Master Project Template: • A template for setting up new projects, which automatically...

I'm seeking a skilled developer for...notifications - An array of advanced features In addition to basic tracking, I want the app to encompass advanced features such as: - Technical analysis tools - Historical data analysis - Integration with brokerage accounts Ideal candidates should have considerable experience in financial app development and a keen understanding of stock market dynamics. Two-factor authentication is preferred for user authentication. The app needs to support iOS, Android, and Web. Skills & Experience Required: - Extensive Financial App Development - Understanding of Stock Market Dynamics - Proficiency in PHP, Python, MySQL, Excel, Power BI, etc - Software Architecture and Testing Skills - Familiarity with Blockchain and AI - Design and Editi...

I'm looking for someone to research and gather comprehensive information about art schools in Singapore. Do use the excel provided. Ideal skills for this job include: - Strong research skills - Ability to synthesize and present information clearly - Familiarity with the art education sector will be a plus

...sponsorships, or affiliate marketing. 3. E-commerce: Create and sell handmade or curated products on Etsy or Shopify. Drop-ship products using platforms like AliExpress. 4. Online Tutoring: Offer to teach a subject or skill (e.g., language, coding, cooking). Use platforms like Preply or Teachable. --- Phase 3: Financial Management 1. Track Income & Expenses: Use simple tools like Excel or apps like Mint to manage finances. 2. Reinvest Earnings: Allocate a portion of your profits to marketing, tools, or expanding services. 3. Savings & Growth: Start saving for future investments, such as opening a small business. --- Expected Outcomes 1. Short-Term: Earn $200-$500 monthly through local services within 1-2 months. Build a small client base...

I've got a drawing for a commercial building and I need an estimate of the concrete quantity and the amount of rebar needed. The estimate should be basic and approximate quantities. Please deliver this in an Excel spreadsheet. Ideal Skills: - Experience in construction quantity surveying - Proficiency in structural analysis - Skilled in using Excel for data presentation

I'm looking for an Excel expert to help me prepare a monthly work schedule for my employees. Key Requirements: - Incorporate a 6 workdays, 1 weekend pattern into the schedule, with a custom shift rotation - Include employee names and shift times in the schedule - Potentially include holidays, workdays, weekends and days off Ideal Skills: - Proficient in Microsoft Excel - Previous experience in creating work schedules - Ability to understand and implement custom work patterns - Attention to detail

...Specialists for Middle Eastern Clients Project Description: We are a digital agency searching for experienced and creative Social Media Marketing (SMM) specialists to manage and grow our clients’ presence across various platforms. Our clients are primarily small and medium-sized businesses targeting Middle Eastern markets, requiring multilingual content in Arabic and English. The ideal partner will excel in crafting culturally relevant, engaging strategies tailored to the region, managing campaigns from ideation to reporting, and driving measurable results. Project Scope: Key Responsibilities: 1. Social Media Strategy Development: • Research target audiences and develop tailored social media strategies. • Identify the most effective platforms for the clie...

I'm in need of an Excel expert who can help me set up a formula for tracking my income. Ideal skills and experience for the job: - Proficiency in Excel, particularly with creating and customizing formulas - Experience in financial calculations - Prior experience in income tracking setup preferred The project involves setting up a formula in an Excel spreadsheet that can assist with financial calculations related to income monitoring. Please bid if you have the required expertise and experience.

I'm looking for an Excel expert to help me prepare a monthly work schedule for my employees. Key Requirements: - Incorporate a 6 workdays, 1 weekend pattern into the schedule, with a custom shift rotation - Include employee names and shift times in the schedule - Potentially include holidays, workdays, weekends and days off Ideal Skills: - Proficient in Microsoft Excel - Previous experience in creating work schedules - Ability to understand and implement custom work patterns - Attention to detail

I'm looking for a proficient data extractor who can download all questions and responses from a website. The link will be provided in chat for safety. Requirements: - Download all data without any filters - Format the data into an Excel file - Provide the completed Excel file via a cloud storage link (e.g., Google Drive) Ideal Skills: - Experience with data scraping and Excel - Familiarity with cloud storage services - Attention to detail to ensure all data is accurately captured and formatted.

...Title: Seeking Creative and Multilingual CMS-Based Website Development Providers Project Description: We are a digital agency looking for highly creative and reliable outsourcing partners to handle small, standard website projects. These websites will be built using a CMS (e.g., WordPress) and cater to multilingual audiences, primarily targeting Middle Eastern markets. The ideal provider should excel in front-end development (HTML, CSS, JavaScript) and CMS customization, while ensuring that websites are visually engaging, user-friendly, and culturally adapted for Arabic (RTL) and English (LTR). Project Scope: Typical Website Structure: Our projects typically include the following pages: 1. Home Page: Creative, visually appealing, and engaging. 2. About Us: Highlighting t...

Looking for a full sta...automatically receive reminders for the event via WhatsApp and email. • Automation tools like Power Automate or other free solutions should be used (no paid 3rd party integrations allowed). 3. Backend Dashboard for Admin • The admin should: • Able to upload an Excel file containing a list of attendees to be added to the sign up database • Create and schedule to Trigger *Unlimited* bulk messages (email and WhatsApp) from the dashboard to remind/invite them to a Zoom session. • Functionality should include: • Bulk messaging from the Excel data. • Management and re-blasting scheduling options for reminders. Recourses : Website is using wordpress . Microsoft suite , hosting . Send me the Vidoe , steps and meth...

I require an expert in Google Sheets or Excel to assist me with complex formulas and functions, specifically for advanced financial modeling with financial data. Ideal Skills and Experience: - Proficient with Google Sheets and Excel - Expertise in complex formulas and functions - Experience in advanced financial modeling - Familiar with handling financial data

I'm seeking a freelancer to provide 2000 verified email leads from restaurants across the USA. The leads should be top-level contacts, one per restaurant. Your work should be delivered in an Excel spreadsheet. Ideal candidates for this project will be skilled in data sourcing, lead generation, and Excel. Previous experience in the restaurant industry or with B2B lead generation is a plus. Please note: All leads must be verified and legitimate. Quality over quantity is key.

...designed to import product data from Excel files, scan product barcodes (or manually input product codes), and generate and print labels that include product information along with QR codes. The system uses Tkinter for the GUI, Pandas for data manipulation, SQLite for storing product data, QR Code generation with the qrcode library, and ReportLab to generate PDF labels. Additionally, Win32 APIs are used for printing the labels. Core Features: Import Product Data from Excel: The user can import product information from an Excel file (either .xlsx or .xls format). The Excel file should contain the order number in cell B1, and the product data starts from row 3 (ignoring the first two rows). The product data sho...

...primary objective is to create a dashboard that seamlessly integrates with Excel as the data source and automatically updates daily to provide real-time insights. The freelancer will need to set up a system where data entries in Excel synchronize directly with Power BI without manual intervention, ensuring accuracy and efficiency. The dashboard must include sections to represent data for two distinct product categories: Aggregate Production and Rock Production. For each product, the dashboard should display three key metrics: For The Day (FTD), For The Month (FTM), and cumulative values up to a selected date. To enhance usability, the dashboard should feature interactive slicers, allowing users to filter and analyze data by date, project, and...

...highly proficient in Excel and has a solid understanding of basic math. The project involves organizing a set of simple numerical data according to various metrics. I have provided a sample dataset along with a detailed list of requirements for this task. While the work is straightforward for someone experienced in Excel and able to follow directions, attention to detail is essential. If this initial project is completed successfully, I have several additional datasets that will require similar organization. One of the key requirements is that the Excel file must be dynamically formulated. Any edits or additions to the data should automatically update the corresponding metrics and visualizations across various tabs. I have already created the founda...

I'm in need of an Excel expert who can create a formula for me to match multiple criteria across several sheets in a workbook. The criteria involve both text and numerical values. Key requirements for the task: - The formula should be able to match text values and numerical values - The formula should retrieve specific data based on the matched criteria - The data retrieval should be from multiple sheets in the same workbook Ideal skills for this project: - Proficiency in Excel - Experience with formula creation - Understanding of data retrieval techniques in Excel

...- Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont waste your time and bid If you have exp...

I need a skilled developer to create a desktop Excel and Office 365 online Add-In for me. The primary use of this Add-In will be the implementation of custom formulas. Key Features: - Automate tasks such as data entry, report generation, and data validation. - Custom formulas should support data aggregation from multiple sheets and integrating with external data sources. Ideal Skills: - Proficiency in Excel Add-In development. - Strong understanding of creating custom Excel formulas. - Experience with automating Excel tasks. - Capable of implementing data aggregation and external data integration features. I'm looking for a freelancer who can deliver a high-quality, fully functional Add-In that meets these spec...

I have a Python web scraping code that needs fixing due to a recent update on the website. The code is currently failing at the data extraction phase, specifically with extracting tables and structured data. - Data Extraction: The code is unable to retrieve the necessary data from the website. - Data Type: The focus is primarily on extracting tables and structured data. - Data Usage: The extracted data will need to be saved as CSV and Excel.. Ideally, the freelancer for this project should have substantial experience with Python, web scraping and database management. Familiarity with the site would be a plus. Please provide examples of similar projects you have completed in your bid.

Freelancer Contest # 1 Dec. 26, 2024 Post link to the populated Excel sheet according to the following requirement. If you post anything else then that is just junk and trash for me. This contest is for $25.00 award to the best deliverables submitted, within 7 days, by any freelancer according to the following requirements. Winner will be given the opportunity to accept the main project for $600.00 Contest Requirements: 1. You will collect a total of 100,000 contact information from the following university websites or from any of the online sources listed below. 2. Populate the Excel sheet, remove duplicate, clean it up with proper formatting, post link to the populated Excel sheet. I do not want to see email in phone column or vice versa. Email is the most ...

I'm looking for a data analyst with strong skills in MS Excel, Java, and HTML. The primary focus of this project is to analyze and report on sales data. Experience in data visualization and reporting is crucial, as the results will need to be presented in a clear and coherent manner.

I need a qualified architect or quantity surveyor to prepare detailed architectural and structural drawings along with a comprehensive Bill of Quantities (BOQ) for a residential villa extension in Harmony 2, Tilal Al Ghaf. Scope of work: - Preparing floor plans, elevations, and sections. - Providing structural and steel detailing. - ...elevations, and sections. - Providing structural and steel detailing. - Developing an itemized BOQ for materials and labor. - (Optional) Supporting authority approvals. Requirements: - Proven experience in residential projects. - Familiarity with Dubai authority standards (e.g., DDA, Dubai Municipality). - Ability to deliver within 1–2 weeks. Deliverables: - Complete drawings (PDF and CAD). - BOQ in Excel format. Assistance in comparing recei...

I need assistance from an Excel expert to help me merge data for 120 people over the course of three years. Key Requirements: - Proficient in Excel with extensive experience in data manipulation - Able to understand and work with a single sheet that has different columns for each year - Capable of providing insight into the data to improve understanding and future planning Your expertise will help me understand the data better and plan accordingly for the future.