Excel vba pivot table add data fields jobs

I'm experiencing issues with Excel's conditional formatting and need an expert to help. Key issues: - Cannot copy entire conditional formatting rules across the spreadsheet. Ideal skills for this project: - Advanced Microsoft Excel expertise - Proficiency in identifying and resolving Excel-related issues - Strong understanding of conditional formatting techniques Please provide regular updates via remote. The troubleshooting will be for Excel 365.

...form plugin to do questionnaire. At th eend of the questionnaire the AI must show a report baed on answers. The web must have a form plugin jotform) The job to do: make the landing pages with information of service, add the buy page of service using table price and direct ckeckout (you can use woocommerce); add jotform; integrate the questionnaire of jotform and the answer with AI to create the authomatic report. The questions of jotform and the answer of jotform must be saved inside my mysql database. So it is necessary use a plugin to create the tables and save the answer add a plugin or code to comunicate with an AI the plugin (wpautomator o Ai engine). Finally it is necessary show the report inside a web page and create a pdf. The report must have an ex...

I'm seeking an instructor to help me grasp the concept of optimization, focusing primarily on Linear Programming. As a beginner with Excel Solver, I need someone who can guide me through solving questions with various constraints. Key Requirements: - Expertise in Linear Programming. - Proficient in teaching Excel Solver. - Capable of explaining different types of constraints depending on the case study. -solve with me questions Ideal Skills: - Advanced knowledge of optimization techniques. - Strong communication and teaching skills. - Experience in using Excel Solver for complex problems. As the type of constraints we will be working with will depend on the case, I require a flexible and knowledgeable instructor who can adapt to different scenarios and explai...

I have approximately 3000 rows of data spread across three Excel 365 sheets. I need someone to extract, link, and manage this data for me. The final deliverable will be a detailed report in Excel. This report should include: - Data summaries - Trends and patterns - Comparative analysis PEASE REFER TO THE ATTACHED EXCEL FILES WHICH WILL BE USED THE SCOPE FOR THE BID IS IN THE WORD DOCUMENT There's no need for complex formulas, but the ability to identify and highlight these aspects of the data will be crucial. Your expertise in data management and proficiency in Excel will be key to the success of this project. THANK YOU FOR THE TIME TO READ AND BID

...Northwest Seed & Pet on top + Spokane, Wa est. 1944 on the bottom (top & bottom words in a circular arc) *I can send a better pic asap. one of the entire bear showing him with no one sitting on it. 8. Tucker, the tortoise 9. Flower/Plant design with Northwest Seed & Pet Spokane, WA est. 1944 on top 10. Plants/Green House with Gertie the cat silhouette by the back door, Ruby the parrot on the pants table, and an iguana on the top bar, as in the picture.  11. Fish design with Northwest Seed & Pet Spokane, WA est. 1944 on top 12. Division store outline - in sketch style - please include the geckos that are on the building.  13. Sprague store—in sketch style—can include cars out from like in the pic, but if it looks better without them, that'...

I am looking for a data operator to assist with a complex data entry project. The ideal candidate should have experience in data entry from digital files, specifically using Microsoft Excel. The work involves significant formatting and clean-up of the data. Skills and experience required: - Proficiency in Microsoft Excel - Strong attention to detail - Ability to handle complex data entry tasks - Experience in formatting and cleaning up data - Experience with creating and using Excel Macros 1 year If you are meticulous, experienced in data entry, and proficient in Microsoft Excel, please apply for this project.

I have 35 pages of handwritten documents that need to be typed in xl. The specific requirements, such as document format and font style, can be budget is $10 if you think this is good for you then you are welcome. Otherwise please do not be on this project.

I'm seeking a skilled photo editor to help me with 50 food photography images featuring pizzas. The task is to remove the table and tray backgrounds, leaving just the pizza. The final images should be delivered in PNG format, ready for use in print materials. Key Requirements: - Remove backgrounds from food photography - Crop images naturally, exactly at the edge of the pizza - Deliver final images in PNG format Ideal Skills: - Proficiency in photo editing software - Attention to detail - Experience with food photography editing Please only apply if you can deliver clean, natural-looking images ready for print.

