Excel vba get active cell row number jobs

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

...exclusion criteria and providing a document containing the output. The details of the literature search can be found in the following link. The candidate performing the job should be skilled in performing medical literature database searches, able to collate the results and write an academic document containing citations style of Vancouver Style. There is no restriction on the number of words. Requirements: - Conduct a thorough search on PubMed focusing on Medical Informatics - Provide a detailed summary of abstracts found in the search - Ensure the search is comprehensive and up-to-date Ideal Skills: - Proficiency in using PubMed - Knowledge and understanding of Medical Informatics - Ability to summarize and report on the search results Please ensure that you have experience

...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen co...

I need a Python script that can batch process text overlay onto images (jpg/png). All the images and all the text will be unique. Each set of text(s) (1-2 sentences) will have its own unique image. (one-to-one) I would like to have a CSV file containing all the unique sets of text. The script would reference a folder of images. The script needs to be able to handle 20-200 images....will be unique. Each set of text(s) (1-2 sentences) will have its own unique image. (one-to-one) I would like to have a CSV file containing all the unique sets of text. The script would reference a folder of images. The script needs to be able to handle 20-200 images. I would like to be able to change the font style, size, the position on the image, and to have the text be able to wrap to the next row on ...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

I need a skilled photographer to take a large number of high-quality images of industrial parts at specific location(s). Requirements: - Expertise in product photography, particularly with industrial parts. - Ability to shoot more than 50 photos. - Flexibility to work on-site at various locations. - Proficiency in lighting and composition. - Prior experience in studio or on-site product photography. Please provide a portfolio showcasing your past relevant work when applying.

...option to bid his own online Session and determine it's Topic & Date/Time, Duration, Cost ... Instructors bids are shown on Students Dashboards. So that, students who are interested can reserve their seats... School Privileges Schools profiles can be created for advertisement or teaching purposes by a School representative through a variety of sponsorship programmes. If the school account is Active, this means the school logo would appear during all online sessions for a specific time. The school account owner can create an online Session (or a set of sessions) and assign it to a specific instructor (Hired or Freelance) Payment System: - The website should include a payment system, allowing students to pay for their online classes. The session creator (instructor or...

Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code

I am currently suspended from selling on Amazon due to inactivity. I have submitted an appeal to Amazon regarding this suspension. But they rejected my appeal in section 3. I need help in reinstating my Amazon account and ensuring that it remains active. Key requirements: - Experience with Amazon seller account reinstatement. - Proven track record in successfully appealing Amazon account suspensions. - Knowledge of Amazon's policies and procedures. - Ability to provide guidance on maintaining an active Amazon account. - Excellent communication skills to liaise with Amazon's support team effectively.

Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tab...questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet onlin...

I'm looking for a talented designer to create a 6x9 E-Book cover for a senior fitness book. The cover should be Bold and colorful, conveying the importance of staying active and healthy in old age. Key requirements: - The cover should prominently feature an image of a senior exercising, engaging the target audience in the fitness theme - A vibrant mix of multiple colors should be used to make the cover visually striking and appealing Ideal skills and experience: - Proven experience in E-Book cover design, particularly in the health and fitness niche - Excellent knowledge of color theory and ability to create bold, colorful designs - Understanding of the target audience and ability to incorporate suitable imagery for seniors - Strong portfolio that showcases your ability to c...

I need an AI website that shows daily stock picks, weekly stock picks and monthly stock picks but there must be limited number of picks and there must be a paid version that shows special picks. For example, AI picks 10 stocks daily but shows only 7 of them, does not show the best first 3 stocks to buy and users need to pay monthly fee to see first 3 stocks.

...will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong attention to detail and accuracy are highly valued. - Understanding of basic financial jargon will be beneficial. This role requires someone who is organized, reliable and able to work independently. The workload will be part-time with flex...

...Guidelines: • Focus on Clarity and Conversion. Deliver a clear message that highlights the product/service's value proposition and compels viewers to take action (e.g., visit website). • Leave space in the design for our brand logo (1:4) • Ensure the product/service is the central focus of the design. • Ensure that the design has a prominent and enticing call to action. • Leave placeholders for our phone number and/or website - you decide what should be included in the billboard Ideal Skills for Contestants: • Previous experience designing billboards • Strong understanding of what stands out on the roadside • Ability to balance brightness and boldness without overwhelming viewers or diluting the message • Ability to create design...

...relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous experience with developing chatbots - Familiarity with sentiment analysis - Ability to create personalized recommendations for users - Skilled in extracting and understanding content from PDF files - Strong problem-solving skills and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need acc...

