How to go to specific sheet in excel vbaроботи
...calories , exercise, weight etc 2) Booking tickets and cancellation 3) Arranging parties etc. I would like to start with Tracking nutrition. In this task, Myself and Wife will share audio notes of the food we took , screenshot of exercise app , etc and this needs to be tracked on an excel sheet ( along with calorie input etc) on a daily basis. We can keep sharing this on a whatsapp group and at the end of a day (or every 2-3 days) the excel sheet needs to be updated. I will share a sample excel sheet we use for calorie tracking , calorie value will be there for the usual foods we take in that sheet. For new ones you need to use websites like nutritionix or apps like healthifyme to get th...
We need an excel fully automated document for the insurance industry that can carry out the following system functions: 1) Excel to receive a word presentation from admin staff for 1 products called Rural Combined which will will contain a lot of data e.g. policyholder details, risk information e.g. names, dates of birth, property information, (risk addresses, sums insured), claims. 2) the risk information is extrapolated from the word (presumably into a CSV file and automatically driven into an excel rating calculator where it will undergo a number of functions to calculate a premium based on a set underwriting criteria where there will be rates built into the system The document will then produce a premium. 3) The information can then be merged bac...
I need a skilled freelancer to help set up a ChatGPT integrated WhatsApp bot via Make.com. I will create the prompts and training myself, but I need help setting up the connection so it is available through WhatsApp. Here is what you nee to do: 1) All work will be done with remote desktop (anydesk) for which I will provide a link and I will be there for the session. 2) Check my Whatsapp/Facebook/OpenAI settings. Is all ok? 3) Set up the connection so the chat bot is reachable through whatsapp 4) Show me how I can train and prompt the ChatGPT so it responds based on my information about the company. 5) In some way, save every interaction and let me have read access to it. Email, save in document.. however. I have active Whatsapp business accoun...
Website Development Brief for Membership-Based Food Community Website ________________________________________ Project Overview: The goal of this project is to develop a membership-based website for a food community across Australia, where users can register, access exclusive content/events, and engage with other food enthusiasts. The website will offer a range of features such as subscription management, secure payment integration, member-only access to pay for events. The overall objective is to create an engaging, easy-to-navigate platform that encourages interaction and delivers high-quality, exclusive food-related content. ________________________________________ Key Features: 1. User Registration & Membership Management o Sign-Up & Profile Creation...
tôi cần lập trình file nhập liệu ex cho tổ chức, chủ yếu là sổ sách thu chi của tổ chức, và xuất báo cáo trực qua bằng đồ thị để dẽ dàng quản lý hơn
I'm seeking a dedicated personal assistant/accountant for my engineering company. This role involves a blend of administrative ...appointments - Handling financial records and bookkeeping - Processing invoices and payments - Preparing and submitting expense reports Essential Skills: - Proficiency in accounting software, particularly QuickBooks and Excel - Excellent organizational skills - Strong communication abilities -Familiar with google drive/sheets/earth Experience in the engineering sector would be a plus, but not necessary. What is crucial is your ability to handle the finances of a growing company with precision and professionalism. Role is for one big data entry project to start along with 1-2 hours a day of on-going to start but c...
...involves manually entering details from around 240 PDF invoices into a Google Sheet. Key Details: - The data to be entered includes date of purchase, item name/description, vendor, and amount. - In most cases, i have included all these details already in the file name (ie date, vendor, and item name) - Most of the PDFs contain a single item, however, some contain multiple items. - In total, there are approximately 300-400 items to enter. - The majority of the invoices are straightforward (from Amazon, eBay, etc.) - some are services provided - I have highlighted on most of the invoices which items need to be included, where there are multiple items. You will be provided with all necessary files and a template Google Sheet to...
I'm in need of a data entry expert who can assist me in compiling and entering mixed data sourced from online databases into a database. Ideal Skills and Experience: - Proficient in data entry with a focus on mixed data (both numeric and textual) - Experience working with online databases - Familiarity with database software and tools - Detail-oriented with a strong focus on accuracy - Able to manage time effectively to meet deadlines - Experience in querying databases using SQL or other querying languages - Strong skills in data cleaning and preparation - Expert proficiency in Microsoft Excel or Google Sheets for data manipulation Your role will involve: - Sourcing mixed data from various online databases - Accurately e...
I'm seeking an Excel expert who can help me create a spreadsheet for analyzing viewing and analysing our machine assets and what stage of 'hire' they are on. Should have the ab ability to pick an asset and see the next 6-12 months, or pick a month, set of month, have one view of all assets etc Key Tasks: - Design a user-friendly Excel spreadsheet tailored for viewing and analyzing - Focus on tracking the 'Asset Hire Status'. The ideal freelancer should have: - Extensive experience with Excel, particularly in designing spreadsheets for data analysis. - Strong understanding of operational metrics. - Ability to create a spreadsheet that can track specific metrics effectively.
We have a store hosted on shopify. We received a message from Shopify indicating deprecation of the current Shopify Checkout API and need tp transition to the new Storefront Cart API or Checkout Sheet Kit. Need Shopify Expert to facilitate the migration.
I'm in need of a professional who can assist me in collecting customer information. The data collection will be primarily through online forms, and the collected data should be organized in an Excel spreadsheet. Ideal Skills and Experience: - Proficient in data collection and management - Experienced in using online forms for data collection - Skilled in organizing data in Excel - Attention to detail to ensure data accuracy
Hi, I'm looking to convert CMM to an application with the following features ordered by necessity with the top 3 being the most important for now. Need help with some other coding items but wanted to get this project in motion and can fine tune the code as we go Main coding issue - having Airbnb, VRBO and all travel site bookings to feed automatically. The guest who booked yesterday was from Airbnb and we then have to manually add to CMM to track all data and calendars on our backend for direct bookings and other sites mixed together into one calendar. I need all bookings to auto sync to the system / owner / calendar / automation immediately upon booking confirmation. WEBSITE TO APP FEATURES...
...Description: I am seeking freelancers with expertise in the following areas: Content Writing: Articles, blogs, and creative story writing. Typing and Copywriting: Fast and accurate typing skills for various projects. Translation: Professional translation services for documents and content. Medical Writing: Assistance with healthcare-related content and research. Data Entry: Accurate and efficient data management. Diet & Public Health Research: Creating reports and articles related to diet and health. PowerPoint Presentations: Creating professional and engaging presentations. Excel Work: Data analysis, charts, and spreadsheet management. Requirements: Strong attention to detail. Relevant experience in any of the above-mentioned fields. ...
I'm seeking a skilled mobile app developer to create an iOS application to manage my loan business. The app should handle various loan parameters and client data, and automate calculations and notifications. Key Features: - Client data management - Loan amount tracking - Interest calculation - Timeframe for repayments - Notification system for due payments - Investor tracking for each loan - Capital totals for investors - Monthly interest calculations for each investor - Active/settled loan status toggle - Automatic Excel database updates Ideal Skills: - iOS App development - Database management - Excel integration - Notification system implementation - Financial software development experience The app should support manual data entry. Please note tha...
...a Linux-based system to monitor and analyze all network traffic, both ingress and egress. Key Requirements: - The eBPF agents should capture and analyze all types of traffic, not limited to HTTP/HTTPS or DNS traffic. - A focus on creating a real-time dashboard to present the data. The dashboard should be user-friendly and provide real-time insights into the network traffic. Ideal Skills: - Extensive experience with eBPF and Linux systems. - Proficiency in network traffic analysis. - Experience in creating real-time dashboards. - Strong understanding of network protocols and traffic patterns. Please note that while the analysis will cover all traffic, the specific data points of interest have not been defined. Therefore, the freelancer shou...
...platform and their API to assist me with setting up the Interactive Brokers API on my computer and then writing a custom algorithm in Python or C++ to enable me to automate trading of a specific strategy that I find it hard to do due to my timezone being not good for the US Market open and close times. Key Skills and Experience: - Proven experience with Interactive Brokers API - Expert in Python - Strong understanding of algorithmic trading - Excellent communication skills I have a clear vision of the trading strategy I want to implement. The freelancer will need to translate my specifications into a working algorithm. Understanding of various trading strategies such as trend following, mean reversion, and arbitra...
I'm in need of a Google Sheets Expert to create a user-friendly Employee Attendance Tracker for me. This system will track punch-in/punch-out times for a small team of 1-10 employees. Key Features: - A Google Sheet where employees can log their daily work hours. - Automatic calculations of total hours worked per day. - A summary section that updates daily to track monthly totals for each employee. - User-friendly design to facilitate ease of use. - Protection mechanisms to prevent accidental changes. - Basic error checks to prevent incorrect data entry (e.g., preventing a punch-out before a punch-in). Deliverables: - A fully functional Google Sheet template. - Clear, written instructions on how to us...
I'm looking for skilled professionals to help develop a robust, multi-faceted educational management system. This system will cater to various educational institutions - from schools to tuition classes and cultural schools. Key Areas: - Development of a Web-based, Mobile app and Desktop application compatible system - Implementation of modules for different types of educational management - Creating a user-friendly interface to facilitate easy navigation Ideal Skills: - Extensive experience in developing educational solutions - Proficiency in creating multi-platform applications - Knowledge in school management, tuition class management, and cultural education systems - Ability to design an intuitive user interface Please not...
...should come in an Excel spreadsheet format. Key Components of the Project: - Inventory Report: This should detail our current stock levels, any shortages or surpluses, and projected needs based on current production rates. - Production Metrics: The report should include total units produced, production efficiency, and downtime causes. This will help us pinpoint areas for improvement and better understand our overall productivity. - Provide batch tracking information to trace inventory items through their production stages. - Include inventory turnover rate to assess how effectively inventory is being managed over time. - Include cost analysis regarding holding and ordering inventory to optimize financial efficiency. Ideal skills for this proj...
Using a given Contact directory, need to cold call and introduce the company and services. Answer incoming calls from prospective customers. Use scripts to provide information about features and prices of products and services and present their benefits. Do prior research to understand potential client’s requirement Ask pertinent questions to understand the customer’s requirements. Persuade the customer to buy by explaining how products or services can meet/compliment their needs and requirements. Record the customer’s personal information accurately in a computer/CRM system and share with the management as directed. Deal with complaints or doubts to safeguard the company’s reputation. ...
Need help with a one page sell sheet to sell a new product to companies. PDF format Professional graphic design. I can provide a basic structure and some images. The Freelancer should be able to provide format and graphic suggestions. Please provide samples of your prior work. NDA & IP Agreement Required Specifics of job will be provided after selected for project
I am seeking an AI/ML engineer with a strong background in 3 + years experienced in Python and various machine learning frameworks, particularly PyTorch, skicit-learn and TensorFlow. Primarily focused on LLM's and RAG. Key Requirements: - Proficient in Python and machine learning frameworks like PyTorch and TensorFlow - Strong understanding and experience with reinforcement learning - Expertise in time series prediction - Experienced in deploying machine learning models to production environments - Ability to develop custom algorithms for specific problems - Strong skills in data preprocessing and cleaning - Knowledge of parallel computing to speed up experiments - Ability to visualize data and model results ...
I need an Excel data dump sheet designed to mimic the look and feel of my personal expense dashboard. This includes using the same colors as the dashboard. It should be tailored to incorporate specific safety categories, with the data arranged to display correctly on the graph. The ideal freelancer for this project should have - Extensive experience working with Microsoft Excel - Strong design skills to match the dashboard aesthetics - Understanding of safety data categories - Proficiency in creating Pivot Tables
...media specialist to help grow my AI Influencer's Instagram following and Patreon subscriptions. This project focuses on organic growth and high engagement strategies, all aimed at attracting model agencies and brands in the long run. INSTAGRAM: alaska_snow_2001 Key Requirements: - Organic Growth: I strictly want genuine followers. No buying followers. The focus should be on effective organic strategies that can increase the follower count authentically. - High Engagement: I need strategies that generate high engagement rates. This includes likes, comments, shares, and saves. The more interactive my account is, the better. - Long-Term Vision: The ultimate goal is to catch the attention of model agencies and brands. So, the strategies should be crafted with thi...
...lack of financial controls. Eligibility & Compliance Risk – Errors in applicant eligibility determination, failure to meet federal/state guidelines. Operational Risk – Staffing shortages, inadequate training, or system failures. Fraud & Abuse Risk – Applicants or vendors misrepresenting information. External Risks – Economic downturns, policy changes, or utility rate fluctuations. Step 2: Assign Weights to Each Risk Factor Not all risks are equal. Assign a weight (%) to reflect their relative importance. Example: Risk Factor Weight (%) Financial Risk 30% Eligibility & Compliance 25% Operational Risk 20% Fraud & Risk 15% External Risks 10% Total 100% Step 3: Score Each Risk Factor Use a scale (e.g., 1-5 o...
i run a small campground… about 80customers. I have created an account includes all services selected by the customer (at the top). The bottom portion is a running account of costs incurred over the season. I share links to each worksheet to the respective customer. Would like to find an easy and quick way to merge this with a database of all customers info so that the top selections of the account sheet can get pre-filled. And sheets created for each customer.
...need a seasoned Go and GraphQL expert to revamp my backend. Currently, my responsive structure is as follows: - category { id, name, items } I want to introduce a subcategory within the category structure, resulting in: - category { id, name, subcategory { id, name, items }, items } Key Details: - Retain existing category fields: The id and name fields in the category should be preserved. - Utilize existing subcategory schema: I have a pre-defined schema for the subcategory, so there's no need to create one from scratch. - Modify subcategory schema: The subcategory schema will require some enhancements, as there are additional fields needed beyond the current setup. Ideal Skills: ...
I'm looking for a comprehensive spreadsheet that will help me manage a speaker management system for an event series. Excel Specification: Speaker Management System Workbook Structure Sheet 1: Dashboard Quick overview of upcoming events Key metrics (number of confirmed speakers, pending approvals, etc.) Deadlines tracker Budget utilisation summary Monthly Event Sheets (Jan-Dec) Each month that has events will have its own sheet containing: Section 1: Event Details (Frozen Top Section) Event Title Date Range (usually 1-4 days for each event but 2 speaker days) Venue Location Target Audience Total Budget Budget Remaining (formula-calculated) Event Website URL Section 2: Speaker Management Grid Columns: Speaker Name Justification/Va...
I have a portrait photo with uneven lighting that needs to be corrected. The areas that need the most attention are behind the hair and around the head. I would like the lighting to be adjusted in a way that enhances the natural look of the photo, rather than creating dramatic effects. Ideal skills for this project include: - Proficiency in photo editing software like Adobe Photoshop or Lightroom - Experience in portrait photo editing - Ability to enhance natural lighting Freelancers with a keen eye for detail and a knack for subtle adjustments will excel in this project. Please provide samples of previous photo editing work, particularly portrait photos, in your bid. The final edited photo should be provided in JPEG...
...after. I will be reporting all "false bids" to Freelancer. This file will remain IN WORD. An excel file can be used to attain external data such as addresses and contact information. Payment will be made on COMPLETE project with no partial payments. Our quotations are made from a MS Word document. I am looking for someone to modify this quotation document with the following information. Please indicate if these requests are feasible without any 3rd party software and preferably form only 1 outside excel file for data. We will create an Excel “Contacts” document that will contain all our customer information. This data should be able to be pulled into our quotation. Company Name, address, contact name, email, ...
I'm looking for a Smartsheet expert who can help create a comprehensive resource allocation sheet that auto-calculates and generates an easy-to-read dashboard. As a clinical researcher, we are looking for a Smartsheet expert to help us manage our clinical trials. From managing budgets, resource allocation, budget reconciliation, to coordinating activities across multiple programs within our portfolio. We need to build a Clinical Project, Program, and Portfolio Management solution within Smartsheet! Things we must have: 01. Timelines & Milestones With smartsheet we need visibility for a single source of truth for trial timelines, milestones, and budgets. This can help you ensure that your trial stays on track and within budget. 02. RAI...
...posts go live. Key Requirements: - Use OpenAI for generating engaging and relevant blog content on specific topics. - Employ DeepSeek and Claude for additional content generation and refinement. - Integrate with RankMathSEO for SEO analysis to ensure the posts are optimized for search engines. - Automate the entire process of content creation, refinement, and publishing to WordPress. Ideal Skills: - Proficient in Python with extensive experience in API integration. - Familiar with WordPress and RankMathSEO. - Knowledge of using OpenAI and DeepSeek for content generation. - Understanding of SEO principles and practices. This project requires a mix of technical programming skills and understanding of content creation and SEO. The goal is to...
...details: What format would you prefer for the email addresses? Excel spreadsheet How many local authorities are you targeting? More than 50 What specific information do you need besides email addresses? Contact names, Phone numbers, Email addresses The project needs to be completed within 1 week. Please verify all email addresses to ensure accuracy. These email addresses will be used for outreach campaigns targeting local authorities. Please include the contact departments associated with each email address. Please categorize the email addresses by region. Please conduct manual verification to ensure the accuracy of the email addresses. Please treat all regions with equal priority. The primary purpose of this outreach campaign is to r...
Hey Jack! First of all, let me show you some of the E-commerce We...designed and developed for Services so you can understand what type of work we can deliver: - https: Open to sharing more once we are aligned! What kind of services are you offering? What payment methods do you want to offer? PayPal, Stripe, direct bank transfer? How do you want customers to book or purchase a service? Do you have any specific design inspirations? My Offers: I can start by providing you with at least 2 to 3 mockup designs for the Homepage within 1 to 2 days to have your feedback on the changes, unlimited revisions will be considered for the changes to have your 100% satisfaction with the design for each page and as soon as the design is goo...
Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.
I'm looking for an Excel expert who can create a Google Sheet for tracking my cryptocurrency portfolio. The sheet should monitor Bitcoin (BTC) and Solana in real-time, displaying market prices, portfolio movements, and gain/loss metrics. It should also feature Line charts, Bar charts, and Pie charts to visualize the data. Key Requirements: - Proficiency in Excel and Google Sheets - Experience in creating real-time data tracking tools - Ability to create and integrate various types of charts Ideal Skills: - Strong understanding of cryptocurrency and market tracking - Excellent data visualization skills - Attention to detail to ensure accurate tracking of gains and losses
I need a price list sheet refined to a clean, professional standard. The design should be modern and minimalistic. Deliverables: - An EPS file with editable text, not converted to outlines - A design adhering to a modern, minimalistic style What I Don't Need: - A design based on specific color schemes or branding guidelines; I trust your discretion Ideal Skills: - Expertise in modern, minimalistic design - Proficiency in creating clean, professional layouts - Experience with EPS file creation in Adobe Illustrator or similar software Please note, the software preference was skipped, so your expertise in any design software is welcome. The price list sheet should be in portrait orientation. The design sho...
I'm in need of a professional who can develop a method to link multiple Word documents with various Excel files. The goal is to create a comprehensive mapping matrix to facilitate process automation. Key Requirements: - Mapping of diverse data types: This includes text, numbers, formulas, assessment questions and workbook content from the Word documents to the Excel files. - Establishing a Many-to-Many relationship: The project involves linking multiple Word docs to multiple Excel files, ensuring a well-structured and efficient mapping system. Ideal Skills: - Proficiency in Microsoft Word and Excel - Expertise in creating mapping matrices - Experience in process automation Your bid sh...
I need a skilled accountant to assist me with year-end financial tasks using CIA Tech One. Key Tasks: - Preparing and analyzing financial statements, including the balance sheet, income statement, and cash flow statement. - Tracking and categorizing expenses. Ideal Candidate: - Proficient in CIA Tech One. - Experienced in EOFY accounting tasks. - Skilled in preparing and analyzing financial statements.
...vendors to develop an order management web application. The initial phase of this project will focus on core functionalities like order creation and invoicing, with a simplified user role system (admin and non-admin) and no external integrations. 2. Project Scope 2. Implement a search function to quickly locate orders using various filters such as customer name, order ID, or date range. 3. Allow exporting orders and invoicing data in various formats like CSV, PDF, and Excel for external reporting or bookkeeping needs. 4. Set up email or SMS notifications for important events like order creation, completion, and shipping updates. 5. Maintain a detailed log of changes and actions performed on each order, such as edits, status changes, and notes. 6. Enable bulk...
I'm looking for a graphic designer capable of creating a unique piece of artwork that emphasizes the phrase "Friends don't let Friends go to Quilt Shops Alone" and incorporates our store logo. The piece of art will primarily be used on our social media platforms. Key Requirements: - The artwork should match the style of our logo, which will be provided. - It should incorporate our store's color scheme and font style. - The designer should have experience in creating visually appealing social media content. - Understanding of our brand identity is a plus.
I need an Excel spreadsheet template for a quality control inspection report tailored for a machine shop. Key Requirements: - The template should include an inspection checklist - There should be a section for Pass/Fail criteria - The template should be user-friendly and easy to navigate - The design should be professional and suitable for a machine shop context Ideal Skills and Experience: - Proficiency in Excel - Experience with quality control processes in machine shops - Ability to create clear, concise, and professional templates
...desktop and mobile. This is a town's homepage but needs to work for every town in the world so it can't be overly specific to a single town. The solution compiles all of a town's news, events and discussion topics. The attached is a mockup and here is a description of the key elements: As you can see in the attached, our current solution includes many elements which all need to be present in your submission. The image with the numbers refers to the numbers below. 1: Platform Name: CleverFeed. I'm not certain that we need it to be on the top left. Just somewhere on the page. It's not extremely important. 2: Town Name: This is the town's site. 3: Login/Account: We used "Join the Di...
...striking and memorable. Key elements to include: - The unit insignia and motto: These should be prominently featured and integrated into the overall design in a meaningful way. - A representation of the unique identity of this unit: This could be achieved through the use of specific symbols, colours, or styles that are representative of the unit. - A nod to the unique location of this unit: This could involve incorporating elements of the local landscape or culture into the design. I have attached the designs that were used by a parent unit for an idea into something similar. I have also attached the logo for my unit itself. Motto: "One team, one fight" The ideal freelancer for this project should have: - A strong background in graphic ...
Transform Our Pricing Sheet Mock-Up into a Visually Appealing PDF Project Overview: We are seeking a talented graphic designer to take our existing pricing sheet mock-up and turn it into a polished, professional, and visually engaging PDF. This document will be a key piece for customer communication and will also be used by our sales team. The ideal design should clearly present our pricing information while aligning with our brand identity. Scope of Work: Design Enhancement: Use the provided mock-up as a foundation to create a refined, professional design that is both attractive and easy to understand. Brand Alignment: Incorporate our brand colors, typography, and design elements to ensure consistency with our overall brand identity. Layout &...
...graphic designer to create a visually appealing web layout for my new website, Wholesale.Email. This site will serve as a support system for resellers, distributors, wholesalers, and businesses for both buying and selling. The goal is to create a user-friendly inquiry platform where businesses can submit requests, find wholesale deals, and connect with suppliers. Key Requirements: Design only (NO coding required). Web layout optimized for all devices (desktop, tablet, and mobile-friendly). Height: 3000px to accommodate detailed content. Clear and structured navigation for buyers and sellers. A professional and modern design that reflects a business support platform. Sections covering: Wholesale Inquiry Submission A simple form for users to submit buying or s...
...talented graphic designer to create a visually appealing homepage layout for my new website, Wholesale.Bid. This site will focus on wholesale auctions, wholesale bidding, and liquidation inventory, providing a marketplace for businesses and resellers to find bulk deals. Key Requirements: • Design only (NO coding required). • Web layout optimized for all devices (desktop, tablet, and mobile-friendly). • Height: 3000px to accommodate detailed content. • Clear navigation sections to highlight auctions, wholesale deals, and bidding options. • Modern, engaging, and visually appealing layout. • Sections covering: • Wholesale Auctions – Bulk lots and pallet sales. • Liquidation Inventory – Overstock, close...
I'm in urgent need of an Excel macros specialist who can help with data analysis and reporting on financial data. Key Requirements: - Expertise in Excel macros, specifically for data analysis and reporting. - Proficiency in handling and interpreting financial data. - Ability to create summary reports from complex datasets. Ideal candidates will have a strong background in finance and data analysis, with a track record of creating effective Excel macros. Please be prepared to showcase examples of your previous work in this area.
I'm seeking a seasoned tender/bid writer with extensive experience in the HVAC trade services. The primary task is to help me craft compelling content for my proposal using my provided template. Ideal Skills and Experience: - Robust background in HVAC trade services - Exceptional proposal writing skills - Able to answer specific tendered questions using our companies information - Experience in telling the story of the company that aligns with the scope of the tender - Ability to convey technical information clearly and persuasively - Attention to detail and commitment to quality
