Combine columns excel using vbacông việc

...marketing and content execution. Please ensure to track social media engagement as a key performance indicator. We are looking for candidates with mid-level experience. We are looking for entry-level candidates. The content should primarily be promotional. The company focuses on the technology sector. The primary goal for the digital marketing efforts is to increase brand awareness. Applicants should excel in content creation. Remote candidates are welcome to apply. educational products and services Expertise in social media management is highly preferred....

Clean home page: slider, attractive promotions, well-organised categories, no duplication. Footer with appropriate links, no words in English. Clean product and category pages (advanced filters, appropriate images). Optimised shopping basket and payment. Mass import of products via Excel file. ATUM confirmed for stock management. Delivery methods configured (zones and extensions). Site ready to inspire confidence and sell.

I'm seeking assistance in extracting numerical data from individual stock pages on a website and storing it in an Excel file in a specific format for multiple stocks. This needs to be done monthly. - Data Points: The data points to be extracted include various metrics like annual sales, operating profit margin (OPM), net profit, and others. - Excel Formatting: The extracted data needs to be stored in a particular format in Excel. Ideal Skills: - Proficiency in Excel - Experience with web data extraction - Attention to detail to ensure data is accurately captured and formatted. Please note, I need this to be set up for monthly updates.

I am looking for a data operator to assist with a complex data entry project. The ideal candidate should have experience in data entry from digital files, specifically using Microsoft Excel. The work involves significant formatting and clean-up of the data. Skills and experience required: - Proficiency in Microsoft Excel - Strong attention to detail - Ability to handle complex data entry tasks - Experience in formatting and cleaning up data If you are meticulous, experienced in data entry, and proficient in Microsoft Excel, please apply for this project.

Clean home page: slider, attractive promotions, well-organised categories, no duplication. Footer with appropriate links, no words in English. Clean product and category pages (advanced filters, appropriate images). Optimised shopping basket and payment. Mass import of products via Excel file. ATUM confirmed for stock management. Delivery methods configured (zones and extensions). Site ready to inspire confidence and sell.

I'm looking for a highly skilled tutor in Excel and KoboToolBox to teach me data collection/visualization/evaluation. Excel: - Help me improve my data analysis skills - Explain complex concepts in an easy-to-understand manner, provide practical examples, and guide me through various data analysis tasks KoboToolBox: - Creating surveys - Teach me how to collect, visualize, and evaluate data Ideal Candidate: - Strong background in data analysis, proficient in Excel, and highly experienced in using KoboToolBox for data collection. - Excellent teaching skills, patience, and the ability to adapt to my learning pace.

I...creative website designs - Understanding of color theory and ability to work with bright and vibrant colors - Knowledge of current web design trends and principles Here are a few of the mandatory requirements for the website design: 1) The main design needs to be 980 pixels in width. 2) The main header graphic needs to be 980 pixels wide x 250 pixels high 3) The body of the website needs to have two columns with these dimensions: 730w large column on left, 250w small column on right 4) Footer dimensions will be 980pixels wide x 100pixels high You can see the attached image to get a general understanding of the dimensions and structure of the website design. If you are able to do this project bid on the project and I will provide a more detailed description of what needs to be ...

I'm looking to implement a day trading strategy using an automated trading setup in Excel with the Shoonya Finvasia broker. This setup will focus on trading options. Key Requirements: - The system must be capable of automated order execution. This is crucial as it will allow for timely responses to market movements. - The system should have a backtesting feature to test trading strategies on historical data. Ideal Skills and Experience: - Proficiency in Excel and experience with creating trading systems within it. - Familiarity with day trading strategies, specifically in options trading. - Understanding of automated order execution systems and their integration within Excel. - Prior experience with the Shoonya Finvasia broker would be a significant advan...

I'm in need of an Excel Macro specialist who can assist in extracting tables from multiple PDF files into Excel. Budget - 20 Max Key Requirements: - Expertise in Excel Macro development - Experience in data extraction from PDF files, particularly tables - Ability to deliver a quick turnaround Ideal Skills: - Proficient in Excel and Excel Macro - Skilled in handling and processing PDF files - Fast and reliable with a strong attention to detail. Please note, the task involves multiple PDF files, so the ability to handle bulk data and automate the process efficiently is crucial. I look forward to your bid and your proposed timeline for completion.

