Excel vba update records jobs

I need assistance with handling customer data. Key Responsibilities: - Data entry - Data analysis - Data cleaning The ideal candidate should: - Be proficient in Excel. - Have experience with data management and analysis. - Be capable of cleaning and maintaining data integrity. Please note that tasks will be primarily focused on customer data.

I'm in need of a field verification executive for assisting in conducting residence, office, business and document verification du...cover the following locations: Rajasthan, MP, UK, UP, Delhi NCR. All visits will be supported by visit photographs with Selfee of executive and Geo tagged. Verifications will be conducted multiple times in a day. Each verification must be completed within 24 hours. Verification reports should be detailed and comprehensive. The verification reports should be delivered in the format: either on call, excel, or informed punched in our software or shared over email with photographs evidence of visit duly geo tagged. Reports should include a basic summary of findings. Verification tasks will be assigned daily. Verification tasks are expected to be betwe...

I'm looking for a freelancer skilled in data entry to help me extract text data from a PDF file and input it into an Excel spreadsheet. The project involves: - Extracting only text data from the PDF. - Converting this data into an Excel spreadsheet. - Applying detailed, specific formatting to the Excel file as per provided requirements. The ideal candidate will have experience in data extraction, data entry, and Excel, particularly with detailed formatting. Attention to detail is crucial to ensure accurate data transfer and proper application of formatting.

I need a freelancer for some data entry work. The task involves entering textual data into an Excel spreadsheet. The dataset is relatively small, with less than 100 entries. Ideal skills for this job include: - Proficiency in Excel - Attention to detail - Ability to accurately transcribe textual data - Experience with data entry tasks

I have an Excel workbook that has an error in the February tab. The daily totals are not posting in the correct cells. I need you to fix this issue and ensure that the tab matches both the layout and the formula structure of the January tab. Additionally, I need the remaining months of the workbook resized to look like the January tab. Ideal skills and experience for this job: - Proficiency in Microsoft Excel - Strong analytical skills to identify and rectify errors - Prior experience with data management and workbook formatting - Attention to detail to ensure accuracy and consistency

I am in need of someone to help me with updating my wordpress website, it was left unattendended for 2 years and a lot of plugin needs to be updated (mainly elementor and wpml).