I'm seeking a freelancer adept at data entry, specifically from digital PDFs into an Excel spreadsheet. The task involves extracting solely text data from these documents. Ideal Skills: - Proficient in Excel - Excellent attention to detail - Experienced in data entry from PDFs Expectations: - Accurate and timely completion of the task - Ability to maintain data confidentiality - Effective communication for any clarifications needed

I'm seeking a professional for data entry, specifically focused on numeric data. The data will be sourced from various digital documents and should be entered into either Excel or Google Sheets. Ideal Skills: - Proficient in Excel or Google Sheets - Attention to detail - Experience in data entry, particularly with numeric data - Ability to maintain confidentiality and handle sensitive information responsibly.

I'm seeking an experienced data analyst and Power BI expert to design an engaging and insightful dashboard for tracking both project progress and financial metrics in the construction industry. Key Features: - The dashboard should track project-related metrics such as completion percentage, milestones achieved, and tasks overdue. - Financial metrics should include revenue forecasts, expense categorization, and project rating. Ideal Skills: - Proficient in Power BI - Strong background in project management tracking and financial reporting - Experience in the construction industry is a plus - Excellent data visualization skills The dashboard should integrate data from Excel/CSV files. start proposal with PREMIER

I need a data entry/web/Instagram scraping specialist who can help me categorize the 2600 businesses I follow on Instagram. The businesses primarily belong to the fields of architecture, construction, and development, with specific focus on: - Architects - Builders - Developers - Project Managers - Landscape Architects The categorization should include the following fields: - Company Name - Website - State - Profession - Do they follow me back A good command of English is essential for this task, as is the ability to follow clear instructions and input data accurately into an Excel spreadsheet. Experience in data entry, web scraping, and social media analysis would be highly beneficial.

I'm seeking a proficient Excel user for data entry and analysis. Skills and Experience: - Proficient in Excel with experience in using Pivot tables, Formulas and calculations, Charts and graphs - Attention to detail for accurate data entry - Ability to analyze data and generate reports if needed Please note that the specific type of data and primary goal for this project have not been specified. The successful freelancer will need to be flexible and adaptable to different types of data and tasks.

...design for mobile and desktop. SEO optimization for better visibility. 2. Choose a Technology Stack Frontend: HTML, CSS, JavaScript (React.js, Vue.js, or Angular for dynamic interfaces). Responsive design frameworks like Bootstrap or Tailwind CSS. Backend: Node.js, Django, Ruby on Rails, or Laravel for server-side logic. Database: MySQL, PostgreSQL, or MongoDB for storing product and user data. E-commerce Platform: Use an existing platform like Shopify, WooCommerce (WordPress), or Magento for faster development. Alternatively, build a custom solution for more flexibility. Hosting: Cloud hosting providers like AWS, Google Cloud, or Azure. Content Delivery Network (CDN) for faster loading times. 3. Design the Website Wireframes and Mockups: Use tools like Figma, Adob...

I need an annual Profit and Loss statement prepared for an SBA loan application. It will be in Excel format. Key Tasks: - Prepare the P&L statement in Excel - Follow a standard template or best practices, as I don't have a specific template - Cover the statement for the entire year Skills and Experience: - Proficiency in Excel - Experience in preparing Profit and Loss statements - Familiarity with SBA loan requirements - Ability to suggest and implement standard templates or best practices.

...contract should be able to be signed, have necessary fields filled out, and be compatible with both iOS and Android devices, as well as desktop or laptop computers. The contract should have both online and offline functionality. Key Requirements: - The digital contract must include various input fields such as text fields and checkboxes. - It should have a designated area for the signatory and be capable of sending the completed contract to an email upon submission. - The signing method will be a digital signature, so the developer needs to implement this feature. Ideal Skills and Experience: - Proficiency in PDF and contract digitization - Experience in developing cross-platform applications - Knowledge in implementing various input fields in a digital for...