...International Yoga Teacher and Therapist, I inspire and educate people how to change and transform their lives. As an international teacher, I have taught in Australia, New Zealand, Peru, and Mexico and have assisted hundreds of people to find inner peace through yoga, meditation, & counselling. As a Coach and Therapist, I have pioneered a wholistic approach that assists people to transform their lives, using Yoga Therapy and Somatic Psychotherapy. This work has been recognised for assisting and affecting positive change in hundreds of people particularly those who suffer from anxiety and depression disorders. As am Empath & Intuitive I also communicate with animals and nature and teach people how to connect with the magic of life in this you want to create profound...

I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.

I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.

...want to target specific job titles within various industries, focusing primarily on the technology sector. Target Job Titles: - CEO/Founder - Technology head - Instrumentation head - Quality head - Digitization manager - Methods and process excellence The primary focus of this project is on gathering phone numbers of these targeted users. However, the deliverable should also include a CSV or Excel file with validated data points such as names, job titles, company details, and contact information. Along with this, a brief report detailing the scraping methods used would be appreciated. Your proposal should include your budget and an estimated timeline for project completion. Essential skills include: - Proficiency with web scraping tools - Experience with LinkedIn and Crunchba...

I'm seeking an Excel expert proficient in creating complex formulas. The task involves working with financial data. The project is a test for a Financial Planning and Analysis (FP&A) profile, consisting of three questions. The formulas need to generate accurate financial projections.

I would deliver scrapping result for all the states

