Workbook.worksheets vba punët
I'm in need of an advanced Excel VBA specialist with proficiency in data manipulation, particularly data filtering across multiple Excel sheets. The tasks required entail: - High-level manipulation of Excel data; - Expertise in filtering data across multiple sheets; - Strong understanding of data validation; - Experience in report generation. Experience in dealing with large amounts of data and creating user-friendly detailed reports from complex data sets will be crucial for this project. Excel VBA certification and verifiable previous projects in similar tasks are a plus.
I have a Power BI file that is insanely slow and unusable. It has some glitch that has drastically slowed it down and cannot be resoled. So I need this file to be recreated in a superfast and fully efficient Excel by using formulas and VBA codes. More details to be share with winner.
I am seeking a VBA developer to help with my Excel automation tasks and creating a set of macros. Key Requirements: Need to extract data from pdf in a way which I want - The primary task involves the automation of Excel processes. - The developer is expected to create macros that will streamline and simplify certain operations within the Excel sheets. - The primary automation requirement is extracting data from different types of PDF documents. Further Details: - The VBA developer should be able to extract data from text-based PDFs, scanned PDFs, and password-protected PDFs. - The extracted data needs to be accurately transferred to Excel. Ideal Skills: - Proficient in VBA and Excel; - Experience with data extraction from different types of PDFs; - Understanding o...
I'm in need of a comprehensive Excel workshop system that can handle all the necessary features, including open job cards, inventory templates, dashboards, bills, estimations, and work orders. Here's what I'm looking for: - **Open Job Cards:** The system should be equipped ...customization should be advanced, allowing me to set up metrics and views according to my preferences. I'm looking for a skilled Excel expert who has experience in creating similar systems, particularly in the workshop or inventory management domain. You should be proficient in creating complex formulas and functions in Excel, as well as designing user-friendly interfaces and dashboards. Experience with VBA programming would also be a huge plus. Please provide examples of previous similar ...
hello, I have a project and I'm stuck at some point, please see the specifications in the zip it's for tomorrow morning budget:20$ language:french,arabic actually no need for much because I hav...see the specifications in the zip it's for tomorrow morning budget:20$ language:french,arabic actually no need for much because I have already done rendering 1 and rendering 2 of the project, now for rendering 3, I just need to modify the block diagrams, the truth table, the state graph and the memory map (which are all done during rendering 1) according to the modifications requested by the workbook. load... We don't need coding in vhdl, just make the modifications on rendering 1 according to the instructions for rendering 3 if ever we can do a 10 minute meeting...
...goal is to streamline the workflow by automating calculations and consolidating rows based on unique identifiers. Project Objectives: Automate complex calculations to increase efficiency. Consolidate multiple rows based on specific unique identifiers. Ensure data integrity and accuracy throughout the spreadsheet. Requirements: Proven experience with advanced Excel functions, including macros and VBA. Ability to troubleshoot and optimize existing Excel formulas. Strong attention to detail and a commitment to delivering precise and reliable results. Please provide your rates, availability, and examples of similar projects you have completed. I am looking to start this project as soon as possible, and timely completion is essential. Thank you for your interest, and I look forwar...
I'm in need of a proficient developer with experience in both Excel VBA and Selenium to create a template that enables automated sending of bulk WhatsApp messages. The core functionality I'm seeking includes: - Automated WhatsApp messaging directly from Excel - Bulk messaging support: The capability to send out multiple messages at a time. The messaging content that will be automated is primarily related to the Products and Services information. The ideal candidate for this project should have a demonstrated history of working with Excel, VBA, and Selenium. Experience with similar projects relating to WhatsApp and bulk messaging automation would definitely be a plus. This will be a unique project with potential for ongoing work and tweaks depending on the initi...
I'm interested in having an Excel template developed which uses VBA to automate the sending of bulk SMS. Major points of focus in this project are: -- Compatibility: The template should be compatible with Excel 2010, 2013, and 2016. -- Phone Numbers Input: I'd like to manually enter phone numbers from which the SMS will be sent. -- Message Customization: Depending on the requirement, both the same message may need to be sent to all recipients and different messages to each recipient. The ideal freelancer for this task should be proficient in Excel, VBA, and have experience in automation. Strong communication skills would be appreciated to better understand and implement the specifics of message customization.
As a frequent user of Microsoft Excel, I'm looking for a skilled professional to design and implement a powerful goal ...of performing multiple cell goal seek operations. This means it should be able to iterate through several scenarios until a set of conditions are met. - **User Interface:** I prefer to trigger this macro through a button click within the spreadsheet. **Ideal Freelancer:** To successfully complete this project, you should have: - Proficiency in Microsoft Excel, including advanced knowledge of VBA and macros. - Previous experience with developing goal seek macros. - Strong attention to detail and a commitment to delivering a high-quality, error-free product. If you're confident in your ability to create a reliable, efficient macro for my needs, I'...
...to be able to: - Manage users: Different access levels and permissions are a must. This includes Admin, Teacher, and Data Entry. - Create and manage large question databases: - Add, edit, categorize, and manage a large database of questions. - Select questions from the question bank to create custom worksheets and exams. - Preview questions before generating worksheets. - Creation and management of question categories, tags, and metadata. - Sharing worksheets with other teachers within the system. - Generated PDF with options for formatting, layout, and inclusion of answer keys. - Handle categorization and tagging: - It should use both hierarchical categories and tags for effective question management. Ideal skills and experiences ...
I am looking for a certified Excel and VBA expert to help me refine an existing financial model. I am looking for a two-days online working engagement where the person will sit with me online and solve for things one at a time. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
I have an Excel file with a sheet that has match tables for academic club's leave. I'm on the lookout for an Excel specialist who can create tailored auto-filters for each club. Each auto-filter must be housed on separate sheets ...requirements: - Each auto-filter should gather all details in the same row, including match place, match time, and results. - Individual worksheet assigned for every club/company, ensuring a streamlined data management process. These filters will serve as a comprehensive and organized system for viewing club/company-specific data. Proficiency in Excel, particularly with auto-filter creation and workbook organization, is an essential skill for this job. Proven experience working with large datasets will be advantageous. The project is one time ...
I'm seeking an experienced Excel professional to bring order and readability to multiple Excel worksheets. Key Tasks: - Managing 2-5 Excel worksheets containing numerical data, - Cleaning and organizing data to improve clarity and accessibility, - Applying formatting to enhance worksheet readability and presentation. Skills & Experience: - Expertise in Excel formatting, and data organization, - Strong attention to detail and respect for data accuracy, - Excellent grasp of numerical data manipulation and presentation in Excel. Your experience shaping numbers into a comprehensible story through smart formatting and efficient data organization could be the critical ingredient of my project's success. Let's connect!
I need an expert to create a system where a rest hours sheet is integrated with a database within the same workbook in Microsoft Excel. Key requirements: - The integration should be made using VBA Macro or simple cell reference. - The database should store information about individuals, leaving out any date, hour or minute details. - The database requires no regular updates triggered by specific events. Ideal skills and experience: - Proficiency in Microsoft Excel - Experience in working with VBA Macros - Understanding of data management in Excel
I will be needing both a Cover & Interior for the book. This book is going to be uploaded on Amazon KDP so the files to be delivered for both the cover and interior are PDF files. I am looking for someone with experience in designing and creating both book covers and interiors for low/medium content books on Amazon KDP. i am particularly searching for s...deliver a perfect interior layout. As for the cover, i will be sharing ideas for the cover design, however, the one thing that i find most important is that the cover has to be high quality, stands out from competition, grabs attention, creative and unique, and finally, conveys the message and the theme of the book's interior perfectly. Attached below are some examples of the competition cursive workbook covers for refe...
I am looking to develop an automated Excel Workbook specialized in the area of cost reporting. Key components I need are: - Calculation Formulas: Enable the workbook to calculate various financial metrics automatically. Should include revenue, expenses, and profit calculations. - Analytical Charts: The workbook should be able to visually represent the data and calculations such as revenue, expense, and profit trend lines. - Advanced Analysis: In addition to basic calculation formulas, the workbook should be able to analyze profit margins and handle cost variance analysis. It should have the functionality to run scenario analysis based on different inputs. Ideal candidates should have strong skills and experience in advanced Excel, particularly in creating au...
I am in immediate need of a freelancer skilled in VBA & .net for the development of a yet disclosed project. The ideal candidate must be proficient in all aspects of VBA and have the ability to deliver quickly given the urgency of this project. Key Requirements Include: - An in-depth understanding of VBA - Proven track record of successful projects - Ability to work under tight deadlines Completion of the project needs to be as soon as possible. If you have extensive VBA experience and can work in a fast-paced environment, I enthusiastically encourage you to bid on this project.
...and warehousing: Proficiency in using AWS S3, Athena, Glue, and other analytical services - Data analysis and visualization: Delivering insights through efficient data analysis and visualization techniques Ideal candidates for this role should have: - Experience with MS Fabric, specifically working with Lakehouses, Warehouse, SQL Endpoint, Data Flows, and Notebook - Proficiency with SQL Server, VBA, and SAS - Previous work with AI/ML algorithms - Exceptional knowledge of AWS services, including S3, Athena, and Glue - Familiarity with GCP storage and Big Query - Competence in using Power Query for data manipulation and transformation Your skills and experiences will play a crucial role in ensuring the successful delivery of this project, so please be sure to highlight your previ...
...automatically format cell values. I will provide the existing format and the new format that I want. - It should be able to add text boxes to specific cells in the Excel file. The content of the text boxes will vary depending on the content of the respective cells. - The tool should allow me to delete specific columns based on the value in a particular cell. Ideal Skills: - Proficiency in Excel macros/VBA - Prior experience in customizing Excel files - Good communication to understand my needs and implement them accurately I have an excel sheet with production data, the file has extra data that i do not need, so i need Macros to delete certain columns, change column widths, change column names, wrap text if needed, add several text boxes that will appear on the output file if f...
Se realizará un script de python el cual permitirá automatizar un proceso de creación de libros de excel de acuerdo al flujo existente de unas macros, adicionalmente el programa debe ser capaz de ofuscar el código de vba e impedir la edición del mismo, El proyecto se realizará en google colab, de forma que pueda ser ejecutado desde cualquier dispositivo con conexión a internet y cuente con acceso al programa.
1) VBA script that creates the excel file you want, 2) Python scipt that does the whole webscraping procedure and saves the data in the excel file named "" in the "Downloads" folder.
Tengo macros vba para excel que quiero transformar a python (la macro crea copias de un archivo base a otros siguiendo una lista con nombres especificos), y este poder ejecutarlo en un servidor online, tambien requieor un offuscador que inhabilite el acceso al proyecto vba de los libros excel. xslm generados por el codigo. 01 primeramente el resultado final sera que el codigo python actue de la misma manera que la macro (per con archivos alojados en gdrive) 02 offuscador y proteccion a los archivos excel generados 03 - Implementar la ejecucion del codigo python de manera online
...produce a guide book with graphics and tables to accompany text. The material is specifically targeted towards caregivers and families of individuals with Down syndrome. The writing will already be completed in the form of a Word Doc. that will need to be put into a more visually appealing document. Key Topics: - Transition from school to adulthood - School led transition planning - Handouts/worksheets will be incorporated into the guide, with the provided information. - **See outline for guide attached** Ideal Skills: - Experience in designing educational guidebooks - Creative mindset to develop visually appealing graphics - Familiarity with design software and technologies (such as InDesign, Illustrator, Dreamweaver, Photoshop) - A keen eye for aesthetics and de...
I need an expert in Excel VBA to help automate complex, repetitive tasks within my large sets of Excel data. Key Responsibilities: - Developing a VBA script to automate repetitive tasks in Microsoft Excel - Implementing PivotTables, Macros, and other advanced functions - Ensuring the automation is efficient, reliable, and error-free Ideal skills for this project include: - Advanced knowledge of Microsoft Excel - Extensive experience in VBA scripting, particularly with automation of complex tasks - Proficiency in creating and working with PivotTables - Strong understanding of Macro creation and modification Please bid on this project if you have the necessary experience, skillset, and can ensure the automation meets the required standards of efficiency and accuracy.
I have 1 unfinished Access/VBA project. I need assistance to finish the project. The project require the developement of Access forms, VBA code and Generation of reports. My estimation is 3 working days. Max budget : 100$ Thanks for you bid
This is a one of project; I'm looking for an Excel expert to develop a workbook enabling data analysis of multiple bank and credit card statements. This workbook must have the ability to run multiple functions/reports - Implementation of SUM and COUNT functions. - Utilization of VLOOKUP or HLOOKUP. - Creation of Pivot Tables and informative Charts. The ideal candidate would be someone with prior experience in financial analysis or data engineering, who can ensure that the workbook provides the insights needed. Ability to ensure accuracy and relevancy within the formulas and functions is essential. Attached is a sample data file. This is a pdf to excel conversion. Prior to submission, the conversion data will be sanity checked and verified. If an alternative...
...various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understanding of data visualization techniques and tools will be beneficial. - Software Development: Experience in developing bespoke software within Excel would be advantageous. Please note that while the visualizations need to be created using Excel, I'm open to suggestions for automating spreadsh...
In need of a skilled Microsoft Access VBA expert to establish various functionalities on an ongoing project. This will include, but not be limited to, creating data entry forms, generating reports, and maintaining the database. Ideal Skills: • Experience in MS Access and VBA is mandatory • Familiarity with creating user-friendly interfaces • Proficiency in designing and maintaining database structures • Expertise in automation of repetitive tasks and processes • Knowledge in data analysis using Access If you have any relevant past work or specific experience in the areas mentioned, feel free to include them in your application. In-depth project proposals are also welcome and will be beneficial in the selection process. The main purpose of the pro...
My project demands the creation of a web-based software that can create QR code images from uploaded CSV files containing text data. Post scanning, these QR codes should display the text information incorporated while creating the codes. Furthermore, the software needs to house an Excel Workbook, which should be updated through manual uploads. The Workbook will be responsible for printing the necessary details derived from the CSV file. In addition, the software should also be engineered to retrieve cellular data upon scanning the QR code. Ideal Skills: - Proficiency in developing web-based software - Extensive knowledge in handling CSV files - Expertise in QR code generation and functionality - Experience in managing Excel Workbooks - Able to incorporate manual ...
I am looking for an Excel VBA script coder to assist me with a project for generating tags for e-commerce products from the description. Products are car spare parts. Need to tag the products with names of make, model, variant. Specific requirements: - - Generate tags for e-commerce products in a excel sheet. The product description is saved in Column A and the tags should be generated by referring to the list of available tags. Please see the excel sheet attached here. _ One product can have multiple tags associated with it from the tags list, The VBA script should run and generate tags while referring to the data in other sheets for tag names. Please see the excel sheet attached. Ideal skills and experience: - Proficiency in Excel VBA script coding - Strong unders...
...homeowners, expats, investors) are applicable to each style and size. - **Subsequent Sheets (Sub-Bundles Details)**: Each subsequent sheet will focus on a specific package, listing all items that make up the sub-bundles for that particular package. Include columns for item descriptions, dimensions, materials, and any other relevant specifications. ### Deliverables - **Excel Workbook**: The final product will be an Excel workbook that includes: - A summary sheet with an overview of all packages by style, property size, and client type. - Detailed sheets for each specific package, showing the breakdown of sub-bundles and individual items. - **Documentation**: A brief document explaining the organization of the sheets and any assumptions or rules used in the data com...
Develop VBA code to meet your requirements
I have a highly encrypted XLSM file that I urgently need help with. This specific project involves making VBA in the file visible. I need someone with advanced VBA skills and experience in cracking down highly encrypted XLSM files. Key requirements: - Expertise in VBA for Excel - Experience with highly encrypted XLSM files - Ability to make VBA visible in such files Please only apply if you have previous experience in this area and can start immediately. BID NOW!!! Serious freelancers only with the skills since it is ASAP!!
I am in need of a professional who has experience using VBA in MS Project to automate the process of generating project summary reports. So the person MUST have Ms Project experience to understand how project constructs data. Key tasks include: 1. Utilizing VBA to automate the generation of project summary reports. 2. These reports must provide a list of all tasks and their current status 3. in particular how to create a table of all tasks related to a Milestone - similar to Task path function for predecessors. The ideal freelancer for this project should possess strong skills in VBA and Microsoft Project. They should have a proven track record in automating and streamlining reporting processes. Previous experience in project management reporting is ESSENTIAL. I&...
I'm in need of an Excel VBA expert who can assist me with writing macros and automating data entry in my spreadsheets. The primary goal of these macros is to automate the data entry process and streamline the subsequent data analysis tasks. Key project requirements: - Building custom macros: I need help with building macros that can automate data entry tasks and facilitate data analysis. - Data analysis focus: The macros should be designed to support data analysis, particularly with a focus on data visualization. - Expertise in Excel VBA: Proficient in Excel VBA is a must, with a proven track record of designing and implementing complex, data-focused macros. - Understanding of data analysis: A strong understanding of data analysis is crucial to ensure the macros ...
...In addition to the video and PowerPoint content, I also need well-structured and visually appealing handouts that summarize key points for students to refer to. - Physical Workbook: - This is crucial, as the preferred format for the curriculum is a physical workbook. The workbook should be designed to be beginner-friendly, supporting those with no prior knowledge in the medical field. Your role would be to: - Design the curriculum outline for each of the four areas, ensuring a logical progression of topics. - Produce high-quality videos, presentations, and handouts that cater to beginners. - Create a physical workbook that ties all the material together, making it easy for students to follow and learn from. Ideal candidates for this project should have: ...
Ju lutemi Regjistrohuni ose Identifikohuni për të parë të dhënat.
I'm looking for a freelancer who can create a simple, yet effective, VBA macro to combine a set of between 10 to 50 small CSV files. These files all share the same column headers, and the macro should merge the data in these CSVs while maintaining the column sequence as provided. This task is straightforward and should not take much time for an experienced freelancer. A successful completion of this task will certainly result in a 10-star rating from me. See the uploaded document that details what needs to be done. I will provide the coder that I choose with several sample small csv files to combine.
I'm looking for a proficient Excel expert to help me set up and automate an inventory in Excel software. Key requirements: - I need to track between 100-500 different types of items. - The inventory should be able to update and transfer data to different worksheets automatically. - I'm also interested in adding automatic calculations, like the total value of the stock. Ideal Skills: - Proficiency in Excel and experience in setting up complex inventories. - Automation skills in Excel to ensure smooth and efficient data updates. - A good understanding of inventory management principles to ensure the system is effective and user-friendly. Please reach out if you have the right skills and are interested in tackling this project.
I'm in need of a custom Excel workbook that can handle RFQ (Request for Quotation) analysis and purchasing. The ideal candidate will be able to create this tool for me from scratch. Key Features: - Data Import/Export Functionality: The workbook should accommodate easy import and export of data from Excel spreadsheets. - Automated Data Analysis: The tool should be designed to perform automated analysis of data imported. This will involve calculation of vendor prices, comparison and evaluation. - Generation of Reports: The tool should be able to automatically generate reports or dashboards based on the imported data. Ideal Skills: - Proficient in Excel: Advanced knowledge of Excel functionalities and VBA is a must. - Experience in RFQ Analysis: A background in R...
...browser based interactive worksheet maker. The site is made in PHP. Works Include: 1. User can upload a PDF/JPG/Docx file in the browser and after that can create different types of questions like true false, multiple choice, text box free text, radio, tick, drag the shape etc, embed audio, video, links, images, write any text with different font colors and sizes, styles. 2. After submitting the worksheets, the replies by students are autoscored based on the number set by worksheet maker. Students can also see correct answer. I need full source code, co pyr i g ht and installation in my shared linux server. See my built site and reference site Code should be well commented and clean. I need regular updates. Lowest Bidder will Win.
I am in need of an expert data professional to handle distinct tasks pertaining to Excel spreadsheets. Here is a rundown of what you'll be required to do: - Upload numerous Excel files - Expertise in Excel VBA, Macros and VB Capabilities - Analyze data professionally, using descriptive statistics The ideal candidate for the project would be well-versed in using Excel to analyze data and create descriptive statistics. Familiarity with data cleaning and visualization techniques would be a bonus. I look forward to your submissions.
I need an Excel macro to move records between two sheets in the same workbook. Here's the challenging part: records should be relocated based upon logical condition within a certain range of values in designated columns. Time isn't a constraint but proficiency in scripting Excel macros and strong grasp of logical functions is mandatory. Clean and efficient code is valuable. Understanding of data management in Excel is also desirable. Patience needed to iterate and perfect the code. Please apply if you meet these criteria.
I am looking for an expert in Microsoft Excel to develop a tool to track changes between two Excel sheets. Key requirements include: - The ability t...develop a tool to track changes between two Excel sheets. Key requirements include: - The ability to identify and track both text and numeric data changes between two sheets. - The tool should not only monitor existing data, but also be built to manage changes related to data newly added in future. - Changes identified need to be grouped and clearly displayed in a separate tab within the same workbook for ease of review. Skills and Experience: - Proficient in Microsoft Excel - Background in data analysis - Experience in creating custom Excel tools - Strong attention to detail in order to identify both major and minor change...
Ju lutemi Regjistrohuni ose Identifikohuni për të parë të dhënat.
I have an excel SS that I need some quick formula help with. No VBA please. Table with expenses, then another table dividing up. I need the expense categories divided over months as per quantaty of time it is used. Explained in the SS attached. I need this done ASAP. Your responsibilities: - Understand the project financials and structure the Excel to match - Create a Gantt style tallies that captures my project expenses effectively Skills and Experience: - Solid expertise in advanced Excel functions - Experience in financial tracking, preferably in project management - Ability to work fast and deliver quickly Note: I didn't specify the expense categories so it should be customizable to accommodate any kind of expense. However, quick delivery is of utmost priority.
I am in need of an Excel Macro skilled professional, who can automate my manual work of generating operational data reports. My preferred output format for these reports is Excel spreadsheets. Key Responsibilities: - Design and create a macro in Excel for automatic rep...automate my manual work of generating operational data reports. My preferred output format for these reports is Excel spreadsheets. Key Responsibilities: - Design and create a macro in Excel for automatic report generation using operational data - Ensure the macro is accurate and efficient, cutting down the time spent on report creation Ideal Skills: - Excellent understanding of Excel Macros and VBA - Experience in creating automated report generation systems - Familiarity with handling operational data is p...
I am seeking a VBA expert with extensive experience in Excel for the creation of a custom macro. The specific task will involve designing a macro that can efficiently audit the financial records of a Trust. The audit should be conducted at a yearly level, ensuring accuracy and comprehensiveness in the review. Key tasks for the project include: - Building an automated audit tool: The macro should be capable of assessing financial records of the Trust with minimal manual intervention. - Ensuring high level of detail: The work is format based. Proper posting of the records should be done repeatedly year on year - Application in Excel: The macro should be fully functional in Excel, allowing for easy integration into the Trust's existing data management processes. Ideal skills an...
...less than 10 excel spreadsheets that I use for various purposes. I'm looking for a talented professional who can re-work these sheets eliminating redundancy. Key objectives: - The primary goal of this rework is to automate repetitive tasks. I'm looking for someone who can introduce VBA scripts and macros to help me achieve this. - The spreadsheets are both independent and share common data. It will be important to create a system that can handle both types of sheets. Ideal skills: - Proficiency in Excel, VBA, and Macro programming is a must - Experience with data manipulation and automation - Ability to understand and work with a mix of independent and shared data I'm open to discussing the project requirements in more detail. Please let me know if you&#...
