Excel vba for työt

More details: Are you looking to hire a freelancer to clean data in both CSV and Excel formats? Yes What is the primary goal for cleaning this data? Assessment What type of assessment do you need the freelancer to perform on the data? pass assignment.

More details: Are you looking to hire a freelancer to clean data in both CSV and Excel formats? Yes What is the primary goal for cleaning this data? Assessment What type of assessment do you need the freelancer to perform on the data? pass assignment.

I am looking for an Excel expert who can set up automation for specific tasks and create custom formulas based on my requirements. Key Requirements: - Automation of specific tasks: I need to reduce manual work and save time by automating repetitive tasks. - Custom formulas: I need new formulas developed to perform calculations and analysis that are not covered by Excel's standard functionality. Autocalculation Trigger: - I want the autocalculation to be triggered every time the Row is highlighted with sold green color. I have ten different columns with hundred of rows with specific beginning text "spect". When user fills a background color assume its solid green on a cell of a particular column the function should autocalculate the complete column a...

I'm launching a project in the medicinal field and am in need of a competent and dedicated research assistant. You'll primarily be dealing with published literature and are expected to perform the following tasks: • Assist in literature reviews in a research topic • Screen search results ibased on a predefined criteria to select studies for inclusion in the review. • Extract data from selected studies using standardized forms and protocols. • Verify the accuracy and completeness of extracted data, resolving discrepancies through discussion with team members. • Summarize and synthesize findings from included studies, highlighting key results and trends. • Participate in team meetings, providing updates on progress, challenges, and insights gain...

I have a project that revolves around copying and pasting text data within a single Excel sheet, focusing on specific rows or columns. - Brief for This Job - Your primary task is to copy text from specific rows or columns and paste them responsibly where needed. This project will probably only take four hours of your time. (course number + date from + date to) copy paste beside every student name I need it for my database to be in this format video will be send to you to understand my requirement each freelancer will cover 200 course out of 1000 course so 5 freelancers will be hired maximum budget is 16$ for each freelancer do not contact me if your bid more than that submission within 24 hours from awarding the project (failure to submit will considere...

I need a dedicated and thorough researcher to help me compile a comprehensive list of local builders... and roofers. Your main task involves finding their emails and Instagram accounts as we need these for marketing purposes. Key Requirements: - The service providers must be local to a specific city which will be provided to you. - The collected information should include the provider's full name, service type, and contact number. - The information should be appropriately organized into a Google Spreadsheet so that it's easy for me to analyze and use. Skills and Experience: - Experience in web research or data mining - Precision and attention to detail - Familiarity with Instagram and ability to find user profiles - Excellent organizational skills - Proficienc...

Have operations based math problems that I need done for a work project. 3 problems that involve aggregate planning, inventory planning, subcontracting, production levels, economic order quantities ect. Strong excel knowledge required where you can run solver.

Welcome to Fortunabs! Are you passionate about digital marketing? Do you have an eye for detail and a knack for constructive criticism? If yes, then this contest is perfect for you! Who We Are: Fortunabs () is a cutting-edge platform dedicated to offering comprehensive digital marketing education entirely in Spanish. Our mission is to empower individuals with the knowledge and skills they need to excel in the digital marketing world. What We Need: We're looking for enthusiastic individuals who are fluent in Spanish to dive into our platform, engage with our content, and provide us with valuable feedback. Your insights will play a crucial role in helping us enhance the learning experience for our users. How to Participate: Register on Fort...

I'm seeking a talented visual effects artist to create a stunning character transformation scene for my film. Specifically, the scene involves a character eerily morphing into a dead body. Requirements: - Proficiency in creature animation, particularly in the realm of morphing effects. - Experience with macabre or horror-themed VFX would be an asset. - Capability to create convincing and visually striking transformation effects, in this case, human to corpse. - Ability to closely collaborate and discuss progress and revisions. This project presents a unique challenge and is ideal for those who excel at creature animation and have a knack for the unsettling and uncanny. Your creativity and distinctive flair will bring an integral scene in my film spect...

I am in need of a skilled SQL coder to help me join the tables and build a health care report in Excel. The report will focus on patient demographics and medical procedures. Key requirements: - Expertise in SQL coding - Proficiency in Excel for report building - Experience in handling health care data - Ability to merge tables effectively The report should include: - Patient demographics such as age, gender, and location - Medical procedures data The ideal candidate should be detail-oriented, able to follow instructions, and have a background in health care data management. It is important that the report is well-structured, easily understandable and can be updated efficiently.

More details: Do you want the Excel program to convert purchase orders and local stock into separate TXT files? Yes Should the program automatically detect and apply specific parameters for each conversion, or will you provide the parameters? Mix of both Which specific parameters do you need for the TXT conversion of purchase orders? Each order should be a TXT

I am looking for a proficient data analyst who can assist me in providing data analysis using Excel. Specific tasks include: I have two online retail catalogs that sells similar products as one another. Medline & CVS Health. Medline has 313 products listed and CVS Health has 892. I need a comparison chart in any format (Excel or Word) that addresses: 1.) how many brand name products are under Medline. List then out. 2.) how many brand name products are under CVS Health. List them out. 3.) how many Medline specific products are under Medline. List them out. 4.) how many CVS branded products are under CVS Health. List them out. 5.) Which products does CVS health have that Medline does not? (Ex: reading glasses) 6.) Which products does Medline have that CV...