I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is looking for a 5-star review.

I have a PDF membership directory that was emailed to me. I need someone skilled in data extraction to help convert it into an easily readable CSV file. The ideal candidate should possess: - Proficiency in working with both PDF and CSV file formats. - Strong data extraction ...directory that was emailed to me. I need someone skilled in data extraction to help convert it into an easily readable CSV file. The ideal candidate should possess: - Proficiency in working with both PDF and CSV file formats. - Strong data extraction skills. - Attention to detail for data accuracy. Each member listed per row with the perinate contact information separated into its own cells ie: entity/last name/first name/address/ste#/city/state/zip/office ph/email/cell ph The task should be comp...

I have a mix of digital and paper cell records from Google Take Out that need to be converted into an easily searchable and readable format. Key points: - Data formats: Both digital and paper - Required output: PDF document - Analysis: I need you to analyze the number patterns for this data, specifically looking at numbers used once versus those repeated over multiple years. This analysis should be done thoroughly and presented in a clear, easy-to-understand manner. Ideal freelancer skills and experience: - Proficient in data conversion and organization - Skilled in creating and working with PDF documents - Experience in data analysis, especially patterns and number analysis - Ability to create visual representations, such as charts and graphs - Strong attention to ...

I'm seeking a proficient developer to create a custom side navigation menu using TailwindCSS and AlpineJS. ...navigation menu should be styled in a vertical layout on the side of the screen. - Interactive Features: It should include collapsible submenus, enabling the user to expand or collapse menu items as needed. Additionally, each item should have a distinctive active state indication. Ideal Skills and Experience: - Strong understanding of TailwindCSS and AlpineJS, including their application in building custom navigation menus. - Familiarity with creating effective and user-friendly interactive features such as collapsible submenus and active state indications. - Ability to follow design guidelines and specifications to ensure the final product meets the desired lay...

We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing source mate...

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation

I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for reference. The idea...

I am in need of a skilled developer to create a group chat application that can be used on both Android and iOS platforms. The primary feature that is required for the app is text messaging. All users must be authenticated using phone number OTP. This project will require the following skills and experience: - Extensive experience with Flutter and mobile app development - Knowledge of implementing and customizing chat features - Proficiency in creating secure authentication systems, specifically phone number OTP - Past experience in developing cross-platform applications Ideal candidates will also have excellent communication skills, be able to work independently, and provide regular updates on progress. The successful candidate will not only be able to deliver a working ap...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

I'm in need of a Python application that can connect around 200 Android and iPhone devices to a PC via USB cables, allowing me to perform various automated tasks and workflows on them. Key Requirements: - **Bulk Con...Proficiency**: The freelancer should have a solid understanding of Python programming, as the main application will be built using this language. - **Mobile Device Management Experience**: Experience in developing applications that manage or interact with mobile devices is essential. - **USB Communication Proficiency**: The ability to establish stable and reliable communication between the PC and a large number of Android and iPhone devices through USB is crucial. Please outline your relevant experience and provide any examples of similar projects you've wo...

As a company, we're looking for talented freelance individuals in the Design and Creative field. The ideal candidate should: - Have a strong portfolio showcasing a variety of design projects - Be able to take on projects on a freelance basis - Be active on social media platforms, as it is our platform of choice for posting these positions The perfect fit is someone who not only has the skills and experience in Design and Creative roles, but also is comfortable working on a flexible, project-based freelance regimen. If you're a freelance designer looking to take on some extra work and expand your portfolio, we would love to see what you've got.

Start your offer with the word in the att...Videos on their sites. Prepare a list with : Name of the company, youtube Channel, Link to the first youtube video you find on the site, PLZ, City, State, Phone, Mail, Website Niches: Construction Systems in Austria, Germany and Switzerland Phsiotherapeuts in Austria, Germany and Switzerland I would like to have at least 2000 websites with top-quality data. Delivered in 1 day. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. We extend our partners for this kind of task´s. With all of them we have a longterm Partnership. To decide who is our partner and to see your understanding, please provide a sample with at least 50 data entries within 2 hours of starting our...

I'm seeking a skilled Python programmer with OpenCV experience, preferably one who has dealt with table detection from PDF and images before. Th...of OpenCV - Familiarity with table and structure detection Your main task will be to develop a program that can accurately identify table structures within input files. The files will be PDFs or images, or both. You're expected to program a feature that detects these components: - Cell boundaries - Text within the cells - Overall table structure For the sake of this project, merged cells should be discerned as a single entity during the detection process. Your solution should demonstrate precision in merged cell detection. I look forward to bids from those passionate about computer vision tasks and tackling challenges ...

