Excel macro concatenate formula number celldela
Hi, I need to link various data between sections in my current Perfex CRM installation. I'll provide you a staging version of the CRM where you can try the customization and then replicate it into the main version. I've attached an explanatory excel where you can see what data is to be shown in other sections of the CRM. (CRM ) Below you can see what data need to be sync in the Perfex CRM. 1. When creating a Lead-related Task, copy the data [Address] [City] [Description] 2. When creating a Proposal related to the Lead, copy the data [Network] In CRM I created a custom Network field (multiselect) for Leads and Customers and the same field within Proposals as well. When creating a proposal associated with a lead or customer the Network data should appear automatically ...
I require a freelancer proficient in excel to assist with data cleaning and sorting tasks for a range of diverse digital files. Your expertise in managing and optimising Excel spreadsheets will be invaluable and greatly appreciated. Key tasks will include: - Using Excel functions to clean datasets, removing discrepancies and inaccuracies - Sorting data into relevant fields and categories for easier access and analysis The optimal freelancer will have: - A meticulous eye for detail to ensure data accuracy - An understanding of Excel formulae and functions - Proven data cleaning and sorting experience - The ability to meet tight deadlines without compromising quality. Your primary role will be to untangle and streamline my Excel spreadsheets, making t...
I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail will be crucial for successful output.
As discussed I have completed the template for Home Team Workbook.
Descripción del Proyecto: Registro de Envíos: Seguimiento detallado de cada paquete, incluyendo número de seguimiento, descripción, fecha de recepción en Miami y estado actual. Dashboard de Control: Visualización clara y precisa de la cantidad de paquetes en bodega de Miami, en tránsito y en bodega/aduana. Base de Datos de Clientes: Gestión de información de clientes, incluyendo nombre, número de teléfono, dirección y saldo recargado de tarifas premium. Análisis de Rentabilidad: Generación de costos previstos para cada embarque, incluyendo costos de transporte, tarifas de aduana, impuestos, entre otros. Cálculo de la rentabilidad de cada embarque y visualización comp...
I'm seeking a home-based freelancer proficient in Microsoft Word, Excel, PowerPoint, Outlook, and Tally ERP 9 for a variety of tasks. Key Responsibilities: - Data Entry: Accurate, timely, and efficient data entry support is a core requirement. - Document Formatting: Assistance with formatting a range of documents, ensuring a professional and consistent appearance. Ideal Skills & Experience: - Proficiency in Microsoft Office Suite: You should have a strong command of Word, Excel, PowerPoint, and Outlook. - Data Entry: A proven track record in data entry, with a focus on maintaining a high level of accuracy and meeting deadlines. - Tally ERP 9: Experience in using Tally ERP 9 is preferred, but training can also be provided. - Organizational Skills: Ability to manag...
I'm seeking a skilled professional to create a web application which automates the extraction of simple tables from word documents and the transfer of this data into a macro-enabled Excel sheet. Key Requirements: - Extraction of simple tables from Word documents - Transferring the extracted table data directly to a macro-enabled Excel sheet - Ensuring the data transfer is accurate and error-free Ideal Skills & Experience: - Proficiency in Web App Development - Strong experience in data extraction and manipulation - Proficiency in working with Word and Excel documents - Familiarity with macro-enabled Excel sheets - Attention to detail to ensure data accuracy and error-free transfer The final product should be a user-friendly, eff...
I require a coder proficient in Ctrader Indicator development to execute my vision. I need an indicator that identifies trend reversals, highlights overbought and oversold conditions and generates buy and sell signals. Specific calculations must include: I would like an indicator for Ctrader which calculates and displays the size of ... I need an indicator that identifies trend reversals, highlights overbought and oversold conditions and generates buy and sell signals. Specific calculations must include: I would like an indicator for Ctrader which calculates and displays the size of a body and total size of the CURRENT candle in the current time frame. It should also display the following on a new line according to this Excel formula: =IF(BODY<=(CANDLE/2);"LLX"...
We have our own ERP...in both scanned image and digital (text-based) formats. - The extracted data from these invoices must be: - Directly integrated into Sales and Purchase Invoice Module for further processing - Exported to Excel/CSV files - Directly integrated into accounting software Ideal Skills and Experience: - Proficiency in OCR technology - Strong background in invoice processing and automation - Experience with integrating software systems, particularly accounting and invoicing modules - Ability to work with both scanned image and digital PDFs - Proficient in data export to Excel/CSV files If you have a track record of successfully implementing OCR-based automation solutions and you're confident in your ability to handle these tasks, I would ...
I need a system that can take data from the existing Excel files and convert them into customized PDF reports. Key Points: - The primary data source is existing Excel files. This means you need to have the ability to efficiently extract and interpret data from these files. - The PDF reports need to be customized with personalized data fields. So, you should be able to dynamically merge data from Excel into the PDF reports. - Proficiency in PDF generation tools and Excel data manipulation is essential. Your responsibilities will include: - Developing a system that can accurately generate customized PDF reports using data from Excel files. - Ensuring that the system is user-friendly and can be easily adopted by non-technical team members. - Working with...
I have a Google sheet where bi I want to send automatic WhatsApp message to people when I enter something on the Google sheet cell this should be automatic and real time
I want to build anything which enables me to send customized whatsapp message as well as images from excel sheets
I want to get a extension which can send messages and images from whatsapp web using numbers and other data from excel sheet
Here is a list of 35000 phone numbers. I need the american country code, +1, added to each entry. There is a way on excel to do this pretty quickly, I just dont know if, hoping you do.
I have an Excel data set that encompasses 5-10 sheets. I need support in: - Data entry: Entering new information into the existing sheets. - Data cleaning: Checking and correcting any errors in the data, removing redundancies. - Data analysis: Conducting basic analysis of data. Ideal applicants should have beginner proficiency in these tasks. Your experience working with Excel data files, especially handling entry, cleaning, and analysis tasks, will greatly benefit this project.
I'm looking for an intermediate Excel expert to create a user-friendly database system for managing contacts and tracking outgoing information. Key Requirements: - Develop a simple yet effective database system within Excel. - Design a user interface that is intuitive and user-friendly. - Ensure the system is structured to manage contacts efficiently. - Implement a feature to track when and what information is sent to each contact. What I'm looking for: - A freelancer with a proven experience in working with Excel and developing databases. - An intermediate level of proficiency in Excel. Advanced skills are not necessary, but a basic understanding won't suffice. - Ideally, I'd like the freelancer to have experience in designing user interfa...
I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.
I'm in need of a professional proficient in Excel and data entry to support two key tasks: data analysis and spreadsheet management. Here are the tasks in detail: - Data Analysis & Visualization: I've collected customer feedback data which need to be efficiently analysed and visualized. - Spreadsheet Creation & Management: The data mentioned above should be incorporated into comprehensible spreadsheets. In terms of analysis, the focus should be on customer segmentation. Ideal candidates should have: - Advanced proficiency in Excel for data analysis and visualization - Strong understanding of data cleaning and formatting to ensure accurate analysis - Experience with customer segmentation based on feedback data.
I'm looking for an experienced data analyst who possesses expert skills in Excel and/or Google Sheets and a proficient understanding of Football, Basketball, and Baseball data. Ideally, someone who is skillful with analyzing and interpreting commercial level sports data into the form a betting model that understands, quantifies, and predicts based on specific metrics. The key characteristics of the models are: - Focus on the following sports: Football, Basketball, Baseball - Analyze the following data: Team performance, Player statistics and Game score projections to forecast point spread, totals, and moneyline bets. I have historical data ready to be applied to these models. This is a project where being communicative, organized, and knowledgeable in sports data ana...
I am searching for a talented designer with experience in creating unique and professional business cards. The key elements to be included are: - Company name and logo - Contact phone number I envision a style that captures classic elegance. The designer should creatively incorporate these elements in a way that maintains a clean and sophisticated look. Previous experience in this type of design would be valued.
as per communication, transfer data from DPF to excel.
I'm in need of an expert in SQL and VBA who can assist with a one-time project. The job will entail: - Writing complex SQL queries - Automating tasks in Excel using VBA - Conducting data analysis and generating reports This will be performed on Microsoft SQL Server. As such, considerable experience with this DBMS is a requisite. Primary skills and experience for the role include: - Expert level proficiency in SQL and VBA - Extensive experience with Microsoft SQL Server - Familiarity with automating Excel tasks and data analysis - Previous experience in report generation This is a one-off project with the possibility of future collaborations for similar tasks. If you have the necessary skills and experience, I'd like to hear from you.
I'm looking for a professional to set up and manage my Amazon, Walmart, and eBay accounts for my product listings. The number of products initially is less than 50. The main goal is to increase sales on all platforms by optimizing the product listings for better search visibility and sales. Key Responsibilities: - Setting up and managing Amazon, Walmart, and eBay accounts - Listing less than 50 products on all the platforms - Implementing SEO strategies to improve product visibility - Writing compelling product descriptions to drive sales Ideal Skills: - Experience in e-commerce product listing, specifically on Amazon, Walmart, and eBay - Proficient in SEO and keyword optimization for e-commerce - Strong copywriting skills for product descriptions - Proven track record of inc...
Hi ITYPE Designs, you guys created a site for me last year, keen to get another site created. Portfolio site for my design company. Landing page About page Projects pages Contact Some functionality which I can provide reference for. I can also provide a number of still slides for these pages as a guide.
I'm looking for a skilled freelancer who can create an automated Excel spreadsheet calculation for me. I need this spreadsheet to perform calculations based on cumulative data, specifically organized by date. You will need to be adept at Excel and have experience in creating automated spreadsheets. Knowledge of data organization and basic statistics would be a plus. I'm looking for a quick turnaround on this project. Please watch my videos for more details on what exactly is required.
In view of capturing a comprehensive B2B database, I am seeking an experienced web scraper who can compile a list of Building Material Supply/Lumber Sales businesses located particularly in Texas, Oklahoma, Arkansas, Louisiana, and Mississippi. Task Essentials: - Collate business data including the Business Name, Business Address, Phone Number, and Email. - Scraping must be performed on specific websites that I will provide. Ideal Skills & Experience: - Expertise in web scraping - Exposure to B2B data collection - Familiarity with the Building Material Supply/Lumber Sales industry - Knowledge of ethical web scraping practices. Your sound abilities coupled with your effective communication skills will be the beacon for this project's success. I look forward to interacti...
...understand what the data says about our operations and ultimately enable us to make strategic project decisions. Details - The task involves analyzing complex financial data associated with our road construction projects. - We need to focus on key financial metrics, including project costs, ROI, profit margins and forecasting future financial scenarios. Skills and Experience - Proficiency in Excel at an advanced level - Background in finance, ideally with a focus in project finance. - Experience in construction sector would be an advantage. - Ability to analyze and interpret complex financial data and present in an understandable format. - Knowledge of financial forecasting and prediction methodologies. This project would demand a keen eye for detail, analytical acumen, and ...
I'm looking for a skilled game developer who can create a game similar to Candy Crush with a dog theme. The game should involve matching three or more dog treats of the same color and shape. The graphics and characters should be dog-themed. The game should have an unlimited number of levels. After the initial 1000 levels, the game should be able to repeat, but with a significantly higher difficulty level. Ideal Skills: - Game Development - Mobile Game Development - Candy Crush Style Game Development - Graphic Design - Experience with Match-3 Puzzle Mechanics - Experience with Dog-Themed Games Please provide examples of similar games you've developed in the past. game requirements include but are not limited to: The game should be based on the idea of Candy Crush, h...
I am in need of an e-commerce website to sell a variety of physical products. Here are some specific requirements: - **Product Categories:** The website will need to accommodate more than 50 different product categories. It's cruci...that the navigation is intuitive and allows for easy browsing through these categories. - **Payment Gateway:** The website should be integrated with Stripe and Zaina payment gateways for seamless and secure transactions. Experience with these payment systems is a must. The ideal candidate should have experience in developing and designing e-commerce platforms, particularly those with a large number of product categories. Proficiency with Stripe and Zaina payment gateways will be highly valued. Please include relevant examples of your previous wo...
Hello, I need several sample drawings to practice SolidWorks. The drawings must be in PDF and must be copywrite-free so that I can share and reproduce them in the software. Please inform the total number of drawings and the value. Thanks.
I'm seeking an experienced digital marketer with a proven track record in increasing app user registration, targeting primarily Arab countries . This capacity is vital as my primary goal is to boost the registration number up to 500k within a month. Your responsibility would include, but not be limited to: - Managing and optimizing existing advertising campaigns to reach more prospects. - Formulating effective strategies for capturing the target demographic. - Outlining projected timelines and key performance indicators. Knowledge in markets and previous experience with apps in the entertainment sector would be advantages for this project.
I'm looking for an Excel expert to automate various tasks relating to our tracking system and create an intuitive dashboard. The tasks will involve automation of formula calculations and report generation, to streamline our data processing workflow, and reduce human error. Key tasks include: - Automate formula calculations: Efficiently automate intricate excel formula calculations. - Automatic report generation: Create a mechanism for generating immediate, error-free reports that highlight key aspects. - Dashboard creation: Design a user-friendly dashboard displaying information based on Automatic report Generation. The ideal freelancer for this job should have: - A deep understanding of Excel's advanced features; - Previous experience ...
Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 2 Hours not more then this, i had the excel to work on just make this on new sheet
...well-versed in the sidereal time system to create an Excel sheet that provides the planetary positions in Vedic Astrology of Sun, Moon, Mercury, Venus, Mars, Jupiter, Saturn, Rahu, and Ketu. The final deliverable should have the planetary positions presented in degrees, minutes, and seconds format and zodiac placement of planet and if the planet is retrograde or not. Successful applicants should provide examples of their past work in Vedic astrology, especially on planetary positioning. A detailed project proposal would also be well appreciated. Ideal skills and experience for the job include: - Programming skills of C, C++, Python or Java and a bit of Vedic astrology knowledge, particularly on planetary positions - Proficiency in Excel - Experience in presenting comp...
I have printed documents that need to be typed into an Excel sheet. The final spreadsheet must also be formatted according to specific requirements. Ideal Skills and Experience: - Proficiency in data entry with high accuracy - Strong understanding of Excel, including: - Use of formulas - Conditional formatting - Data sorting and filtering - Attention to detail to ensure accurate data entry and formatting
Develop financial modelling in excel spreadsheets based on information supplied. This may lead to a long-term ongoing assignment(s) depending on your skill level and capabilities
I'm looking for a Python expert who can develop a script that can take an image URL as input and return the OCR text response. The purpose is to extract numbers with a minimum of 4 digits from images, using only Free OCR tools. The desired output should be a JSON object. The script must support the JPEG and PNG formats. It's unclear how many digits the numbers in the images could have, so the code should be robust enough to handle variable digit lengths. Experience in optical character recognition (OCR) and handling JSON objects are crucial for this project. Specific requirements: - Python coding experience - Knowledge in OCR - Proficiency in handling JPEG and PNG formats - Experience in managing JSON objects Please see the attached images for a better understanding of the p...
Due to the large number of offers, please send me a preliminary model for modification, and send it in private, and I will give approval for the preferred model. I am looking for a designer with experience in color theory and design aesthetics. The project includes changing the colors of the texts and graphics in my current design so that the complete design consists of one or two colors only so that the cost of printing the carton is low, but while preserving the beauty of the design as much as possible and modifying it in accordance with the limits of one or two colors, and I believe that modification is needed more in fruit drawings. who else
I'm seeking a Google Sheets expert to assist me with creating a dynamic client database with a functional search button and also save and modify button . Key tasks will include data analysis, spreadsheet automation, and formula creation. The database needs to store specific information like client name, accountant name, bank names, and sort, amongst others. Ideal freelancers should have extensive experience in Google Sheets with a knack for complex formula creation and automation. Strong data analysis skills will also be useful for this project. Familiarity with creating searchable databases is highly desired.
I'm looking for an Excel expert to handle a set of 10 company accounts from 2014 to 2024. Key Responsibilities: - Data Entry and Organization: The successful freelancer will be responsible for ensuring that all company account data is correctly input into Excel. - Financial Analysis and Forecasting: I need someone with the ability to perform in-depth financial analysis and create accurate forecasts based on the data provided. - Data Visualization and Reporting: You should be able to create professional and easy-to-understand visualizations, graphs, and reports. - Audit and Dashboard: The final deliverables should include an audit of the accounts and a dashboard that provides a clear overview of the financial health of each company. The accounts are currently in digita...
I'm in need of an experienced developer or programmer who can create a modified bar graph for me. The project will require: - The modified bar graph should have basic text labels on the vertical axis. - The design should be clean and professional, ensuring a good user experience. Ideal applicants should have: - Proven experience in creating bar graphs. - Excellent knowledge of the technology needed to implement such a graph. - Strong attention to detail to ensure the labels are correctly aligned and clearly legible.
I have a project that involves converting text from txt format into an Excel spreadsheet. Key Requirements: - I need someone who is meticulous and efficient at data entry. Your responsibilities: - Convert text from provided txt file into an Excel spreadsheet. - Ensure accuracy and maintain proper formatting. Ideal Skills: - Proficient in Excel. - Strong attention to detail. Sample is attached.
I am in need of an expert in Excel to assist with data entry and organization. The work involves entering both numerical and textual data into Excel, and then organizing it by category. In addition, I require the use of data validation functions to ensure the accuracy and integrity of the data. Key Responsibilities: - Inputting both numerical and textual data into an Excel spreadsheet - Organizing the data by category - Implementing data validation to maintain data quality Ideal Skills: - Proficiency in Excel - Experience with data entry and organization - Familiarity with data validation functions - Strong attention to detail This project is ideal for someone who is meticulous, organized, and has a good understanding of Excel functions.
As someone unfamiliar with the specific version of Microsoft excel I'm using, I am seeking a proficient freelancer in handling Excel Automation. To successfully take on this project, you need to demonstrate: 1. Proficiency in Data Entry, Calculation, Analysis and overall Data Manipulation using Excel. 2. Good knowledge across different versions of Excel, since I'm uncertain of the specific version I am currently using. 3. Responsiveness and good communication skills. While the turnaround time for the task isn't defined, I appreciate a quick and efficient service. However, quality should not be compromised. Experience in working across various Excel versions will be an added advantage. I look forward to receiving your bids.
...Managers up to 60 Projects). Output > Requirement 2 > Overarching Gantt Chart showing all projects to create an easy way for executives to see where projects are at in the stages and when the projects are expected to be complete. Requirement 3 & 4 will provide me with an overarching program/portolio view They should cater to a variety of project information, covering: Requirement 1 (Open to Excel or Word Formatting) Individual Project Reports should 1. Project Name and Brief Description, Project Manager/Lead Name 2. Project Stage and Project Type (i would like to choose from a selection/list ) 2. Status Indicators- Overall, Financial, Schedule, Risk and Issue 3. Risks and Issues Details 4. Critical Dependencies 5. Upcoming Milestones 6. Exceptions 7. Start, Fi...
I need a detail-oriented and focused individual who excels in manual data entry to convert data from my physical documents into a spreadsheet. Requirements include: - Transferring data from paper formats into a computer system - Strong typing speed and accuracy - Experience with MS Excel or similar spreadsheet software - Ability to maintain confidentiality when handling sensitive information. Accuracy is absolutely critical for this project, so keen attention to detail is a must. Previous experience with similar projects will be highly regarded.
I require the expertise of a Python developer to convert an excel file for automated task execution. The primary purpose of this project is to automate certain data manipulation tasks, specifically the application of formulas and calculations within the dataset. The chosen freelancer should demonstrate a proficient understanding of both Excel operations and Python programming in order to seamlessly translate the existing manual processes into an autonomous, error-free script. Your application should include any previous experience with similar data manipulation or automation tasks.
...experience in creating modern logos. - Proficient in color theory and can work with a neutral, earthy color palette. - The main element of the logo should be a symbol. The meaning behind it will be discussed further upon project commencement. - Ability to deliver a unique, compelling and memorable logo design that will resonate with our audience. This is an exciting opportunity for creatives who excel in translating brand vision into compelling visual design. Show me your portfolio that showcases your clean and modern design sensibility. Looking forward to seeing your applications! we need a logo for our cushion product used for orthopedic purposes. we have attached a sample logo for reference. we need the source file and all the fonts and elements. If you have any questions p...
...consolidate into a single Excel spreadsheet for my project. The main goal is to have all the information in one place to ease the decision-making process. I'm looking for a freelancer who can help me with this project and provide ideas on how to make this work. Key Points: - The data is spread across a large PDF and a website, and I need it all extracted and combined into a single Excel spreadsheet. - I need product decision, finish, list price, cast Qty, Master Qty, weight, length, and similar details extracted from both sources. - The extracted data should be organized in the Excel spreadsheet with each data point in a separate column. Ideal Skills and Experience: - Proficiency in data extraction and consolidation from PDFs and websites. - Experience in ...