...looking for a skilled and experienced Excel expert to create a detailed and comprehensive Excel spreadsheet which will serve as a trucking business operational tracker. Key Information to Include: - Revenue: Primarily from freight charges. - Expenses: comprising of fuel, maintenance, office expenses and rent. - Profit Margins: Determine the profit margins by deducing expenses from revenue. - Mileage and Fuel Costs: Tracking to determine efficiency and cost-effectiveness. Frequency: - The ideal candidate should create a sheet easy to update on a daily basis. Ideal Skills & Experience: - Proficiency in Excel - Astute attention to detail - Experience with financial and operational data tracking - Knowledge or experience in the trucking industry would ...

I am in need of an expert in Excel to create a system for managing my financial and inventory operations. With your specialized skills, I require a streamlined and seamless workflow for my business that includes the following: Accounting: - Managing both income and expenses in a clear and concise manner Invoicing: - Capabilities to create invoices directly within the sheet - Functionality for generating these invoices in a PDF format - A reliable system to track invoice payments Inventory Management: - A method to effectively track stock levels - A simple way to generate purchase orders as needed - A solution for generating sales reports for analysis The freelancer best suited for this project would have an extensive background in Exc...

بالمرفقات أنا بحاجة إلى شخص يمكنه إجراء بعض العمليات البسيطة على ملف Excel الحالي الخاص بي. تشمل المهام ما يلي: - تنظيم البيانات وتصنيفها - إضافة الصيغ والحسابات - اجرائات اخرى

?THIS ANNOUNCEMENT IS ONLY FOR THOSE WHO WANT TO SHARE THE SYSTEM? I am selling a system for recording and tracking bird sightings designed to facilitate the process of observation and monitoring of biodiversity. This system provides an organized and updated platform for the registration of birds observed in different areas, allowing to identify and monitor the species of birds that inhabit the area. In addition, the system encourages learning and interest in bird watching and biodiversity conservation. The system has the following specifications: Login: the user can log into the system using their email and password. Reset password: the user can reset his or her password in case he or she has forgotten it. Sightings registration: The system should allow users to ...

Necesito construir un dashboard dinámico en excel para análisis de información

Hi Kelvin Writer, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I require immediate assistance for a web scraping into Excel task. This project focuses on the extraction of complete tables from different websites. Requirements: - Have expertise in web scraping and excel. - Be able to deliver completed work ASAP. Ideal Skills: - Proficiency in tools or programming languages for web scraping. - Strong command of Excel and data wrangling. - Demonstrated punctuality and adherence to deadlines. This is a time-sensitive task, requiring both speed and accuracy. Please, only serious and dedicated freelancers should consider this project. Job Description: There are 2 sets of tables, Soccer and Basketball for my analysis during my free time. 1. The links are in the spreadsheet highlighted in yellow. The script mu...

