Macro columns text excel jobs

Hi, we require an SQL macro that we need to be able to delete EAN codes that have less than 8 numbers from the import. So EAN codes that have between 1 and 7 digits must be removed from the import. We use a software called StoreManager that uses SQL. The formulas entered in the software look like this IF([CSV_COL(16)]=0 OR[CSV_COL(16)]=‘’ OR[CSV_COL(16)]<0,‘’,[CSV_COL(16)]) Payment and/or Milestone after the problem has been solved.

I'm seeking a skilled developer to create a website where users can generate customized Excel tables. Below are the key project requirements: Key Functions: - The website should allow users to generate customized Excel tables based on specified criteria such as user input, date range, and data filters. - Implement a user registration and login system to secure user data and table generation history. - Incorporate export options to enable users to download the Excel tables they generate. AI-driven Automation System: - It's important that the system integrates an AI-driven automation system. This will streamline the table generation process while providing accurate and efficient results. Subscription Offering: - The system should offer a subscription model w...

I'm seeking a professional freelancer who can meticulously remove text watermarks from various photographs. - Primary Task: Accurate and subtle removal of text watermarks from my photographs, without affecting any area of the images adversely. - Output: Photographs should retain their original quality after the watermark removal. Ideal freelancer must: - Have a proven track record of handling similar projects and using image editing software competently. - Be detail-oriented to ensure that there is no damage to the original image. - Deliver high-quality, original-retaining photographs promptly. Your handling of this task must uphold the integrity of the photographs while removing the watermarks completely.

The project requires a freelancer with exceptional attention to detail and expertise in Excel to conduct a thorough review of a spreadsheet for any data inaccuracies and anomalies. The primary tasks involve identifying and rectifying incorrect or illogical entries, ensuring the consistency and integrity of the data, and highlighting any variables that require correction. The ideal candidate for this role should have strong proficiency in Excel and data handling, as well as experience in data quality assurance. This meticulous review is crucial to maintaining the accuracy and reliability of the data, which is essential for making informed decisions based on the spreadsheet information. Attached with the details is a sample of the spreadsheet with 20 participants. The complet...

...individual who can handle a medium-sized excel database (1000-5000 rows) that comprises of numerical, categorical and textual data. Key Tasks: - Data Entry: The selected candidate will need to input some outstanding data into the excel database accurately. Great attention to detail is vital for this task. - Data Analysis: I want someone who can decipher patterns and trends from raw data. This may include evaluating figures, trends, and other areas to draw practical insights. - Data Visualization: After carrying out an in-depth analysis, I want the extracted information to be presented visually to aid understanding and decision-making. Desirable Skills: - Proven experience in data entry, analysis, and visualization - Proficiency in using excel for data tasks...

As a beginner, I'm in need of someone skilled in typing data into Excel spreadsheets. The data entry will involve basic formulas and functions for simple data analysis, and I'm looking for someone who can make this process easy to understand and execute. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Able to explain basic formulas and functions in a clear and concise manner - Attention to detail to ensure accurate data entry - Patience and understanding of beginner level tasks

...accurately entered into an Excel spreadsheet. This will be done manually, so you must have excellent typing skills and attention to detail. - **Turkish Characters Proficiency**: An essential requirement for this job is a strong proficiency with Turkish characters. As some of the books will have titles and authors in Turkish, you should be able to accurately interpret and enter these characters. - **Handling Missing Data**: In the event that a book's details are missing or illegible, I would like you to search online for the information. If this is not possible, then the field should be left empty. Please note that I do not want placeholders like "Unknown" used in the spreadsheet. Your responsibilities will include: - Typing in the book title and author accuratel...