I'm seeking assistance in improving the organization of my Excel sheet which records staff daily work activities. The primary focus will be on refining the data layout for better clarity and accessibility. I need to separate outreach calls vs in-person assistance/community events. I started formula to total based on week and the month. Ideal Skills: - Proficiency in Excel, particularly in data sorting and filtering. - Experience with creating organized data layouts. Although I don't have specific formulas in mind, I would appreciate a professional with knowledge of various Excel functions who can suggest and implement suitable ones to enhance the functionality of the sheet.

Hi there I'm seeking a professional who can help me gather data from 100 UK websites. This data should include: - Company name and its corresponding LinkedIn page URL - Work email addresses of facility managers and office managers (London-based) - LinkedIn profile URLs of the aforementioned managers - The source link for each piece of data An Excel template will be provided for you to input the data. The ideal freelancer for this project should be: - Detail-oriented and able to follow instructions accurately - Proficient in data collection and research - Familiar with LinkedIn and its functionality - Able to work with Excel Please note, I only require work emails, not personal ones. The companies should be in the legal industry. ...

I'm in need of a professional resume that reflects a well-rounded work experience. The ideal candidate for this job should have a strong background in resume writing, particularly aimed at creating versatile resumes that can cater to various industries and job levels. Key requirements: - Abil...customizing resumes to match specific job descriptions and roles - Competence in conducting keyword research for resume optimization - Experience with resume design and visual layout to enhance readability - Expertise in writing resumes for individuals undergoing career transitions - Strong proofreading and editing skills to ensure error-free resumes Experience in corporate, creative and technical fields will be an added advantage. The goal is to create a resume that showcases a well-...

...a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that info. I have used substitute functions, then did evaluate formulas, but doesn't turn out right. Key Responsibilities: - Develop an Excel template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Ideal Skills: - St...

I have numerous Excel workbooks containing sales data that need to be cleansed and transformed into a single table. This project requires expertise in data processing and analysis. Key Tasks: - Cleanse the data from individual workbooks to a single workbook table - Transform the cleansed data into a single comprehensive table -there are approximately 300 workbooks, that each have about 8 sheets of similar data that is not tabled -extracting "amount paid to installer" sheet information is not part of this scope, but could be added at additional cost if it make since to extract that data at the same time. Do not include this in your price, but if interested chat message about details. The final table sho...

...Branding Video Overview: I’m creating a high-energy, cinematic personal branding video as part of a job application for a Strategy Consultant / Business Development role at Arcane Marketing. This is not a standard talking-head video—this is a visually dynamic, engaging storytelling piece that blends humor, authenticity, and creativity to showcase who I am, my skills, and what I bring to the table. I’m looking for a freelance videographer to assist with shooting, framing, and potentially some light editing. The shoot involves multiple locations, a mix of cinematic and comedic shots, and drone footage. I’ll provide a detailed shot list and schedule—just need the right pro to help execute the vision. What I Need from a Videographer: ✅ Pro-l...

I'm looking for someone to analyze an academic paper focused on the energy sector within the realm of...specifically cover the experimental results presented in the paper. Key Requirements: - Expertise in the energy sector of science. - Strong skills in analyzing experimental results. - Ability to provide clear and concise interpretations of findings. Task: - Understand the method that undergoes in the following research paper - Write the maths that goes from the data till the results step by step on paper and send the pdf - After that make an excel for conducting such step by step maths The ideal freelancer for this project will have a strong background in science, specifically the energy sector, and can demonstrate experience in analyzing academic papers and their...

