Vba combine data columnงาน
I'm in need of a proficient VBA programmer to create an interactive Excel for me. The Excel will serve as a tool for users to query a protected dataset. This dataset contains information about various hospitals across the UK. Key Features: - Users will be able to filter the data based on: - Hospital type - Geographical region - Specialty services - The data will be visualized on a Heatmap within the Excel. - Users should have the ability to save their query results as a PDF. Ideal Skills: - Strong proficiency in VBA programming - Extensive experience with Excel - Familiarity with creating interactive tools in Excel - Prior experience with data visualization, particularly using Heatmaps - Understanding of creating protected datasets in Exce...
I need a skilled Excel VBA programmer to create a macro that can automatically delete specific rows in my Excel worksheet based on a specified cell value. Key Requirements: - The macro should automatically run each time a new entry is added to the Excel sheet. - It should be designed to delete rows that meet a certain criteria based on a cell value. Ideal Skills: - Proficiency in Excel VBA and automation. - Experience in creating macros for Excel that execute based on certain conditions. - Strong understanding of Excel functions and capabilities.
I'm looking for an expert in CRM who can create a specific bubble chart in the dashboard. For some reason we can not get it to work. The data is there, but the chart is not being generated. On the X-axis, we want to plot the % chance of winning the project. (we have this data in a % chance column) On the Y-axis, we want to plot the length of the project in time (we have this data in the months column) and the size of the bubbles - we want the potential value of the project (we have this data on the unweighted value column) You need to be an EXPERT in monday.com. Thanks
I am looking for an experienced VBA programmer with strong expertise in MS-Visio to help format the shadows of role shapes in my Visio file. The task involves applying different shadow colors based on the Work location value for each shape. Specific Requirements: Format each shape’s shadow color according to its Work location value as specified below: UB/OT: #FF4A4A KB/OT: #FF4A4A OT: #00749B UB: No shadow DZ: #F47721 KB: #70A489 BNE: #AB9AC0 PEK: #AB9AC0 PER: #AB9AC0 General Shadow Setup: Transparency: 0% Size: 105% Blur: 0pt Angle: 50° Distance: 5pt Ideal Skills and Experience: Proficiency in VBA programming Extensive experience with MS-Visio Ability to implement predefined color schemes effectively If you meet these criteria and are interested in this project...
The spreadsheet that was created by Rahul needs the following 1. I was able to fix most of the tabs with the exception I cannot get the SALES TOTAl of the INDIVIDUAL SUMMARY tab and the SALES TOTAL of the TEAM SUMMARY tab to match 2. Also would like to add a column for the year 2027 to the tabs.
I'm in need of a Typescript expert who can convert an Excel file with existing Macros and VBA code into a format that can be opened and used with Microsoft 365 App. Key Responsibilities Include: - Retaining all the Macros from the original Excel file Please note that the client didn't specify the intended use of the converted file or any specific formatting requirements. The ideal candidate for this job should possess the following skills and experience: - Proficiency in Typescript - Experience with Excel Macros - Experience with Microsoft 365 App and its compatibility requirements
...the following areas for a series of development, automation, and web projects. The ideal candidates should have proven track records in their respective fields and the ability to deliver high-quality results within deadlines. Required Skills: VBA Excel (Automation): Expertise in automating Excel tasks using VBA. Strong knowledge of Excel functions, data manipulation, and custom macro development. Ability to create complex automated workflows and reporting tools. Python Expert: Proficient in Python with experience in developing automation scripts, data analysis, web scraping, and API integration. Familiarity with libraries such as Pandas, NumPy, Selenium, and Flask/Django. Ability to write clean, efficient, and well-documented code. Java, JavaScript: Stron...
Hi, I have csv file uploaded in cloud server, that file generates and upload to the server automatically. I'm looking for shopify expert to import products from csv file link. The main part the images column is not inside in csv file. images are uploaded in separate directory of the server. you have to link and map each images to product that are import using csv file. Budget for this task $40, start your proposal with "Shopify Expert" so i know you read my description. Looking forward now
Hi, I will do your fixed data automation project. Thank you
I'm in search of a talented illustrator for my children's book. Key Requirements: - Illustrations should be in a realistic style, suitable for a 6-8 years old audience. - Ability to bring to life a fantasy world through illustrations. - Experience with children's book illustrations is a plus. This project is perfect for illustrators who can combine technical skills with a deep understanding of children's literature and fantasy themes.
I'm looking for a skilled professional to combine Unity with Intel RealSense camera technology for real-time football movement detection in a desktop application. Key project requirements: - Utilizing Unity: The project requires an expert who is well-versed in Unity, with the ability to integrate complex technologies with ease. - Realsense Camera Integration: Experience with Intel RealSense technology is a must. The successful candidate will need to have a deep understanding of this camera's capabilities and how to leverage them for precise motion detection. - Desktop Application: The end product will be a desktop application, so experience in developing for desktop platforms is preferred. Your responsibilities: - Develop a real-time football movement detection system us...
I have an Excel spreadsheet with a list of beginning and endpoint coordinates, and I need a VBA script written that will interface with Adobe Illustrator CC to draw solid lines connecting these points. The completed script should draw a grid pattern. The script should then save the file in dxf format. Key requirements: - Proficient in writing VBA scripts - Experienced with Adobe Illustrator CC - Able to work with Excel spreadsheets
As a business owner, I'm searching for an experienced and innovative Android app developer to construct a mobile app with social networking capabilities. Here's what I'm expecting from this project: - The creation of a user-friendly social networking app specifically for Android users. To match the demands of the pro...project, you should possess the following skills and experience: • Proficiency in Android development tools and software. • Strong background in designing and developing social networking apps. • Exceptional problem-solving abilities. • Experience in UI/UX design for optimal user experience. It's crucial to me that the mobile app is both visually appealing and easy to navigate. Your ability to combine aesthetics with funct...
We need a bunch of updates to consolidate files on sharepoint based on set logic. Also need to update dropdowns to source from an external VLOOKUP file. Also need to add new columns to files but not all files, but the logic need to work consistently. More details to be shared with winning bidder.
I'm seeking a talented cartoonist with proficiency in creating engaging political caricature-style cartoons. The cartoons will be used in online news media political cartoons and greeting cards. Expertise should cover themes encompassing elections, political personalities, ...Create multiple (and ongoing) unique caricature illustrations - Cover provided themes: elections, prominent political figures, and policy debates and issues - Final designs should be appropriate for online news / political cartoon media and greeting cards The ideal freelancer should: - Have proven skills in caricature-style illustration - Demonstrate understanding of political humor - Be able to combine political subtlety with impactful humor in their illustrations - Showcase a portfolio of humorous pol...
I'm in need of a skilled website developer who can create a vibrant and colorful website tailored for adult audiences. Thi...Key responsibilities and requirements include: - Designing a website that has a vivid and engaging color scheme - Implementing features for product/service promotion - Ensuring the website appeals to an adult audience - Having relevant experience in vibrant web design - Utilizing innovative techniques to drive user engagement and conversion. In essence, I need a developer who can effectively combine vibrant aesthetics and functionality, ultimately to promote my product/service to adults in an engaging way. The ideal freelancer should have strong experience in creating colorful websites that drive product engagement and seamlessly fit the specified targ...
I'm seeking a PHP developer to enhance my iTours Ticket System application with additional functionality. Key Tasks: - Incorporate a 'Demo Done' & 'Demo Rescheduled' column in the daily reporting email. - Modify the system to display the Company name and Client name for 'Demo Done' instances. - Implement other minor features as required. Ideal skills for this project include: - Proficiency in PHP - Experience with application feature development - Ability to enhance functionality based on specific requirements The enhancements will primarily be for internal staff use. Please note, while there are some specific tasks outlined, there may be additional minor feature requests that arise during the process.
I'm seeking a designer to craft a striking, modern logo for my brand. The logo should combine text and an icon, featuring a bright and bold color scheme. The design should clearly convey our business of buying homes for cash. PLEASE SEE THIS CHANGE Company Name: Cash 4 Sellers Ideal Skills and Experience: Expertise in modern design principles Proven experience in creating combination logos Strong understanding of color theory and bold design Excellent typographic skills Portfolio showcasing previous modern and bold logo designs
I'm looking for a skilled photo editor who can seamlessly combine two images into one PNG file. The primary aim is to display two different options with a diagonal line to separate them, specifically for website use. The final image should be of a specific dimension, which I will provide upon hiring. Ideal skills and experience: - Proficiency in photo editing software - Ability to merge two images into a single PNG file - Experience in creating images for web display - Understanding of basic design principles Looking forward to working with a professional who can deliver a high-quality image that meets these specifications.
I need a system that allows my staff to log their bre...should capture some information automatically, but also allow manual input. The supervisor should be able to review the data in an Excel file. Key Requirements: - Staff should be able to log their breaks - The system should capture employee name, break start and end time, and reason for break - The system should combine automatic tracking with manual input - The supervisor should be able to review the data in an Excel file - report every month about the timing of breaks Ideal Skills and Experience: - Proficient in Excel and VBA for developing user-friendly interfaces and automated processes - Experience in creating systems that allow for both manual and automatic data entry - Understand...
I'm looking for a professional to help me automate process follow my instruction Key Requirements: - You'll need to create a system that can follow my instructions for automation (VBA, Macro). - see the attached files
...multiple reviews for multiple companies. Each review is on a separate row eg. Row 1: Column names Row 2: Company 1 | Reviewer 1 | Review 1 | Email 1 | Date 1 | Row 3: Company 1 | Reviewer 2 | Review 2 | Email 2 | Date 2 | Row 4: Company 2 | Reviewer 3 | Review 3 | Email 3 | Date 3 | and I want this converted to Row 1: Column Names Row 2: Company 1 | Reviewer 1 | Review 1 | Email 1 | Date 1 | Reviewer 2 | Review 2 | Email 2 | Date 2 | Row 2: Company 2 | Reviewer 3 | Review 3 | Email 3 | Date 3 | Reviewer 4 | Review 4 | Email 4 | Date 4 | etc ie. I am looking for file which consolidates these reviews into a single row for each separate company. Key Requirements: - Each review should be placed in a separate column - The number of reviews can be up to 12000 per...
The goal of this project is to set up a Class 5 Session Border Controller (SBC) with comprehensive Least Cost Routing (LCR) capabilities. Key Requirements: - Implement LCR: The SBC should be able to facilitate LCR to optimize costs. This includes: - Dynamic route select...Support: The SBC must support the SIP protocol. Ideal Skills: - Extensive experience with configuring and managing Class 5 Session Border Controllers. - Proficiency in setting up and maintaining Least Cost Routing functionalities. - In-depth knowledge of SIP protocol and its intricacies. - Strong troubleshooting skills for fallback routing options. This project is perfect for someone who can combine technical expertise with cost-saving strategies. Your bid should reflect your experience and capability in th...
I'm looking for ...with live streaming and short video features. - Understanding of multi-vendor e-commerce systems. - Experience working with influencer marketing platforms would be a plus. - Strong UI/UX design skills to create a user-friendly interface. Need to include Pk Battle multi Live, Voice Chat Room Loyalty point multi skin ecom store status points/level I already have those apps listed below., Need to combine the features
I'm in need of a proficient Excel expert who can build macros for automated reporting on a portfolio model. Ideal Skills: - Advanced Excel skills - VBA (Visual Basic for Applications) programming - Experience with building macros for automated tasks - Understanding of portfolio management and reporting Please note, the specifics of the assets and data points for the reports have not been defined yet, so flexibility and the ability to suggest appropriate metrics and assets will be a plus.
I am currently utilizing Excel for VBA automation in my work. However, I am seeking a savvy Excel expert to further optimize this process - making report generation more efficient and effective. -The primary task involves automating the generation of classroom job reports. -Ideal candidates should have prior experience with VBA automation and report creation within Excel. While the focus is on report generation, an understanding of data analysis and formula calculations may also come in handy for this task. Looking forward to discussing how you can help streamline my classroom job reporting process.
I am currently seeking a creative and talented designer to bring my vision for a modern logo to life. The logo will be bright, bold, and embody the spirit of m...The logo will be bright, bold, and embody the spirit of my brand. Key requirements are: - Implementing a modern design style - Utilizing bright, bold colors - Incorporating my company name, a symbol, and a catchy tagline. Business focus is sustainable fishing charters, North Queensland. Ideal applicants should have extensive experience with modern logo design and a demonstrated ability to combine typography, iconography, and color to create compelling visuals. Please provide examples of logos you've designed with similar specifications. Your creativity, originality, and attention to detail will be highly valued i...
I'm looking for a skilled graphic designer to create an engaging and informative flyer for our upcoming middle school volleyball tryouts. Key Details: - The flyer should reflect a professional and straightforward style. - It should include the date, time, and location of the tryouts. - ...Date:TBD (Will provide when confirmation is had) Place: Playcourts Contact Information: Mr. Edouard Classroom: C10 Email: 20379601@ Must add QR code for interest survey Ideal Skills and Experience: - Proven experience in graphic design, particularly in creating promotional materials. - Understanding of the target audience (middle school students and their parents). - Ability to combine professionalism and engaging design elements. - Prior experience in sports-related design would be a...
...facial pictures a and b, Sqirlz Morph would use the equation c = (a + b)/2 to obtain c, the average of a and b. But our new program would assume that the two facial pictures given were not a and b in the above equation but a and c. Solving the equation for b gives b = 2c - a where b is the face that would have to be averaged with a to give c. I have written a very simple program in Python to combine the pixels of two pictures in this way and would be happy to send the code along if that would be helpful. So why don't I just use my Python program for my purposes? Because, of course, manipulating the pixels is the easy part. The code behind using the user-supplied dots to align the features of the faces is way beyond my pay grade. Before running my Python program, I ha...
I have a hard copy membership directory containing about 725 individuals. I need this information transcribed into a spreadsheet. The data includes: - Company name - Contact name - Contact title - Contact phone - Contact email - Address The scanned pages will be organized in a multiple column format. You will need to follow a specific template for the spreadsheet. Ideal skills and experience for the job include: - Proficiency in data entry - Excellent attention to detail - Familiarity with spreadsheet software (Excel, Google Sheets, etc.) - Ability to follow specific formatting guidelines.
...- Formatting text (font, size, color) - Adjusting paragraph formatting (spacing, alignment) - Applying styles and themes (headings, templates) I have unlimited documents that need this kind of treatment, with a mixture of similar and different content throughout. Ideal skills for this project include: - Proficiency in programming languages suitable for automating Word document tasks (Python, VBA, etc.) - Strong understanding of Microsoft Word's formatting features - Capability to create a user-friendly program The goal is to save time and maintain consistency across all documents....
Design Brief: Skilled Designer for Unique T-Shirt Project Project Over...Requirements: - NO STOCK OR AI PHOTOS - Front: "Eavesdrop" formed with bubbles. - Back: Detailed, vintage-style Virginia outline as a beer glass with 'Eavesdrop' in foam and a pin on Manassas. Designer Qualifications: Looking for a designer with a strong background in graphic design, especially in t-shirt design, and ideally with experience in beer-related visuals. The candidate should be able to combine a clear vision with creative flair, resulting in a design that resonates with both state pride and our brewery identity. Objective: Create a visually appealing design that balances state pride, brewery identity, and a vintage aesthetic, ensuring it resonates with our customers and hig...
I need assistance in organizing our screenshots for reviews, which will be used as testimonials for our site. These reviews are for our online 3-day challenge aimed at emerging yoga entrepreneur teachers. Key Requirements: - Organizing reviews in a consistent manner - Matching the organization with our brand colors - Creating a single column list layout for the testimonials Ideal Skills: - Graphic design - Brand consistency - Attention to detail Please note that the reviews need to be organized in image formats such as jpg, jpeg, gif, and png. GDRIVE our screenshot testimonials: The website where your Testimonial list graphics will be uploaded:
I'm in need of someone who can help get my Office Excel VBA program, currently running on Win 7 and MS Office 2003, to also run smoothly on the most recent versions of Mac and Windows operating systems, as well as the latest Office version. The program's main functionalities are automation tasks that include entering data into a spreadsheet via forms and creating various graphs. It is crucial that these key functionalities remain intact. The necessary source code and files will be provided. Ideal Skills: - Proficiency with Excel VBA - Experience with Windows 7, Windows 10, MacOS, MS Office 2003 and latest Office versions - Problem-solving ability - Attention to detail
I'm in search of a skilled individual to assist with a crucial task. Your role would essentially entail copying and pasting data onto the product pages of my website. The key points are as follows: Need data point only column D. Budget 3k data 3AUD - The primary goal of this task is to ensure that information is displayed accurately and appropriately on the product pages. Therefore, attention to detail and precision in data entry are essential. - While the frequency of data updates isn't specifically outlined, it's anticipated that the information will need to be added to the website periodically. So, a level of flexibility and availability is preferred. - The information to be copied and pasted is specifically intended for the prod...
...technology so I can get consistent results. Consistency and reliability are very important to my project. Therefore, only an expert in this field should apply and offer solid background into how they can achieve this. - Data Type: The primary focus will be scraping product information. - Frequency: The script needs to run weekly. The ideal freelancer for this job should have: - Extensive experience in web scraping and Python programming. - Familiarity with platforms like ScrapingBee and Apify or others - Understanding of anti-scraping technologies. - Ability to ensure data consistency and reliability. Filters The web scraping script that is to run on the enterprise scraping service needs to complete the following: I would like to scrape all properties from that meet th...
I have two 1-minute videos of myself from different angles that I need to be combined into a single 1-minute video. Requirements: - Combine the two videos seamlessly with a professional editing touch. - Add CAPTION text to the video representing what I am saying. - Ensure the video quality is as good as the quality of the files I provide. - Visual style should be professional and corporate. Ideal Skills & Experience: - Proven experience in video editing, particularly with multi-angle editing. - Proficiency in adding caption texts. - Strong understanding of maintaining high video quality. - Portfolio demonstrating editing with a professional and corporate visual style.
...the incoming data from Page #1, and they can edit and update the lead every time by themselves The old webpage is here: PHP code for the 2 old pages is attached below. The new pages should auto-detect mobile and laptop screens and render correctly on both. They should be light, easy to load and have a modern design. You can refer to these examples - we are looking for a similar design, but in PHP: 1. 2. 3. IMPORTANT: You will need to create MySQL table to store the data, and an update form separately to update the data. Please see this by clicking "Update" on the right side column of Webpage #2
I'm in need of a professional logo that will serve as the identity of my brand. I am looking for a minimalist, modern design that cleverly combines text and imagery to communicate the values and essence of my brand. Key Requirements: - Design a logo that is modern and minimalist in style - Successfully combine text and imagery to represent the brand - Ensure the logo is unique and stands out - The logo should be versatile and suitable for a variety of applications, including digital and print Skills and Experience: - Proven experience in creating modern and minimalist logos - Ability to effectively blend text and imagery in a design - Understanding of branding and the importance of a logo as a brand identity - Strong portfolio of past logo designs for brand identity I'...
I need a Word document layout for internal team use, following a provided previous layout of a play script. The document will be used by my team for internal purposes. Your job will be to take the layout of a previous script and use it as a templat...for internal team use, following a provided previous layout of a play script. The document will be used by my team for internal purposes. Your job will be to take the layout of a previous script and use it as a template where you'll copy-paste the text of the source Word document. The specifics of the layout are as follows: - 3 columns - 117 pages of source Word documents to be pasted in each column - No images nor illustrations I'm looking for someone who's skilled in Word document layout. Looking for best price,...
NOTE: YOU CAN ALSO COMBINE IMAGES AND PRESENT THEM. I DON'T MIND ORIGINAL ARTWORK, GRAPHICS, AI, OR ILLUSTRATIONS BUT WHAT I ENVISION IS SOMETHING LIKE MOST IMPORTANT: IT SHOULD LOOK REAL AND NOT CARTOONISH AND ALSO LORD RAMA, RAVANA, AND LORD SHIVA'S BODY, ATTIRE, AND COSTUME SHOULD LOOK GOOD. just as help, refer to youtube for prompts on ultrarealistic images, for example - I'm in need of a highly creative realistic graphics or AI image for the cover of my upcoming book on mythology (Ramayana). The image should depict an intense scene featuring Lord Rama and Ravana in combat, with Lord Shiva in between but can be one step back. The following points are key: 1. The image should be detailed and
I am looking for a proficient Python Developer expert in Pandas ETL (Extract, Transform, Load) to assist with extraction tasks for my project. Information needs to be sourced from SQL Server Database. In this project, we'll focus on: - Extraction of data from an ERP using Python and Pandas - Combine and join datasets to maintain the states of data - insert/update to SQL database Ideal Qualifications: - Proven experience in Python and Pandas ETL process - Familiarity with SQL
I need a VBA script that automates sending emails from filtered data in my pivot tables across various sheets. The emails will be sent through Outlook, and the script should be able to handle sending these emails automatically. Key Requirements: - The VBA script should send emails automatically. - The emails should be sent through Outlook to multiple users with defined email subject & email content - The data extracted from the pivot tables should be specific filtered data Ideal Skills and Experience: - Extensive experience in VBA programming. - Proficiency in using Outlook for email dispatch. - Strong understanding of pivot tables and data filtering in Excel.
...transition points in time series in the original scale of the data, and make sense of them. Critical transition in this case could be the change of trend/turning point BEFORE WE GET TO THAT POINT. It could be the percentage level, price point or date. These is a sequential project, meaning you should only move to the next point once you fully complete the current point. Use good visuals The model is already coded, trained, and tested, therefore the original coding should not be changed. Rather, you will understand its inner workings, architecture, structure and replace the savannah rainfall data and tailor the model to detect the critical transitions points in 10 years of gold prices (from 2012-2022) , then try on 10 yrs of US Real GDP data (2012-2022), 10 y...
I need an experienced video producer to create a 60-second product introduction video. This will be made from a provided stock of footage and images, along with scripts. Key Requirements: - Combine and create into a video - Create a professional voice-over - Add sound effects and background music to enhance the video The tone of the voice-over should be strictly professional. The final product will be used for company presentations. Ideal Skills and Experience: - Video Production - Voice-over Artistry - Sound Design - Music Composition - Experience with creating product videos
Tasks to be completed: - Update vehicle selection pop up to display VIN number - Add option on vehicle pop up to copy VIN number - Sort the "Year" column in vehicle selection page and vehicle selection pop up to be in descending order - Allow users in percentage update to revert the changes to original price. - merging above changes to dev branch and deploying to dev instance
Develop a simple automation script that enables seamless data transfer between Excel worksheets and VBA modules. The script should eliminate the need for manual copy/pasting operations, thus saving time and reducing potential human error.
...logo, surrounded by the text "Atif Mega Vision Network." My picture should be rendered in an artistic style, and the logo should have a circular format. please do not use a bandage on my forehead please remove it, I think the b&w picture is more appealing but you make your own decision. please give multiple styles to choose from. Key Requirements: - Incorporate personal branding elements - Combine my image with the business name seamlessly - Create a design that exudes professionalism and trustworthiness Ideal Skills and Experience: - Previous experience with personal branding logos - Proficiency in graphic design software - An eye for detail and creativity Please note that I have omitted specific preferences for colors, fonts, and additional graphical elemen...
I'm seeking an expert in Power Automate to help streamline my processes. The primary focus is on creating workflows to automate email notifications, ensuring no important updates or alerts go unnoticed. Sharepoint list column validations, power apps forms creating views for the permissions. Ideal Skills: - Proficient in Power Automate - Experienced with designing workflows for email alerts - Understanding of SharePoint and Power Apps Objectives: - Develop Power Automate workflows prioritising email notifications - Enhance operational efficiency through automation
