Excel automatic references vba jobs

I'm in search of a proficient web app...for a lot size calculator of fixed amount on every trade, implementable on Angelone's platform. Key Components: - Design an intuitive, user-friendly interface for using the trading algorithm - Integrate the algorithm with Angelone's trading platform Ideal Skills & Experience: - Proven experience creating web apps and trading algorithms - Understanding of lot size calculators in trading and automatic stoploss of 5% in every trade in bracket order (robo order) - Familiarity with Angelone's trading system - Strong coding and AI skills - Experience in user interface/UI design. Your proposal should include your previous experience in building trading algorithms and web applications. Also, please share if you have any ex...

I am looking to significantly revamp my home's exterior in order to increase its c...include: - Window replacement: To maintain a unified style, the new windows should complement the modern rustic look. - Addition of front dormers: Designed to integrate seamlessly with the existing structure while adding to its visual appearance. - Stone and siding: Both these elements should be curated carefully to bring the essence of the modern rustic style to life. Experienced freelancers who excel in exterior home remodeling with proficiency in modern rustic designs would be ideal for this project. Critical abilities include an eye for design, detail-oriented work, and the capability to execute window replacements and dormer additions smoothly. Previous experience working on similar proj...

I'm looking for a professional who can help me generate contact information (name, email, and phone) for leads suitable for my direct email marketing campaign. Key Responsibilities: - Develop a robust strategy to identify and collate data from various sources. - Ensure the data is accurate and up-to-date. - Organize and present the data in an Excel spreadsheet format. Ideal Skills: - Experience in sales lead generation. - Proficiency in using data collection tools. - Strong analytical and organization skills. - Knowledge of email marketing best practices. Experience in direct email marketing or a CRM system would be a bonus. The successful candidate will be meticulous and detailed-oriented, with the ability to deliver high-quality, targeted leads to support my marketing ef...

...be responsible for designing T-shirt graphics, managing print orders, and handling various marketing tasks. **Objective:** The primary goal is to increase sales, so your designs should be not only visually appealing but also commercially viable. **Design Styles and Themes:** - **Styles**: We are particularly interested in pop culture references—a style that's both entertaining and statement-making. - **Themes**: While open to a range of pop culture references, specific themes include movies, TV shows, music, science, and even a bit of political satire. **Responsibilities:** 1. **Designing T-Shirt Graphics:** - Create original and appealing T-shirt designs that resonate with North American (Canadian and American) audiences. - Understand current trends a...

EXCEL VBA + EXCEL EXPERT. Please check video attachment and excel file and tell me if you can do this. Quality of proposal cover letter is always #1. Be #1. This will take 1 hour to code and complete if you know what you are doing.

I'm looking for a data analyst to scrape LinkedIn data and create a series of analytics from the information. Linkedin Recruiter or Premium Account will be needed for this task. Output should be presented in Google Sheets or EXCEL.

I'm looking for a talented graphic designer to create a unique and eye-catching logo to commemorate my business's 15-year anniversary. Use the attached logo and redesign how ever you see fit. The 10 year has been used since 2020 and have attached that as well. Key Requirements: - Color Scheme: Please refer to the attached document for specific color references. - Elements/Symbols: The logo should reflect the essence of our business, therefore, the use of the elements/symbols provided in the attached document is essential for this project. - Font Style: The font style should be based on the reference provided in the attached document. Ideal Skills and Experience: - Proven experience in logo design, particularly for anniversary or commemorative purposes - Strong understan...

I require proficient excel skills to create two distinct spreadsheets. The first spreadsheet should focus on an immediate expense breakdown, specifically highlighting repair costs as an individual category. Knowledge in business accounting would be advantageous to ensure accurate representation of financial data. The second spreadsheet requires a CAPEX table, based on an example I will provide in PDF format. Freelancers will ideally have: * Expertise in Microsoft Excel * Background in accounting or financial planning * Detail-oriented and able to follow a provided example * Ability to create easy-to-understand, visually appealing spreadsheets Please assure that the work is precise and completed on time.

