Excel Macro VBAdela
I'm looking for an expert with a keen attention to det...representing the date and time, and the second representing a series of numbers. Once this data is extracted, it will need to be organized into an Excel spreadsheet and promptly emailed to me following each extraction. Skills and Experience: - Proficiency in data collection and entry - Familiarity with Excel spreadsheets - Exceptional attention to detail - Ability to work without supervision - Punctuality to ensure data sets are sent promptly after extraction. The success of this project relies greatly on accuracy, timeliness, and observance of instructions. Hence, the ideal freelancer should have great attention to detail and proficiency in Excel. Timely delivery is also paramount. As such, punctuality...
Project Title: Customizable Excel-Based Mark Book System for English Learning Area Tracking This reads like a lot, but I am only trying to be clear. It's just a mark book. Project Overview I need a skilled Excel developer to create a solution that helps schools track student progress against specific English Achievement Standards across year levels of the Australian Curriculum. The goal is to pinpoint areas needing improvement, empowering schools to target resources effectively. Is it Speaking and Listening, Reading and Viewing, or Writing and Creating? If so what particular Aspect (sentence? Key Requirements Foundation: Excel workbooks to accommodate multiple teachers and classes. Structure: Year Levels (tabbed sheets) with each year's Achievement...
Buscamos experto/a en planillas (excel) y docs en Drive, nube, etc., para varios trabajos de: - Arreglo de planillas a paquete de documentos actual. - Personalización de paquete de documentos a entregar a clientes (estandar, a todos se les entrega el mismo paquete) - Creación de un panel o sitio web con google sites, para montar (replicar) los documentos y hacer más lúdico su uso. Nota importante: no se requiere crear planillas desde cero, sino solo mejorar/actualizar las existentes. Informar: - Horas aprox., disponibles por semana (inicialmente, 3 a 6 horas por semana) - Valor hora (necesitamos fijar un valor hora para el pedido de arreglos de docs, entregas de la nube con el paquete de documentos, etc.) y otras actividades indirectas que puedan resu...
Seeking a Python wizard to generate line and scatter plots from simple numerical data housed in Excel files. Your expertise in Python and experience with data visualization is key to succeeding in this role. Please, in your application: - Highlight your experience in Python plotting - Specify similar projects you've completed Going above and beyond to deliver an error-free, clean and professional visualization will be appreciated. Trust me, I value quality. Let's get started!
...I need your expertise in developing VBA scripts and macros in Excel to help me automate several repetitive tasks. I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file. This tool will allow us to transform a specific Input file into another Output file. • Input: catalog_product_option-YYYY-MM-DD • Output: The 2 files are attached, with a color mapping to recognize the columns in scope. In summary, we need to be capable to issue an export file in a specific format (see attached picture “”): • Specific Orders of the column (Green) • Suppress the duplicated values for some line items, on 3 fields. The m...
I'm in need of a proficient Excel specialist who can help create a solution for selecting rows to display in Excel with a total at the bottom. Requirements: - Proficiency in Excel and experience with creating VBA or macros - Ability to display both numerical and text data - Ensure compatibility with Windows Operating System Please note, this task calls for a clean, simple solution. Your proposal should detail your previous work with similar Excel functions.
I'm in need of a data handling professional. Gig is $36 Max. I have a large excel file that houses data from multiple sources but the columns are misaligned. I want it to be organized to Name, email, city, state, phone number, additional info columns. Your task will be to: - Correctly align the columns - Merge any duplicate records Ideal freelancer would have: - A strong background in Excel - Experience in data cleaning - Proven track record of handling large datasets - A keen eye for detail to spot and fix misalignments
Looking for an experienced Excel professional who can help debug my university project. I'm currently grappling with project-related issues and need rapid assistance. Expectations include: - Rectifying the project - Delicate understanding of Excel debugging - Fast turnaround time - as soon as possible Ideal candidate should have prior experience with Excel debugging, problem-solving ability, and methodology to correct projects. Knowledge about appropriate data structures will be appreciated. Being a student's project, confidentiality will be highly appreciated.
I'm looking for a skilled Python developer to combine around 1000 XLSX files into a single one. I need this new file to contain all the data from the original files. The Excel files have a structure where each file contains data for a different entity. The end goal is to have all this data centralized into a single document for easier management and analysis. The successful freelancer for this project should have: - Proficiency in Python, particularly in working with Excel files. - Experience in data manipulation and consolidation. - Strong attention to detail to ensure that all data is accurately captured and combined without loss. Please provide examples of your previous work in Python, particularly relating to data consolidation if possible. This will help me asse...
I have a Word document that requires a few tasks to make it more professional and accessible. - **Photo Conversion**: The photos within the document need to be converted into both tab...an intermediate level of detail. This means that the translation should accurately capture the content and tone of the original document. - **Formatting**: The document should be formatted in a standard business format. This means that the layout, fonts, and styles should be consistent and professional throughout the document. I am looking for a freelancer who has: - Proficiency in Word and Excel - Translation experience, preferable with a business background - Strong attention to detail - Excellent communication skills Please provide a quote and an estimated time for completing this project. ...
I'm in need of an efficient, digital solution to streamline our insurance quoting processes as our current method is manual. Key Features: - Quote Comparison: An element that allows for easy comparison of different quotes for the customer's selected coverage. Access: I am open to ideas for the program's accessibility. It could be a web-based platform, a desktop application, or even an Excel program. The primary goal is to transition from manual quoting to a more efficient, digital process. Ideal Freelancer: - Experience: A strong background in insurance software development and a proven track record in creating similar programs. - Innovative: Capable of suggesting and implementing creative solutions for an optimal quoting experience. - Detail-Oriented: Attentive ...
Hi Milan S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I need a data entry operator proficient with spreadsheet data entry. The work involves keying in data from scanned PDF documents into a spreadsheet. Key Requirements: - Proficiency in spreadsheet data entry - Comfortable working with PDF documents Ideal Skills: - Experience in data entry - Proficiency in spreadsheet software, particularly Excel The scanned documents will be provided to you in PDF format. I will provide clear guidelines on formatting and data entry requirements. The accuracy and efficiency in data entry is crucial for this job.
...should be a dedicated section for setting and monitoring financial goals, which can help in achieving short and long-term financial aspirations. Colorful Design: The design must be visually appealing and colorful, utilizing a palette that is both engaging and suitable for easy viewing and differentiation of categories. **Deliverables:** A fully functional digital template in editable format (e.g., Excel, Google Sheets). A user guide or instructions on how to use and customize the template. Initial design mockups followed by final design files. **Preferences:** Experience in creating financial templates or tools. Strong portfolio featuring clean, modern designs, especially those that effectively use color. Understanding of user interface design for ease of use in digital format...
A partir del listado de empresas adjunto, necesito encontrarlas en el buscador de empresas Empresite () e incorporar a una tabla el propio enlace de Empresite y los datos que ofrece de (1) tipo de actividad, (2) rango de volumen de facturacion, (3) numero de empleados, y (4) pagina web.
Need an Excel VBA expert to do automate a workflow of flagging the date of the first non-zero value in a row. I'm looking for a freelancer with the following skills: - Proficient in VBA programming. - Previous experience in developing Excel automation scripts. - Able to deliver the project as soon as possible.
I need an Excel macro developed for my employee training tracking workbook. I want to have a feature that sends email notifications to both the new hire and their manager based on the completion date of each training module. Key Requirements: - Email Trigger: The macro should send emails based on the completion date of each training module, not just the hire date. - Email Recipients: The email notifications should be sent to both the new hire and their manager. - Email Content: The email should include the name and email of the new hire, along with a list of overdue training modules. Ideal Skills and Experience: - Proficient in VBA and Excel: You should have a strong background in developing macros and automating processes within Excel. - Famili...
I need a skilled data analyst to work on a large dataset in Excel. Key Responsibilities: - Sorting and filtering data: The dataset contains over 10,000 rows, so the analyst must be adept at handling large data sets. - Creating pivot tables: Organizing data is a key step in our data cleaning process. - Performing Statistical Analysis: Appropriate statistical analysis will be crucial for accurate data cleaning and preparation. Ideal Skillset: - Proficiency in Excel: The freelancer must have extensive experience working with advanced Excel features and handling large datasets. - Data Analysis Skills: The individual should be well-versed in data analysis techniques, including statistical analysis and data preparation. - Attention to Detail: As the primary goal is data c...
I'm in urgent need of a skilled Excel expert to unmerge text cells in my spreadsheet. Here's what I need: - Unmerge text cells - Format the data as requested - Complete the task ASAP The ideal freelancer for this job should have: - Proven experience in Excel - Strong attention to detail - Ability to work quickly and efficiently Please submit your proposal if you can get this done right away.
I am in need of an Excel form that will track data and facilitate scheduling. This will primarily be used by our administrative staff, so ease of use and clarity are paramount. Key Requirements: - The form will need to provide a user-friendly interface for entering data. This should be intuitive and easy for administrative staff to use without any advanced knowledge of Excel. - The form should also be capable of performing calculations based on the data input. These calculations are central to the purpose of the sheet, so they must be accurate and reliable. - Data should be stored across multiple tabs for organizational purposes. This will help ensure that the data remains clear and easy to access as the form is used over time. Ideal Skills: - Strong Excel proficienc...
...document to be converted into an Excel table. The layout is moderately complex. Here are some additional details: - **Task**: The primary purpose of this conversion is data entry. As such, the Excel table must be an accurate representation of the information in the PDF. - **Layout**: The PDF contains multiple columns of text which need to be correctly mapped to the appropriate cells in the Excel spreadsheet. - **Verification**: After the conversion, manual review and correction are required to ensure that the data has been accurately transcribed. Ideal skills and competencies for this project include: - **Strong attention to detail**: Given the manual verification needed, an eye for detail is crucial. - **Excel proficiency**: A good understanding of Exc...
Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 2 Hours not more then this, i had the excel to work on just make this on new sheet
I'm in need of an expert who can assist with entering text data into an Excel spreadsheet. Key Responsibilities: - The primary task is to accurately input text data into the designated cells of an Excel file. Ideal Skills and Experience: - Proficiency in Excel, especially in handling text data. - Attention to detail and accuracy in data entry. - Previous experience in similar projects will be an added advantage. Looking forward to your bids. My typing speed is 55wpm
I am seeking a proficient CBP Entry Data Specialist for a part-time position of approximately 10-20 hours per week. The suitable candidate should efficiently perform tasks including: - Accurate Data Entry - Rigorous Record Keeping - Document Verification The role will require expertise in using tools such as Microsoft Excel and specialized Data Entry Software for smoother execution. Prior familiarity with the Customs and Border Protection database will be a significant advantage, although it's not a mandatory requirement. Excellent attention to detail, accuracy, and organizational skills would make you an ideal candidate for this role.
I'm looking for a meticulous freelancer to help with entering text data into an Excel sheet. My project entails copying texts verbatim from multiple online sources, there's no need for any sort of editing. Here's what you should bring to the project: - Proven experience in data entry - Proficiency in Excel - Ability to handle large volumes of text data - Strong attention to detail to ensure accuracy - Ability to work independently and adhere to deadlines Prior experience with copying data from online sources will be a major plus. Let's put your data entry skills to work in this project!
...enrichment is to gather specific information that will be crucial for our lead generation efforts. Requirements: - I need accurate and up-to-date information for each number. This includes the individual's name, location, email, and social media profiles. The accuracy of this information is crucial to the success of our lead generation campaign. - You will be provided with the phone numbers in an Excel or CSV file, and I would like the enriched data to be returned in the same format. Ideal Freelancer: - Experience with bulk enrichment of phone numbers, especially in the Indian market, is essential. - Proficient in using tools like Truecaller or any other app that can provide the required information. - A good understanding of lead generation and the importance of accura...
I need a proficient VBA professional who can help develop an Excel recruitment tracker dashboard. Key components should include: - Display recruitment data in visually engaging formats including bar charts, pie charts and tables. - Incorporate dropdowns using macros form control for flexible data querying. - Capture essential data points such as candidate name, the position applied for and the application status. - Provide tracking capabilities for application status reflecting stages like pending, shortlisted, and interview scheduled. -Should have recruitment metrics like Time to hire, recruitment funnel and other key metrics The ideal candidate should have robust skills in VBA and Excel, particularly in creating dynamic and interactive dashboards. Experie...
...record in creating, managing or implementing cloud-based robo calling systems and also conversational AI calls that is good with asian language, especially Bahasa Indonesia. the subject of the research must have : telephony (SIP/VOIP) a working AI model or open to integrations with AI Basic Telco Services features such as, Campaign Calls, scheduler, call recorder) Wide system integration capability Macro/logic/script editing(for robo caller,pre recorder or AI generated TTS) white label ready or not. KPI analysis The Goal of this research is to figure which or what is the best system/platform/Integration to use that gives the right combination so it result in cost effective, work effiency, best call per minute or per second tariff etc etc, feel free to do your own custom setup...
In need of a meticulous freelancer to undertake a copy-pasting project. Your primary task will be to copy-paste text content into an Excel spreadsheet. Key Responsibilities: - Accurately copy text content. - Efficiently paste the content into a structured Excel database. Ideal Skills: - Proficiency in working with Excel. - Strong attention to detail for error-free work. - Ability to maintain structured and organized data. - Prior experience with copy-pasting tasks a plus. Your effort will be critical in maintaining an accurate and reliable database. I am looking forward to seeing your applications and working with you on this project.
I'm in need of someone to assist me with typing text data into an Excel sheet. The data will be provided in a digital format (PDF, Word, etc.). Key requirements: - Accurate and fast typing skills - Proficiency in Excel for proper data entry - Familiarity with using specific fonts and sizes for consistent formatting - Experience with data sorting and filtering in Excel Your attention to detail and ability to follow formatting guidelines is crucial. The ideal candidate will be organized, efficient, and able to deliver high-quality work within the agreed timeframe.
I'm seeking a highly skilled Excel expert to develop a versatile, either fully or semi automatic, Excel formula or action algorithm that can handle specific data manipulation tasks. This Excel tool must be able to automatically select data from a certain type of table. Hence flexibility is essential. Likewise, it should be able to arrange this selected data against particular types of rows. The formula should be customizable to adapt to various row types. The main aim is to create a solution which allows for selection and rearrangement of data based on multiple potential criteria, whether by column header, row label, or specific values even though I have not specified them at this point. Therefore, excellent comprehension of Excel data manipulation,...
I need an expert in web scraping, specifically in Python, to extract text data from a particular website. The scraping is a one-time task, not requiring routine updates, and the extracted data needs to be saved in an Excel file (or CSV). This will be hidden behind a login wall - so I suggest that the Python script will go to the website and then wait one minute, where I will manually log in. Ideal Skills and Experiences: - Proficiency in Python for web scraping - Experience with scraping text specifically - Ability to deliver the required output in a CSV format
...geological tools. Key deliverables: - Icons representing various geological tools, specifically: - Wind Rose Diagram - Bore Log - Water Strike - Groundwater Level - Lithology - Field Data Collection - Data Import - Data Export - Data Exchange - Modifications of existing logos to icons to use to indicate integration within the App. Excel (for an Excel export) GWSDat ProUCL AGS Ideal Skills and Experience: - Proficiency in Material Design and minimalistic design styles. - Demonstrable experience in iconography and digital design. - Familiarity with geological graphics would be
As a business owner, I'm constantly confronted with the tedious tasks of data entry, data formatting, sorting, and filtering. I am looking to automate this process to save time and improve efficiency. Key Features Needed: -A VBA Macro for Excel to automate data entry and formatting of a text (.txt) file. -Automation of data sorting and filtering needs to be incorporated. Ideal Skills & Experience: -Strong proficiency in VBA and Excel. -Experience in automating data entry, sorting, and filtering via Macros. -Real-world experience dealing with text files in Excel. With your help, I envision a tool that ultimately makes my life easier and my workload manageable.
I NEED THIS ANALYSIS TO BE MADE IN MAXIMUM 4 HOURS. IT NEEDS TO FOLLOW THE SAME ( OR VERY SIMILAR) STYLE OF THE LINK BELOW... : - Generate a report based on selected financial ratios; specifically, liquidity, profitability, and solvency ratios. - Assess and include the following liquidity ratios in the report: current ratio, quick ratio, and cash ratio. - Evaluate and incorporate these profitability ratios: gross profit margin, net profit margin and return on assets. Ideal candidate: - A proficient user of Excel. - Strong mathematical and analytical reasoning abilities. - A deep understanding of financial statements and financial ratios. - Ability to deliver under a tight schedule. Looking forward to your prompt bids. Thanks!
...appears that the model() function within is not being triggered. Expected Outcome: The successful candidate will diagnose the problem, ensure that CSV imports result in new contacts being added as expected, and address any issues related to the modifications made to the original extension. Technical Skills Required: Expertise in Laravel and Laravel Nova. Experience with the Maatwebsite Excel package. Familiarity with debugging and troubleshooting Laravel applications. Ability to work with modified third-party extensions. Collaboration Tools: Screen Sharing: Due to a private GitHub repository containing sensitive information, we prefer to work through screen sharing for code review and collaboration. We are open to using Teamviewer, Discord screen share, or similar tools where ...
I need an efficient and detail-oriented freelancer to populate a database with information about my customers. The project involves collecting, inserting and cleaning the following data of around 12,000 rows of ...management tasks would be analyze, identify and delete duplicates, and the main data to be collected would be only: - Customer Name - Email Address These data points will be provided, and your task is to efficiently and accurately compile this information into our database. Experience in data entry, database management, and customer service will be beneficial to complete this project. Knowledge of Excel and other data management tools is essential. The freelancer must be meticulous and trustworthy as they will be handling sensitive customer information. Thank you. Kin...
Creating a fillable PDF form with specific functionalities drop-down boxes, auto printing, auto-saving to a server, and inserting pictures if possible The data is in Excel format, ready to go.
I'm in need of a freelancer who is skilled in designing both process and workflow flowcharts via Microsoft Visio, as well as project management checklist forms in Excel. The checklist should be of an intermediate level complexity, incorporating features such as drop-downs and validation. Prior experience in constructing Visio flowcharts and Excel forms is imperative to understand the project's need thoroughly. Proficiency in Excel functionalities would make tackling this task comparatively easier.
You will be given 5 articles, submit each of the articles to 10 High DA (60+) websites. You create accounts on 50 High DA (60+) Websites with our email address (hello@MandarinNu com) We will own these accounts, log in and modify articals in the future. If you need assistance in the regi...own these accounts, log in and modify articals in the future. If you need assistance in the registration process, like to get verify code in the account registration email, we will be here to help. We agree to be using the following tool to verify DA score, links from low DA websites will not be counted. 【Hand-In】 You need to submit me an excel file specifying 50 links of the articles that we can check, with account/password of those websites.
I need an auditor or an Excel expert to help me with my tax report. The report contains 3600 transactions that need to be accurately calculated. Ideal Skills and Experience: - Proficient with Excel and complex calculations - Understanding of tax reporting - Attention to detail and accuracy
...the application backend. - Roles: Three distinct user-level roles need to be created, each with specific permissions and access rights. These roles will include capabilities such as creating new logins, granting access permissions, and other administrative functions. Technical Specifications: - The project requires a freelancer with experience in PDF generation/manipulation, data extraction from Excel files, and implementing role-based access control systems. - Knowledge in web development languages/frameworks (specify if you have a preferred stack), experience with script fonts in PDFs, and a solid understanding of backend development for user management is essential. Deliverables: 1. A fully functional Instructor section as per the described specifications. 2. An integrated r...
I am in need of a simple Excel sheet for my pastry shop. It will be used for workers to log and track their daily production. Specific Information & Organization: - The table should be organized around daily production. - The information to be included in the table should encompass: - Flavors (10-15 in total) - Locations - Amount produced in each batch - Day of production At the end of production, employees press submit button and the data is transferred into Google Sheets with saved information while the form gets cleared and ready for next submission. Ideal Skills: - Proficiency in Excel; ability to create user-friendly and easy-to-understand tables - Experience in creating similar tracking or production sheets a plus - Understanding of basic bakery or food ...
Prosimo, vpišite se ali se prijavite za več podrobnosti.
This task requires a dedicated portal using Flexbox and CSS....dedicated set of elements on a dedicated new subdomain, which will only contain these products in a nice Flexbox CSS design. Key aspects of the job: - Design based on the current design. - Products listing: Upload and import products from an Excel sheet - Each product should have a sub-page where details of the product are mentioned and listed - Approx 10 types of attributes are to be handled centrally for the products and filtering should also be possible Specific requirements: - The imported data from the Excel sheet should be updated on the portal - existing products to be updated - The products are listed as Flexbox Other requirements: - Work based on a full price offer, invoice to EU company is needed
...look and feel. However, design must not be so fancy that its difficult to navigate the site 4. Move the introductory site, text, etc., to eZBrandz. ae (copy text and photos (if applicable)). There is no automated way. It will give you a login, but there is only one good way to do this other than copying the text and things from that webpage. This site will provide the text. 5. Use one Excel sheet supplied to populate the product pages so that we can understand how the functionality will work. 6. We have yet to connect today on social media to the ezbrandz. We need you to connect the online store to the social media platforms. Register, Setup and connect to the various stores on the following platforms: a. Facebook b. Instagram c. Whatsapp d. TikTok e. Google ( and if possible, ...
The project comprises 6 regression models (linear, logistic, and moderation) based on a set of dependent and independent variables. I need someone with good knowledge of statistics to operate a dataset, make log transformations in the data, and give me the regression analysis results in an Excel spreadsheet.
Wir stellen in unserem Unternehmen unsere Dokumente um. Hierzu sollten die Dokumente, die im spezifischen Apple-Format erstellt sind wieder in die Microsoft-Formate umgewandelt werden: Pages -> Word Numbers -> Excel Keynote -> PowerPoint. Es sind gut 100 Dokumente, die umgewandelt werden müssen. Dabei sollen die Dokumente in den Microsoft-Formaten nachbearbeitet werden: - SIlbentrennung aktivieren - Seitenumbrüche prüfen und ggf. korrigieren. Die/ der Freelancer:in muss die detusche Sprache beherrschen.
