VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
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
For this project, I'm seeking a skilled professional who is proficient at integrating composite animation videos. You'll need to be able to: - Generate an animation video with a file ported using Unity Unreal Exe. - Export the video as an mp4. - Complete the job ASAP. - Include these: 1 PLM 2 AI report 3 AI Foreman 4 QA 5 Safety 6 Collaboration Each in less than 10 seconds Ideal skills and experience: - Proficiency in Unity Unreal Exe. - Familiarity with Windows mp4 format. - Attention to detail and excellent time management skills. The deadline is a high priority for this project, so please only apply if you're confident you can deliver on time.
...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...
I am seeking an adept Adobe Animate Animator. I have the character drawn in an illustrator file. Key expectations: - Expertise in Adobe Animate with a portfolio showing cartoon-style character animations - Proven record in meeting strict deadlines In a nutshell, I'm seeking a skilled artist who can bring my character to life to send me a Adobe Animate file ready to record the lip sync and export it for me to use in adobe premiere. The three things to animate in the character are the following: blinking, lip syncing visemes and hand gesture.
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
Exporting survey data using a xsl template (template for export survey data inside "Stake rail" or "Check rail"). It is necessary to edit the template to export only the selected points within job (currently the template exports all points, even deleted points).
The project is to create Inverter automation to start export, stop export and charge the battery automatically using a microcontroller that can subscribe to the server to get spot prices to run the automation. Objectives: 1. Modbus read and write 2. ESP32 Webserver 3. Spot price subscribe 4. Calculation / rules 5. MQTT Service (Server) 6. Price Service (Server) 7. Device Dashboard (Server) Project scope and system architecture are referred to the project brief documentation "Inverter Automation Project "
One excel file with macro as per the customer requirement
...social platforms. We require the following post schedule: 1. Facebook and Instagram: 1-2 posts per day. 2-3 stories per day. Late morning and early evening tend to work best. 2. TikTok: 1-3 posts per day. Mid-morning and late afternoon are ideal 3. Twitter: 3-5 tweets per day. Morning, noon, and early evening. 4. LinkedIn: 1-2 posts per week. On weekdays before evening * All times in USA EST or PST, whichever is easier for you. (EST preferred). The key content to share are following: 1. Deals from our website. (Any deals you may find interesting, or currently trending products in the world/networks via a link from our website) via text and images 2. Deals and posts from our affiliate partners 3. Polls 4. Very basic videos of products or storytelling, you can edit yourself or ...
saya nak bina software untuk final project saya di politeknik tetapi tidak tahu untuk siapkan lagi 50% dari project tersebut jadi saya perlukan bantuan software developer dari malaysia yang mahir dalam biadang ini untuk menolong saya . saya menggunakan unity untuk membina dengan memasukan 3d layout yang saya export dari matterport dalam bentuk .OBJ. dan saya stuck disitu .saya nak buat dia macam ni , bila buka apps tu dia akan keluar option untuk pilih bilik belajar di politeknik yang saya dah scan 3d dan automatik keluar kamera dan ada arrow pointing yang menunjuk arah ke pengguna dan juga kalau boleh ada sedikit robot kecik di setiap belik menerangkan fungsi bilik belajar/lab di aras 0 itu. saya harap encik dapat menolong saya.
I require an e-commerce website for selling joinery hardware. Open for woo commerce or shopify option I have website on woo were i want to export all products with media for new one. I have a lot of variable products, so bare in mind This will be new hosting with server and new domain I am looking for pricing and suggestion This all need to be connected with google and ready for SEO Please provide timing too Thanks
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 ...
...your main focus will be to develop an efficient, user-friendly UI for my machine learning application. Key Responsibilities: - Code the frontend of the application using React - Write backend code using Python - Liaise with me for regular updates and iterations Although not specifically detailed, the development may require real-time data visualization, user authentication, and the ability to export data in different formats. Ideal Skills: - Proven experience with React and Python - Previous experience crafting UI for Machine Learning applications The timeline for completion wasn't specified, allowing you to focus on quality rather than rush to meet a deadline. However, regular progress updates are expected. This project is an excellent match for developers seeking to...
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?
Hi, The task is to scrape a pdf that is downloaded on website. Steps: 1. Go to website 2. Enter code in search and click search. (We provide list code) 3. On the results page Click on pdf document and open or download it 4. Extract 14 pieces of data from the PDF and export into excel sheet. There are about 150.000. Some codes do not have any data then skip. I have attached a word document with pictures and flow for you to review. Thanks!
...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'm seeking a developer to help me setup a simple PSD editing via API or similar. The task involve...This could be accomplished using : []() or the Photoshop API. or any other library you suggest. ---- One guy started working on this for me, but from all of a sudden just disappeared and stopped answering completely, so all I have is this video he sent me of making such function, to edit the text via a form, and to export the image, check it out here: He made this in less than 1 hour. So this. task itself should be easy for someone knowing this. If you do a good job, this task is just the start, it's just a small part of a very big project that I will need help with in the upcoming near future. Check the video:
...**Core Features:** - **Resume Templates:** Design and implement a variety of customizable resume templates to cater to different job industries and levels of experience. - **Resume Customization Options:** Incorporate AI-driven suggestions for resume customization, helping users to tailor their resumes to specific job postings or industries. - **Import/Export Resume:** Enable users to easily import their existing resumes and export the newly created ones in various formats (e.g., PDF, Word). - **LinkedIn Integration:** Implement functionality allowing users to link their LinkedIn profiles for easy import of professional achievements, experiences, and network endorsements. - **Cover Letter Builder:** Develop an AI-based cover letter builder that guides users in creat...
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 have marble quarries with good grades in Turkey. I export these marble blocks to all over the world. I am looking for experts to work together on a commission basis (win-win). You will sell my marbles based on tons and earn commission.
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...
As a textile exporter, I'm seeking a proficient lead generator who will assist me to accelerate my sales in the United States, United Kingdom, and Germany. Key Tasks: - Identify and generate leads specifically interested in importing fabric and home textiles. - Comprehensive understanding of textile industry is a plus. - Proven experience in lead generation, with emphasis on foreign markets. Desired Skills and Experience: - Strong research and strategic analysis skills. - Proficient in creating and maintaining client relationships. - Experience in international business development particularly in the textile field. - Strong fluency in English, knowledge of German language is a plus. Ultimately, the goal of this project is to boost my sales, extending my reach in the internati...
i have a server with opnsense 24.1.5 installed iam trying to configure VPN, but it is not working i tried to follow guide on youtube and this guide -Adding a User -Add SSL Server -create vpn server -Firewall Rules -Export Client Configuration but not working for me using viscocity you have to help me set this up using anydesk
I'm looking for a skilled WordPress developer to assist me in creating a custom, multipage form using Contact Form 7. This... - Sent to a designated email address - Stored in a specific page inside WordPress dashboard, already configured Furthermore, I require the setup of an export mechanism for this incomplete data, specifically in a CSV format. This CSV should: - Have separate columns for each field to ensure easy data processing - Include timestamps for each form submission for traceability and analysis. The ideal candidate should be proficient in WordPress development, especially with Contact Form 7 plugin integration. Experience in setting up and managing multipage logic for forms is a plus. Additionally, knowledge of data handling and export in CSV format ...
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...
I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skill...file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migratio...
I'm in need of an experienced telemarketer and lead generator to assist with my export business. Your primary focus will be on home textiles, so a flair for this industry and its nuances would be invaluable. Key Responsibilities: - Conducting cold calls to prospects in the home textiles industry - Generating leads and setting appointments for further negotiation - Managing data and documenting sales prospects Your Skills: - Proven experience in telemarketing and lead generation - Excellent communication and negotiation skills - Familiarity with the home textiles industry - Ability to maintain a positive attitude in a high-pressure environment. I'm looking for someone who is not only able to generate leads, but also has the ability to close deals. The ideal candidate wi...
I am experiencing a problematic error with my Excel sheet. An error message k...sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A thorough understanding of Excel functions and spreadsheet error troubleshooting is also required to successfully deli...
...strong understanding of software architecture and design patterns. - CAD Software Development: Prior experience in developing CAD software, particularly with a focus on 3D modeling, will be highly beneficial. - Windows OS: A good understanding of Windows OS and its specific requirements for software development. - File Format Handling: Experience in handling DWG files and developing import/export functionalities for CAD software. If you have relevant experience and skills in C++ development, particularly in CAD software, and can commit to creating a high-quality, Windows-compatible CAD software, I'm keen to hear from you. Extra info: I am looking at a long term contract of 1 year, renewable each year. I will conduct a written test before making offer,...
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'm looking to upgrade my current system, perhaps keeping the current Opencart (V1.52) system and working with it where possible... unless its deemed a rebuild is cost effective. The opencart system we use has been added and modified over time, hence it is not possible to simply upgrade to a newer opencart version. The business we operate in is parts for coal and wood fires, ...website communicates with (sending data either way) and any data grabs. NO 5. Confirmation of payment gateways used. Realex (redirect to payment interface), PayPal 6. How the databases (products, customers, orders) are stored and if the data can be exported. Standard OC table structure… yes it can be exported as SQL data dump and all the products to stock link via the export fe...
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...
I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require as...MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a...
NETCheck es una compañía especializada en consultoría y soluciones tecnológicas en entornos SAP, Microsoft, Open Source, Big Data, Ciberseguridad, BI e Inteligencia Artificial. Somos Microsoft Partner, con certificaciones: Gold en DevOps, Data Platform, Application Development y Application Integration, y certificación Silver en Cloud Platform. Desde el 2003 somos Service Partner de SAP . A lo largo de 22 años, hemos desarrollado proyectos para más de 100 compañías, tanto del sector público como del sector privado, en más de 15 países, incorporando en nuestros proyectos las mejores prácticas del sector. ¿Qué te ofrecemos? • Incorporación a una compañ&iacut...
I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm...format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data ...
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 in need of a tool that can convert PDF voter lists into Excel in a text format. Here's a breakdown of what I'm looking for: - Conversion Style: I'd like the tool to convert the PDF voter list by combining all columns into a single table. This will make it easier for me to wor...incorporating multi-language support. Ideal Skills and Experience: - Proficiency in PDF extraction and conversion tools - Strong knowledge of Excel and text formatting - Experience in developing error detection and correction features - Attention to detail for accurate text conversion - Fluent in the English language for error-free translation. Attached PDF file. Note: It’s NOT a one-time PDF to Excel export requirement. The project is to have a tool to locate PDF files & ...
As the VP of sales for a fast-growing coding BootCamp company, I require a highly proficient individual to assist me with several key tasks. 8am - 5pm PST availability, full time role. Key Responsibilities: - Data Analysis: You should be able to dissect and interpret a variety of data sets, particularly surrounding sales, leads, and conversion rates. - Report Generation: Using Excel or Google Sheets, you will be responsible for creating detailed reports on sales performance, lead generation, and conversion rates. Ideal Skills and Experience: - Fluency in Excel/Google Sheets - Previous experience working as an executive or virtual assistant for sales managers or VP of sales, ensuring you understand the requirements and demands of the role - Exceptional attention to detail and a tra...