I am in need of a proficient Google Sheets wizard who can utilize their expertise in managing and modifying spreadsheets for a specific task. I am interested in adding dynamic drop-downs to the cells in the ranges A1:A1000, B1:B1000, and C1:C1000 in Google Sheets. Key aspects for my project include: - Dynamic Population: These drop-downs must be dynamically populated and each row should maintain its independence from other rows. - Dropdown Values: The values for the initial dropdowns (A1:A1000) are derived from a specific list on Sheet2 of the Google document. - Manual Updates: The values on Sheet2 will be updated manually by the user. The perfect candidate should possess the following skills: - Advanced knowledge in Google Sheets: You must be able to easily navigate Google Sheets ...

...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation of repetitive tasks within A...

I need someone to consolidate data from multiple Excel sheets. The data in these sheets consists of both text and numeric values. The goal is to bring all this data together into a single sheet, while handling duplicates in a distinct manner. Key elements of the project include: - Merging text and numeric data from several Excel sheets into one - Handling duplicate entries by marking them without removing - Organizing the data by grouping it as per the provided sheets separately Ideal candidates should have: - Proficiency in Excel and experience working with data consolidation - Understanding of handling and marking duplicate entries if any - Ability to accurately organize and group data Your task will be to create a consolidated view of text and numeric data from t...

Hi Work-Nix Solutions, I would like to work with you again please on refining the great Excel-spreadsheet that you have helped me to build.

Hired already client is aware of details

I'm in need of an Excel developer who can aid me in analyzing data, creating advanced formulas and functions, and programming macros. With your expertise, the primary goal is to develop an Excel file that will be used to generate various reports. Ideal Skills and Experiences: - Proficient in Excel data analysis and manipulation - Experienced in creating advanced formulas and functions - Able to implement macro programming - Adept in generating insightful reports from complex data Our goal is to provide you with an exportable dashboard in Excel, a tool that will efficiently display opportunity details per property and provide a dedicated area for your notes. Opportunities that meet the threshold should display the value. The dashboard should be sortable a...

...and login system. - **Service Provider Profiles**: It's important for users to be able to view and select service providers based on their profiles. - **Booking and Scheduling**: Users should be able to book appointments with service providers easily. - **Tracking**: It would be great if an in-app feature could allow users to track the status of their service requests. - ** Service Reminders: Automatic reminders for upcoming maintenance based on service history - ** Emergency Services: Provide options for emergency roadside assistance, such as towing, flat tire repair, and jump-starting. - ** In-App Chat Support: Provide real-time chat support to assist users with booking queries, service issues, or any other concerns. - **Service Packages: Offer bundled service packages at ...

Please Sign Up or Login to see details.

I'm looking for a translator to adapt my English screenplay into Japanese. Though the tone is informal, accuracy is of utmost importance. Applicants should have expertise in the following areas: - Dialogue translation: Ensure idiomatic speech is authentically converted and makes sense in the target language. - Cultural nuance management: The screenplay references multiple localized subjects, which need to be accurately depicted for the Japanese audience. - Knowledge of technical terms: Some industry-specific terms need translation without losing their original meaning and context. The objective of this project is to localize the screenplay for the Japanese market in Final Draft. Therefore, a solid understanding of Japanese pop culture, idioms, and slang would be ideal. Pref...

I am in need of a Senior Financial Analyst to assist with our company's financial modeling, forecasting, and data analysis and reporting. The ideal candidate must be familiar with various financial concepts, data analysis, and proficient in the use of Microsoft Excel, Tableau, and QuickBooks. Key Responsibilities: - Develop and maintain financial models for our operations and future forecasts - Analyze and interpret financial data - Prepare regular reports on financial performance - Utilize Microsoft Excel, Tableau, and QuickBooks for data management and analysis. The candidate must have significant experience in financial modeling and data analysis, preferably in a senior role. The ability to communicate complex financial information in a clear, concise manner is hig...

