Excel vba link formcông việc
I am in dir...Your core responsibilities will include: - Data Entry: You should be familiar with Microsoft Excel, as a significant part of your job will be related to entering and managing data in a structured, orderly manner. - Email Management: Not only will you be tasked with responding to inquiries on my behalf, but you'll also be setting up automated responses to maximize efficiency and ensure no email goes unanswered. - Scheduling: You will also help in scheduling meetings. This will involve coordinating with multiple parties to find suitable times. Ideal candidates should have prior experience in administrative roles and should be proactive with excellent communication skills. Mastery of Microsoft Excel is a must, and previous experience with email management ...
Th...To successfully meet the project's goals, I require a specialist in email scraping to obtain addresses for real estate agents across South Africa and the UK. The target website where these emails will be extracted from is Property24. Of utmost importance and unique to this project is the regional scope. It should cover all regions, without exclusions, within the two countries mentioned. To excel in this project, having the following skills/experience would be ideal: - Strong experience in email scraping - Familiarity with the Property24 platform - Sound understanding of real estate markets in South Africa and the UK - Ability to accurately segment data by region Your commitment to accuracy and attention to detail will strongly influence the success of our subsequent l...
I am looking for an experienced VBA developer to create a custom add-in for Excel. This project will require: - Developing custom functions to automate the generation of multiple types of charts in Excel, specifically pie charts, bar charts, and line charts. - These charts should be formatted according to our specific design requirements, including our house style and measurements. The ideal freelancer will have exceptional skills and experience in VBA and Excel add-in development. I expect a strong understanding of data analysis and an excellent ability to perform tasks accurately and efficiently. Furthermore, I value clear and regular communication so we can ensure the end result meets our expectations. Please only apply if you are confident you ...
I'm in urgent need of a web based applicat...transforms PDF files, largely bank statements, into Excel layouts. Key Features: - The application should have batch conversion support, allowing numerous files to be converted at the same time. - It needs to have OCR (Optical Character Recognition) capability for pinpointing and extracting info from scanned PDFs. - Its operation should be secure with user authentication and access control features to maintain data privacy. Ideal candidate skills: - Robust experience in web application development - Familiarity with OCR technology - Knowledge in building secure applications with user authentication and access controls - Ability to work under pressure to fulfill project needs ASAP P.S: Keep in mind, the goal is to produce files i...
Today, I need a professional with deep understanding of database creation and Excel data organization to produce a new, streamlined database from my current Excel one. Key Project Requirements: - Convert an Excel database with 1-10 sheets/tabs into a new database system. - Your task is to simplify and streamline the layout of the data for ease of use, without losing critical information. - While expertise in Excel is a must, experience with other database systems is also necessary, considering we might need a smoother platform than Excel. Ideal Candidate Skills: - Thorough experience working with Excel and other database systems. - Exceptional at delivering swiftly to meet today's deadline. - Excellent understanding of efficient data layo...
...about yourself, your current situation and show me previous work. *Important* - I expect a sample to quality check your work, if I find qualified for the position, I will provide you with raw footage and you will create a short-form video from it. Fluent English is a must + you must be able to jump on a Zoom call to go through the onboarding process (webcam is a must). Daily reports are expected whenever we get to work. Looking forward to hearing from you? Please share your portfolio featuring relevant work, and detail your process in crafting engaging short-form educational content....
Amend UI and sidebar arrangmennt
I need an experienced data scraper who can extract specific information from a horse racing website. Your task will be to gather data on past horse race records, focusing on: - Horse Names - Race Dates - Horse Positions - And the complete data from the table What I need is for this information to be extracted from the website and then outputted into an Excel file. Proficiency in Data Scraping tools and Excel is mandatory for this task. Prior experience with similar sports data scraping will be highly advantageous. Efficiency and accuracy are crucial in this project.
Job Title: Education Sector Telecalling Sales Expert (Work from Home) Position Overview: We are seeking a highly motivated and results-oriented individual. The ideal candidate will possess excellent communication skills, a proactive attitude, and a strong sales mindset. This p...experience in selling educational products or services. 2. Familiarity with online learning platforms and technology solutions in the education sector. 3. Additional language proficiency is a plus, especially in regions with diverse language demographics. This is a remote position offering competitive compensation with attractive incentives based on performance. If you have the skills and motivation to excel in a telecalling sales role within the education sector, we encourage you to apply and join our dyn...
I need an expert in MS Excel to finalize an advanced timeline schedule. It should consider different factors such as: - Variable work hours per day, - Weekends, - Overtime hours. It's crucial that the dynamic schedule intelligently adjusts to these factors, providing an accurate timetable for my team's workflows. Column M should focus on "Estimated Completion Time". Ideal candidate should possess: - Excellent knowledge and experience with Excel functions and dynamic formulas, - Attention to detail, - Adherence to specified conditions, - Familiarity with corporate scheduling norms will be a plus. Your insightful input to perfect this timeline tool would be highly appreciated.
As an entity constantly dealing with vast amounts of data, I need a proficient Excel VBA expert to assist in automating my reporting and dashboarding processes. An ideal candidate for this project should possess the following: Skills and Experience: • Extensive experience developing VBA Macros • Capability to generate reports automatically • Familiarity with handling data across multiple sheets Specific Tasks: • Developing macros to automate data retrieval from sources such as Excel workbooks and CSV files • Implementing these macros to streamline the process of report generation and dashboard updates By simplifying these tasks, this project will enhance our overall productivity and data management processes. It is crucial that the ex...
I'm looking for a proficient data analyst with the ability to tackle complex data sources and deliver clear, actionable insights. Key Skills and Experience Required: • Exceptional statistical analysis abilities; • Strong data visualization and programming skills. Expected tasks: • Handle data from different sources such as Excel spreadsheets, SQL databases, and CSV files. • Analyze the acquired data meticulously and generate concise reports on your findings. Project Outcome: • Provide profound insights and recommendations based on the data analyzed. • Create comprehensive visualizations and reports to aid in decision making. • Develop predictive models derived from the data analysis. The ideal candidate for this project will have a notab...
I'm looking for a highly organized and meticulous freelancer to handle a numeric data entry task on Excel. Your task will encompass: - Entering simple numeric data into predetermined fields. - Color-coding the entries to ensure easy readability and data categorization. - Ensuring the data is entered accurately and double-checked for any potential errors. Prior experience with data entry, particularly numeric data, is highly advantageous. Proficiency in Excel, particularly with color-coding functionalities, is also a must. Attention to detail is key, as well as the ability to adhere to strict formatting guidelines. Hearing from candidates with a proven track record of delivering high-quality data entry work.
I need an expert in finance and Excel to provide oversight on my project. The Excel model you'll work with is tailored for financial forecasting. The main tasks include, but are not limited to: - Scrutinizing and validating existing formulas - Ensuring data accuracy and integrity - Identifying and promptly fixing any errors These tasks require a robust understanding of finance-related models, specifically in the realm of financial forecasting. Familiarity with investment calculations and risk assessment would also be beneficial, though not a primary requirement. The right professional for this job must have in-depth experience with Excel, its advanced features, and the finance industry. Your insights and expertise will help fortify this model and ensure its ...
...out new opportunities, I need an expert freelancer to beautify my Word document resume. I already possess the necessary content. What I need now is someone who can bring their creativity and sound formatting skills on board to make my resume not just stand out, but shine. Ideal applicants should: - Have prior experience with resume design, particularly in a corporate style and AtS compliant - Excel in the formal formatting of documents, specifically Word. Your duties would include but are not limited to: - Arranging my existing content into an elegant, eye-catching layout - Suggesting addition or removal of sections in order to increase clarity and cogency In your application, kindly elaborate on how you plan to approach this task, what would be the timeline, and how you c...
...Keeping track of all transactions and inputting them into my system accurately is the key. Mastery of Microsoft Excel is an absolute must as this is the platform used for managing this data. - Bookkeeping: I require someone who is well-versed in handling financial records. You will be responsible for keeping all the financial facts and figures in check. - Financial analysis: I expect a high level of accuracy and attention to detail in reviewing financial data for any irregularities. Your role will involve providing insights based on these analyses. Skillset: - Excellent Microsoft Excel skills: Proficiency in managing large sheets of data and adeptness with utilizing various Excel functions and formulas are prerogatives for this role. - Experience in bookkeepin...
BUDGET - 10$ I urgently need a professional developer to fix a problem with my website's contact form. The specifics of the issue remain unclear as it was not identified. Ideal Skills and Experience: - Expertise in web development and troubleshooting. - Past experience in handling similar projects. - Good communication with regular updates. Note: This project needs immediate attention and completion.
I'm looking for an Excel specialist to integrate a user-friendly Graphical User Interface (GUI) into my existing price list spreadsheet for a complex software product line. The GUI should considerably simplify the selection process for our customers, offering the choice between software packages and a la carte ordering. Key functionalities to be included: - Package selection: The GUI should contain an interface allowing users to choose from various software packages. - A la carte ordering: For added flexibility, there must also be functionality for users to select individual software options independently of packages. - Option selection: A tool for detailed and specific software choices is necessary. For displaying the available packages and options, the use of checkboxes is...
I am in need of a skilled Tally developer to customise my current system, specifically to improve our ways of exporting data. I am looking for an expert who can: - Modify our Tally system so it can export TDS deduction data to an Excel template format we use. - Include deductor's detail and deduction details in the data that is exported. - Seamlessly transition data from Tally to our IT PL BS format as well as CAOffice tb format. Experience working with these specific modules and formats will be highly valued. Your expertise should include understanding the requirements of data export and manipulating Tally to suit those needs.
I need a spreadsheet created from All of this information is updated and relevant. Once into excel, I need the postal mailing address for each organization. This will need to be found and verified via google.
As an employer, I require a capable freelancer who can create an efficient Excel attendance sheet for me. The ultimate goal is to track my employees' attendance on a daily basis by their work shift. Scope and Deliverables: - Design and implement an attendance sheet using Excel - Categorize the data according to different work shifts - The sheet should capture daily attendance data Ideal Candidate: - Must be proficient in Excel - Should have prior experience in HR systems or work schedule development. - Understanding of data categorization and visualization methods. - Attention to detail is key to perfectly capture the attendance data. Let's implement a tool to maintain an efficient, organized working environment. Hope to collaborate soon!
... see the most right picture, the table doesn’t show up 3. In the Worksheet "Link 1", this contains a list of basketball league tables from several countries. I have only listed 1/10 of the full list for the purpose of testing the outcome of this job. 4. The link for each of the table is listed in the RED weblink. 5. Requirement- The requirement to copy from the "R" until the last row last string, such as W1 in the example. The data will be pasted in the cell right below the link, in this example is Cell B7. 6. Requirement- When the spreadsheet is opened, there should be an option if i want to refresh all the links, or remain as it is. 7. Requirement- Computation or refresh of the data should be within the Excel file itself, if an...
NECESITO UNA TABLA EN EXCEL, PARA MANEJAR UN EMPRENDIMIENTO EN EL CUAL SE PUEDA CALCULAR STOCK AUTOMATICAMENTE, COSTOS ,GASTOS UTILIDAD Y TOTTAL DE UTILIDAD DE TODOS LOS PRODUCTOS Y QUE AL MOMENTO DE DESCONTAR 1 ITEM DEL STOCK ME GENERE EL COSTO Y EL GASTO Y LA UTILIDAD QUE SEA SOLO INGRESAR LOS DATOS.....ES UN EMPRENDIMIENTO DE IMPORTACIONES DE CHINA , ASI QUE LOS PRODUCTOS VAN A SER VARIADOS Y DE TODO TIPO .
I'm in need of an experienced freelancer versed in SEO and link building strategies. The task involves creating article links from a range of free article sites. Here's a quick overview of what I require: - Extensive link building from prominent free article sites including but not limited to EzineArticles, ArticleBase, GoArticles. Skills and Experience Needed: - SEO Expertise: The freelancer must be proficient in modern SEO techniques, specifically link building. - Content Writing: The freelancer should have a good grasp of content creation to craft engaging articles that wouldn't appear as spam. ( Using CHAT GPT) - Knowledge of Free Article Sites: The freelancer should be aware of the guidelines of these free article sites and should ensure the...
I am in need of a talented interior designer to add a modern twist to the midcentury styled bedroom, en suite and wardrobe in my home. The specific requirements for the job are: - Design knowledge: Having a deep understanding of midcentury design and an ability to incorporate modern elements within this design language is necessary. 2D plan...- Experience with residential interior design, specifically bedrooms and en suites - A keen eye for modern trends that mix well with midcentury aesthetics - Strong portfolio demonstrating your design capabilities and versatility. This project requires expert project management skills to oversee smooth operations and timely completion, making it a particularly exciting opportunity for those who excel in their creative and administrative cap...
Looking for web scrapping and automation expert with strong fundamental knowledge of various web frontend and backend frameworks. Task at hand - Should be able to write generic application to automatically sing in , sign up and fill forms for popular frameworks. NOT a website specific task but should work for any general website on these frameworks like react , angular, etc Exciting project so only reply if you have the string internet fundamentals on these technologies. And can implement using python or any standard scripting language
son 3 formulario que se llenan a mano, me gustaría automatizar esos proyectos quiza en excel o en google sheets. La idea es crear un solo formulario para que estos se generen automáticamente,
In this task, I need a freelancer to transform my Google Sheets data into a Microsoft Excel file. While I am unsure about the preservation of formatting during the file conversion process, I appreciate someone who could provide advice on this matter. I am not currently using any filters, so this will not be a concern. Finally, the total should be displayed in bold in the last row. Skills and Experience: - Proficient in Microsoft Excel. - Strong understanding of data conversion between Google Sheets and MS Excel. - An ability to suggest the best approach for formatting preservation could be advantageous.
I am seeking a skilled R programmer to develop code for comprehensive data analysis. The project revolves around analyzing scientific research data, with an emphasis on providing descriptive analysis of these data sets, particularly writing code to create interaction matrices that will be used for social network analysis. The code will need to read in data from 80+ Excel sheets, create interaction matrices, and link in ID numbers from a separate document. Ideal Skills: - Mastery of R programming - Experience with scientific research data - Strong skills in data analysis
This task revolves around gathering data available online to paste onto an excel spreadsheet. Here's what I need: - Have the skills to conduct online research. - Extract company names, financial data, and the location of companies found during the research. - Have the ability to organize this information nicely in a spreadsheet. - I will give you the company names and where to find the information, so this is also about the ability to follow instructions I'm looking to get this done asap so speed vs cost is important to me. This is a very simple task. Ideal freelancers will have proficiency in web research, be organized and detail-oriented, and possess excellent data entry skills. Knowledge of finance and basic understanding of businesses is a plus but not necessary, to...
I need assistance with filtering data based on date ranges within SQL queries for a database that uses a DD-MM-YYYY format. The ideal candidate would possess: - Proficiency in writing and debugging SQL queries - Experience with implementing conditions in SQL queries - Strong understanding of date formatting and how to filter data based on a given date range. Deliverable: I have an excel sheet extracted from sql server I need a query to have the punch in and punch out on the same row note sometimes the punch in and punch out is not in the same date
Buscamos un Especialista en Excel con experiencia comprobada en la creación de paneles o cuadros de mando. Desarrollará paneles de control que proporcionen información clave sobre diversas áreas de gestión de la empresa, incluyendo producción, productividad, compras, stock, contabilidad, ventas y más. Crear tablas dinámicas, gráficos y KPIs que proporcionen una visión clara y precisa del desempeño de cada área. Requisitos: Experiencia demostrable en la creación de dashboards y cuadros de mando utilizando Excel. Profundo conocimiento de funciones avanzadas de Excel, incluyendo tablas dinámicas, gráficos, macros, y fórmulas complejas. Habilidad para interpretar...
I am looking for passionate and experienced Excel experts who can optimize my Excel Gantt Planner (Calculette Rollout v13 - ) through several adjustments: Formatting Improvements: - **Color Coding:** Implement my provided color palette to create a more visually intuitive and aesthetically pleasing spreadsheet. - **Macros corrections** - **Calendar translation** >>>>>> I need what is in the PPTX file that is attached with the project <<<<<<<< Any ideas, improvements are welcome. + There is another Excel table (Suivi ) and I need a nice looking GANTT planner to be added to it (Project 2 Gantt ). Please DO NOT CONTACT ME to ask for more money than the budget I can afford.
I'm seeking an experienced data visualisation expert for the creation of an interactive D3.js project. Key Requirements: - Prior expertise in creating visuals from numerical data. - Strong proficiency in D3.js for advanced - may need to do data manipulation ising excel or python to get the data tonthe right format for visualisation (not simple bar or pie charts alone) - visualisation to be used in website - Proven skill in creating interactive data visualisations. I am aiming for these visualizations to be very interactive, allowing viewers to engage with the data in a dynamic way. The successful freelancer would ideally present a portfolio evidencing similar past projects. Working closely together, let's make data exciting visually!
I am in search of a detail-oriented freelancer proficient in data entry. The project entails the following: - Inputting data for cooking, baking, and beverage recipes into online forms. - Error-checking and validating all entered data. - Ensuring all forms are filled out completely, following established procedures. Ideal experiences and skills include: - Proficiency in data entry and form filling - Familiarity with culinary terms and recipe formats - Strong attention to detail - Exceptional organizational skills. This project is perfect for individuals who are familiar with various types of recipes and have proven data entry skills.
Ich benötige jemanden, der mir eine Umfrage in Limesurvey erstellt. Die Fragen sollen sich auf das Interesse an Schulungen bezieh...eingefügt werden, kein Transfer von anderen Formaten notwendig. - Es soll dieses Typeform möglichst 1:1 übernommen werden und auch das Look & Feel gleich sein. → <> - Die Teilnehmer sollen nach Absenden der Umfrage eine E-Mail mit allen Antworten bekommen. (Buchungsbestätigung) - Die Schulungsorganisation soll eine Email mit allen Antworten bekommen. - Eine Excel-Liste mit allen Anmeldungen soll zum Download bereitgestellt werden aus Limesurvey Bitte stellen Sie sicher, dass Sie mit Limesurvey vertraut sind und eine ansprechende und logisch strukturierte Umfrage erstellen können. Ich freue mich auf Ihre Vor...
I'm seeking an experienced freelancer for my project which requires filling 50-200 online forms. - Type of work: Each form will require in-depth information through multiple-choice questions. Familiarity with complex form structures and detail-oriented data entry is crucial. - Ideal Skills: Excellent attention to detail, solid comprehension of multiple-choice questions, and proficient in handling a sizeable batch of forms. Previous experience with detailed and sizable data entry tasks will be highly valued. This project will require a systematic approach, efficient time management skills, and a track record of accuracy.
I'm seeking a skilled developer to create a web-based NGO membership software with a mix of pre-made templates and custom design. Functionality is key, and the software needs to easily handle: • Member and staff registration and login • Import and Export Membership with CSV/Excel format • Features for alerts via email and mobile SMS • Payment management • Comprehensive communication tools • Leads and member follow-up capabilities • Appointments and call management • Document management for customers • Creation and dispatch of quotations & invoices • Expense tracking • Staff management features • In depth accounting reports • Catalog or service management features • Features for alerts via email and mob...
I'm currently working on a book project that features 50 newspaper articles I've written. To ensure my work's credibility, accuracy, and ensure no copyright issues, I need assistance in ...assistance in tracing back the original source of each article. Key tasks will include: - Determining the original source of every article - Verifying the accuracy of the information in the articles - Identifying the newspaper title, publication date, and the URL of each original publication All the gathered information must be recorded in an Excel workbook. Experience in data research, data entry works, and strong proficiency with Excel would be crucial for this project. Knowledge of journalism, media law, and an understanding of copyright law would be bonus skills w...
I need someone to build a contact form with backend like this one: It has to follow a special css structure (I will send css). I will send you HTML file, all you need to do is to put all labels and text boxes found in this page () and built js back-end contact form that send all details filled out by customer to specific email address I will provide. Please ask questions before accepting to start working.
I am seeking a qualified individual who can integrate affiliate link buttons into both my Android and iOS mobile applications, using my pre-existing API. Key elements of the task include: - Crafting a database system: The successful candidate will construct a database to store the API data needed to support the affiliate links. - Incorporating affiliate link buttons: The developer will be responsible for adding these into specified screens within both of my mobile applications (2 Android and 2 iOS). - Ensuring functionality: Upon user interaction, the link buttons must reliably transport the user to a particular website. - Database will dynamically create with information from API. - Incorporate the API version code, when API is updated database is dropped and new...
I'm looking for an expert in web d...a password for the purpose of account verification. This information will be vital in giving them exclusive access to our content. Your responsibilities will include: - Creating a user-friendly interface for data input - Ensuring robust security measures are in place to protect these data In instances where a user forgets their password, the system you create should be able to generate a reset link and send it to the user's registered email. This requires expertise in both frontend and backend development, with a focus on cybersecurity. Familiarity with handling sensitive data is a must. Ideal skills: •Frontend and backend development •Cybersecurity •Experience in creating data collection interfaces •Knowledge on ...
I'm seeking a talented individual with strong data entry skills to digitize contact information from 125 business cards into an Excel spreadsheet immediately. Details: - Data to be entered includes: ENTER THESE FIELDS BUSINESS FIRST NAME LAST NAME POSITION PHONE CELL PHONE FAX EMAIL WEBSITE ADDRESS CITY STATE ZIP CODE Ideal Skills: - A keen eye for detail as accuracy is paramount - Prior experience with data entry projects - Proficiency in Excel - Excellent time management skills to ensure prompt project completion Note: Only bid if you can start immediately. I'm on a tight deadline and need this task completed posthaste.
I'm looking for an expert in Microsoft and Visual Basic for Applications (VBA) to streamline my repetitive financial data entry tasks. Key Tasks: - Develop a VBA script to automate the entry of financial transactions Ideal Profile: - Proficiency in programming with Microsoft and VBA - Previous experience in automating data entry, preferably financial transactions - Strong attention to detail to ensure accuracy in data entry automation - Basic understanding of financial transactions for effective development of the automation system The successful freelancer will create a simplified and efficient data entry process that eliminates the manual input of financial transactions. Attention to detail, speed, and efficiency are vitally important for this project.
I am looking for a professional who can efficiently extract and copy all information from a PROTECTED Airtable sheet to Excel. No adjustments or specific arrangements on the data are required - I just need all the values intact and legible. Key responsibilities: - Extract all data from the PROTECTED Airtable sheet: - Copy data to Excel without any modifications This is a one-time task, so timeliness and accuracy are essential. Ideal freelancers are those who have extensive experience with both Airtable and Excel, as well as a deep understanding of data extraction principles. Strong attention to detail is an asset.
Necesito a alguien que sepa bien de fórmulas de excel para hacer una planilla que cuente con: - Porcentajes automáticos - Checkboxes Trabajo a realizar HOY. Si no tienes disponibilidad para comenzar de inmediato por favor no ofertes. Presupuesto $10
I'm seeking a skilled Excel specialist to develop an efficient reporting system derived from our Core Banking System. Key Responsibilities: - Enable data extraction, both manual and automatic, for maximum flexibility. - Integrate fundamentals like Financial and Regulatory reports. - Incorporate functionality for Ad hoc reports based on unique user requirements. - Ensure the system is adept to update the aforementioned data on a daily basis. The freelancer best suited for this task will have exceptional skills in Excel, and experience developing similar banking or financial reporting systems. Appreciation for detail and understanding of financial and regulatory protocols are also desired.
I am in search of a skilled sales officer to join our team at Yes Bank, specifically within the ...clients to our credit card services. - Sales Target Achievement: Meeting and surpassing outlined sales targets regularly. The perfect fit for this role is an individual with the following qualifications and experience: - Sales Experience: Proven track record in a sales environment. - Excellent Communication Skills: Ability to engage effectively with potential customers. - Microsoft Excel: Proficient in using Excel for data management and reporting purposes. This role offers the opportunity to work in a dynamic and fast-paced environment, providing measurable results towards the company's success. If you meet the above requirements and thrive in a sales position, we would ...
I need an expert typist to input assorted data - text, numbers, and dates - into a multi-columned Excel sheet. Key Tasks: - Manually enter a vast amount of structured data, extending over 50 columns and rows - Ensure accuracy as the consistent structure should be maintained across all filled cells Ideal Candidate: - Proven experience with high-volume Excel projects - Exceptional attention to detail for accuracy - Ability to follow a strict data structure - Familiarity with varied data types - specifically text, numbers, and dates.