...of a freelancer who can help me create a visually appealing PowerPoint presentation and handle some moderate data analysis in Excel. PowerPoint: - Your role will be to make my content visually engaging through simple transitions and animations. - Creativity and a good eye for design are essential to make the presentation impactful for the audience. Excel: - You will also be tasked with handling moderate levels of data analysis and visualization. - I will require you to work with pivot tables, conditional formatting, and possibly other mid-level Excel skills. Ideal Skills: - Proficient in PowerPoint with a strong design sense. - Comfortable working with Excel and able to handle moderate data analysis tasks. - Excellent communication skills to understa...

I'm looking for a Python programmer who can create custom code to extract text, numerical data and dates from an Excel spreadsheet and populate PDF fields using the PDFMiner library. You should be confident writing Python scripts and have experience manipulating Excel and PDF files. Familiarity with PDFMiner is a essential. - Must Haves: - Proven Python programming experience. - Familiarity with the PDFMiner library. - Ability to extract and manipulate data from Excel. - Experience in PDF field population.

I require proficient help to tackle a substantial data cleaning and organization job. The task involves over 2000 records that must be meticulously cleaned and streamlined. You'd be working directly in Excel, so a thorough knowledge of this software is essential. Understanding of data organization, deduplication, and data cleaning is required. Aptitude for managing large quantities of data would be advantageous. A keen eye for detail and commitment to delivering high-quality results are crucial.

...a multi-platform application(both Android and iOS) for my project. The application's primary objectives include: - The conversion of text into speech at the click of a button - The ability to subsequently send the original text via both SMS and WhatsApp without needing to manually open the latter You'd be working with our in-house text to speech engine for this project. Previous experience working with different TTS engines will be advantageous. The app needs to be user-friendly and highly intuitive, enabling seamless interaction for the user. Ideal skills for this job include: - Experience in cross-platform mobile app development - Knowledge of text to speech technologies - Proficiency in integrating apps with messaging platforms like Whats...

I'm looking for someone proficient in data entry to help me transform scanned PDF documents into an organized spreadsheet format. Ideal Candidate: - Proven experience in data entry from PDF to excel or similar - Precise attention to detail to ensure accuracy of the data - Efficiency to meet deadlines with minimal supervision Principal Duties: - Convert scanned PDFs into an Excel spreadsheet - Focus on extracting and entering text content from the PDF documents - Maintain the overall integrity of the original information - Ensure the accuracy and reliability of the final spreadsheet data

I'm in need of an experienced data entry specialist to input text-based data from typed documents into an Excel spreadsheet. I have a series of typed documents that need to be transferred into Excel. The data consists entirely of text, with no specific formatting required. It's important that the freelancer pays close attention to detail in order to ensure the accuracy of the data entry. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Strong attention to detail - Previous experience in data entry - Time management skills to meet deadlines - Ability to do research - Fluency in English

I have a handwritten document that needs to be typed up in a Word document. The formatting required is basic, including headings, paragraphs, and bulleted lists. Key Requirements: - Convert handwritten text into a Word document - Apply basic formatting, e.g., headings, paragraphs, and bulleted lists - Include page numbers Ideal Skills: - Proficiency in MS Word - Excellent typing skills and accuracy - Understanding of basic document formatting - Attention to detail to include page numbers as required If you have experience in typing up handwritten documents and can efficiently manage basic formatting in Word, I'd like to hear from you.

I'm looking for a diligent freelancer who can help with entering text data from handwritten documents into a digital format. Requirements: - Entering text data from handwritten documents - Ensuring general accuracy (minor errors are acceptable) - Organizing the data in a clear and coherent manner Ideal Skills: - Proficiency in data entry - Attention to detail - Patience and perseverance - Basic understanding of the English language The task requires someone who is meticulous and can maintain a good level of accuracy throughout the process. If you have experience with data entry and can ensure timelines are met, I'd love to hear from you.

I design a brand logo for your perfume brand's name. I use the information given to create two options logo for you. I hope you are satisfied with my work and can collaborate with you for the next business.