...understanding of this field. As a VA, you will play a pivotal role in managing various tasks associated with our crypto-related platforms, including a YouTube channel, social media accounts, a blog, and a Telegram community. Key Responsibilities: Research and Summarization: Conduct research on new crypto products, trading companies, and product features. Summarize findings in visually appealing Excel sheets or Designs or reports for easy comprehension. Partnership Outreach: Reseacrch & Contact potential partner programs to explore collaboration opportunities. Negotiate special deals, such as free products or community discounts, or paid sponsorships. Follow up with potential partners to finalize agreements. To manage inbox and keep it up to date Replying to Inquirie...

I'm in need of a skilled freelancer to assist with some data entry work. While the specifics of the work have not been defined yet, it will likely involve entering data into a database, transcribing written documents into digital format, and/or filling out online forms. The task can involve different formats such as Excel spreadsheets, Word documents, or online platforms.

I'm in need of a Google AdWords expert to help me generate leads and boost conversions at an affordable price. Key Project Details: - The campaign is aimed at both local and national customers. It's important that the specialist can tailor the ads to these specific audience segments. - The overall goal is to increase the number of leads the campaign brings in and to ensure a high conversion rate. Ideal Freelancer: - Proficient in Google AdWords and has a proven track record of generating leads and boosting conversions. - Experience in managing campaigns for both local and national customers. - Ability to work within a tight budget and still deliver effective results. - Strong analytical skills to constantly optimize the campaign for better performance. Please only bid...

I am in need of an experienced Japanese to English translator. The project will consist of translating a number of documents from Japanese to English. The documents to be translated will vary in field, including legal, business, and technical documents. The ideal candidate should be well-versed in translating such material, and be able to deliver accurate and high-quality translations.

...resolved in an excel file for every data point (every metre). Drag and motor thrust which depend on the current velocity of the vehicle (see matrix explanation below). The first lap is different to the remaining 9 laps, you can work around this however you like but, please ensure you use the correct data. Furthermore, all the constants relating to the vehicle forces must be able to be changed directly from an excel file page called constants. To find the optimal solution you must use some sort of genetic algorithm (explained with flow diagram) that turns the motor on twice per lap to build up speed and then coast using the speed gained. Using the current velocity at a given point, the force of the motor is interpolated from a matrix [Vehicle velocity, Motor Force] found in...

I'm seeking to secure funding for a multi-industry workers' accommodation project. The accommodation caters to construction, seasonal farm, wind farm, abattoir, and gold mine workers. For this, I need a professionally crafted project proposal and a corresponding financial model in Excel. Ideal freelancers for this project should possess: - Proven experience in drafting project proposals related to housing or accommodation - In-depth knowledge in the creation of financial models using Excel - A strong understanding of multi-industry accommodations - Great analytical and strategic thinking skills - Familiarity in the Construction, Agriculture, Energy, Food Processing, and Mining Industries would be advantageous.

Looking for a graphic des...modern and minimalist branding graphics for my product. Photos shows the fruit packer robot in place over a conveyor with multiple units next to each other. Logo, branding colors and photos of machines in a factory are in the data set. Machine currently have a blue logo sticker. This will be removed and replaced with new branding. Orange should be used sparingly as there are lots of machines in a row next to each other and don't want the branding to be over powering. The front an rear needs a location for an ID numbers (shown in the photos) Clear windows can have some branding but it needs to be subtle and not obscure the view too much. The top of the machine is not visible so does not need branding or minimal branding depending how it wraps o...

Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including tr...

I am working on a collaboration platform that will serve as a hub for individuals and small businesses. I need a skilled professional who can bring this vision to life through both design ...write initial proposals Ideal Skills: - Experience in designing and developing collaboration platforms. - Proficiency in blockchain wallet integration. - Knowledge of AI for potential future enhancements. - Strong understanding of user experience design. - Familiarity with security measures like End-to-End Encryption. - Previous experience with implementing reward systems in platforms. Be pro active in advising how best to proceed with features, what features to have, how things will work best etc. The platform should be user-friendly, efficient, and secure, providing a seamless experience for ...

I'm seeking a skilled individual to urgently delete misleading information from a Wikipedia account. Who has an active and old wikipedia account. To also do source analysis and vote. Key Tasks: - Identify and remove misleading content: The primary task is to review the existing content on a Wikipedia account and identify any information that is misleading. Once identified, this content must be permanently deleted. - Ensure Compliance: The successful candidate will need to ensure that the content removal process complies with Wikipedia's guidelines and policies. This includes avoiding the removal of any content that may be perceived as neutral and supported by reliable sources. This project is time-sensitive. Immediate action is required to maintain the reputation and re...