...Saturday (Half-day) Joining: Immediate (within 5 days preferred) ________________________________________ Key Responsibilities • Screen candidates and assess their suitability for roles • Communicate effectively with candidates via calls and emails • Arrange and schedule interviews between candidates and hiring managers • Ensure compliance with the Applicant Tracking System (ATS) and maintain records • Shortlist qualified candidates for final manager screening • Record Keeping in CRM • Support organizational strategy during non-peak hours ________________________________________ Ideal Candidate Profile • Experience: 2-5 years in recruitment Skills & Knowledge: o Proficiency in Applicant Tracking System (ATS) and CRM software (desire...

...Developer Needed for Cart Page Redesign & Integration ( & PHP) Job Overview: We need a full-stack developer experienced in and PHP to redesign and integrate the Cart Page for the e-commerce platform. The design, Frontend, and Backend are ready—your role is to connect, modify, and fix a pricing update issue. Responsibilities: ✅ Update Cart Page Theme – Manage cart functions (add, remove, update items, show totals) and integrate with Frontend & Backend. ✅ Fix Pricing Update Issue – Ensure real-time price updates from the Dashboard to the website. ✅ Integrate with System – Ensure smooth backend integration and write clean, scalable code. Requirements: ✔ Strong & PHP experience (API integration, Frontend & Back...

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.

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...

Product Update and Listing Optimization on Shopify + Google Integration I need a freelancer to assist in updating and optimizing product listings on my Shopify store. Additionally, I require the integration and proper syncing of my Shopify store with Google to ensure the products are correctly displayed on Google Shopping and Tasks: Product Updates on Shopify: Review current product listings and update with accurate details (images, descriptions, pricing, tags, etc.). Ensure each product is properly categorized for easier navigation and searchability. Add any missing product variants (size, color, material, etc.). Update or add SEO-friendly titles, meta descriptions, and product URLs for better search ranking. Google Integration: Ensure that the Shopify store is c...

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

...key areas of focus will be: - Data Visualization: Primarily through tables with filters and functions that provide Restful-API. Your ability to create dynamic, interactive visualizations will be critical. - Real-Time Updates: This will be crucial to ensure the dashboard always reflects the most current data. The dashboard will be displaying a variety of data, primarily images, datasets, and records. Ideal Skills and Experience: - Proficient in React with a solid understanding of its core principles. - Experience in developing and customizing dashboard functionalities. - Skilled in creating data visualizations, particularly through tables with filters. - Knowledgeable in implementing real-time updates. - Familiar with working with Restful-API. - Able to handle and visualize co...

I ha...warnings due to some dependencies. I need a skilled developer to: - Fix the deprecation warnings by addressing the dependencies issues - Deploy the fixed app on Vercel - Add a custom domain to the deployed app - Implement a password-protected page for user access only - Perform a thorough review of the existing codebase for additional issues - Optimize the web app for performance enhancements - Update the version to the latest stable release Experience with Vercel and domain management is a must. I also need your expertise in setting up the password protection. The specific method for this has not been decided yet, so I would appreciate your input on the best and most secure option. Please note, the goal is to make this web app accessible only to a selected group of use...

I require a professional to integrate the Elavon payment gateway with Invoice Ninja and migrate data from the CloudOneX database to Invoice Ninja. The data to be migrated includes customer data, invoice data, payment records, settings, and others. Key requirements: - Integrate Elavon payment gateway with Invoice Ninja - Migrate data accurately from CloudOneX () to Self hosted Invoice Ninja () - Experience with Invoice Ninja and Elavon payment gateway is highly preferred. - Proficiency in data migration and integration tasks. Ideal Skills: - Invoice Ninja - Elavon payment gateway - Data Migration Please note that the payment integration includes the following features: - standard credit

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 professional content creator to prepare a comprehensive help guide for my app aimed primarily at new users. Key Requirements: - The guide should contain clear and concise text instructions complemented by visual aids such as sc...easy-to-understand language. - Proficiency in creating or working with visual aids. The goal is to make this help guide as user-friendly and informative as possible for new users. The help guide should be created as a web-based resource. Visual aids should primarily use screenshots for better understanding. The content should maintain a casual and friendly tone throughout the help guide. Please update the help guide in the website admin panel. The help guide should be detailed and thorough. Only text instructions and visual aids wi...

My Apex class is currently at 59% coverage and I need to boost it to a minimum of 85%. The areas with the least coverage are loops and conditions. I have test data available to simulate different scenarios, but I need help ensuring the tests cover specific scenarios and edge cases, particularly unusual user inputs and multiple records handling. Key Skills: - Salesforce Development - Apex Language Proficiency - Test Class Creation and Optimization - Data Simulation - Problem-solving for Unusual Scenarios Ideal Experience: - Proven track record of improving Apex test class coverage - Experience handling complex loops and conditions - Familiarity with Salesforce's development environment - Ability to work with provided test data - Experience with edge case testing in a Salesfor...

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 shou...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 propos...

I need someone to change the color theme of my PowerPoint presentation as per specific colour codes that I will provide. The update should be applied uniformly across all slides, without altering any images.

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 ...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 b...

As a Package Handler/Shipment Coordinator in Orlando, FL, I am looking for a reliable individual to manage the receipt and forwarding of packages. You will primarily deal with small parcels and medium-sized boxes. Special handling will include fragile items. Key Responsibilities: - Inspect incomin...Handler/Shipment Coordinator in Orlando, FL, I am looking for a reliable individual to manage the receipt and forwarding of packages. You will primarily deal with small parcels and medium-sized boxes. Special handling will include fragile items. Key Responsibilities: - Inspect incoming packages for damages or discrepancies - Verify package contents and update records - Forward packages to designated recipients via in-person delivery - Maintain accurate records of packag...

... - If a **Destination does not have Subcategories**, list Tours directly. - This modification should be applied to **``**. 4️⃣ **Modify the Subcategory Archive Pages (`/tours/destination-name/subcategory-name/`)** - These should **only list Tours belonging to that Subcategory**. - Ensure that no duplicate tours appear across multiple categories. 5️⃣ **Update Permalink Structure for Custom Tours Post Type** - Ensure the URL hierarchy follows this structure: ``` /tours/ → Lists Destinations /tours/destination-name/ → Lists Subcategories (if any), then Tours /tours/destination-name/subcategory-name/ → Lists only relevant Tours /tours/destination-name/subcategory-name/tour-name/ → Individual Tour Page ``` - Modify ...

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.

... Purchase a domain name and set up hosting. Go Live: Deploy the website and monitor for any issues. Marketing: Use digital marketing strategies like Google Ads, social media campaigns, and email marketing. Offer promotions and discounts to attract initial customers. Analytics: Integrate Google Analytics to track user behavior and sales performance. 8. Maintain and Update Regular Updates: Add new products, update prices, and refresh promotions. Customer Support: Provide excellent customer service via chatbot Feedback: Collect customer feedback to improve the website and user experience. To automatically extract data from PB Tech NZ () and load it onto your website, you can use web scraping techniques. However, before proceeding, it's important to note

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.

I need assistance understanding my app's situation and legal guidance. I'm looking to set up a dedicated group chat on Freelancer messaging with a legal expert. - Legal Help: I'm not sure what's happening with my app, so I could use a legal professional's perspective to help me understand the situation and assess any updates. - App Developer Communication: I'm not getting any responses or updates from my app developer, so I need someone who can also ask them what's going on. - Analyze existing contracts with the app developer to identify any breaches or obligations. - Prepare a detailed report of the current legal standing of the app. - Suggest updates to terms of service or privacy policy in light of recent app developments. - Provide a risk assessme...

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.

...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. Budget: Flat rate 5 NZD per 100 companies (100 office managers & 100 facility managers) Time: 2 days Please start your bid...

...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'm seeking assistance to get my Amazon SES account set up and approved for both transactional and marketing emails. Currently, I haven't taken any steps in the application process. Key Responsibilities: - Guide me through the Amazon SES application proces...SES account set up and approved for both transactional and marketing emails. Currently, I haven't taken any steps in the application process. Key Responsibilities: - Guide me through the Amazon SES application process to get out of the sandbox. - If necessary, assist in the setup and configuration of DKIM and SPF records to improve email deliverability. Ideal Skills: - Experience with Amazon SES - Knowledge in email deliverability techniques - Familiarity with DKIM and SPF records - Strong communication ...

I'm looking for someone to analyze an academic paper focused on the energy sector within the realm of science. The analysis should specifically c...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 experi...

I need a skilled professional to assist in cleaning up and reconciling my QuickBooks Online (QBO) accounts. Key Tasks: - Review and reconcile bank accounts, credit card accounts, and my QBO chart of accounts - Clean up and reconcile transactions from the past 7-12 months The primary objective of this project is to identify and correct errors in my financial records. This task is crucial for ensuring accurate financial reports and preparing for future tax filings. Ideal candidates for this project should have: - Proficiency in QuickBooks Online - Experience in financial account reconciliation - Strong attention to detail and problem-solving skills

...the Figma design. Additionally, if possible, you'd like to combine mobile versions with desktop versions, making the design responsive. For pages that don't have a mobile version, they should be made responsive, as there are no specific Figma designs for them. You already have a frontend built with Vanilla JS, but due to recent changes in the design and some issues with the frontend, you need to update it to match the Figma layout. There was a separate version for mobile, but not all pages had a mobile version. So the goal is to merge existing mobile versions with the desktop versions and make everything responsive. Pages without a mobile version should be adapted to be responsive since there's no Figma layout for them. For reference, you can look at the website

I'm seeking a professional service to conduct pre-employment vetting for potential candidates in Seville, Spain. Background Check: - This involves a thorough investigation into the candidate's past. The background check should cover criminal records, credit history, and education verification. Criminal Record Check: - The level of detail required for the criminal record check is the same as the background check. Ideal Skills: - Expertise in conducting comprehensive background checks. - Familiarity with the legal and ethical guidelines for background checks in Spain. - Excellent attention to detail. Experience: - Prior experience in pre-employment vetting services. - Proven track record of conducting thorough and accurate background checks. - Experience working with c...

I'm looking for a talented web designer/developer to redesign my X-CART website with a modern visual aesthetic. The primary goal is to update the visual design, so a strong grasp of contemporary design trends and principles is essential. Key Requirements: - Expertise in X-CART platform - Proficient in modern web design principles - Strong visual design skills - Experience in website migration Please provide examples of your previous work that align with a modern design style.

...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 filtered data (e.g.: performance by period, platform). 3. AI System AI Integration in Chat: Connect to an NLP API . Train the model to answer technical marketing questions (e.g.: "How to improve ROAS?"). Automatic Insights Ge...

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 help with uploading a code update (HTML/images) to my static website via GitHub. I already have a GitHub repository set up for the site, I just need some guidance on how to implement the update.

I need help modifying my Eagle PCB design. The changes involve: - Adjusting the copper across all layers to align with the Gerber files. - Making routing adjustments to ensure the design matches the Gerber. The ideal freelancer for this project should have a deep understanding of PCB design and routing, particularly with Eagle software. Experience with Gerber files and copper layer adjustments is crucial. Please provide examples of similar projects you've completed in your proposal.

I'm looking for an experienced appointment setter to help generate leads for small businesses. Key Responsibilities: - Make phone calls to potential leads - Schedule appointments for sales meetings - Report on call outcomes and lead status - Update CRM with lead details and interactions Ideal Skills: - Excellent communication skills - Experience in B2B lead generation - Ability to handle phone calls professionally - Sales-oriented mindset Experience with small businesses is a plus. The role is compensated on an hourly basis.

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.

...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 (preferably in Excel or JSON format). Condition Logic: The flow...

I'm seeking a Wix website expert to re-design my site with a focus on updating my branding. Key areas of focus will be the typography and layout, as well as the imagery and icons. Key Responsibilities: - Implement a new typography and layout as per my provided specifications - Update imagery and icons to reflect the new branding - Ensure the overall design is consistent and professional Ideal Skills and Experience: - Extensive experience with Wix website design and re-design - Strong graphic design skills, particularly in typography and layout - Experience with brand-focused website design - Ability to implement provided design specifications accurately

We will need to make a lot of changes to our website please

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 a professional bookkeeper to help me catch up with my business's financial records. My business is service-based, and I have been operating for nearly 2 years with less than 2 years worth of transactions. Key responsibilities include: - Recording all income and expenses accurately. - Preparing financial reports to give insight into the business's performance as well as to prepare for tax filing. Tools: - All bookkeeping will be done on Wave, so prior experience with this software is a plus. Ideal freelancer's profile: - Proven experience in bookkeeping, particularly for service-based businesses. - Proficiency in using Wave. - Excellent skills in preparing comprehensive financial reports. - Ability to work independently and meet deadlines.

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.