I'm in need of a serious, detail-oriented freelance virtual assistant for some important data entry tasks. Key Requirements Include: - Specialized in data entry, with strong attention to detail. - Experience with Excel spreadsheet is compulsory because all text-based data entry will be done here. - As this is text based data, a great understanding of English and excellent typing skills are required. - Being well-organized, disciplined, honest and able to complete tasks on time is essential. This job is suitable for someone who enjoys data input tasks with a knack for precision, consistency and quality of work. If you meet these requirements, I want to hear from you!

I'm seeking a talented writer with a nutrition background to create a high protein recipe E-Book for my online training and nutrition coaching business based in Australia, Key project elements: - The book should be in PDF format. - It should include recipes with complete nutritional information, particularly macro breakdowns for each one. - Should include breakfast, lunch, dinner and snack options. - The ingredients should be Australian based- things that are sold in Australia Ideal Skills: - A strong understanding of nutrition, specifically macronutrients. - Experience in ebook writing and formatting, preferably with a focus on recipe or health books. - Ability to create engaging and informative content. - Precise, clear, and concise writing style. Please note, additiona...

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current ...

Create a consolidated financial statement for a transportation sector group. The tasks include: - Translating and reclassifying financial statements from...financial statement. - Paying particular attention to intercompany transactions, as 98% of the branch's revenue comes from the mother company. - Ensuring that intercompany transactions are correctly accounted for in the appropriate fiscal years. - Carefully handling different currencies (RON and EUR) present within the branch. - Producing the final result in English, using Euros as the currency, and in Excel format with notes on intercompany transactions regularized in the correct fiscal years. Requirements: - Certification in financial analysis. - Experience in creating consolidated financial statements. Note: - This pro...

I have less than 50 pages of handwritten notes needing professional transcription and formatting. The right freelancer for this project should: - Have exceptional typing skills - Be detail-oriented t...needing professional transcription and formatting. The right freelancer for this project should: - Have exceptional typing skills - Be detail-oriented to ensure accuracy in transcription - Possess skills in formatting to provide a final document that is both readable and presentable Your job will involve meticulously transcribing my handwritten contents and subsequently formatting the typed text. Previous experience in handling such a project will be a great advantage. Please showcase your skills and experience in your bid. Anticipate a job well-done for potential similar tasks ...

I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.

I am seeking a design professional to create a logo that effectively combines both text and icon elements. The final design should represent a balanced mix of my business nature and abstract concepts. Key responsibilities: - Develop a conceptual visual identity that merges the essence of my business with some level of abstraction - Present various draft proposals before finalizing design - Modify designs to client's satisfaction Ideal skills and experience - - Proficiency in graphical softwares like Adobe Illustrator or CorelDraw - Prior experience in creating logos - Ability to interpret complex concepts into visual designs - Strong communication and listening skills Please note that I have no specific color scheme in mind thus I am open to suggestions. Make sure ...

...aspects: Text to Speech and Speech to Text development: - fix existing code - API integrations - using elevenlabs and assemblyai - Integration of voice to text and text to voice features - Experience in developing RAG web applications Data Analysis: - Strong analytical skills and experience in handling data - Able to provide insights and make recommendations based on data - Proficient in Python data analysis libraries In particular, I need the voice to text and text to voice functionality to be focused on converting text to speech. Ideal candidates for this project should have: - Proficiency in Python, with a strong focus on web development and data analysis - Experience in creating user registration and login features, content manag...

...adept at managing my calendar and coordinating with my contacts. - Managing emails and correspondence: You'll be responsible for filtering and replying to emails on my behalf. - Organizing documents and files: Keeping my paperwork in order is crucial. You should be proficient at filing, archiving, and retrieving documents. The ideal candidate should be well-versed in: - Microsoft Office (Word, Excel, PowerPoint) - Google Suite (Gmail, Google Docs, Google Sheets) - Calendar and scheduling software (Outlook, Google Calendar) In addition, fluency in German and Spanish, on top of English, would be considered a significant asset. This is a long-term role, with no strict deadline for completion. I value professionalism, discretion, and efficiency in my secretary, and I'm e...