Hi everyone, I am looking for a freelancer who is able to help me with a Magento 1 task. I got a template: ‘’Porto theme’’ and I can’t find out how to build / structure pages properly. The manual is not sufficient for me. How can I integrate the page structure of a demo (home)page for example? The automatic function is not working for some reason. I have contacted the developers: ‘’P-themes’’ and they suggested to go into the folder: ‘’app/code/local/Smartwave/Porto/etc/import’’ on the server, but from there I don’t know how to integrate these (short)codes on the page properly. Hope you can help me integrate it and explain how to build a page this way. There are some other pages that I want to stru...

I'm in search of an individual who is both tech-savvy and creative, capable of designing and editing an Excel-based yearly budget tracker for my department. This document must not only be functional, but visually appealing, making use of our company's branding and in a way that ensures user-friendliness. Key Requirements: - Creating a Comprehensive Tracker: I need a budget tracker that can calculate data and maintain it in a clear and organized manner, reflecting both incoming and outgoing finances. - Visual Appeal: This tracker should not be a typical, boring spreadsheet. It should feature vibrant colors and bold fonts, while still maintaining a clean and simplistic design. Additionally, it should incorporate our company's logo and color scheme to ensure it's o...

Hi everyone, I am looking for a freelancer who is able to help me with a Magento 1 task. I got a template: ‘’Porto theme’’ and I can’t find out how to build / structure pages properly. The manual is not sufficient for me. How can I integrate the page structure of a demo (home)page for example? The automatic function is not working for some reason. I have contacted the developers: ‘’P-themes’’ and they suggested to go into the folder: ‘’app/code/local/Smartwave/Porto/etc/import’’ on the server, but from there I don’t know how to integrate these (short)codes on the page properly. Hope you can help me integrate it and explain how to build a page this way. There are some other pages that I want to stru...

...Detection In terms of output, I require the processed videos to generate a Metadata file, which ideally is formatted into an Excel or CSV file. This data should include details such as date, time, classification, and direction. While I do have an Azure account for hosting and I am comfortable with it, I am also open to suggestions on which programming language would be the best fit for this project. The ideal freelancer for this task should possess the following skills and experience: - Proficiency in Python, C++, or Java - Familiarity with Microsoft Azure or similar - Experience in image classification and object detection - Ability to create Metadata files in Excel or CSV format. Remember that while these are the core requirements, I am open to suggestions and m...

I'm in need of a tool that can effortlessly upload text information from an Excel document to a website form on a daily basis. The tool should also facilitate the mapping of Excel columns to the corresponding fields in the website form through a user-friendly interface. Key requirements include: - Daily automated upload of data from Excel to the website form - A straightforward, user-friendly interface for mapping Excel columns to website form fields - Accurate and efficient transfer of text information - A secure and reliable tool that ensures data integrity Ideal candidates for this project should have: - A strong background in web development with experience in form automation - Proficiency in Excel, including working with data extraction and ma...

...inputting it into an Excel spreadsheet. The key aspects of the project are: - **Data Extraction:** This involves comprehensively retrieving data from various websites. Some sites may have more complex structures, requiring the freelancer to navigate and extract data accurately. - **Excel Formatting:** The extracted data needs to be entered neatly into an Excel spreadsheet. - **Advanced Level Detail:** The data extracted should be detailed and comprehensive, including historical data and analytics where relevant. The ideal freelancer should have experience in web scraping and data entry, as well as a good understanding of Excel. They should be meticulous, capable of handling potentially complex website structures, and able to work with a high level of det...

I'm looking for a 3D animation specialist to create a 90-second explainer video for a groundbreaking African payment solution. Key Requirements: - Animated characters: I'd like this video to employ engaging, relatable characters to help convey the message effectively. - African cultural references: The video should incorporate cultural elements to resonate with the audience and demonstrate the solution's roots and relevance. Target Audience: The video is intended for the general public, so the specialist should be able to create content that is both entertaining and informative for a broad audience. Ideal Skills and Experience: - Proficiency in 3D animation - Experience in creating explainer videos - Knowledge of African cultures and payment solutions is a plus. ...

