Excel vba update records jobs

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

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

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'm in need of a comprehensive, web-based hospital management software. This software should cater to the following aspects: - Patient Records Management: The ability to efficiently handle and track patient data. - Scheduling and Appointments: A system for managing hospital schedules and patient appointments. - Billing and Invoicing: An integrated system for hospital billing and invoicing. Crucially, the software must support varied access levels for different user roles, specifically: - Administrator - Doctor - Nurse - Receptionist Ideal candidates for this project should have extensive experience in software development, particularly in the healthcare sector, and a strong understanding of the requirements for different hospital roles. Excellent knowledge in creating secu...

I'm looking for a program tailored for private investigations. This software should be capable of outputting all information, posts, and pictures from a person's digital footprint online. Key Features: - Surveillance capabilities across all platforms, not just social media sites but also blogs, forums, and public records and databases. - An exhaustive reach, covering 'everything that's out there'. - Specific tracking on all major social media platforms including Facebook, Twitter, Instagram, and more. - AI-powered analysis to identify and highlight patterns or connections in the gathered data. - Multiple data export options including CSV, PDF, and other formats for easy reporting. - Historical data retrieval to access information that has been deleted or a...

search and download

I'm looking for a talented web developer with strong CSS skills to help improve the visual style of my website without altering the existing layout. The focus will be purely on enhancing the overall aesthetic appeal of the site. Website: Currently, the website uses Bootstrap 5 as a CSS framework. Key Responsibilities: - Update and refine the CSS styles to enhance the site's visual appeal - Ensure no changes are made to the current layout Ideal Skills: - Proficient in CSS / Bootstrap - Experience with web styling - Strong eye for design and aesthetics Please note that I do not have any brand guidelines or design references, so a creative approach and a good sense of modern web design will be greatly appreciated.

I'm seeking a skilled mobile app developer to create a second version of our Android and iOS logistics tracking app. The app should: - Incorporate GPS tracking - Prevent the OS from putting the app to sleep while an active shipment is in progress (It needs to update our system of its location every X miles traveled or hourly) - Integrate with our internally developed proprietary software's API (Read and write access) The ideal candidate will have extensive experience in mobile development and integrating apps with complex systems. Familiarity with logistics and tracking systems will be a significant advantage. In addition, I would like to discuss the management of our mobile development accounts. If you have experience in this area, please highlight it in your proposal.

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

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 analytical skills to understand and appl...

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.

Project Overview We are looking for a Django/Python developer with experience in MediaCMS to complete two tasks on our website, , which is built on the MediaCMS platform (Python/Django framework). Project Scope ? Project #1: Fix Video Indexing Issue Our site has an issue where newly uploaded videos are not being properly indexed and do not appear in search results or certain sections. We need an experienced developer to diagnose and fix this indexing issue to ensure all videos are searchable and categorized correctly. ? Project #2: Merge Video Categories on Front Page We currently have multiple video categories displayed as separate sections on the front page: - Featured Exclusive Vids - Hot Girl Vids - Fight Vids - Fail Vids - Going Viral We want to merge all these sections under a ...

Job Description: We are seeking an experienced Microsoft Excel specialist to develop a dynamic and automated spreadsheet to monitor the status of a loan contract. The spreadsheet should efficiently track loan payments, calculate interest, and provide a structured yearly overview of the loan’s status, including the available credit line. The final solution must be compatible with both Microsoft Excel for Windows and Microsoft Excel for Mac. Project Requirements: Input Data: Loan start and end date Interest rate (%) Maximum loan amount (credit limit) Loan payment records (date and amount) Core Calculations: Interest calculation for each loan payment Cumulative interest tracking Available credit line (credit limit minus utilized loan amount) Yearly Overview ...

...Property Manager to manage and optimize our Airbnb listings. In this role, you will be responsible for posting and updating property listings on Airbnb, ensuring that they are accurately presented and attract potential guests. You will also engage with inquiries from guests, providing excellent customer service and ensuring smooth communication throughout their stay. Key Responsibilities: Post, update, and manage property listings on Airbnb Respond promptly and professionally to guest inquiries and booking requests Maintain a high level of communication with guests, ensuring a positive experience Monitor guest reviews and feedback to improve service Coordinate check-in/check-out processes and ensure properties are ready for guests The ideal candidate will have: Proven exp...