I am in need of an Excel expert to help in building a comprehensive Excel file. The purpose of this Excel file is to manage different types of data. This data is of intermediate complexity, consisting of multiple data sources and types. Key Tasks: - Data Analysis: I need assistance in analyzing the data that will be managed within the Excel file. - Formulas and Functions: The Excel file will require the use of various formulas and functions to ensure its smooth operation. - Data Visualization: Help is needed in visualizing the data in the Excel file. Skills and Experience: - Extensive experience with Excel, especially in data management. - Proven ability in data analysis, including the interpretation and manipulation of complex datasets. -...

I am seeking a proficient Excel programmer who can assist me in automating tasks, creating complex formulas and calculations, and generating reports and trading signals based on S&P500 Index data. The ideal candidate should have: - Proficiency in Excel with a strong track record of automating tasks and creating formulas - Experience in generating reports based on financial data, specifically S&P500 Index - Strong analytical skills to ensure the calculations and data analysis are accurate and reliable - Excellent communication skills to understand my requirements and provide regular updates Some of the key responsibilities and tasks include: - Automating the extraction of S&P500 Index data - Creating formulas and calculations to analyze the extracted data - Devel...

I'm seeking a savvy graphic designer with a firm grasp on creating a compelling logo. The ideal candidate should excel at crafting Corporate and Bold designs. Key requirements: - Develop logo consistent with brand identity - Color scheme: Vibrant Colors - Experience in Corporate and Bold style preferred Your portfolio demonstrating similar work will greatly enhance your application. Be ready to provide a draft and work iteratively. This project will involve a creative, charming and bold design to reflect the character of my brand. Your committed engagement till the end of this project is appreciated.

I'm in search of a proficient Excel Macro programmer who can automate data entry tasks with emphasis on numeric data. The ideal candidate would deliver a macro that inputs numbers into Excel and uses "if, then else" logic to perform specific tasks. Essential skills include: - Extensive experience with Excel Macros - Solid understanding of data entry automation - Proficiency in working with numeric data - Good grasp on logical functions especially if, then else Your primary function will involve interpreting requirements and programming the macro to swiftly and accurately complete data entry tasks. Please ensure your portfolio showcases relevant work.

I'm in need of a professional who can create a 20x20 inch door decal for me by 7pm. I have the logo I need the hours and social media under the logo all of the text is provided, Put the hours directly under the logo. Please use instagram icon for Instagram instead of words. Put the mail icon for email. WHITE TEXT: Monday 12-7 Tuesday 12-7 Wednesday 12-7 Thursday 12-7 Friday 11-8 Saturday 11-8 Sunday 12-5:30 Instagram: @ lluxecafe Website: www. Email: lluxecafe @

I need a skilled Adobe Illustrator designer to modify existing image elements to more closely resemble another provided sample. The modifications required are: • Changing the layout by resizing and rearranging elements. • Textual changes: Changing the font type, adding new text content, and deleting unnecessary text. • Updating existing chart images with new data. Prior experience with layout modification and text editing in Adobe Illustrator is ideal.