I'm looking for a SEO specialist to help me to improve the traffic on my website. The focus is on local search engine optimization / onpage-seo. ## Note: - I need only an instruction excel - list. The language of the page is in german, but an online translation tool can be used. - No Plugin will be used, but other proven SEO - Tools are possible. Key Responsibilities: - On-page SEO analysis to identify the status of the page (one page, homepage) - You will send me your seo recommendations for onpage optimations - You will use a seo tool (we discuss which one is best) - I only need a written instructionfile what should be done at page, - start asap - Time: 2 hours a week for one month Ideal Candidate: - experience with on-page SEO for websites - Strong analytical skills ...

Hi Nadia A. The project is: Research and identify qualified 1,000 sign manufacturers /stores /sellers /suppliers (that sell signs) across Germany. Compile the leads data into a Excel format.

...Here are the specifics of what I am looking for: - **Trello Integration**: I need the developer to work on automating the process of synchronizing tasks, notifying on changes in cards, and creating cards automatically. This will ensure a seamless workflow and efficient task management within Trello. - **WhatsApp Integration**: The main goal behind this integration is to enable the sending of automatic messages. This could be vital for sending reminders, updates, or other important information to my team or clients. - **Billing Software Integration**: The developer should also work on establishing a connection between our billing software and other applications. This could involve automating invoice generation, tracking payments, or other relevant tasks. The ideal candidate ...

...digitized and transformed into an Excel spreadsheet. The document consists of approximately 238 pages, and I require the following: - Organization: Calls, texts, and data should be separated into distinct columns in the spreadsheet. - Data Layout: The information should be laid out in an ordered manner which we will discuss further. Additional requirements include: - Calculations: The Excel sheet should include specific calculations like total call duration and data used. - Data Fields: The "To/From", "City", and "Time" fields should be organized in distinct columns within the spreadsheet. Ideally, I'm looking for a freelancer with: - Proficiency in PDF to Excel conversion. - Strong organizational and data handling skills. - Ex...

I have a list of 2060 SKUs in an Excel sheet that I need corresponding images scraped from Website A. Each image should be saved with the SKU number as the filename (e.g., for SKU 32440). Key Requirements: - Scrape images from Website A for 2060 SKUs - Save each image as a high-resolution jpg with the SKU number as the filename Delivery: - I will provide you with the Excel sheet containing the list of SKUs via email. - You should deliver the images in a compressed file with 2060 images, each named according to the corresponding SKU. Ideal Skills and Experience: - Experience in web scraping, particularly image scraping - Proficient in Excel for managing SKU lists - Ability to deliver high-resolution images - Attention to detail to ensure correct matching of SKUs an...

ITALIAN LANGUAGE MANDATORY. Starting from a list of 12500 Company names in excel, we need to fill in the other columns finding online: - website URL - Zip Code - VAT Number - Type of Industry (selecting it from the excel drop down menu)

...reputation management goals of the project. - Formatting according to Wikipedia's guidelines: It's crucial that the article meets the specific formatting requirements of Wikipedia to guarantee that it is published and maintained on the platform. Therefore, the ideal candidate should be well-versed in these guidelines. - Adding references and external links: To further solidify the credibility and authenticity of the article, I need an expert who can add relevant references and external links that will enhance the reader's understanding of the subject matter and its importance to the general public, industry professionals, and investors. I am looking for someone with a proven track record in creating Wikipedia articles and a deep understanding of the gaming ...

i want to be data entry job use word, pdf , excel , PowerPoint , and any type of graphic design work . i have 3 years teaching experience with data collection , data entry , and graphics design . i have fully and wonderful experience in Microsoft office , excel, PowerPoint , photoshop , illustrator, CorelDRAW, filora

For this project, we need to consolidate customer data from multiple Excel files into one Excel sheet using macros. This will allow us to manage our data more efficiently. Key tasks include: - Creating a macro that can extract and merge customer data across several Excel files. - Managing the data in a way that it is grouped by Customer ID. Skills and Experience: - Extensive knowledge in Excel and proficiency in creating macros. - Prior work experience with data consolidation projects. - Exceptional attention to detail. - Ability to organize data effectively. - Knowledge of data management according to customer demographics.