...data untuk kebutuhan sales pipeline, segmentasi pasar, serta enrichment data ICP dan buying committee. 3. Membantu penyusunan laporan metrik kampanye, revenue, serta administrasi program awareness dan demand generation. 4. Kerja 4 Jam Sehari, Mulai dari jam 13.00-17.00 WIB secara online, wajib responsive Yang Saya cari: 1. Pengalaman dalam riset data, analisis, dan tools seperti Google Sheets/Excel. Familiar dengan teknologi CRM (LinkedIn, Salesforce, HubSpot, dll) jadi nilai plus. 2. Familiar dalam menggunakan tools dan teknologi seperti ChatGPT, Google Advance Search, Metabase, dan AI lainnya. 3. Detail-oriented, bisa kerja mandiri, dan mampu memenuhi tenggat waktu. 4. Kemampuan komunikasi baik, terutama dalam menyajikan data secara jelas dan terstruktur. Email to (Removed b...

I'm seeking a fashion or illustration designer to create a one-of-a-kind, realistic-style hat design for a mom and her baby. The hats should be adorable, soft pastel-colored and inspired by both dinosaurs and capybaras. Id...one-of-a-kind, realistic-style hat design for a mom and her baby. The hats should be adorable, soft pastel-colored and inspired by both dinosaurs and capybaras. Ideal Skills & Experience: - Fashion design or illustration experience, preferably with children's clothing - Ability to create realistic and adorable designs - Understanding and experience with pastel, soft color schemes - Ability to creatively combine elements of both dinosaurs and capybaras - Knowledge of textiles and materials suitable for children's hats. The hat design should...

I'm looking for an Excel specialist who can help me compare three files containing inventory data. Specifically, I need to identify quantity discrepancies and item mismatches. Key Responsibilities: - Compare data across three Excel files - Identify quantity discrepancies and item mismatches - Create a separate summary sheet highlighting these differences Ideal Skills: - Proficiency in Excel with extensive experience in data analysis - Detail-oriented with a knack for spotting discrepancies - Ability to organize data in a clear and concise manner

I need an Excel expert to design a spreadsheet for me that includes various charts and graphs for data visualization. The project specifically requires the creation of bar charts and pie charts. Ideal Skills: - Proficiency in Microsoft Excel - Experience in designing custom Excel spreadsheets - Ability to create clear, effective data visualizations Please note, the main purpose of the Excel file has not been defined yet, hence flexibility and adaptability will be key in this project.

...Features: View a list of all users who have signed up for membership. Filter users based on membership type, registration date, etc. View each user’s details, including form data (e.g., name, contact information). Approve or disapprove membership requests if necessary. Download or export user data to CSV/Excel for reporting purposes. See statistics about user sign-ups, including total users, active/inactive members, etc. 5. Data Security: All user data must be securely stored (preferably using encryption for sensitive data such as passwords). User passwords should be hashed and not stored in plaintext. Admin should have access to manage user data but should only view sensitive information when necessary. 6. Design & UX: Responsive Design: The website should be re...

I'm looking for a skilled Excel Macro specialist to automate the importing of data from PDF files into my Excel spreadsheet. Fixed Pay - $20 Key Responsibilities: - Create an Excel Macro to automate data entry from PDF files into Excel. Ideal Skills and Experience: - Proven experience with Excel Macros. - Proficiency in data manipulation and automation. - Familiarity with importing data from PDF files. - Excellent problem-solving skills.

I'm seeking a proficient developer to create an AI agent for me. The agent's primary function will be to locate fitness-related businesses in multiple specific regions. The collected data will need to be organized into an Excel table, including details such as: - Name and website of the business - Location and contact details - Person name and job title An example of the task would be finding all personal trainers in Redcliffe, Australia, Postcode 4020. Ideal Skills and Experience: - AI and machine learning development - Data mining and web scraping - Proficient in Excel and data organization - Understanding of fitness industry would be a plus

I'm looking for someone to help me create a financial model in Excel focused on budgeting. The primary task will be filling in the blanks with the appropriate formulas. Ideal Skills: - Proficient in Excel - Experience in financial modeling - Knowledgeable in budgeting processes Please ensure your proposal highlights relevant experience and skills.

I need assistance with matching two lists of brand and company names. The data is in Excel format. - The first list has 4 columns and the second list has 1 column. - The type of matching required is 'fuzzy match'. Ideal skills for this project include proficiency in Excel, experience with data analysis, and knowledge of fuzzy matching techniques. The work needs to be completed by Friday morning India time .

Je recherche un professionnel ayant de solides compétences en Excel et en design pour améliorer la présentation visuelle d’un document Excel utilisé pour des présentations clients et la génération de rapports PDF. Domaines clés à améliorer : Mise en page générale Graphiques et diagrammes Schémas et illustrations Le candidat idéal devra : Avoir un œil attentif pour un design moderne et élégant Être capable de rendre les présentations clients plus attrayantes Améliorer l’esthétique générale du document Excel sans compromettre sa fonctionnalité Vous devez être capable de comprendre le fra...

I'm looking for a skilled developer to transform my MS Excel files into a functional web application. Key Requirements: - The web application should be focused on data entry and form submission. - It should be compatible with desktop only. Ideal Skills: - Proficient in web application development. - Experience with data entry and form submission interfaces. - Understanding of desktop compatibility requirements.

I'm looking for a freelancer who can download numerical data from a specific website and organize it in an Excel spreadsheet. The data is updated daily every 3 min, so this will be a regular task. Requirements: - Download and organize all available numerical data columns from the website into Excel. - This task needs to be done daily in sync with the website's updates. Ideal Skills: - Proficiency in Excel and web data extraction. - Attention to detail and ability to follow daily schedules.

I'm looking for a professional Excel macro developer who can help me create a macro that extracts specific information from one Excel file and organizes it into another new Excel file. Key Requirements: - The Macro should be able to extract specific information from Sample A and make it into an organized Excel file exactly like Sample B. - NOTE: Sample A will have Comments on what specific information will be extracted and become Sample B. Hover over them to view the comments - NOTE 2: If some of the information in Sample A is Blank, then leave them blank for Sample B Ideal Skills: - Proficient in Excel, especially in creating and implementing macros. - Experience with data organization and manipulation in Excel. - Strong attention to detai...

The objective of this project is to produce an instructional video utilizing Kali Linux to transmit an observer file to a WhatsApp number. This endeavor is intended solely for educational purposes. The following requirements must be met: 1. Kali Linux must be accessed via Oracle Virtual Machine. 2. The video should detail the process of creating the file in formats such as PDF, JPG, Excel, Word, or even video or audio files. 3. The file must be recognized as safe by WhatsApp and Android security measures. 4. The file should enable the sender to view the gallery photos and camera of the WhatsApp Android device. 5. The file must not contain any malicious algorithms. To receive payment, you must demonstrate that you have successfully completed the aforementioned steps. 1. The...

I'm looking for a skilled data scientist with experience in building recommender systems, specifically using Graph Neural Networks (GNN) models such as LightGCN and GraphSage. The project involves creating a personalized recommender engine for cryptocurrencies. Key Requirements: - Utilizing diverse data sources: The recommender engine should leverage transaction data, social media trends, and market prices. - Primary objective: The main goal of this engine is to maximize investment returns. - Personalization: The system should tailor recommendations based on the user's past transactions and their preferred cryptocurrencies. - Integrate real-time data feeds from various cryptocurrency exchanges and social media platforms. Ideal Candidates: - Proven experience with GNN mod...

I'm looking for a data vendor who can provide a list of homeowners in Los Angeles, California, who have expressed interest in home improvement within the last two weeks. The list should include: - Name and contact details - Property details - Type of home improvement needed - List phone numbers for quick contact. Please deliver the list in an Excel spreadsheet. Ideal candidates for this project should have experience in data collection and analysis. They should be able to provide accurate, up-to-date information in a timely manner. Knowledge of the home improvement sector would be a plus.

I'm looking for a skilled Power BI professional who can create multiple operational reports. The data primarily comes from Excel spreadsheets and will be processed through Power BI. Your proficiency in Excel is crucial. Key Responsibilities: - Create operational reports in Power BI - Utilize Excel spreadsheets and Power BI as primary data sources Preferred Skills: - Mastery in Excel - Expertise in Power BI - Experience in creating operational reports Ideal Candidate: - Able to create visualizations such as bar charts and graphs, pie charts and doughnut charts, and heatmaps.

Need Freelancer for development of excel spreadsheet tool for financial projections, scenario analysis and presentation materials for same. Spreadsheet function is to calculate cash position and standard EBIT/EBITDA information from 2023 to 2040 (pre-revenue through profitability) for a (renewable energy) technology development and licensing company: not manufacturer, not a software developer, nor SAS provider. The basic financial structure includes simple operating cost structure, project-based revenues, non-operating income, minimal capex and equity infusion. Project Revenue Types are: • License payments based on milestones related to tangible progress for design, construction and commissioning of commercial and annual annuities (royalties) based on plant capacity (or ...

I need assistance exporting quotes from an Excel price list into a Word document. The quotes should be organized by product category. The exported quotes should include the following details: - Product name and price - Vendor information - Quote expiration date Ideal skills for the job include: - Proficiency in Excel and Word - Attention to detail - Organizational skills

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

I'm looking for an Excel expert to create a variable tracking Excel file for me. I will be inputting a list of 1000 or more 3-digit numbers (ranging from 1-5) like 123, 231, 542, etc. Key Requirements: - Track the movement of each digit (whether it's +1,2,3, or 4 or -1,2,3,4, and also 0 when the number remains the same in the next sequence). - Provide a tally of movements for each digit in each position. For example, digit 1 in position 1 moved +1 75 times into the next sequence, +2 100 times, and so on. - Allow me to constantly update the list of 1000 numbers. - I will be copying and pasting the numbers into the file. Outputs/Reports Needed: - A summary table that presents the movements in a clear and comprehensible manner. - Please use standard formatt...

I'm seeking a detailed contact list of roofing, restoration, and mitigation companies located in California & Florida. The list should be compiled into an Excel sheet and include: Construction Companies: 1. Mitigation 2. Restoration 3. Reconstruction 4. Roofing 5. Water, Fire, Hail Damage. - Company name and address - Phone number and email - Key contact person's name and role - Specific roles such as Owner, Sales Managers, and HR Ideal skill set for the job includes proficiency in data collection and Excel, and ideally, some experience or understanding of the insurance roofing and restoration industry.

Renders de 5 productos ( primeros 4 del excel + muestra) con sus dos variaciones de cada uno

I need help analyzing a list of companies in Excel and identifying duplicates based on specific criteria. Your task will also involve assigning MTAuIDs to these companies according to a set of rules. Key Requirements: - Identify duplicate companies based on their Business Name - Assign different MTAuIDs to Joint Ventures - Assign the same MTAuID to DBAs, CEOs/Presidents, Trade Name companies, AKA companies, and divisions The list of companies includes additional key attributes such as Address, Email, Website, Phone numbers, and Type of Business. Please provide a description of your approach and the code you will use to solve this problem. Ideal candidates should have experience with data analysis, coding, and understanding of business structures.

I'm seeking a data entry expert to assist with entering menu information. Specifics about the menu type, the data format, and the manner in which it will be provided are yet to be determined, but the need is immediate. Ideal Skills and Experience: - Proficient in data entry - Excellent attention to detail - Able to work under time pressure - Familiarity with common data entry software (Excel, Word, etc.)

I'm looking for an experienced data scraper who can gather information from various social media platforms. Ideal Skills: - Proficient in web scraping techniques - Familiarity with social media platforms - Excel data management skills The scraped data needs to be compiled in an Excel format. The specifics of the data to be scraped will be discussed in further detail with the chosen freelancer. Please include relevant experience in your proposal.

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

I'm looking for a skilled data parser who can extract product information from a specified website and organize it into an Excel spreadsheet. The data that needs to be extracted includes product descriptions. Ideal candidates for this project should: - Have experience with web scraping and data parsing - Be proficient in Excel - Have an eye for detail to ensure all data is correctly captured and organized.

...analytical skills and the ability to interpret quantitative and qualitative data. •Knowledge in validating information sources and critically analyzing data. •High level of English proficiency (C1 or higher) with advanced writing and editing skills in English. •Experience working with business intelligence reports, impact metrics, or financial analysis (preferred). •Familiarity with data analysis tools (Excel, Power BI, Tableau, etc.) is a plus. •Attention to detail and ability to manage multiple reports simultaneously. Key competencies: •Critical thinking and ability to detect inconsistencies. •Accuracy and attention to detail. •Ability to synthesize and communicate clearly. •Autonomy and proactivity in problem-solving. •Adaptab...

I need my Excel worksheet polished for print. The project involves enhancing the current layout of the worksheet, specifically to optimize it for printing. Key Requirements: - Adjusting the page layout and margins to ensure the worksheet is print-friendly. - Creating a green color scheme that is suitable for printing. Ideal candidate should have: - Proficient Excel skills especially in layout enhancement. - Experience in creating print-friendly documents.

I'm looking for a detailed Excel spreadsheet that covers the top 20 social media accounts for every sports team across the NBA, AFL (Australian rules football), NFL, MLB, IPL and international cricket. The accounts should span Twitter, Instagram, TikTok, and news outlets. Specific Requirements: - Top 20 Twitter accounts - Top 20 Instagram accounts - Top 20 TikTok accounts - Top 20 news outlet accounts - top 20 journalists covering the team - top 20 player accounts Each entry should include: - Account name - Profile link - Number of followers - Engagement metrics - Average post frequency: The average number of posts per day or week. Ideal Skills: - Proficiency in Excel - Familiarity with social media platforms - Ability to gather and analyze engagement metrics - ...

...growing team. Professional development and growth opportunities. To Apply: When applying for this role please include reference ATCMAX250127B when you provide an overview of top 4 reasons you feel you're suitable for this North American role. All applicants must past up to 2 levels of practical assessments to be considered for this which includes an Excel assessment. If you're not highly proficient in analyzing large amounts of data in Excel or equivalent, please don't apply....

I am trying to develop an app that automatically synthesizes two images in the app and shows them in the app. The development budget is fixed at $400. Initial version. Please note that I do not speak English, so use of a translator is essential.

...archivo pdf de buena calidad con 10 - 14 que no todas las hojas tienen tablas, el archivo que este en una carpeta llamada pdf y se tiene que extraer solo las tablas y pasarlas a otra carpeta llamada procesadas a un archivo Excel con el nombre de la primera hoja. Disponibilidad inmediata del Freelancer para ponernos de acuerdo en detalles. Si no hay comunicación por más de 8 horas o tarda demasiado en aceptar el trabajo se cancelará y publicará el proyecto de nuevo. 1.- Scripts en Python pdf a excel 2.- pdf en la carpeta llamada pdf 3.- extraer las tablas y hacer un archivo Excel con nombre de la primera hoja del pdf en la carpeta procesadas. 4.- cuadro de salida en Looker, power bi o tablear. Plazo de entrega 1 día máximo 1...

I'm looking for a professional to help me with a project involving two of my websites. I need all Elementor it...Sites are and www.apexambientair.com. Ideal Skills: - Proficient in WordPress and Gutenberg - Experience with Elementor - Ability to manage website content migration - Attention to detail to ensure all Elementor items are replaced Key Requirements: - Remove all Elementor items from the two websites and delete Elementor plugin. - Replace removed Elementor items with 'Columns' Gutenberg blocks - Ensure the websites maintain their functionality and design aesthetics post-migration. This project is crucial for my websites' performance and I am looking for someone who can efficiently and effectively carry out this task. Looking forward to your propos...