Create data files excel vba jobs
...who is able to automate the trading process for me. This script must be capable of placing trades automatically and executing it smoothly. I have code for login trading accound and fetch token data. I need to update code to my system. I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 10 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. i need it like application Broker: Note: I dont know about coding, If you install the code and run successfully at my system thereaft...
Project Description: I need a compelling Facebook ad created for my electronics product to boost sales. Your task will involve sourcing an engaging reel video from the internet that aligns with the product's features and appeal. You will then design and optimize the ad for Facebook, ensuring it resonates with the target audience and drives conversions. More Details: Product Type: Electronics Objective: Increase sales Target Audience: Teens and young adults (ages 13-25) The ad should be dynamic, eye-catching, and emphasize the product's benefits to appeal to a younger audience. Creativity, attention to detail, and experience with Facebook ads are essential for this project.
I need assistance in exporting emails from my Outlook account to an Excel file. The emails should be categorized by the sender. The specific information I want included in the Excel file are: - Sender's email address - Email body content - Attachment names Ideal skills for the job include proficiency in data handling, familiarity with Outlook and Excel, and experience in email data extraction.
I need assistance with a task of data entry involving copy-pasting. The data is sourced from multiple Word documents, and it needs to be pasted into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in copy-pasting tasks - Familiarity with Word and Excel - Attention to detail to ensure data is copied accurately
Video Brief for Beesante Manuka Honey Reels (Vertical Format) ________________________________________ Objective: We are seeking creative video designers to produce engaging and visually stunning short-form videos (Reels) to showcase the benefits, uses, and uniqueness of Beesante Manuka Honey. These videos will be used on Instagram and TikTok, so they must be vertical and optimised for attention-grabbing, shareable content. IMPORTANT: This is MANUKA honey, which is only derived from the Manuka flower. DO NOT USE SUNFLOWERS OR ANY OTHER FLOWERS. You need to produce 20 Videos. ________________________________________ Video Requirements: 1. Format: o Vertical (9:16 aspect ratio). o Duration: 10-30 seconds. 2. Inclusion of Jar: o The Beesante Manuka Honey jar must be prominently featured in...
I need assistance converting three logos from Canva to AI vector files in Adobe Illustrator. Key Details: - Preferred File Format: AI - Design Elements: Only the shapes of the logos need to remain unchanged during the conversion. The colors and text can be altered if necessary, but should generally remain the same. - Modifications: No modifications or enhancements are needed for the logos. Ideal Skills: - Expertise in Adobe Illustrator - Experience in converting images to vector files - Attention to detail to maintain specific design elements
...seasoned web developer to create a custom-built web application for managing a medicine/drug bag system. This system should incorporate a subscription-based billing model. I've begun outlining the concept in an Excel spreadsheet, detailing the necessary actions and content. Key Features: - User Roles: The system will have two types of user roles. An Admin role, which I will manage, and a Customer role, representing the end-users. - Core Functionalities: The web app should include inventory management, subscription billing, and user account management. - Maintain detailed logs of user activities and access times. - Ensure the app is fully responsive and optimized for mobile devices. - Integrate secure payment gateways for easy subscription purchasing and renewals. - I...
I'm looking for an expert in Google Sheets and scripting who can help automate data entry for my project. The primary task involves importing data from external sources, specifically CSV or Excel files. We want someone that can get us a name of someone working at a specific company. It should work on Google Sheets. When we put a company variable it should get us one specific name of someone that works there. Key Requirements: - Proficiency in Google Sheets and its scripting capabilities - Experience with data automation - Ability to work with CSV and Excel files - Attention to detail to ensure accurate data entry The goal is to streamline the process, saving time and reducing the possibility of human error.
I'm seeking a detail-oriented freelancer to assist with data entry from PDF files. The data consists of a mix of text and numerical information. Ideal Skills and Experience: - Proficiency in data entry - Familiarity with handling mixed data - Attention to detail - Experience with PDF data extraction - Ability to maintain confidentiality and handle sensitive data responsibly. Please ensure you can handle mixed data types and have experience working with PDF files before bidding. Thank you. The project involves entering data from less than 100 pages. The final data should be in an Excel file. The final Excel file should have a detailed level of organization with categorized and labeled section...
I'm seeking a professional to help optimize my hotel's pricing strategy. The project will involve: - Analyzing historical booking data, market trends, and competitor pricing data to develop a more effective pricing strategy. - Implementing this strategy in a way that maximizes revenue. The ideal freelancer will have extensive experience in revenue management, particularly in the hotel industry. Proficiency in Excel/Google Sheets is a must, as this is the primary tool I currently use for this project. The goal is to increase the hotel's occupancy rate.
I'm in need of a data scraping expert to extract insights from online forums, product reviews, and social media sites concerning air fryers. I'm particularly interested in understanding: - Product features that consumers feel are lacking - Common complaints that consumers have - Desired improvements that are frequently mentioned The final deliverable should be an organized Excel spreadsheet containing this data. Ideal skills and experience for this job include: - Proficiency in web scraping tools and software - Ability to analyze and categorize data effectively - Prior experience in product research and consumer analysis - Competence in Excel and data presentation This project is crucial for identifying potential product development ...
I'm in need of a skilled Google Sheets expert to set up a table for me. The table should utilise tools like VLOOKUP, SUMIF, QUERY, and INDEX/MATCH to pull data from a larger table containing dates, values, and categories. The end goal is to have a summarised data table that is organised by date range, category type, and value range. the data and table are on two tabs of the same google sheet Ideal freelancer should have: - Advanced knowledge in Google Sheets and or EXCEL - Proficiency in using VLOOKUP, SUMIF, QUERY, and INDEX/MATCH - Experience in data handling and summarisation - Ability to deliver clear, summarised data in an organised manner. Link will be provided to the awarded winner.
...with a variety of tasks. This is a consistent, long-term opportunity for the right person. Key Responsibilities: Edit and add content to WordPress websites. Perform basic Excel tasks, including cleaning data and creating charts. Conduct market research and compile findings into reports. Research topics and provide concise, well-organised summaries. Communicate with customers via written channels (email, chat, etc.). Take on varied tasks as needed week to week. Requirements: Excellent written and spoken English skills. Experience with WordPress and basic content management. Proficiency in Microsoft Excel (e.g., cleaning data, creating charts). Strong organisational and research skills. Reliable internet connection and ability to work independently. What We Off...
...parameters for floating wind turbines with rated power levels ranging from 5 MW to 30 MW. These parameters, covering turbine characteristics and operational conditions, are essential for the design and calculation of floating platforms and their mooring systems. The parameters should be categorized into sections such as blades, nacelles, towers, and others, and provided in an expanded and refined Excel format based on the attached reference table. Suggested parameters for inclusion are listed below, though this list is not exhaustive: 1, Blade Parameters ·Number of blades ·Blade mass ·Rotor diameter ·Minimum and maximum rotor speeds (rpm) ·Other blade parameters...... 2, Nacelle Parameters ·Rotor-nacelle assembly mass ·Hub height ...
I'm looking for a dedicated professional who can assist me with managing a database through online data entry. My ideal freelancer is someone who has robust experience in: - Manual data entry - Data entry from scanned documents - Various aspects of online data entry - Data cleansing and validation tasks - Experience with database management software - Formatting data accurately - Resolving errors in data entries Your primary task will be to maintain the integrity and accuracy of the database. Skills in Microsoft Excel and Google Sheets are essential. If you have a keen eye for detail, strong organizational skills, and the ability to work independently, I would love to hear from you.
...irrigation and fertigation systems. Data Fields Required for Each Lead: Company Name. Website Address. Industry Type/Focus. Contact Person’s Name (Director, Procurement Head, or Design Head). Designation of the Contact Person. Email Address (verified). Phone Number (direct line or verified business contact). Company Location (city and state). Key Skills Required: Expertise in lead generation tools and platforms like LinkedIn Sales Navigator, , ZoomInfo, , etc. Proficiency in web scraping and data mining techniques. Familiarity with email verification tools to ensure high data accuracy. Strong research and data organization skills. Experience in generating B2B leads in industrial or OEM sectors is a plus. Expected Outcome: A structured and verified ...
I have a spreadsheet with multiple columns containing details about various companies. I need a freelancer to extract email IDs from the company names listed in the first column. Ideal skills for this project: - Proficient in Excel or similar spreadsheet software - Experience with data extraction tasks - Attention to detail to ensure accuracy - Basic understanding of email formats to enhance extraction efficiency - Should have subscription of or similar softwares, to get the verified data.
I need an Excel macro to automate data extraction from another Excel file. Key Requirements: - Expertise in creating and optimizing Excel macros - Proficient in data extraction techniques - Prior experience with repetitive task automation The primary goal of this project is to streamline the process of data extraction, saving time and increasing efficiency. The macro should specifically automate the extraction of dates & quantities data from the other Excel file. The extracted data should be saved in XLSX format.
...and merging several Excel (or CSV) files from various online databases. The files are accessible through direct download links. Your primary task will be: - Downloading files from specified online databases - Merging all the downloaded data into single files based on provided criteria (zipcode, city) - Some manual work required when classifying (zipcode, city) - Knowledge of USA geography is a plus (or experience working with different levels of shape files) Ideal skills and experience for this job include: - Proficiency in Excel and handling CSV files - Experience with data merging and manipulation - Familiarity with downloading files from online databases - Ability to follow instructions accurately - Pr...
Auto invoice number automatically to populate Invoice date automatically to populate Customer database where I could select the customers from a list that I could add or delete the customer A section where I could manage when they make payments, and how it was made to keep track of my invoices The total for all Invoices, as well the total for open invoices that haven’t been paid
Looking for senior SR. RPA DEVELOPER BRIEF Senior RPA Developer to join our team and lead the development, implementation, and maintenance of robotic process automation (RPA) solutions. As a Se... Automation Anywhere, and Blue Prism â–ª Experience with integration technologies, such as APIs, web services, and databases (e.g.; MS SQL Server, MS Access, Oracle) â–ª Excellent communication, presentation, and problem-solving skills â–ª Ability to work independently and as part of a team â–ª Ability to manage multiple priorities and meet deadlines â–ª Good working knowledge on scripting languages and excel macro automation (vbs,JS) â–ª Hands-on experience in automating different processes using applications like Citrix, SAP, Oracle EBS, Terminal, All windows native application , Web applicati...
...expert in data analysis to guide me on financial data gathered in the past two weeks to identify key trends. data and ai exist already. you help me conclude best results. circa 2000 rows and 30 columns. i have been using chatgpt and excel but not much luck. so someone can help me analyse trends in the data. all subjects in 2000 rows, which 2 or 3 or 4 column combinations results in the best % output. Key Requirements: - Analyze financial data, focusing on trends related to revenue, expenses, and profit margins. - Utilize AI tools and spreadsheets for in-depth analysis. - Provide clear, actionable insights and guidance based on the findings. Ideal Skills and Experience: - Proficient in data analysis, particularly with financial ...
I need a Gantt chart created in Power BI based on my task data. This data includes date, name, start time, end time, and task. The chart needs to visually represent the duration of tasks over time and must be viewable in Microsoft Excel. Key Requirements: - Gantt chart: This chart will help visualize the duration of tasks over time. - Manual Update: The chart should be updated manually with a refresh button when new data is added. - Power BI: The project will be done and viewed in Power BI. Ideal Freelancer Skills: - Power BI: Advanced Power BI skills are required. - Data Visualization: Experience in creating Gantt charts and other data visualizations. - Attention to Detail: The Gantt chart must accurately reflect the task data. The prim...
We are seeking the best graphic designer to create sale banners for our website, inspired by the design style of our competitor. Here is my competitor's website for reference: Details: Payment: ₹700 per banner Total Requirement: 10 banners Task: Deliver visually engaging banners that align with modern design trends and enhance our website’s appeal. Requirements: Graphic Design Expertise: Proven skills in crafting clean, high-quality visuals. Brand Alignment: Ability to create banners that harmonize with the website's branding. Creative Eye: A strong sense of color, typography, and layout design. Modern Aesthetic: Familiarity with current design trends for visually appealing banners. Portfolio: Please share examples of similar work you’ve done. If int...
I'm seeking a professional with expert...automate a crawl search in sites like Linkedin, Apollo, Zoominfo, Hunter etc. Deliverables in Excel are: last name, first name, email address, company name, product produced Key Requirements: - Skilled in LLM prompt engineering - Experienced in data extraction from web pages - Familiar with sites like Hunter, Apollo, Zoominfo, and LinkedIn - Capable of periodic batch processing of data The extracted data will primarily be used for marketing purposes. Please note that this is not a real-time data extraction task, but rather a periodic batch processing task. I look forward to your proposals. The batch processing should be carried out on a weekly basis. The extracted data should have high accuracy. The ...
...--Monitor and report metrics related to the number of completed project forms, scheduled jobs, and other relevant data. --Update Consulting Profile with appropriate keywords. **Perform other assigned tasks as needed** Requirements: IT Consulting Virtual Assistant --General knowledge of IT applications, infrastructure, and security vendors or have experience with IT companies --Proficient in reading and writing English. --Proficient in using ChatGPT for communication and assistance. --Timely response to project jobs and adherence to deadlines. --Experience in responding to IT consulting job requests. --Ability to track and document project-related metrics. --Familiarity with Gmail, Excel, and Chrome. --Access to a working computer. --Nice to have: Experience with Chrome p...
Re-create this web((#site. joelube dot%% xyz. You can use any tech or platform.
Creating a plan on excel sheet for 5 years projection
I'm looking for an expert in Microsoft VBA for PowerPoint who can create custom macros and functions for me. The main objective is to streamline repetitive tasks, specifically formatting slides and inserting uniform content. I already have the code which I have integrated as an add-in to my PowerPoint Toolbar. I need some help troubleshooting to fix some errors. Ideal Skills: - Proficient in Microsoft VBA - Extensive experience with PowerPoint - Ability to create custom macros and functions - Understanding of slide formatting and content insertion - Experience in debugging and troubleshooting VBA code efficiently. The project needs to be completed within 1 week. The macros should also integrate with Outlook for email functionality.
I'm seeking a professional who can create an Excel spreadsheet for financial reporting purposes. This spreadsheet will need to generate income statements and cash flow statements. Key Requirements: - Develop an Excel spreadsheet capable of generating income statements and cash flow statements. - Incorporate standard financial formulas into the spreadsheet. - Ensure the spreadsheet is user-friendly and efficient for financial reporting. Ideal Skills: - Proficient in Excel with experience in financial reporting. - Familiarity with income statements and cash flow statements. - Ability to create user-friendly spreadsheets. Use a basic design and formatting for simplicity. The spreadsheet should support manual data entry with predefined fields.
I need an expert in Excel and VBA to develop a macros for me. This macros will match invoices from one set to another in the same Excel file and perform a reconciliation between both sets and highlight the difference way I want. Key requirements: - Highlight discrepancies in GST tax numbers even when party names are the same - Handle invoice numbers that are in different formats or of different lengths - Automate this process to reduce manual work The main focus for this project is to highlight tax number discrepancies. Currently, the invoice numbers are formatted in different formats. The ideal candidate should have extensive experience in Excel and a deep understanding of how to create and implement macros. Knowledge of tax number formats and invoic...
I am seeking a part-time financial modeler with advanced expertise in Microsoft Excel to assist with various financial modeling projects. The ideal candidate will have a strong understanding of financial analysis, forecasting, and Excel-based modeling techniques. Key Requirements: Proficiency in advanced Excel functions (pivot tables, macros, VBA, etc.). Experience in financial modeling, budgeting, and forecasting. Ability to analyze and interpret financial data. Strong problem-solving and analytical skills. Attention to detail and accuracy in work. Application Instructions: Please attach your resume and include samples of your previous work in financial modeling. Applications without samples will not be considered.
...Dealers/Distributors: Companies dealing in water flow meters, electromagnetic flow meters, and ultrasonic flow meters. Details Required for Each Dealer/Distributor: Company Name Website Phone Number Email Address Geographic Coverage: Maharashtra Gujarat Expected Volume of Leads: 1,000 to 1,500 companies are expected from this search. Output Format: The information should be delivered in an Excel file, with columns for each required detail (Company Name, Website, Phone Number, and Email Address). Requirements for the Freelancer Ability to perform a detailed and accurate search, ensuring the inclusion of relevant companies only. Verification of contact details to ensure authenticity and usability. Timeline The project should be completed within one week from the date of commen...
[Overview] We are currently looking for someone who can efficiently collect URLs of YouTube ad videos displayed during video playback! [Task Details] YouTube Ad URL Collection Record the URLs of ads displayed during YouTube videos. The ads must meet the following criteria: Published within one month. Have over 1 million views. Data Organization Input the collected URLs into a Google Spreadsheet. The spreadsheet will be shared only with those selected for this task. [How to Collect URLs] â–¼ How to Collect URLs on a Smartphone Tap the three vertical dots in the top-right corner of the video. Select "Statistics" (or a similar option depending on your device). Copy the red-framed portion from the attached example image: Add the URL suffix and submit the complete
...Maharashtra. Scope of Work Target Contacts: Maintenance Heads (Instrumentation) EHS (Environmental, Health, and Safety) Heads Procurement Heads Details Required for Each Contact: Full Name Designation Email Address Company Name Website Address Target Companies: Large manufacturing companies in Nagpur Medium-sized manufacturing companies in Nagpur Output Format: The details should be compiled in an Excel sheet with clear categorization for Name, Designation, Email Address, Company Name, and Website. Project Timeline We expect the project to be completed within 1 week from the start date. Budget and Payment Payment milestones can be discussed based on progress and delivery. Expected Quality All leads must be verified and accurate. Emails should be valid and active to ensure ...
...professional who can help me clean up my Excel file by removing disconnected phone numbers. Specifics: - I will be using Twilio as the phone validation service. - It is crucial that the disconnected numbers are completely deleted from the file, not just moved or highlighted. Ideal candidates should have: - Experience with Excel and data management. - Familiarity with Twilio or similar phone validation services. - A keen eye for detail to ensure no disconnected numbers remain in the file. The Excel file contains between 1,000 to 10,000 rows. Please format the remaining numbers in a specific way. Please format the remaining numbers in national format. Please create a backup of the original file before making any changes. Clean the data inlin...
I'm looking to enhance my current process of sending payslip PDFs to employers. The task involves modifying my Excel file, which contains employee email addresses in a dedicated column, to send individual PDFs to corresponding employees. Currently, I generate payslips from Excel and send them via Outlook as attachments. The ideal freelancer for this project would be proficient in Excel and Outlook, with experience in automating email distribution from Excel.
Need an excel / google sheet template. Faraz and Mohsin are business partners. Mohsin owns 60% and Faraz owns 40% and all the profit and expenses are split accordingly. They both spend money in the business from their own personal bank accounts, and they both also collect revenue in their personal bank accounts. At the end of the month they need to figure out who needs to give how much money to who, that is, if Faraz needs to give money to Mohsin or Mohsin needs to give money to Faraz depending on the profit and loss for the month, and how much expenses each incurred, and how much revenue each collected. Data for the current month: Total Revenue Collected by Faraz: $3091.47 Total Revenue Collected by Mohsin: $0 Expenses paid by Mohsin: $3200 Expense paid by Faraz: $512.32 ...
I'm looking for a professional data analyst who can help me make sense of my sales data. The data is currently in Excel/CSV files. Ideal Skills: - Proficient in data analysis software (Excel, Python, R, etc.) - Experience with sales data analysis - Ability to identify trends and patterns - Strong statistical skills - Skills in managing and querying databases (SQL, NoSQL, etc.) - Experience with Extract, Transform, Load (ETL) processes Please note that specific insights I want from the data have not yet been defined, so I will appreciate your expertise in uncovering significant insights from the data.
...highlights. 1. Data Privacy and Security: - Ensure data is handled securely and complies with privacy regulations. - Include user consent mechanisms for profile visibility. 2. Analytics and Reporting: - Implement analytics tools to track user behavior and directory usage. - Provide admin reports for user registrations, listing activities, and interactions. 3. Scalability: - Ensure the system can handle a growing number of users and listings. - Keep options open for adding more features in the future. 4. Additional Features : - Membership badges or highlights for premium members. - Integration with social media for profile linking or sign-ups. - Event or job posting capabilities within the directory. - Download of member list in various formats like csv, exc...
I'm seeking a freelancer to develop a comprehensive stock pitch presentation for a long on a small to mid cap US-based company, excluding the finance and utilities, energy, oil sectors. Key Requirements: - The freelancer must create a 2-3 differentiated thesis points, risks, business overview and include a detailed DCF model, comps analysis, and revenue build. - The DCF model must encompass all components: revenue projections, operating expenses, and terminal value calculation. - The project has a tight deadline of 2 days. Ideal Skills and Experience: - Strong background in finance and investment analysis. - Proficiency in creating engaging and persuasive stock pitch presentations. - Experience with small to mid cap companies in the US. - Familiarity with DCF models and comp...
More details: What type of database are you using? Microsoft Access What specifically do you need to edit in the database? Both remove password and add new process What kind of process or function do you want to add? generate Purchase Order from the system i have excel + microsoft access database and current i cant edit the report and want to add procees of PO generation from the quotation . currently no purchase PO option . The new process should integrate seamlessly with existing systems.
I'd like to request a quote for "Math excel project I need it done in 6 hours.". My budget is 95USD.
More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Experience How soon do you need your project completed? ASAP
Custom Bank Comparison Excel Tool Project goal: Develop an Excel-based tool to compare client servicing levels across multiple banks efficiently. Scope of work: - Analyze the provided example calculator along with bank-specific calculators to understand the requirements. - Develop a new, user-friendly Excel calculator that allows for easy input of client details. - Ensure the calculator can produce a clear, comparative analysis of client servicing levels across all the banks. - Incorporate functionality to update calculation logic or data as banks update their criteria. - will need continuous update for the calculator when bank makes changes so can align with the bank calculator Additional information: - Will provide an example calculator along ...
Hey! I have an expertise on excel and i can provide you quality work.
I am in need of a one-page Excel form designed for recording daily patient visits. The form should have a small grid and be structured with pre-defined sections and headers. It is essential that this form captures specific information, including: - Patient ID and name - Date of visit and notes The form will be filled out by hand, so clear sections and headers are crucial for ease of use. Please include sections for the four different therapies. Please include a section for medications and duration of visit.