...data from Excel Sheets. The goal of this task is to determine if the presented ad spend had a significant impact on total sales or sales in our stores. The data spans from May 2016 to May 2024. Key Requirements: - Compile ad spend data from Google Ads and Facebook Ads, and sales data from Excel Sheets. - Perform trend analysis on the data sets to determine if any discernable impact exists between the ad spend and sales. - The focus should be on whether ad spend, regardless of platform, led to a measurable and discernable difference in sales. Ideal Skills: - Strong data analysis and interpretation skills. - Proficiency in working with ad spend and sales data. - Experience with trend analysis and correlation studies. - Proficient in Google Ads, Facebook Ads, and...

...targeted at the undergraduate level. Specifics: - The project should focus primarily on Electromagnetism, providing a thorough and detailed understanding of this topic. - The work should align with the standards of academic coursework fit for an undergraduate physics level. - The outcome will be utilized as an academic submission. So, it should be free from plagiarism and cite all the relevant references. Required skills and experience: - A physics background, preferably with expertise in Electromagnetism. - Experience in preparing university level academic research or coursework. - Strong written communication skills to effectively articulate the complex ideas in an easy-to-understand manner. - Understanding of academic standards, citation methods and research integrity. ...

I need a skilled Wikipedia developer with experience in creating detailed, professional pages. The page will focus on my company, offering a comprehensive overview of our history, a breakdown of our prod...overview of our history, a breakdown of our products and services, as well as information on our leadership team and structure. Key milestones will be emphasized, which include: - The company's founding - Important product launches - Awards and recognitions received The ideal freelancer has experience in creating business-related Wikipedia pages and strong research skills for sourcing reliable references. Attention to detail is crucial to ensure the accuracy of all presented information. A background in business or marketing would be advantageous, as well as familiarity wit...

Hi, i am looking for help with a solidwork project. I want to build tuned pipe , expansion chamber for dirt bike. I do know all my dimensions lenght and diameters. I want to be able to draw a line wich will be my centerline and then on this line i want customize every lenght and diameter of each section. Then had radius in sections. ...adjustable point to be able to adjust length and diameter for each my subsection. Because each pipe is build with many differents cones -Each section/cone needs to be customable on the amount of flat pattern needed. Each flat pettern are to be angle from both edges Steel plate thischness will be 1mm All dimensions are to be outside diameter. I want to be able to enter all my dimensions and length on an excel sheet(edit table) that will be included in ...

Translation of two files, from English to Hebrew. File #1 contains 8 rows of text in Excel format, 119 English words. File #2 contains 85 rows of text in Excel format, 2,035 English words.

I need a skilled developer with Opencart experience to create an automatic updater for my Opencart version 2.x store. The task is quite urgent, so I need it done as soon as possible. Key Requirements: - The system must update the following fields: - Product name - Product description - Meta Tag Description - Meta Tag Keywords (same as Product Tags) - SEO Heading Title - Meta Tag Description (160 characters limit) - I need the product description to be: - Minimum 200 words - Taken from the supplier's website - Translated from English to Danish - SEO optimization for each product Ideal Skills: - Proficient in Opencart - Familiar with APIs for data extraction - Strong in SEO and content writing - Able to work promptly and efficiently This project is time-sensi...

We have a list of around 4,795 energy consultants. This list contains the name of the consultant, the company name they work for, contact information including general email address, telephone number, website, and address. However, we need you to find out the personal corporate email address of each consultant, and insert it into Column K in the Excel sheet. Check the attached file. Time : 48 Hours Budget 50$ Lowest Bidder will win Milestone Payment : no advance milestone payment. After Completed work get payment. Thanks

We have different Brochures, but now search a new Layout in A4 Page and A5 Page. How can you help us, can you design our layout from now a little more professional and update the brochure. For future, we would like give self products in the pages - always more and bigger and need than every month a feedback and update from you. What is possible ? Language German References for Vehicle (Car/Truck) Brochures ? Send us layout samples from your works via message, after this we check and you get a feedback.