I have included examples of each of the following files I would like to have: - Each US state in a vector EPS file with a cut line. Each as their own file name. - A photo of each with dimensions - A mock up photo of each state decal on the back window - An excel sheet with all the states and associated dimensions Example: North Each state .EPS cut file would need to be within a 3.5" x 5.5" rectangle or a 5.5" x 3.5" rectangle. Whichever best fits the state. I have attached an "Examples" file as well that gives further instruction for setting up the file. There are 50 States. I will need 3 folders: 1- Cut Files (50 .EPS files) 2- Dimension Photos (50 Photos) 3- Mock Up Photos (50 Photos To find all the state outlines, you will need to Googl...

I'm urgently seeking a freelancer who can assist in modifying the formatting in a PDF file I have. Your responsibilities will include: - Adjusting the text charges in the document. Ideal candidates for this project will have excellent attention to detail, proficiency in working with PDF files, and the ability to work swiftly as this task needs to be completed ASAP. Knowledge of diverse formatting styles will be a real asset. Please provide examples of similar work you've done in your proposal.

I have a level sensor which is currently sending data to a local Wi-Fi network, accessible through a web brows...through a web browser using the sensor's IP. I'm seeking assistance to automate this process and have the following requirements: 1. Data Fetching: The sensor is measuring liquid levels. This specific information needs to be fetched and transferred directly to an Excel sheet. 2. Data Update Frequency: The data should refresh in the Excel sheet every minute. 3. End Goal: The collected data will be used to generate a chart in Excel. Ideal skills for this project would include extensive experience with automation, proficiency in Excel, and understanding of level sensor operations. Knowledge of networking would be a plus. Are you the right p...

I'm seeking a proficient developer to build a user authentication and authorization system using JS, Node.js, and MySQL. The core function of this project will be role-based access control. Key Features: - Role-based access control system: The system should be able to accommodate three different roles - Admin, User, and Guest, each with different permissions. Ideal Skill...sent to the relevant address based on the campaign. • I have a list of ASM email addresses from a Company. I'd like to trigger emails to each of the ASMs on the list. (Campaign wise)" 8. Download Reports: • Include Camp Details Entry Date: This option focuses on the purpose of having the date - to track when the camp details were entered. • To select Date Range • To Select HQ Wise ...

I'm in need of a proficient Smartsheet expert to assist me in recommending and developing multiple program and project plans. I want to work with expert on a shared screen to help me to learn as we go. I need someone fluent in English - I have a little hearing loss Key responsibilities will involve: -Building SMARTSHEET plans -- Linking to External data (i.e. Excel) that will be used in updating the SMARTSHEET plans. - Utilizing SMARTSHEET Functions: Proficient use of formulas and calculations is essential for this project. - Building Reports and Dashboards: Experience in creating comprehensive and visually appealing reports and dashboards is necessary. The primary goal for this project is to efficiently and accurately track the progress of different projects within the ...

*** US CANDIDATES ON...background to manage various tasks. Key Responsibilities: - Budgeting: You'll be responsible for creating and monitoring budgets to ensure financial health. - Expense Tracking: Accurately log and keep track of expenses to maintain a clear financial picture. - Invoicing: Prepare and send invoices to vendors and clients in a timely manner. Your Experience: - Proficiency in Excel: Since I currently handle finance using Excel, it is essential that you are comfortable with this software. - Previous Finance Management: Experience in budgeting, expense tracking, and invoicing is a must. - Strong Communication: Being able to keep me updated and informed on financial matters is key. Please highlight your relevant experience and how you can support me in ...

I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.

I need a diligent individual to assist with meticulous data entry into less than 25 tables and slides. The data to be entered is a combination of text and numerical data which I will send. Ideal freelancer will have: - Proficiency in data entry with strong attention to detail - Proficient use of PowerPoint Your primary task will be to enter data and headings into already-created table/slide templates. Typical table will have three columns and 3-5 rows. See attached examples. Successful completion of this task requires precision and accuracy to ensure the information is captured correctly.

I'm looking for an expert in Excel to build a comprehensive 'Team Scorecard' for my team. This sheet will be used to track a range of tasks and behaviors to ensure the team is performing at their best. Key Features: - The project involves tracking various tasks and behaviors including daily reports, client communication, social media postings, timekeeping, invoicing, and meeting attendance. - I need the sheet to calculate total and average points automatically. This will be based on the tasks completed and the quality of those tasks. - It should also include conditional formatting to highlight outstanding performances. This will help us recognize and reward exceptional work. - Data validation is important to ensure accuracy and consistency in point entries. - Visu...

I'm in need of an experienced sales agent who will work as a representative for my travel consulting services, focusing on individual clients. Key Responsibilities: - Promoting and selling my consulting services - Establishing new relationships with indiv...for my travel consulting services, focusing on individual clients. Key Responsibilities: - Promoting and selling my consulting services - Establishing new relationships with individual clients - Providing expert advice on travel solutions You're a great fit if you: - From Taiwan - Have prior experience in sales, especially in the field of consulting - Understand the travel solutions market - Excel at building customer relationships over diverse clientele. I look forward to boosting my travel consultancy service s...

Please Sign Up or Login to see details.

I'm in need of a modern, sleek logo that combines both text and an icon. The logo will be used primarily on my website and on product packaging. I have a preference for a black color scheme, though I'm open for suggestions. Key points: - Modern, sleek logo design - Combination of text and an icon - Primarily for website and product packaging - Preference for black color scheme, though open to suggestions

I require a skilled and experienced web developer to create a custom HTML emailer for me. The emailer should be compatible with both Outlook and Gmail. Here are the specifics of the project: - You will be provided with a JPG image that will form the basis of the emailer. Your task will be to incorporate a single line of hyperlinked text in the middle of this image. The hyperlink should lead to a designated URL. - The emailer should be designed to display correctly across different email clients, especially Outlook and Gmail. The ideal candidate for this project would have: - Proven experience with creating custom HTML emailers. - Proficiency in working with JPG images and integrating hyperlinks into them. - A good understanding of the unique constraints and requirements of emai...

I am looking for an experienced Scala developer to implement a specific functionality in a data processing environment. The aim is to process text data more efficiently. Key Requirements: - Deep knowledge of Scala and spark - Proven experience in data processing, notably with excel, json and text data - Ability to deliver clean and efficient code The ideal candidate should be able to show previous projects where they successfully implemented or improved similar functionalities.

I need an expert to conduct a color analysis on an apparel website. Your task involves studying product images and employing Adobe Illustrator's eye dropper tool to identify the hexcodes for each. Main objectives include: - Identifying hexcodes for main colors using Adobe Illustrator - Organizing the hexcodes by clothing type - Completing the provided Excel Sheet Your role is critical as the information will be utilized in color trend analysis for apparel. Therefore, a proven background in graphic design, color profiling, knowledge of Adobe Illustrator and an eye for fashion would be ideal. My budget for this project is 100 USD. Please, proficient users of the English language only for accurate communication.

...an online system to replace the use of Excel sheets for data storage and calculations. The system will need to have: - Data Entry and Storage: It should be able to handle both numerical and textual data effectively and efficiently. - Automated Calculations: The system should be designed to automatically handle basic calculations such as summations and subtractions. To ensure the system is user-friendly and can handle our basic data management needs, you must have a solid understanding of relational databases and be proficient in web application development. Experience in designing systems with automated calculations is a big plus. A keen eye for user experience and the ability to follow design guidelines is also appreciated. We have an example excel sheet that can be s...

Please implement a one page website that is essentially a text editor similar to HemingwayApp dot com. For the full specs, please see the attached PDF file.

I need an experienced data entry specialist to input an extensive amount of text data. This project will involve: - Entering over 500 records of text data efficiently - Ensuring 100% accuracy in data entry, as this is of utmost importance Comprehensive attention to detail, past experience with large volumes of data, and proven accuracy in data entry are essential skills needed. All work will be cross-checked for precision.

...client profiles Creating and managing client and user profiles, including assigning users to clients or groups In essence, the app should allow for the creation of client profiles with customizable fields. JSON data received from devices in alarm states should be stored in Firebase, linked to client profiles via device ID, and trigger alarm notifications on the user's app until acknowledged. To excel in this project, you should possess: Strong proficiency in Firebase and Flutterflow, along with cloud functions Previous experience in building intuitive and responsive mobile applications Attention to detail, particularly in implementing a reliable alarm system Effective communication skills to understand and execute project requirements Note that user registration and authen...