...season or demand. Communicate with Customers: Communicate directly with customers to answer their inquiries and coordinate details. Reports and Statistics: Provide reports on the number of bookings, revenue, and user reviews. Maintenance Management: Reminders for periodic boat maintenance. Document Reminders: Reminders for upcoming document expirations (license, sailing permit). Update Boat Status: Ability to update the boat's status (available/unavailable) in real-time. Additional Features: Special Offers: Create special offers to attract customers. Inventory Management: Manage safety equipment and other supplies on the boat. Technologies Used Mobile Applications: The two applications should be developed for iOS and Android. Server: There should be a robust and sec...

I need immediate help from an Excel expert to identify why my total on one financial sheet doesn't align with the revenue summary on another sheet. The task needs to be completed within 15 minutes. Ideal Skills: - Proficient in Excel - Quick analytical skills - Able to deliver under time pressure

My website is currently down due to some recent changes I made to my DNS settings. I have modified various DNS records, including A, CNAME, and MX. I am in need of an experienced professional who can: - Identify the root cause of the website issues - Repair the DNS and name server settings - Ensure that the website is up and running smoothly - Provide insights to prevent similar issues in the future Ideal skills for this job would include a deep understanding of DNS settings and name server configurations, as well as experience in troubleshooting website issues.

I'm looking for a professional and corporate styled website for crypto investment. The core of this project involves building an Ethereum Decentralized Application (Dapp) integrated with smart contracts. Key Features: - The Dapp will specifically facilitate staking and rewards. - The website will su...options:  • Crypto Payment APIs: (Coinbase, Binance, Trust wallet, , etc.)  • Fiat Payment Gateways: Crypto Wallet, Bank Card transfer  • Withdrawal Options: Bank transfer, Crypto wallets • Wallet Access for Fund management Step 7: Launch & Marketing Pre-Launch:  • Beta testing with a big user base.  • Fix bugs and security issues. Step 9: Ongoing Maintenance & Scaling  • Regularly update security featu...

...part-time role primarily involves day shifts, with a competitive salary and benefits package. In this role, your responsibilities will include: - Assessing and monitoring patient conditions - Administering prescribed medications and treatments - Collaborating with doctors and healthcare professionals - Educating patients and their families on health management - Maintaining accurate patient records - Adhering to healthcare regulations and safety standards Ideal candidates should be between 25 and 35 years old, possess a passion for nursing, and have: - Advanced Cardiac Life Support (ACLS) certification - Excellent communication and teamwork skills - Compassionate and patient-centered approach We offer: - A supportive and inclusive work environment - Opportunities for profe...

I need a proficient Excel expert who can create a comprehensive profit and loss sheet for my agricultural business. Key Requirements: - The spreadsheet should be able to track profits and losses on an individual job basis. - The design of the sheet should be intuitive and user-friendly, with clear delineation of different sections. Ideal Skills: - Proficiency in Excel and data analysis. - Experience in creating financial tracking tools. - Understanding of the agriculture industry. Please provide a portfolio of similar projects you've completed, as well as any relevant industry experience.

I would like the following features implemented on my website, : Make it easy to update the delivery time for products so that it is clearly visible to customers. Add a section on the product page with information about the exact date the items will arrive in stock. Ensure that stock status and estimated delivery time are easily accessible to customers. In some cases, display the exact delivery date directly on the product page. These improvements will help provide a better shopping experience and clear communication for our customers. Please see attched printscreen for info. Open for new design in Shopify for Stock atatus and preorder info. Main focus is the look and design for mobile version!!

Based on our conversation, we're looking to make adjustments to the workflow on as per the guidelines listed here We're hoping to have the project completed within 5 days

...businesses to reward their customers. With this feature, when a customer makes a payment at a business that has chosen this option, they accumulate loyalty points directly on the application. The company can then define how these points will be used, according to its own criteria and configurations. This enables flexible, customized loyalty programs to be set up for each company. What's more, a future update of the platform will facilitate payments via a QR code. Customers will then be able to pay for their purchases directly via the application, offering an even more fluid and modern experience. Pricing - Basic: $15/month - Loyalty: $15/month - Pay: Percentage (variable according to usage) - 1-year commitment Sales commissions 
Sales staff who sell the solution are p...

Overview A lightweight Expo React Native app for Android only, allowing users to create reports, add comments and descriptions, and export them to Dropbox as PDF files. No Play Store deployment—APK installation only. No user management or backend; Dropbox acts as storage. Key Features ✅ Report Management: Create, update reports. Each report generates a corresponding folder in Dropbox (e.g., "X-location-date"). ✅ PDF Generation: A single, predefined template for all reports (inspired by Report & Run). ✅ Dropbox Integration: Sync reports, images, and metadata (stored as a JSON file in the root folder). ✅ Basic UI: Functional, minimalistic interface with a home screen listing reports (sorted by date, filterable). ✅ Image Handling: View reports with attached image...