...seeking multifaceted expertise in Software Development, AI, Cybersecurity, and IT Support. This includes but is not limited to: - Python Development: Proficient in building software with Python. - Web Scraping: Need for extracting data from websites. - Process Automation: Streamlining tasks to enhance efficiency. - Cybersecurity & Pentesting: Safeguarding systems against threats and vulnerabilities. - IT Support: Providing technical assistance and troubleshooting. - Server Configuration: Setting up and managing servers. - Data Analysis: Interpreting complex data sets. - Machine Learning: Implementing AI solutions for predictive analysis. Ideal candidates will have a robust understanding and experience in these areas, with particular emphasis on Software Develo...

...analysis to identify opportunities for growth. • Optimize on-page and off-page SEO to increase organic visibility. • Collaborate with content teams to ensure SEO best practices are incorporated into all content. Technical SEO Management • Perform website audits to identify and fix technical SEO issues (site speed, mobile usability, crawlability, indexation, schema markup). • Implement structured data, meta tags, and alt attributes to enhance search engine understanding. • Work closely with developers to resolve technical SEO issues and improve website performance. • Ensure compliance with Google's core web vitals and other search engine ranking factors. Keyword Research & Content Optimization • Conduct in-depth keyword research to ident...

I need to leverage AWS Bedrock for extracting specific fields from my scanned documents. This task will involve processing a daily influx of these documents. Key Requirements: - Extract fields: Names and addresses, Dates and case numbers from legal documents. - Deploy the model across different AWS accounts. I need to learn what Bedrock models I can use for this purpose, how to train my model for better accuracy and finally, how to deploy this model to different aws accounts. Ideal Skills: - Proficiency in AWS Bedrock. - Experience in document processing and field extraction. - Knowledge in deploying models across multiple AWS accounts.

I'm in need of a tailored CRM solution for my enterprise, with a primary focus on customer support functionalities. The ...should primarily facilitate effective customer support. - Sales Management: Incorporate lead tracking, pipeline management, and sales forecasting capabilities. - Personalization: The CRM should allow for extensive personalization including custom fields and layouts, automated workflows, and personalized dashboards. Ideal Skills and Experience: - Proven experience in CRM development, particularly for enterprise use. - Strong understanding of customer support and sales management functionalities. - Expertise in creating personalized systems with custom fields, automated workflows, and personalized dashboards. - Ability to deliver a user-friendly and e...

...Ads and TikTok Ads to retrieve real-time data (e.g.: campaigns, metrics, budget). Create an OAuth2 authentication system for these platforms. Real Authentication System: Replace the current mock with a secure system (e.g.: Auth0, Firebase Auth, or JWT + OAuth2). Add permission controls (e.g.: admin, analyst, client). Real-Time Notifications: Develop an alert system using WebSocket or tools like Pusher/Socket.io. 2. Data Features Data Synchronization: Create jobs to automatically update campaign data (e.g.: every 5 minutes). Store metrics history for temporal analysis. Automatic Insights Calculation: Develop algorithms to identify trends (e.g.: "CPA increased by 20% in the last week"). Report Export: Generate PDF/Excel with...

I am looking for an Excel professional who can assist me with implementing VLookup, HLookup, and X-Lookup functions in my spreadsheets. Key tasks include: - Implementing these lookup functions to streamline data analysis and financial report creation. - Assisting in the update of data across different sheets to ensure all reports are current. The primary report we need to generate is a product costing sheet. Ideal candidates should have: - Extensive experience with Microsoft Excel, particularly with lookup functions. - A strong understanding of financial reporting. - Excellent attention to detail and ability to work with complex data sets.

I'm looking for a professional to create a fillable 3-page PDF form for application submissions. This form will primarily be used to collect personal information and income details. Key Requirements: - Experience in designing fillable PDF forms - Ability to incorporate specific data fields for personal and financial information - Attention to detail to ensure the form is user-friendly and functional The ideal candidate will have a strong background in PDF form creation and data collection processes. A keen eye for design and usability will be a significant advantage.