Ge...regresión tipo probit o algun modelo prospuesto por el analista con las variables datos demográficos con la productividad, la permanencia, las asistencias, la puntualidad, las horas trabajadas y el salario para obtener un perfil laboral del trabajador que mejor se ajuste a la empresa. Perfil del cargo: • Profesional con estudios de estadistica o certificación en analisis de datos • Conocimientos Excel, Power BI o Tableu , BBDD y semantica. • Experiencia en análisis de datos Funciones: • Analizar datos y confeccionar dashboard con semantica. • Establecer manejo de bases de datos y su optimización. • Regresión lineal o modelos para obtener analitica fiable. • Integración y qwerty ...

I need help developing a risk assessment in Excel for my clients. I had one developed for an Ergonomics assessment, now I need to amend this to include additional fields and scoring for Quickchangeover (QC). I need an expert to create a new worksheet, formulas, macros, etc. Review the attached Ergo assessment so you can see what was developed previously and what I need (directionally) the QC assessment to move toward. Are you interested? Read the ReadMe file and look at the docs. thank you.

I'm in need of an expert in Excel to create a spreadsheet that will automate data entry, perform calculations, and generate reports. The complexity isn't clear yet, as I'm unsure how many different tasks will need to be automated. The suitable candidate should have: - Proficiency in Excel, including advanced features - Experience with automation within Excel - A good understanding of data entry, calculations, and report generation I'm open to a dialogue to specify the details further. On the first tab in Excel, I'd like to have all the individual contributors. Then have a tab after that for each individual to show their trends over the months. Anything over 95 is considered good and below 95 would be not good. There are 15 con...

There is an excel file to modify according special rules

...Someone who can combine data from other files, and websites, and connect it into one spreadsheet. Key requirements: - Website image scraping - Combine data of external websites with existing spreadsheets / excel csv files. - Data scrape images from external websites, and copy url to match the google spreadsheet lines - Download mass URL of these images into a separate accessible folder for future management. Potentially around 50,000 lines of data to manage and enter. Ideal Skills: - Google Spreadsheets - Data Organization - Image uploading and management - Web form integration - Excel We will provide as much data as possible. your job is to enter it in. Most of the database is in English, some of the entry is in Japanese. some example of websites we will ...

I am looking for a seasoned professional who can leverage artificial intelligence (AI) analytics to enhance my business efficiency. The project will involve: - Data analysis - Predictive modeling - Natural language processing These tasks aim to utilize machine learning (ML), as well as harness the power of Azure Databricks, Azure Data Lake Storage, Copilot, and Azure Data Factory. This project will also use Azure Kubernetes to ensure that the analytics processes are scalable. The main goal is to augment our standard business processes and make them more effective by leveraging these technologies. The data to be analyzed is structured and originates from various sources like Excel, CSV, SQL, etc. Ideal skills for this project include: - Proficient in AI analytics ...

More details: What type of data do you need to convert? Text data What is the desired output format for the converted text data? Excel spreadsheet Do you require any specific data manipulation or analysis within the Excel spreadsheet? Data sorting and filtering

I have an Excel sheet that contains text data and I need it to be parsed. I am looking for a Python expert who can use pandas to extract the text data and present it neatly in a new Excel sheet. Key requirements: - Extracting text data from an Excel sheet using Python pandas - Presenting the extracted text data in a new Excel sheet - Sorting and filtering the extracted text data as per business requirements Ideal Skills: - Excellent knowledge of Python, especially pandas - Proficiency in working with Excel sheets - Experience in sorting and filtering text data - Strong attention to detail and commitment to quality

...pieces that align with Verve Clothing's brand identity. 2. Trend Awareness: Stay updated with current fashion trends, especially in bottomwear, and incorporate them innovatively into designs. 3. Color Sense: Strong understanding of color theory and the ability to create visually appealing color palettes for bottomwear collections. 4. Software Proficiency: Proficient in CAD (Computer-Aided Design) software for creating technical drawings and Adobe Creative Suite (Illustrator, Photoshop) for design presentations and mock-ups. 5. Portfolio: A diverse portfolio showcasing previous bottomwear designs, demonstrating creativity, attention to detail, and understanding of trends. 6. Collaboration: Ability to collaborate effectively with the design team, patternmakers, a...

