VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
...talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational 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 Featu...
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...
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, s...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. - Macros: The project involves basic macro creation and execution. - Conditional Formatting: You should be able to apply conditional formatting to present data in a more user-friendly manner. If you believe you have the right skill set for this project, pleas...
I need a Notion API expert to customize my Notion pages for a smoother workflow and integration with other apps. Key requirements: - Integration with other apps: I'm looking to connect my Notion pages with an email client, specifically Microsoft Outlook. The goal is to automatically create draft emails in Outlook whenever new orders are created in Notion. - Automation of tasks: The freelancer will need to create a system that automates the email creation process. This should be seamless and require minimal manual intervention. - Email drafts customization: The only specific requirement for the email drafts will be the Email body. Ideal skills and experience: - Strong knowledge of the Notion API - Experience with integrating Notion with external apps, particularly ema...
I'm in need of a skilled email template designer to create a responsive email template that fits the Zoho CRM. Key Requirements: - The email template needs to be compatible with Zoho CRM. - It should be responsive, ensuring that it displays correctly on various email clients, including Gmail, Outlook, and Yahoo Mail. Application Requirements: - Please include your experience in designing email templates.
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çã...
...exceptional professional who can create an engaging PowerPoint presentation for HR induction. The objective of this presentation is threefold: introducing our company culture and values, providing an overview of our internal policies and procedures, as well as showcasing employee benefits and perks. The presentation should fit within a 10-15 minute span, offering a succinct yet comprehensive outlook of the following aspects: - Company Culture and Values: This should include our mission statement and core beliefs. Visual artwork that suits our corporate identity must be incorporated to bring these elements to life. - Procedural Overview: Aim to depict company policies and the way work is achieved in our organization. - Employee Perks: Highlight the benefits and advantage...
...professional-themed project, I expect a sophistication that will portray my engagements in a streamlined, clear, and engaging manner. Key Aspects: - Single master slide design - Dominant color: Yellow Ideal Skills: - PowerPoint design expertise - Graphic Design Knowledge - Fluent in English to understand communication nuances The right freelancer should combine their creativity with a professional outlook. Remember, less is more in this scenario. Looking forward to an elegant, yellow-themed design that can encapsulate my professional presentations in a single master slide. Familiarity with corporate designs is a bonus. The slide is used to provide a monthly update on key information to our business. Style guide and logos will be provided to successful freelancer. Potential f...
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.
I need some minor changes made to a HTML template. The email template needs to be optimized for various email clients, including Gmail, Outlook, and Apple Mail. I need the new layout to be inspired by specific designs I will provide.
...Sources is looking candidates for Senior 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 ...
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 interfaces for Excel.
Calling all ace animators; we are in need of your groundbreaking skills in 3D animation to produce engaging videos for our brand promotion. We aim to target teenagers primarily so the videos must resonate with their interests, likes ...on brand awareness. We aim to imprint our brand in the minds of our young audience through compelling stories, colors, and music that they'll relate to. Skills & Experience: - Proven ability in 3D animation with no less than 3 years of experience - Previous experience in creating animations for teenagers - Outstanding storytelling capability that can draw the audience's attention - A creative outlook that will bring our brand to life, inspiring young audiences We are excited to see how your skills can help our brand become a household...
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...
I'm in a project to migrate Windows devices to new Microsoft 365 Tenant. The devices are registered in Intune in the current tenant and users are using their Microsoft work Account to log in to Windows. After I retire the device from Intune Portal (Source Tenant) ...and try to add a new work account (that is the user account in the destination tenant) I got the following ...and users are using their Microsoft work Account to log in to Windows. After I retire the device from Intune Portal (Source Tenant) ...and try to add a new work account (that is the user account in the destination tenant) I got the following error message: "the work or school account couldn't be found. check the account name and try again" The user is signing in successfully to Services like Out...
...link, and deploy across all users. - An active countdown clock feature within the signature. - Compatibility with Microsoft Outlook, our primary email client. Additional Requirements: - While not essential, the ability to track interactions (clicks) on the email signature elements would be a nice to have. Ideal Skills and Experience: - Strong graphic design skills with a portfolio of visually appealing email signature designs. - Proficiency in HTML and CSS for email signature creation. - Experience in incorporating rotating banners and countdown clocks in email signatures. - Familiarity with QR code generation and usage. - Previous work with Microsoft Outlook email signatures is highly desired. - Familiarity with tools for tracking email signature interactio...
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 am currently in the need of a professional who can set up a business email account for my new website using Outlook. Key Requirements: - Experience in setting up business email accounts on Outlook. - Familiar with domain integration. - Can assure a standard security level for the account. Please note, I already have a purchased domain for the business email. You are expected to promptly align this task within the given requirements. The right candidate should have the experience and skills to carry out this task efficiently.
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...
Having a significant issue with my Outlook and Microsoft Business account. When I create a new users in our system they are UNABLE to send outgoing emails to external parties. To help solve the issue, I'm looking for a skilled individual with: -We use Proofpoint, microsoft office, and cloudflare -Domain knowledge, cloud flare, - Expertise in troubleshooting Outlook email - Knowledge about the ins and outs of email settings - Prior experience in dealing with similar issues Your task will be to resolve this issue so I can seamlessly send and receive emails across all our devices for all our employees
...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 with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...
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'm in need of a professional logo for my company, Bristol Heritage Wills and Probate. The logo must be modern and incorporate the color gold. Key requirements: - Modern Design: I'm looking for a logo that reflects a modern outlook while maintaining a sense of professionalism. - Color Scheme: I've chosen gold as the color for the logo. The design should be centered around this color, potentially using it as a primary element. - Industry Relevance: Given that my company is in the legal sector, the logo should reflect a sense of trustworthiness and reliability. Ideal Skills and Experience: - Experience with logo design, particularly for corporate or legal industry. - Proficiency in modern design styles. - Strong understanding of color theory and experience in using g...
I'm seeking a video editor who specializes in basic editing, such as trimming and merging. The raw footage total duration is less than an hour and I would like the final edited video to be less than 10 minutes. Skills and experience: - Proficient in basic video editing which includes trimming and merging. - Experience with managing raw footage of less than one hour. - Proven track recor...total duration is less than an hour and I would like the final edited video to be less than 10 minutes. Skills and experience: - Proficient in basic video editing which includes trimming and merging. - Experience with managing raw footage of less than one hour. - Proven track record of producing final edited videos of less than 10 minutes duration. - Exceptional attention to detail and creative ...
I used my cpanel webmail at my hosting company easily on my Gmail account for years, and it stopped working on Sunday. The email still works on roundcube mail on my control panel. It's supposed to be easy to set up either Outlook or Gmail, but I can't do it. Is this expensive?
...directly within Outlook's meeting creation interface. The add-in should allow users to input agenda items and action items while creating a meeting event in Outlook. Upon meeting creation, the add-in should gather all meeting details, including the agenda and action items, and pass this information to an API endpoint in Salesforce. Subsequently, this data will be utilized to automatically create a corresponding meeting record in our Salesforce application. Our team includes Salesforce developers who will handle any necessary integration with Salesforce. Therefore, the focus of this project is solely on the development of the Outlook add-in. The add-in's responsibility will be to capture meeting details, including agenda and action items, and pass them to an API...
I need a virtual office assistant primarily for managing emails and appointments, as well as some data entry tasks. The ideal candidate would be skilled in the following areas: - Proficient in Microsoft Office Suite: As a part of this role, you will be handling my email and appointments. Familiarity with Microsoft Outlook will be a plus. - Google Suite: Your knowledge and experience with Google Suite, particularly Google Calendar, will be essential as well. I'd like you to maintain my calendar and schedule, so you should be comfortable working with this tool. - Data Entry: You will also assist with some basic data entry tasks. Therefore, attention to detail and accuracy are important. I'm looking for someone who can commit around 10-20 hours a week to start, with the pot...
...novice and realize I need help with this. Key Requirements: - Expertise in email deliverability: I need a professional who can accurately diagnose and rectify the problem. - Gmail/Outlook Knowledge: Familiarity with Outlook/Gmail interface and settings is helpful as it's used when sending from outside our CRM. Familiarity with Zoho CRM a plus but not required. Ideal Skills and Experience: - Proven track record in successfully improving email deliverability. - In-depth understanding of SPF, DKIM, DMARC implementation. - Specific experience with deliverability issues when sending from Gmail and outlook. - Strong troubleshooting and problem-solving skills. Your role would involve investigating the underlying cause of the delivery failure, making ...
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 delivering high quality and d...
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...Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined 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, please provide example...
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'm looking for an experienced 3D artist who can create realistic, high-quality renderings of my paper ice cream tubs. Please recreate the tubs without lids and on a plain white background and stick to the same Pantone colours. Here's what I'm lo...already been created, but I need it to be convincingly brought to life in a 3D environment. Ideal Skills and Experience: • Proven experience in 3D product rendering • Expertise in highlighting packaging design elements • Attention to detail for a realistic rendering • Ability to work with existing designs and stick to them closely • Knowledge of texture mapping and lighting for a realistic outlook If you can faithfully reproduce my design in 3D and make it appealing and realistic, you coul...
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.
...automated workflows as an intitial test: Flow 1: If a new email is received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, save the attached excel file as a csv and rename the csv file the date of the email in YYYYMMDD format and save to a folder in onedrive for business. On successful completion send an email confirming success. >If there is no new email in the other outlook 365 folder, email our info@ email address notifying that it is not present. Repeat the checking process 2 days later until successful Flow 2: If a new email is received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, unzip the attachment using a password, save the attached excel file as a csv and r...
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 interfaces for Excel.
I'm seeking an expert to improve and maximize my Office 365 email deliverability rates by boosting DMARC, SPF, and DKIM authentication protocols. I'm not completely certain if I'm experiencing any deliverability issues or ...completely certain if I'm experiencing any deliverability issues or receiving bounce-back messages, hence, expertise in diagnostic skills for these issues is highly desirable. Ideal candidate for the job should: - Have in-depth knowledge and experience with DMARC, SPF, DKIM authentication protocols. - Be capable of identifying and fixing potential deliverability problems. - Have experience with Gmail, Outlook, and Yahoo Mail services to ensure emails are properly received in those platforms. Time efficiency and meticulousness are key attri...
...Management:** As an Outlook user, you'll be responsible for keeping my inbox organized, flagging important emails, and responding to emails based on pre-set criteria. - **Calendar Scheduling:** I need someone who can effectively manage my calendar. You'll be responsible for setting up meetings, appointments, and ensuring that my schedule is well-organized and up-to-date. - **Prioritizing Tasks/Events:** I'm looking for someone who can help me prioritize my tasks and events. You need to be able to understand my schedule and commitments and help ensure I'm allocating my time effectively. The ideal candidate for this role should have: - Prior experience in personal assistance or administrative support - Excellent organizational and time management skills - Profi...
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 Dat...based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard QR codes. - Ease of use: The end-user will be working in Excel, so the implementation should be user-friendly and seamless within the Excel environment. Ideal Skills and Experience: - Proficiency in Excel: A deep understanding of Excel formulas and VBA scripting is essential for this project. - Experience with QR code generation: Prior experience with generating QR codes, especially within Exce...
As an IT professional, I'm looking for an expert in Microsoft's Exchange Server 2019, as I need it set up for several organizations. The server setup must allow client access through Outlook on the web, Exchange ActiveSync, and Outlook Anywhere (RPC over HTTP). Ideal Skills and Experience: - Proficiency in Microsoft Exchange Server 2019 - Previous experience setting up servers for multiple organizations - Familiarity with various client access setups including Outlook on the web, Exchange ActiveSync, and Outlook Anywhere (RPC over HTTP) This task involves complex server configuration so only those with corresponding expertise should apply. This job would entail making sure that setup and client access is seamless for each organization.