...challenges with implementing form fields. Specifically, I need these fields to visually resemble real input elements within the editor while supporting live updates, similar to other elements. Additionally, they should retain their settings when deselected and reselected. While the save/load functionality is largely implemented, some object types are causing issues during loading. also get the video field type to work correctly. also make sure the settings panel is fully functioning and storing all settings/loading settings. I am seeking assistance in refining these aspects of the editor to ensure seamless functionality. The entire plugin was built inhouse with react, babel and fabric Please utilize React for enhancing the live editor. Prioritize ensuring form fiel...

I'm seeking a Smartsheet professional who can help with automating data synchronization from Excel files into the platform. Ideal Skills and Experience: - Extensive knowledge of Smartsheet and its workflow automation features - Proficiency in Excel and understanding of data synchronization processes - Previous experience working on similar projects - Excellent problem-solving skills to troubleshoot any issues that may arise during the automation process - Ability to understand my specific needs and tailor the solution accordingly.

Subject: Power Automate Flow for Extracting Data from Wedding Agreement (Adobe Sign) and Updating Excel Hi, I need help in creating a Power Automate flow with the following requirements: Objective: The goal is to extract data from a completed wedding agreement (Adobe Sign) and add the relevant information into an existing Excel file. Depending on specific data in the agreement, I need the flow to either add one or two rows in the Excel file and update those rows with the extracted data. Key Steps: Trigger: When a wedding agreement workflow is successfully completed (signed), the flow should be triggered. Extract Data: Use the Get form field data action to extract the form data from the agreement (pr...

I need help with a mail merge project. I have a Word document that needs to be populated with names and from an Excel file. And then I then I also need one for mailing labels or printing on envelopes. Ideal Skills: - Proficiency in Microsoft Word and Excel - Experience with mail merge - Attention to detail

I need info from a PDF file transferred into an Excel spreadsheet. The PDF is a membership directory. I only need members that are a "Presenting Organization" (which starts about half-way down the directory). I've attached the PDF and a blank xls file with headers to populate. Please provide a bid and an estimate of the numbers of members to be imported so I know you understand the scope.

Subject: Power Automate Flow for Extracting Data from Wedding Agreement (Adobe Sign) and Updating Excel Hi, I need help in creating a Power Automate flow with the following requirements: Objective: The goal is to extract data from a completed wedding agreement (Adobe Sign) and add the relevant information into an existing Excel file. Depending on specific data in the agreement, I need the flow to either add one or two rows in the Excel file and update those rows with the extracted data. Key Steps: Trigger: When a wedding agreement workflow is successfully completed (signed), the flow should be triggered. Extract Data: Use the Get form field data action to extract the form data from the agreement (pr...

I'm seeking a freelancer to help me extract data from the Livescore app for all football matches over the weekend. The data should be organized into an Excel sheet with separate sheets for each match date. Ideal Skills: - Data Extraction - Excel Proficiency - Attention to Detail Please note, the specific leagues, tournaments, and data points to be extracted have not been determined yet. Therefore, flexibility and good communication skills will be vital for this project. A keen interest in football could also be an advantage. I need all this informations into Excel sheet please check image jointe

Seeking a skilled content writer for engaging blog posts in the Chemical and Life Sciences fields. The primary aim is to educate the general public about these industries in an uncomplicated and captivating way. Ideal Skills: - Proficient in simplifying complex scientific concepts - Excellent writing and storytelling abilities - Experience in marketing and audience engagement strategies - Background in Chemical and Life Sciences is a plus

search and download

Please Sign Up or Login to see details.

I'm looking for an Excel expert who can help me create a file that meets specific conditions. Here's the situation: - I have an Excel sheet with 4 columns: address (A), city (B), state (C), and zip code (D). I want in column E to automatically display the word "IMAGE". However, this word should function as a trigger: when hovering over it, a photo corresponding to the location will pop up as a note. This needs to work for every cell in that column. - There is address list - I need this to be done in an automated way. Requirements: 1. I want to be able to understand the solution, so I need you to explain it to me via video call. 2. I have experience with Excel but have hit a roadblock, so a fresh perspective is needed. 3. I don't need a lot ...

A Railway station will be designed using the DIALux program, and a report will be written. Main Components of the Report 1.⁠ ⁠...standards, and tables should be included. 4.⁠ ⁠Meeting the Requirements The lamps used in the lighting design and the reasons for their selection should be explained. The lamp layout, lighting angles, and mounting heights should be described. A table including location coordinates should be provided for field personnel to understand the setup. 5.⁠ ⁠Dialux Modeling Results Visual and written results of the calculations performed using Dialux should be included in the report. Light distribution maps, illuminance levels, glare control results, and similar data obtained after modeling should be presented. Compliance with relevant standards should be e...

I have an excel sheet consisting of about 5000 lines and about 15 columns. The data is a bit random and requires advanced logic to organize. I have added an explanation video and sample excel data sheet to the files. Due to company restrictions, I can't share the excel sheet directly, but I can provide snapshots and detailed descriptions of the tasks and formulas required. Key Responsibilities: - Utilize advanced Excel formula logic to sort data into specific categories. - Implement conditional calculations, data aggregation, and advanced filtering as per the project needs. Ideal Skills and Experience: - Proficiency in advanced Excel is a must. - Prior experience in data sorting and organization. - Strong analy...

...Objective Develop in Bubble a social platform that allows users to: Register and authenticate securely. Interact through posts and comments. Benefit from AI-backed content moderation. Send invitations to their contacts to expand the network. Participate in a safe and reliable environment with optional identity verification. 2. Key Features 2.1. User Registration and Authentication Registration Form: Fields: Email, password, first name, last name, phone number, municipality. Real-time validation (email format, password strength). Document and Selfie Upload: Optional. Supported file formats: PNG, JPG, PDF. Purpose: Identity verification. Profile Picture: Optional. Supported formats: PNG, JPG. User Status: Pending: Registered but not yet verified. Verified: User validated with docum...

I'm facing an issue with a database where certain text fields are not mapping properly. It's crucial for me to have these fields accurately aligned for data integrity. A freelancer with strong database management skills and experience in field mapping is ideal for this task. Please, reach out if you can help me fix this simple yet pressing problem.

Dear [Client's Name], I am excited to apply for this data entry project. With experience in handling various data types, including text and numerical information, I can ensure accurate and efficient entry from Excel, Word, and PDF files into designated platforms. I have a strong eye for detail, excellent typing speed, and proficiency in Microsoft Office tools, ensuring high-quality and error-free data processing. My commitment to accuracy and efficiency makes me confident in delivering results that meet your expectations. I look forward to the opportunity to assist you. Let’s discuss how I can contribute to your project. Best regards, Wan Zakwan Fitri

I'm looking for someone to help me create a line chart in a spreadsheet to display comparable equipment data. This chart will need to compare more than 3 sets of data. Ideal Skills: - Proficiency in spreadsheet software (Excel, Google Sheets) - Experience in data visualization - Strong analytical skills - Attention to detail Please provide examples of similar work you have done in the past.

I have a set of last year's ticket sale data that needs to be entered into Excel. - Data Entry: The tickets are currently in Excel 10, and I need someone to accurately input all relevant data. - Excel Skills: Proficiency in Excel 10 is crucial, as the data will be entered into this software. - No Analysis Required: At this stage, I do not require any data analysis or reports generated from the entered data. However, a keen eye for detail will be beneficial to ensure accurate data entry.

I'm looking for a professional data entry expert to help me input mixed data from various digital files. Key Responsibilities: - Accurately enter mixed data (text and numerical) from various digital sources into designated platforms. - The data source will primarily consist of digital files such as Excel, Word, and PDF. - Ensure all data is entered correctly and efficiently. Ideal Skills and Experience: - Proven experience in data entry, particularly with mixed data types. - Proficiency in handling and navigating through Excel, Word, and PDF files. - Attention to detail and ability to maintain accuracy under pressure. - Excellent typing speed and computer skills.

Generate python script to send information using the protocol: "wialon retranslator" Data is obtained from a mysql table