I am looking for an experienced freelance to convert my past year's Profit and Loss statement into a fully itemised budget for the upcoming year. This will encompass the following elements: Key Requirements: - Extract and organise data from a PDF P&L statement - Formulate an Excel-based budget plan for the upcoming year including Revenue, Expenditure, and Cost of Goods Sold - Base projection data on the historical records from the P&L statement - Breakdown of expenditure must be category-wise - Incorporation of a pie chart visualising the budget details Considering the urgency of this project, I require the final product within the next 12 hours. Ideal Skills: - Excellent understanding of financial document analysis - Proficiency in using ...

I need a data entry specialist to compile an Excel spreadsheet database of addresses and opening times relating to approximately 400 branches of the Citizens Advice Bureau. The data will be collected from URLs that I will provide. Ideal Skills and Experience: - Proficient in data entry and Excel - Experience with web research - Attention to detail - Ability to meet tight deadlines - Previous experience with similar projects is a plus This is an urgent project and I need it completed as soon as possible. Thank you.

...put as an example (can be another one) 2- Download the information to excel and using chatgpt for excel modify the description of each fair so that the content is original (we will give access to the plugin for excel with enough credits and chatgpt 4). 3- by means of chatgpt for excel modify the date format 4- include a no follow link to the fair in question. 5- (very important) check that Chatgpt does not make mistakes in the description or dates (this happens very often) We will not release the milestone if we see mistakes. 5- Create a dynamic calendar for wordpress that removes the old dates and leave only the content from the date of the current day. You can also use a plugin if it exists. Very important:

...in need of a skilled professional who can help me showcase live game data directly from an Excel spreadsheet on my WordPress website. Key Requirements: - Real-time data update: The data should be updated on the website as soon as changes are made in the Excel file. Ideal Skills: - Proficient in Excel: The freelancer should be well-versed in Excel in order to effectively parse and represent the data in a user-friendly manner. - WordPress Expertise: A solid understanding of WordPress is essential to ensure the data is displayed correctly on the website. - Experience with Real-time Data: Previous experience in displaying real-time data is a huge advantage. I don't have a specific plugin in mind for this task, so I'm open to suggestions. Howe...

...If you’re a top Rep with experience who takes initiative, self-motivates and make things happen this is the job for you. We have a market filled with opportunity and are happy to offer aggressive compensation - provided you bring results. tinyB chocolate specializes in Brazilian chocolate truffles called brigadeiros. We offer chocolate-making team building activities, chocolate gifts and chocolate-filled LavaCookies. Our work has earned a 5-star rating from consumers and Fortune 500 companies alike. We often hear people say that our products are some of the best they’ve ever tried. DESCRIPTION/RESPONSIBILITIES We’re expanding into an exciting new market and are looking for a self-motivated, experienced sales rep who will call on General Managers of ...

...options trading system implemented through an Excel sheet. This tool will execute real-time data trade operations, following a specific strategy. Ideal Skills and Experience: - Proficient in Python programming - Experience in Stock Market trading systems - Knowledge of Excel VBA and integrating with Python - Understanding of Custom Trading View Indicator strategy The work involves: - Engaging in the end-to-end development of the Excel system. - Coding a Python script to fetch and populate real-time trading data. - Implementing the Custom Trading View Indicator strategy in the Python script. - Testing the system to ensure the accuracy and efficiency of the trading. Please note, I don't have an existing Excel sheet for this trading sys...

I am in need of a freelancer well-acquainted with data entry for translating text data into a usable Excel spreadsheeet. Key Requirements: - Proficiency in text data entry - Experience working with a diverse range of project types - Skilled in Excel, especially formatting and data organization Your task will be to translate the original data (which could be a PDF file, printed hardcopies, handwritten notes, or a different format depending on the project) into neat, easy-to-read Excel spreadsheets. Prior experience with Excel and other similar tasks will be crucial for completing this project accurately and efficiently.

I'm in need of a professional proficient in Excel macros to assist with creating custom formulas specifically for data manipulation. The primary task would be to formulate macros that can effectively merge and separate data. Demonstrable experience in managing large datasets and solid knowledge in automated data manipulation will be essential for successful completion of the project. A background in eliminating duplications or inconsistencies would also be advantageous. I look forward to a hassle-free process and accurate results.

