Vba macro show datapráce
Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl
...vytvořená na míru našim potřebám, a úpravy jejích stávajících funkcí, - práci na vývoji nových funkcí (např. s cílem usnadnění administrativní práce v nadaci a tím dosažení významných finančních úspor). Hledaný programátor by měl mít: - perfektní znalost MS Access (tabulky, dotazy, formuláře, reporty), - znalost MySQL, - znalost základů relačních databází, - perfektní znalost programování ve VBA (Visual Basic for Application). Nabízíme: - Možnost komunikace s autorem databáze. - K dispozici bude dok...
This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.
...institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements without disrupting existing functionalities. Key Features to Include: Advanced User Management: Implement a secure login system with multi-tier user roles and permissions. Dynamic Data Handling: Design the system to manage large volu...
As an entrepreneur in the bo...be well-structured and contain all the necessary elements, including but not limited to executive summary, company description, market analysis, organization & management setup, product line, marketing & sales, and financial projections. Ideal Skills & Experience: - Proven track record in business plan writing - Knowledge or direct experience in boutique/retail industry - Understanding of both macro and micro market dynamics - Experience in structuring financial projections for businesses This business plan stands as the blueprint for our business operations and the document will likely be used to engage with future potential partners and stakeholders. The right candidate for this job will be able to articulate our vision and strategy cl...
...with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and manipulate pivot tables. ...
EN Project with the intention of reducing the time for creating cutting files and eliminating errors in saving. Aplication Area: Engineering and manufacturing Automation of saving cutting files and manipulation of drawings, 1 - Save cutting files, considering the file type and correct naming. There is a file with several layers categorized in a standard way, these layers should be separated and saved in different files with specific names according to the layer. 2 - Save steel cutting files and possibly make changes/cuts (e.g., Slide). PT Projeto com intenção reduzir tempo de criação de arquivos de corte e eliminar erros no salvamento. Area: Engenharia e manufatura Automatização de salvamento de arquivos de corte e manipulaçã...
I’m needing the attached trade show exhibit branding updated from my previous brand POKERRITO to my new brand STICKBUG. See attached original PDF and another with my noted changes. When completed I need an updated pdf please.
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
...Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office s...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfac...
I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...
Do you know the SMIIRL Desktop counter? These "mechanic" counters are mostly used to display number of likes on Facebook, Instagram or TikTok. However they can be purchased in a "custom edition" where you should be able to monitor a lot of things like how many orders is in line in your online store. I need something so I can get a SMIIRL counter to display number of reviews my online store has on Trustpilot Im in contact with support at who are very helpfull. There are more options available with something called Zapier and JSON
Hi Sir, I can create the macro as per instruction shared . Thanks Arun
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
...you give me the code. So branch one will have different tabs frequency than the other branch. The UI should reflect that. 3. Maybe it would be easier if it records the exact keystrokes I make and then plays them back(no Mouse) a. So I can just do my routine over and over and then a macro records that specific pattern and plays it back by pressing an assigned hotkey. I am open to creative ideas on how to do this differently then I have described below. Key Requirements: This is basically like a macro, or autohotkey, (if you do a gui then I can determine the winner as soon as whoever finishes first with working code, wins. The gui for the python code is up to you but maybe it could work well if I can have section one establish focus on right scrolling panel and igno...
I'm looking for a creative and experienced screenwriter to help me with my draft a satirical TV show script. Key Requirements: - The script should focus on satirical comedy - The primary setting for the screenplay is modern day - The target audience for this project is 30-40 young parents Ideal Skills and Experience: - Prior experience in writing satirical comedy is a plus - Experience in writing for TV, online or audio content - Ability to tailor comedy for a specific target audience - Understanding of modern day culture and trends - Excellent creative writing skills Your deliverable would be a well-crafted, engaging and funny script that resonates with the target audience. If you have a knack for satire and a passion for comedy, I'd love to hear from you.
I'm looking for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work wit...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
2 excel files with VBA macro as per customer requirement
One excel file with macro as per the customer requirement
I am urgently seeking a proficient macro developer to create a small, efficient macro capable of identifying and removing rows based on specific phrases present in multiple columns. Key Project Requirements: - The developed macro must target multiple columns in the sheet. - Deleted row criteria: rows with specific text present. - Must complete as soon as possible. Ideal Freelancer Skills and Experience: - Experience in macro development, particularly macros for Excel or similar programs. - Strong attention to detail and a proven ability to interpret and implement specific criteria. - An ability to work quickly and efficiently to deliver the project as soon as possible. Feel free to ask any questions that will assist you in accurately pricing your bid. I a...
As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to deliveri...
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace inc...list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle daily data updates would be ideal. If you have experience with similar projects, p...
The purpose of this project is to create a detailed, technical drawing using SolidWorks 2022. The emphasis of the project is documentation of plastic parts, both on a macro and micro-level. Key Requirements: - Able to generate technical drawings that include overall dimensions, shapes, specific features, and tolerances of plastic parts. - SolidWorks 2022 ONLY!! - Extensive experience and understanding in documentation of manufacturing processes and components - Expertise in rendering intricate details of plastic parts - Must be able to abide by all requirements for precision-driven, technical documentation - Detailed and clear communication The ideal candidate will have a background in mechanical engineering or a related field, as well as experience in creating detailed, techni...
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.
I need to edit a less than 15-20 minutes comedy show with a strict deadline of 24 hours for 1k INR. Do a minute sample and do your entry. Reference: Raw footage: Key Requirements: - Trimming and rearranging clips - Enhancing audio quality - Bit Animation Final out should convey fun well. There’s two camera angles try and switch it up, Keep background music and lower it slightly, get close ups of facial expressions when something really happening, closer when the ladies are trying the forfeits, level out the voices a bit more, other than that it’s good. just needs polishing. Sound effects shouldn't overpowers the voices.
I need to edit a less than 15-20 minutes comedy show with a strict deadline of 24 hours for 1k INR. Do a minute sample and do your entry. Reference: Raw footage: Key Requirements: - Trimming and rearranging clips - Enhancing audio quality - Bit Animation Final out should convey fun well. There’s two camera angles try and switch it up, Keep background music and lower it slightly, get close ups of facial expressions when something really happening, closer when the ladies are trying the forfeits, level out the voices a bit more, other than that it’s good. just needs polishing. Sound effects shouldn't overpowers the voices.
As the client for this project, I urgently require an expert in VBA.
We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.
I'm planning an event for a trade show and need the assistance of a talented designer to create an engaging and attractive floor design. The proposed design should have the following characteristics: - Must showcase our range of vendors and sponsors. - Needs to be visually appealing to stand out among others. - Design must set a welcoming tone to entice attendees and engage in meaningful conversations. Ideal freelancer should be experienced in floor plan designs specifically for trade shows. An understanding of consumer behavior and past work with product/service showcasing would be a great plus. Please provide a portfolio of your previous work in your proposal. Looking forward to your creative ideas.
I'm on a quest to find episodes from the Sirius XMU radio show "The Carles Show"/""/"Hipster Runoff Radio" that are between 2 and 10 years old. For this task, keen research skills are necessary, with potential capability to bypass potential online obstacles in order to find the audio files of said show. Transcripts aren't needed, just the audio files. Experience in tracking down hard-to-find audio content will be a great advantage.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfac...
I'm looking for a professional and experienced camera crew to film my upcoming reality TV show. The project is based in the United States and will involve both indoor and outdoor shooting. Key Requirements: - Cinematographer: Someone who can plan the visual aspects of the show and capture high-quality footage. - Camera Operator: Skilled in operating professional cameras and capturing shots at the right angle and moment. - Sound Technician: Proficient in handling sound recording equipment and ensuring high-quality audio. The project is expected to take more than 2 weeks, so availability for an extended project duration is crucial. Experience in reality TV or documentary style filming is a plus. Please provide links to previous work in your proposal.
I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is...
I am looking for a skilled Pro Tools Sound Engineer to handle the technical aspects of an upcoming variety show recital that I will be hosting. Key Responsibilities: - Operate and manage the sound system using Pro Tools - Ensure sound checks are conducted properly for all performers - Troubleshoot any technical issues that may arise during the show Ideal Candidate: - Proven experience in operating Pro Tools specifically in a live performance setting - Strong knowledge of sound engineering principles - Ability to multitask, work under pressure and solve problems quickly and efficiently
Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time rep...
I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfac...
Flyer need for boxing show promotion. Theme is Michael Jackson Thriller ( just to avoid using Michael Jackson face, so use like silhouette or side of face or bad is good). The good is just put it in a boxing ring and make the text like the work "THRILLER" show in example of images. Please make is entertaining for boxing and very sophisticated. This is more of announcing event, without full details. Information must have on the flyer: Galveston Battle of the Badges ( and the logo) Boxing ring with possible fighters with head gear Michael jackson with thriller zombies Make it pop and use the theme, use the thriller txt. (Date) November 2024 Please get creative and use elegance and vivacious quality like vegas style. Attached give you style fo boxing flyer I'm ...
I'm on the lookout for highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the required...
• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book of Transfer_[Date of extraction from the porta...
I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail will be crucial...
I need a freelancer well-experienced in VBA to automate the generation of reports for my business, specifically in Gmail. It's critical for this project to be completed as soon as possible, and here are the specific needs: - Develop VBA scripts that will automatically generate and send specified reports. - Must have a deep understanding of Gmail infrastructure in order to correctly implement the automation process. - Must demonstrate a proven track record in completing similar automation tasks. Your expertise in ensuring efficiency and accuracy is important. If you believe you're the perfect candidate and can deliver this project promptly, please reach out.