Hello; I need to generate a new set of websites (.EUs), integrated/generated them with an already active set with a lot of basic content (basic analysis, from set .ITs); Objective: digital sale of GREEN RIGHTS, starting in the EU and BRICS area; with option to generate some apps to upload NFT/DeFi (Solidity/ERC721) to specifics cryptocurrency markets; I think of a good system and its subsequent easy management; a lot of material needs to be reorganized, offered in English, with a sober and professional style, similar on every website, with the option of being available in every language (Wordpress); the basic contents and plan in matrix at the bottom in (first column general info, each others column basic contents on specific websites/patent); ...not need easy migration (traslati...

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

...historical orders The user I formation to register will be Full name Adresse IP adresse scanned during the registration Telephone number Admin Interface (web only) • Enable/disable users • User password reset functionality (user will receive an email for a reset password) • View user historical orders with a scrolldown list of users • Pause of the application in case of maintenance, so the users could not make orders • Show the number of orders and sum per country per day • Define price per countries Order module • Create/import a letter (mport from a pdf or an other type format such as word or just flat text maximum number of pages per order is 2 A4 format) • Type in an address of destination • Sel...

I am engrossed in studying a company's customer, product, and trucks data for my PhD research. Contemporary businesses encounter a significant challenge wherein their delivery trucks often travel from one region to another with insufficient loads (Half of the trucks are empty), resulting in inefficient use of resources. My research aims to minimize the number of empty or partially filled trucks traveling to those areas, particularly in the last-mile delivery process. Below is a list of stores. I kindly request you to extract the dataset from one of the listed companies. The list of stores is prioritized in order. 1- IKEA (IKEA store that located in Saudi Arabia) 2- Home Centre 3- Home Box

...BI professional to assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designin...

...or Amazon VA. • Excellent verbal and written communication skills in English with clients • BSc/BA in Business and/or Marketing from an English speaking institute preferred • Solid organizational skills to timelines, tasks and documentation across multiple accounts • Expert knowledge of Amazon flat file upload (Seller Central & Vendor Central) • Advanced knowledge of Microsoft Office (expert in Excel) • Experience using project management platforms (Trello) • Able to analyze workload and tasks to estimate turnaround times • Fluent in English, other EU languages is a plus • Strong attention to detail • Analytical skills • Research and Problem solving skills • Strong interpersonal skill • Most importantly be passi...

I require a talented content writer to help me develop engaging and SEO-friendly blog articles. Key Requirements: - The content should be well-researched and highly informative. - It should be optimized for search engines to help drive organic traffic. - A keen understandi...of my target audience is crucial, as the articles need to be engaging and relevant to them. Ideal Skills: - Proven experience in crafting high-quality blog articles. - SEO knowledge to create content that ranks well. - Ability to write in a tone that resonates with my target audience. - Good research and analysis skills. - Understanding of effective content promotion strategies. The specific number of articles needed is yet to be determined, so I'm looking for a writer who can be flexible and adapt to m...

I have a 1-page Excel spreadsheet with 9 text columns that need to be merged. I'm looking for someone who can start this job immediately and has experience in Excel data manipulation and formatting. Please only bid if you can do this job immediately and I will award and give you the file.

I have an iOS app ready to go and an active Apple Developer account. I've managed to set up the app's metadata and assets for the App Store. However, I need someone to assist me with the final step of actually publishing the app. Ideal skills and experience: - Experience with publishing iOS apps to the App Store - Knowledge of Xcode and the iOS development process - Proficiency in managing and navigating the Apple Developer account interface - Ability to troubleshoot and resolve any publishing issues that may arise - Excellent communication skills to guide me through the process and answer any questions I may have This project is quite straightforward as most of the work has already been done. I just need someone to take the reins and ensure the app gets published succes...

I'm seeking an expert in Excel analytics. This project involves working with existing but undisclosed business data to help me understand and optimize the business's performance through indicators like KPIs. The freelancer's task encompasses: - The creation of robust dashboards that effectively communicate KPI outcomes. - The execution of classification analysis to differentiate key data points. - Clustering the data into discernable patterns to aid business decision making. Ideal skills for this job include Excel proficiency, data analytics experience, and an understanding of key business metrics such as KPIs, dashboards, classification, and clustering. A background in business data analysis and the ability to assign meaning to raw data is desired.