VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
Adding the export feature in "Admin audit trails" module on a Drupa 10 website.
...experienced digital marketer who can handle a spectrum of tasks. They include but are not limited to creating engaging content for our Instagram and Twitter accounts, taking charge of managing our online community, and crafting effective e-mail marketing campaigns. You should be an individual with strong command of English, and a creative mindset to help push the boundaries of our digital marketing efforts. Responsibilities Include: - Creating Social Media Posts (image + content) on Instagram and Twitter; - Doing community management in social; - Creating e-mail marketing campaigns; - Creating blog posts; - Managing a CRM (Monday); - Ability to create reports with insights; The end goal of our marketing efforts includes both increasing brand awareness and drivin...
Contact us for leather jackets track suits shoes bags or in other fabric you want... also for sports items and sportwears....we send you sample as free of cost for quality checking.... All items are good in quality and cheap in price We export all these items and goods...in other countries If you are interested then contact us.... Thank you?
...- on incoming message the forwarding is done by a configurable delay in milliseconds milestones: MS1: implement a basic hardcoded forwarder which detects new SMS (event) and forwards them via e-mail to a hardcoded e-mail address (android and ios) MS2: design & implement a UI, which has a settings dialog for the rules: - add/delete/update/display (CRUD) operations on rules - user can choose a regex pattern to detect specific phone numbers (from) - user can choose the destination(s) (a list of destinations) with whatsapp, telegram, sms, e-mail - implementation in this MS on the UI only for e-mail (but user can select all the named options) - user can choose to use macros like: - sender phone (smsSenderPhonenumber) - sender name (smsSenderDisplayNam...
I'm looking for an Excel and VBA expert to help streamline my workflow and boost productivity. You'll be responsible for: - Automating repetitive tasks: I need you to develop efficient scripts that will handle routine operations in the spreadsheets, eliminating the need for manual intervention and enhancing the overall efficiency. - Crafting custom functions: The custom functions I require are complex and involve external data sources. Your role will involve creating these functions effectively, ensuring they are accurate and function seamlessly within the Excel environment. The ideal candidate will have extensive experience in Excel, VBA, and creating complex custom functions. Solid understanding of data analysis and automation is crucial for this role. Your mai...
...provider) Application would be used to enter customer orders that are taken over the phone or in person. (Employee will enter customers info and order) (NO PAYMENT processing or customer access) Employee and admin level (Employee cannot delete order, only void) Customer (First Name, Last Name, Phone Number, Note ) (Option to import/export customers would be great) (from Excel file) Item/Product: (Product Category, Product name, SKU, Price) (Option to import/export Products from Excel file) would be great) Workflow would be: Login to App (email and password) (Option to stay logged in) (Option to reset password through email) Flow 1. Customer calls in to place an order. 2. Employee will search for customer by first or last name or phone number of customer. (Search ...
I'm looking for an experienced designer to create an HTML email banner that is compatible with Gmail, Outlook, and Mailchimp. The purpose of the design specifics has been left open to your creativity. Ideal Skills and Experience: - Advanced knowledge in creating HTML email banners - Familiarity with Gmail, Outlook, and Mailchimp platforms - Proven record of creative design approaches. Create a design that's universal and can adapt to different campaign purposes, from promoting a sale or unique offer to advertising a new product or service, or increasing brand recognition. Please note, the use of certain design elements like the company logo, product images, or animated effects is also left to your discretion. Looking forward to your unique spin on this project!
**Your Bidding Amount is Final. No change allowed later**##Please read the attached file for details## I have an existing Online Stamp Inventory for Postal Stamp Collectors in my site. It is made in CakePHP. I need to add some features to it and repair current feature. I want to add Export feature, improve search feature and add the feature of uploading images/document, repair Year field, URl field, make the current captcha and email verification system better. Further, I need to add Subscription feature. Free Users can add limited number of entries whereas Paid Subscribers can get full features. See the site: This is very easy Project. Just making Form fields and report generating. Lowest bidder will win this project. You don't need to develop
Hola, busco un sistema que reciba los lead que llegan desde las campañas de Facebook Formularios y tiktok formularios. en la primera etapa solo me interesa esos 2, que me apenas llegue un formulario este lo reciba y lo envie por mail o whatsapp al dueño de la campaña. la idea es hacer algo como esto:
I am in need of a skilled professional to develop software. We have all barcodes in EAN formats in excel (14-15 digits format) Everyday we sell products online. We would like to be able to find a certain barcode on a shelf as we have many EANS on the same shelf. We have bought a wireless handheld scanner. So we wo...We have all barcodes in EAN formats in excel (14-15 digits format) Everyday we sell products online. We would like to be able to find a certain barcode on a shelf as we have many EANS on the same shelf. We have bought a wireless handheld scanner. So we would like to be able to transfer those eans (EAN ) to use this wireless scanner to find a certain product on shelf. Or maybe not transfer but to export some batch of eans everyday in order to find them faster everyday ob ...
I'm urgently in need of a VBA expert to help tune an existing Word VBA that's not performing as expected. Even though it runs, it's not accomplishing the task it was meant for. Key objectives for this project are: - Identification and resolution of current issues with the VBA to align with its original purpose - Modification of the VBA to extract Word OLEs, while entirely bypassing PDF files (skipping them). The ideal freelancer for this task will have: - Extensive experience in VBA coding and troubleshooting - Experience with OLE extraction from Word - Proven track record in meeting deadlines. The timeline for this project is within a month. If you think you're the right fit for this project, I'd like to hear how you can hel...
I have a MySQL database that needs exporting. All user data, product data, and transaction data are required to be exported. Key Tasks: - Export all MySQL user data - Export all MySQL product data - Export all MySQL transaction data The final export should be in Excel format. This is not a job for beginners. You should have prior extensive experience with large database exports and MySQL. It would be a big plus if you're familiar with handling sensitive user and transaction data. As the project involves substantial data, confidentiality and data security are non-negotiable. Please include samples of similar database exporting projects you've completed.
We are in need of several highly skilled and experienced WooCommerce experts to assist with my stores. The project involves a variety of tasks, including theme customization, integration of a payment gateway, and potential product import/export. The ideal candidate will have: - Proven experience working with WooCommerce - Strong understanding of payment gateway integration - Familiarity with product import/export processes - Creative design skills for implementation of aesthetic improvements. - You must be comfortable and skilled to resolve different WooCommerce plugins issue, conflicts or bugs. A successful candidate with great track records in Woocommerce will have the great opportunity to work with us on a continuous basis.
I'm in need of a skilled professional who can help me set up SPF (Sender Policy Framework) and DKIM (DomainKeys Identified Mail) for my Gmail account. Key Tasks: - Set up SPF: I need you to authenticate my emails using SPF to prevent spoofing and phishing attacks. - Configure DKIM: Implementing DKIM will ensure that my emails are not tampered with in transit and that my domain is not being abused by spammers. Requirements: - Proficient in email authentication protocols. - Experience with DNS settings and domain authentication. - Familiarity with Gmail's email authentication systems. - Ability to explain the process clearly and concisely. Please provide a brief overview of your relevant experience in the field.
...cloud web application that's capable of: - Import customers lands based on GPS coordinates - Each land should be capable to hold information about it (fertilizing, used machinery, ...) - Utilizing the Sentinel Hub satellite maps API - Showing normal map layer - Providing a feature for customers to create a vegetation index analysis - Showing real-time weather forecast information through a widget - Export analysis to shapes for different terminals in tractors and machinery The application will have different logins for different customers. Ideal skills and experience for this job include: - Proficiency in web application development - Experience with satellite maps APIs, specifically Sentinel Hub API - Familiarity with data analysis, particularly in creating vegetation in...
I'm seeking an expert who can assist with developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom...developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom dashboards for financial analysis within Excel. - Automate data management processes within both SMART sheet and Excel. - Integrate the dashboards into SMART sheet for seamless use. Ideal Skills & Experience: - Strong expertise in SMART sheet and Excel, including VBA. - Proven track record of developing dashboards for financial analysis. - Ability to automate data management processes. - Excellent communication skills. Please provide examples of similar project...
I need to scrape specific information from a website for all search results with a particular key. The data should include Name, Address, Phone number, Email, Company name, and Job title. This data should be organized into an Excel file, with each category of information in separate columns. Ideal Skills: - Proficient in Excel VBA - Experience in web scraping - Understanding of VPN usage to access region restricted sites Please note that the website will only work with a USA VPN.
...and sustain a mail merge campaign to these prospective clients. So I need to automate a regularly occuring search for the most recent lawsuits that are filed on these clerks' websites and extract the defendants' names, mailing addresses and case numbers. The only problem is that the addresses are not found neatly on the web pages of the search results, but they must be extracted from individual PDF documents by going into each individual case docket and opening a certain document called a summons, which will have the defendant's address usually in the middle of the page, but always on the first page of the summons. Some of the summons are not PDF readable so I will need OCR functionality. Finally, when the data points are extracted, they can be exported into an exc...
I'm seeking a seasoned logo designer to create a sleek, modern logo for my cleaning chemicals supply and packaging company, Reliable Consumables. The ideal freelancer has experience with the follo...logos in a modern style with clever use of colour and space - Works well understanding and employing color psychology in designs The logo should weave in blue, green, and hints of earth tones. An understanding of our business, in terms of being a supplier of cleaning chemicals, could add value while working on this project. I look forward to an eye-catching logo that reflects our sleek, modern outlook yet ties back to our core business very well. Many thanks for considering my project. My Website link is Attached is my current logo, i want it completely changed.
My laptop is currently facing a software error that requires immediate attention. Key Requirements: - Proficiency in software troubleshooting - Availability for immediate assistance Your role will involve: - Quickly diagnosing the software issue on my laptop - Implementing the necessary fixes to resolve the problem - Ensuring the laptop is operating effectively post-resolution Ideal skills for this job would include: - Proficiency in Windows operating system - Experience in troubleshooting software issues - Strong communication skills and ability to work under a tight deadline.
We are a SAAS based application looking for Digital...weekly) 2. *SEO Marketing* NOT WRITING BLOGS We have around 700 blogs already written ONLY SEO is required to do TASK keyword, Metatag, Imagetag, SEO Quantity : ( 2 Post weekly) 3. *COMMUNITY & PRODUCT BUILDING Marketing* TASK Mantaining DISCORD, QUORA Q&A, trustpilot, google reviews Reviewing and Mantinaing on G2, Appsumo. 4. *EMAIL MARKETING* we can use sendgrid (paid) or GOOGLE Business Mail or some other external application TASK Target 1200 - 1500 email daily. 5. *VIDEO MARKETING (OPTIONAL)* We can hire ANOTHER (+1) freelancer to do it but we will be responsible for POST & MANTAINENCE TASK a. reels 02 weekly (< 20sec) b. 2 LANDING video (45 ~ 50 sec) The payout will be monthly. The meeting will be...
I'm seeking an experienced developer to design a tailored CRM system, loaded with features such as: diary task management, word & pdf forms mail merge, and outlook email merge along with the ability to store inbox and sent items in chronology. This project involves the creation of a desktop application that will operate under Windows and allow me to create custom workflows in C++. I have three crucial aspects related to custom workflow creation that are: - Assignment of tasks to users - Visual representation of workflows - Flexibility in editing workflows A developer versed in c++ is critical, furthermore, experience in task management and workflow design becomes a deciding factor. The success of this project will be gauged on these functionalities and their se...
I'm in need of a developer to create an app that displays free and busy schedules. The app should be compatible with Android and also be accessible on the web. Key Features: - The app should support user authentication. - It should retrieve users' schedule information from external calendar services such as Google Calendar and Outlook. Ideal Skills: - Proficiency in Android app development. - Experience in web-based app development. - Familiarity with user authentication systems. - Integration skills with external APIs, particularly calendar services. If you've worked on similar projects or have the required skills, please reach out with your proposal.
I'm in need of a professional who can help me solve the problem of my emails being marked as spam. The issue is primarily related to the emails that I send to others, and I'm looking for someone who can effectively prevent this from happ...to the emails that I send to others, and I'm looking for someone who can effectively prevent this from happening. Key Considerations: - Expertise in SMTP configuration and troubleshooting to resolve the rSPAM issue - Proven experience in enhancing email deliverability and preventing emails from being marked as spam this is the error I am getting for my outbound emails - SMTP error from remote mail server after end of data: 550 This message was classified as rSPAM and may not be delivered. Respond only if you know what this means...
...explaining the best approach for quiz creation. Screenshots: Seamless embed, maybe even uses website's CSS information? Picture or Icon Mobile Responsive: Features: * E-mail me the Lead with all information collected * Save in Google Sheets as a database * Main thing is to have it look nice and don't look out of place, similar font style, sizing, font size, etc * Use embed code to copy and past into my page builder * Create a plugin to help me customize the quiz, like images, text & size, etc. Desired Programming Language: PHP / SQL * I'm looking for the best deal
...skills for explaining the best approach for quiz creation. Screenshots: Seamless embed, maybe even uses website's CSS information? Picture or Icon Mobile Responsive: * E-mail me the Lead with all information collected * Save in Google Sheets as a database * Main thing is to have it look nice and don't look out of place, similar font style, sizing, font size, etc * Use [Shortcode-14] to embed into my page builder * Create a plugin to help me customize the quiz, like images, text & size, etc. Desired Programming Language: Wordpress Plugin / PHP / SQL * I'm looking for
I'm in need of an end-use documentation expert to create user training materials, a user manual and technical specifications for our products. - The documentation needs to be accessible to both general users and technical staff, so the language should be clear ...tech industry would be a plus. Documentation will most likely be hosted using Docfx, so the final format should be markdown. The software is a Web Application has 10 simply admin screen (e.g. Countries CRUD), a Dashboard, 6 medium complex screens with data validation rules (which should also be documenated, about 30 validation rules), One data visualisation screen with charts and metrics, and 3 export report pages for different industry regulations. I will provide access to the application so that you can review be...
Hi, I am looking for a virtual assistant that is bilingual in Spanish and English and is available to work from 9am PST until 3 or 5pm PST Monday through Friday for a doctor's office long term (>12 months) There are retention and production bonuses paid. Must have reliable internet. Duties include - data entry - translating over the phone - calling people to obtain information - scheduling appointments - responding to emails and voicemails - using a Slack like program You will have weekly meetings to answer any questions with the doctor (who is also bilingual). You will have access to a mentor/support team. You will be given scripts to use and specific questions to ask. You do NOT have to: scribe, create social media, create marketing emails, code, create gra...
I am in need of an experienced developer to create a custom Google Sheets Add-On that will enable data import/export, custom formatting and seamless integration with Plaid API. Key Project Requirements: - **Data Import/Export**: The add-on should facilitate the smooth import and export of data in and out of Google Sheets. - **Custom Formatting**: The tool should allow for flexible, user-defined formatting options for the data within the sheets. - **Plaid API Integration**: The developer should be well-versed in integrating with the Plaid API, ensuring a seamless and reliable connection. Ideal Skills and Qualifications: - Proven experience in Google Sheets Add-On development. - Strong background in custom software development and API integration. - Familiarity with Pl...
I'm searching for a skilled digital marketer to boost the number of my business' Google reviews. Despite having an average rating of 4 stars or higher, I see the need for a larger quantity of reviews to solidify my business' credibility and visibility. Key elements of this project include: - Developing and implementing a strategy to organically increase my Google reviews. - Incorporating Soc...for a services-based business. - An understanding of how to effectively use social media and a business website in encouraging reviews. - A proven track record of delivering results without resorting to spam or fake reviews. Please provide prior work examples of similar projects, specifically related to Google reviews growth. I look forward to working with you and strengthening our...
"Using Unity3D 2022.3, I've managed, to achieve basic lighting when exporting to Apple Vision Pro. However, I need impeccable, perfect lighting for both the Apple Vision Pro device and simulator, starting from Unity3D, since that's where my application is bilded. I'...Unity3D 2022.3, I've managed, to achieve basic lighting when exporting to Apple Vision Pro. However, I need impeccable, perfect lighting for both the Apple Vision Pro device and simulator, starting from Unity3D, since that's where my application is bilded. I'm seeking someone who can prepare and configure my already finished scene with the best lighting in Unity Editor. This is to ensure that when I export it to Apple Vision Pro, it looks nearly perfect, and it looks well lit, so th...
I'm in need of an expert to perform important adjustments on my Fortigate router. Your main task would be to: - Open both TCP and UDP ports. - Focus sp...Your main task would be to: - Open both TCP and UDP ports. - Focus specifically on the common email ports, IMAP, POP3, and SMTP – essential for a smooth function of our mail server. - Additionally, set up our mail server in the DMZ. The ideal freelancer for this project should have substantial knowledge and experience in network and server configuration, especially with Fortigate routers and email servers. Familiarity with DMZ setup is also required. Your ability to ensure the privacy and security of our mail server in the DMZ setup is paramount. we have recently relocated office and need to pass thro...
I'm in need of a VBA Excel expert to assist with generating weekly financial reports. Key Requirements: - Weekly Reporting: The expert should be able to create efficient and accurate VBA scripts that will automate the generation of excel charts based on our csv files reports downloaded from our service management software on a weekly basis. The chart is basically to display the Technician's daily sales of labour and material sold (shown in separate charts. - Financial Data: These reports will be based on our financial sales data, so the expert should be comfortable working with and manipulating this type of information. Ideal Skills: - Proficient in VBA for Excel: The ideal freelancer should have a deep understanding of VBA and Excel and be able to l...
The client is looking to integrate "SMTP" on the website so that the E-mail functionality would work properly
...Online EXPERT. You will migrate information from one account to another. My data includes customer and vendor information, account balances, transactions, and payroll data. Several companies were added under one license (as they were divisions of one company) and now are being separated onto different companies and thus, different licenses. Key responsibilities include: - Ensuring the accurate export and import of all necessary data - Handling the migration process smoothly with minimal disruption to the business operations - Ensuring that the structure and integrity of the data are maintained throughout the migration process The ideal candidate for this project would have: - Extensive experience with QuickBooks Online and a deep understanding of its data structures - Prior...
I urgently need a certified MS Word Expert who can efficiently handle several tasks in a short time-frame. The tasks include: - Formatting Business Reports and Academic Papers - Creating specific Templates - Conducting Mail Merge processes The project must be completed ASAP, so proficiency and speed are essential. Ideal skills include advanced MS Word knowledge, expertise in creating and formatting documents, ability to create custom templates, and proficiency in Mail merge. Efficiency and the ability to meet tight deadlines are also crucial for this project.
...performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integratio...
...performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integratio...
Hi guys, we have an excel contact list. In that list we have persons & companies with their con...an gmail inbox. When emails are sent from specific mails to this inbox the python script should read the body and depending on the request in mail syript should send requested Excel back. There are 8 different excel saved locally wich the script can take and send back. So depending on the contect of the mail script should choose the right excel file and send this with an text like "here your requested Contact List Periskop in attachment. kind regards" If its help. in attachmend an little python script we wrote to send back an mail with attachend. In that case it was an PDF.
...need of financial an expert who can develop a thorough financial model . The model should be able to accurately forecast future financial performance, and help steer my investment decisions. 1-Building up a comprehensive financial model (financial statements, valuation, returns) of the business. 2-Preparing a PowerPoint presentation that covers: 3-The selected market in (current status and outlook).Preferable segment within the Education market to target. 4-Analysis of proposed target (operational/financial) 5-Discussion of projections (assumptions/results) 6-Recommendation of proposal with justifications Key Skills and Experience: - Proficient in financial modeling - Business forecasting and investment analysis experience - Advanced knowledge of financial data including in...
Dear Concern, I'm looking for a tech. person for below works, - Web design (5 to 7 page/Informative) - Logo design - Letter head design - Business/Visiting card design - E-mail templates design (Gide-line or assistance needed for automation email marketing) Need unlimited revision for all upper works I provide content, also Already have purchased domain & hosting. Our Business : Chemicals supplying & treading Only for your reference to understand design with nature of business :
I'm on the outlook for a top-performing marketing expert with a broad range of skills, including Google Ads, SEO, and social media marketing. I'm establishing a new company and require comprehensive marketing strategies to help establish a powerful online presence. Key Objectives: - Bolster brand awareness - Drive massive traffic to our website The ideal candidate will have expertise in creating and optimizing Google Ads, utilizing SEO best practices, and developing successful social media marketing strategies. Target Audiences: Our campaign is aimed at general consumers. The perfect candidate would understand the dynamics of marketing to such an audience and can create tailored strategies accordingly. Please only bid on this project if you have a proven record in...
I need assistance in setting up a mail merge (publipostage) in Excel to report information from the Excel sheet into a Word template. Key requirements: - Excel Data Analysis: You should have experience in data analysis using Excel. - Mail Merge: Proficiency in creating mail merge documents in Excel advanced - Word Template Populating: Understanding of how to populate Word templates with data from Excel. It's important that only the text information from the Excel file should be included in the Word template. Ideal skills and experience: - Proficiency in Excel and Word - Experience in data analysis - Familiarity with mail merge functionality - Previous experience in setting up similar Excel-Word integrations. Please get in touch if you've worked...
I need to migrate 11-50 email accounts from Microsoft365 (specifically using Outlook Web Access) to CPANEL IMAP server. This task will require a freelancer who's proficient in both email system administration and migration. Key Responsibilities: - Transfer all existing emails, new IMAP server with zero data loss. - Ensure all the email accounts are set up and functioning correctly on the new server. I'm looking for a reliable freelancer who can deliver this task efficiently and with minimal disruption to our daily email operations.
...- The work needs to "live" in only two places - the reference table worksheet, and the worksheet doing the calculations. Because of how I'm structuring multiple sheets, I can't have a "scratch pad" sheet with intermediate lists. - The lookup will live in many different rows, performing lookups/calculations in each row based on selections - Because of the above, I believe it needs to be done via VBA, possibly by storing arrays and setting variables for row references. Ideal skills for the job: - Advanced Excel skills, particularly in lookup functions. - Experience in data analysis in Excel. - Proficiency in creating Excel functions for basic arithmetic operations. - Visual Basic I've attached the reference table, which will likely grow over ti...
...client's preference, this should be determined by user location. Your expertise in geolocation implementation is a must. 2. **Instructor Payouts:** I'll retain the authority to manually send them out. This process will be done on a regular, pre-established schedule. Hence, it's critical you have understanding of payment gateways, automation and scheduling systems. You'll be required to send an e-mail confirmation to the instructors whenever their payout is released. Consequently, top candidates should have a strong background in Laravel, payment gateways, geolocation services, email/SMS gateway API integrations and automated scheduling systems. This project demands clear communication, punctuality, and reliable delivery of quality code. A portfolio showc...