I am trying to fetch ebay api token. Code works in php but not in vba

I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!

...seeking a professional with extensive Excel experience who can help convert data from a spreadsheet into a more user-friendly form. Here are the key elements for this project: - Autofilling: The form should make use of specific criteria for autofilling using text. Your proficiency in creating autofill functionality is crucial. - Conditional Formatting: I require a unique approach to formatting cells containing more than one line of text. Specifically, if a cell has multiple line items, they should be combined in the same cell but placed underneath each other. - File Format: The data to be converted resides in an Excel spreadsheet, therefore your familiarity with Excel is paramount. This task requires not only technical skills in Excel but al...

...knowledge of the specific password that I used for the file at the time. I have a list of 35 passwords that I was using for various tech systems around 2009. One of which is likely to open it or as a professional you may know a different way to access the data. In addition to a Reckon Accounts 2013 Pro file of the data I can use, at minimum I need from you an Microsoft Excel or Libre Calc file of all of the data in its fields that I can work with. Ideal professionals for this task should: - Have proven experience with Quickbooks, especially old/legacy versions - Be familiar with potential issues of opening older Quickbooks files using newer versions - Be able to ensure that data integrity is maintained throughout the process To show you're up for...

I am in need of an experienced data entry specialist who can assist me with entering basic data into Excel. The data to be entered will be from handwritten notes. Ideal skills and experience for the job: - Proficient in Excel for basic data entry and formatting - Detail-oriented with high accuracy in entering data - Ability to work with handwritten notes - Good communication skills to clarify data points if needed

I'm in need of someone adept in bookkeeping, expense tracking, and financial reporting. You don't have to have experience in a specific software, but being proficient in tools like QuickBooks, Excel, and Xero would be ideal. I need the Account Assistant to handle: - Bookkeeping - Expense Tracking - Financial Reporting In your proposal, please include: - Details of your past work and experience in similar roles - A detailed project proposal outlining how you'll carry out the tasks I'm excited to hear from you, and start working together on this project.

I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!

I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!

I am in search of a seasoned data analyst who will perform a comprehensive analysis on a large Excel dataset, with more than 10,000 rows. The range of tasks to be undertaken includes: - Data Cleaning: Ensuring the data quality, eliminating any errors or redundancies. - Data Visualization: Creating intuitive charts and graphs to illustrate the data trends and patterns. - Statistical Analysis: Implementing statistical methods like Regression Analysis, Time Series Analysis, and Hypothesis Testing to interpret the data and draw conclusions. This demands a great deal of experience in Excel, data cleaning, statistical analysis, as well as in working with large datasets. A solid understanding of regression analysis, time series analysis, and hypothesis testing is strongly requir...

I'd like to request a quote for "$50 GPS Mapping for MHJ excel file attached". My budget is $30 - 250AUD.

I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!

I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!

I require an expert in Excel macros that can help me with a specific task. I have numerous .dl files from which I need certain sections of text extracted. Here's what I need: - Development of a reliable Excel macro that can accurately identify and extract the necessary data from .dl files. - The macro should be robust enough to handle any inconsistencies or errors within the .dl files. In the event of an issue, rather than stopping entirely or skipping the file, the macro should create a log file noting the inconsistency or error for later review. Ideal skills: - Experience in Excel macro development - Familiarity with .dl file structure - Attention to detail - Problem-solving skills, particularly regarding file inconsistencies or errors - A backgroun...

Hello, 1: you will create aspx webpage, and load data from mssql table to gridview with paging. 2: when user check some checkboxes, and enter value in textboxes and click on a button, it will store those values in session and save in database table. 3: when user enter some values in page 1 or anyother page and go to next page like page#2 and come back to page#1, the values he entered must...and save in database table. 3: when user enter some values in page 1 or anyother page and go to next page like page#2 and come back to page#1, the values he entered must show and not loss. Note: has the gridlayout. ischecked and grosspremium are editable checkbox and textbox I included the vb code as well in endorsements-vb The datasource contains 86 rows and attached as excel.