I'm seeking a freelancer to correct the date format in my Excel sheet that is currently not displaying correctly. Key Requirements: - The Excel sheet must display dates in the format DD/MM/YYYY. Additional Details: - The corrected date format is only required on specific sheets within the same workbook, not all sheets. Ideal Skills & Experience: - Proficiency in Excel and its date formatting functions - Experience with correcting date format issues in Excel - Attention to detail to ensure all specified sheets are updated correctly.

I need a freelancer to search List of Medical centers & Hospitals in Australia. Currently we have a list of centers & hospitals but need to search & add about 3000 more which are not included there (Including the contact details). We need a complete file with accurate detils & milestone will not be released until the work is checked. All centers should be added as per the state. Please quote with the time period & the exact fees you will charge for this. Ongoing work for successful candidate.

...live support needed via teams. The request has to be fulfilled this week. I'm in need of a professional who can assist me with creating workflow automations and integrating with Microsoft applications. We will organise a teams sessions and go through the desired customizations , all the work is done via remote access. I have a Microsoft environment comprising of SharePoint, Outlook, Teams, Word, Excel, and PowerPoint. Some tasks need to be automated such as document approval , collaborations and other SharePoint settings. Ideally, you should be highly proficient in Power Automate (Microsoft's workflow automation tool) and have strong experience in integrating various Microsoft applications. A background in SharePoint, Outlook, Teams, and the Office suite is a big pl...

I have a basic school project that requires inputting provided data into Microsoft Excel. Here are the specifics: - You will be provided with a simple dataset. - The main objective of the project is to input data from this dataset accurately based on the given instructions. The ideal freelancer for this project would be someone who is: - Proficient in Microsoft Excel. - Detail-oriented to ensure accurate data input. - Able to follow provided instructions carefully.

**Project Objective:** We are looking to automate the management of absences within our company using VBA Excel. The goal is to simplify and optimize absence tracking, reporting, and data analysis to save time and improve accuracy. **Project Description:** The project involves developing an automated solution in Microsoft Excel that includes: 1. **Absence Data Entry:** - Interactive forms for entering absences (sickness, vacations, authorized absences, etc.) - Data validation to ensure accuracy and consistency. 2. **Automatic Absence Calculation:** - Automatic calculation of absence days per employee. - Tracking different types of absences and their quotas (paid leave, sick days, etc.). 3. **Report Generation:** - Creation of weekly, mo...

I need help with a data entry task that involves copying and pasting data from PDF documents into an Excel spreadsheet. Key points: - The task involves strictly copy and paste work, no data cleaning or formatting is required. - The primary source of data is PDF documents, so proficiency in extracting data from PDFs is a plus. - The data should be accurately transferred into an Excel spreadsheet. Ideal Freelancer: - Proficient in PDF data extraction and Excel. - Attention to detail is crucial. - Previous data entry experience is preferred.

I'm in need of a Power BI expert to create a comprehensive dashboard for our recruitment department. The dashboard will pull data from our existing Excel spreadsheets and update daily. Key Features Required: - Job Status: This will give us a clear overview of the number of open positions, positions in the interview stage, and positions that have been filled. - Recruitment Pipeline: Visual representation of where in the recruitment process our candidates are, from application to hire. - Applicant Information: A detailed breakdown of our applicants, their demographics, and the source from which they applied. - Application Source: Analysis of the effectiveness of our recruitment sources. - Time to Hire: Ideally, a calculation of the time it takes to move a candidate from applicat...

I am in need of a diligent professional who can assist in extracting text data from PDF files and accurately inputting the information into an Excel spreadsheet. The job calls for attention to detail and excellent data entry skills. Essential Skills and Experience: - Proficiency in Data Entry - Expertise in Excel Your responsibilities will include: - Accurately converting text data from PDF files into Excel - Ensuring data integrity through careful data entry - Delivering the project on time Ideal candidates would have prior experience in handling similar tasks. Your accuracy and commitment to the task at hand will be pivotal to the outcome of this project. Looking forward to receiving your bids.