Combine columns excel using vba jobs
I cant figure out the correct formula for this hence asking our incredible freelance community online. I have a spreadsheet with two pages. -To-do page -Done Page The To-do page contains a table with data The Done page has that same table with no Data (it has the same headings) I want to be able to move a row of data from table in the To-do page to the table in the Done page. After I've moved that row of data, the row should be completely deleted from the To-do page. Also would like a Total counter on the To-do page that increments by 1 every time a row is moved. Attached is a test sheet containing small sample size of data. If someone can implement the correct formulas so it works on the test sheet, I'm happy to share the correct dataset with them for them to action. Dat...
I'm looking for a logo that embodies a classic style with a monochrome color scheme. Key Features: - Incorporate both text and a symbol into the logo. - The design should be primarily monochrome, without any color variations outside of this scheme. Ideal Skills and...for a logo that embodies a classic style with a monochrome color scheme. Key Features: - Incorporate both text and a symbol into the logo. - The design should be primarily monochrome, without any color variations outside of this scheme. Ideal Skills and Experience: - Proven experience in classic and minimalist design styles. - Strong graphic design skills, particularly in creating logos that combine text and symbols. - Portfolio of monochrome designs is a plus. - Excellent understanding of typography and symb...
...data entry. The task involves entering specific sales data into Excel and tracking transactions in Tally Prime. Key Responsibilities: - Data Entry: Inputting sales invoices and summaries from Tally Prime into a standard Excel format. - Tally Prime: Manage and track all sales data in Tally Prime. Requirements: - Proficiency in Excel: Familiarity with the standard Excel format is necessary, as you will be expected to use this for all data entry. - Experience with Tally Prime: Prior experience working with Tally Prime is crucial, as this will be the primary platform for tracking sales data. - Attention to Detail: Precision is key, as data accuracy is critical for this task. Ideal skills for the job include: - Data Entry - Excel - Tally Prime - Attenti...
I cant figure out the correct formula for this hence asking our incredible freelance community online. I have a spreadsheet with two pages. -To-do page -Done Page The To-do page contains a table with data The Done page has that same table with no Data (it has the same headings) I want to be able to move a row of data from table in the To-do page to the table in the Done page. After I've moved that row of data, the row should be completely deleted from the To-do page. Also would like a Total counter on the To-do page that increments by 1 every time a row is moved. Attached is a test sheet containing small sample size of data. If someone can implement the correct formulas so it works on the test sheet, I'm happy to share the correct dataset with them for them to action. Dat...
As a class 11 commerce student, I'm seeking a dedicated tutor specializing in Accountancy, specifically Financial Accounting. Key Requirements: - Expertise in teaching Financial Accounting - Previous experience with 11th grade curriculum - Patience and ability to explain concepts clearly - Flexi...I'm seeking a dedicated tutor specializing in Accountancy, specifically Financial Accounting. Key Requirements: - Expertise in teaching Financial Accounting - Previous experience with 11th grade curriculum - Patience and ability to explain concepts clearly - Flexible schedule for tutoring sessions Your role will primarily involve conducting tutoring sessions aimed at helping me understand and excel in Financial Accounting. Please provide your tutoring approach and availabili...
I'm looking for a freelancer who can assist in gathering the details of company directors from a list of data centres. The project involves finding information for 100 plus data centres. Key Requirements: - Full Name, Title, Email Address, and Phone Number of the directors are required. - Experience wit...and research is crucial. - Prior experience in sourcing business contacts is a plus. - Directors' LinkedIn Profiles are required for validation. - Please include the directors’ specific company roles in your search. Your bid should reflect your ability to provide this information accurately and efficiently. Looking forward to your proposals. The gathered information should be organized in an Excel spreadsheet format. Please include the directors’ specific c...
I cant figure out the correct formula for this hence asking our incredible freelance community online. I have a spreadsheet with two pages. -To-do page -Done Page The To-do page contains a table with data The Done page has that same table with no Data (it has the same headings) I want to be able to move a row of data from table in the To-do page to the table in the Done page. After I've moved that row of data, the row should be completely deleted from the To-do page. Also would like a Total counter on the To-do page that increments by 1 every time a row is moved. Attached is a test sheet containing small sample size of data. If someone can implement the correct formulas so it works on the test sheet, I'm happy to share the correct dataset with them for them to action. Dat...
I'm in need of an Excel worksheet It is already in a wook book split into 3 parts with a total of 32 questions. The questions are designed for a beginner level course, so they're not overly complex. Key Requirements: you are a financial analyst at a large corporation responsible for managing and analyzing the company's product reports and financial data. Your goal is to set up a dashboard to display the needed information. Ideal Skills: - Proficiency in Excel - Experience in creating educational materials - Competence in trend analysis - Ability to work with financial data Heres the Project: You are a financial analyst at a large corporation responsible for managing and analyzing the company's product reports and financial data. The company deals w...
I need a proficient Excel developer to create an interactive dashboard that will help visualize work accomplished from different Excel sheets. Each sheet has slightly different data points but shares common elements like quantities completed on specific days and the number of additions per day. The dashboard should also incorporate some aging aspects of the efforts on each sheet. Key Requirements: - Proficient in Excel with experience creating dashboards - Skills in data visualization using line charts, bar charts, and pie charts - Ability to perform and display calculations including sum of quantities, count of entries, and difference between start and end values The dashboard must include: - Data visualization through number fields (count, sum, difference) -...
Looking to create the views in mariadb required for a calculation system to process sales data and automatically determines commissions based on various metrics. Category-based calculations Flexible rule implementation Experience with Excel/MariaDB Strong analytical skills Experience with business calculation systems Ability to implement complex business logic Looking for clean, maintainable code with proper documentation.
I need someone to transfer data from an Excel spreadsheet to a Word file, following a provided template, and then save it as a PDF. Ideal Skills and Experience: - Proficiency in Microsoft Excel and Word - Attention to detail (this is a must) - Ability to follow instructions accurately - Experience with data entry and document formatting Data Types: - The data consists of a mix of both text and numbers. Task Specifics: - A template will be provided for the Word file, which will require simple formatting (e.g., bold, italics, headings). - Instructions will be provided on how to organize the data in the Word file.
...control over orders, users, and reports ✅ Driver Panel: Drivers can access their orders, track, and update statuses ✅ Order Statuses: Created, In Delivery, Pending, Delivered, Rejected, In Warehouse ✅ Smart Scanning: Drivers can scan packages using a camera or scanner ✅ Warehouse Management: Accept and process incoming shipments ✅ API Integration: Connect with other courier companies in Albania and North Macedonia ✅ Reports & Analytics: Generate reports for orders, drivers, and sellers ✅ Order Printing: Print orders in A4 format and label prints ✅ Excel Import: Bulk order registration for higher efficiency Preferred Technologies: ✅ Laravel / Node.js for Backend ✅ React / Vue.js for Frontend ✅ MySQL / PostgreSQL for Database ✅ Mobile App (Optional) ? If you have expe...
Hello, here is really a simple contest, put my video on a third Grade Youtube Channel (Around 300 members, it can be more) It's a little teaser/first look for a PC MMO Strategy Game for a kickstarter campaign. This teaser is FAR from perfect (But on little channel it's not a problem). The one with the most views win. You can use any URL trackers y...rev-share on the found the kickstarter campaign will bring, with a real contract (Considering I'm from Europe this last offer is more for European Freelancer). Still Kickstarter have strict rules so do NOT abuse anything. The PDF under include the "Title", "Short Description", "Presentation", "Features List" and Links (referrals available in PDF too, I will update it daily, you are adv...
...with two Excel files: 1. “List to be sent to ” (Main Inventory File) • Contains a list of medical disposables and device parts used in our facilities. • Each row represents a unique item that must be mapped to both EMDN & UNSPSC. • You will add four new columns to this sheet: • EMDN Code (from reference sheet) • EMDN Name (from reference sheet) • UNSPSC Code (from reference sheet) • UNSPSC Name (from reference sheet) 2. “Global Item ” (Reference Data for Mapping) • Contains official EMDN & UNSPSC codes in two separate sheets. • You will use these sheets to correctly classify each item from our inventory. ✅ Requirements & Skills ✔ Experience in medical device classification & i...
...with two Excel files: 1. “List to be sent to ” (Main Inventory File) • Contains a list of medical disposables and device parts used in our facilities. • Each row represents a unique item that must be mapped to both EMDN & UNSPSC. • You will add four new columns to this sheet: • EMDN Code (from reference sheet) • EMDN Name (from reference sheet) • UNSPSC Code (from reference sheet) • UNSPSC Name (from reference sheet) 2. “Global Item ” (Reference Data for Mapping) • Contains official EMDN & UNSPSC codes in two separate sheets. • You will use these sheets to correctly classify each item from our inventory. ✅ Requirements & Skills ✔ Experience in medical device classification & i...
I can write code in VBA for moving rows (orders) from one sheet to the next upon entering specific data in a cell or any other event. Client will explain the rules for moving data in each particular sheet.
...an experienced AutoCAD freelancer to design and mark the electrical conduit layout for the slab of a 17-room hotel. The layout must be efficient, compliant with electrical standards, and allow for future modifications. Scope of Work: Electrical Conduit Layout: Draw conduits for lighting, fans, power outlets, HVAC, and emergency systems. Ensure conduits are routed properly, avoiding beams and columns. Junction Boxes & Conclaves: Mark conclave positions for ceiling lights, smoke detectors, motion sensors, and security systems. Include waterproof conclaves in bathrooms and kitchen areas. Future-Proofing & Scalability: Plan spare conduits for future installations (CCTV, automation, additional lighting, etc.). Ensure the design allows easy modifications for future upgrade...
m365_results_2025-01-30 m365_results_2025-01-30 m365_results_2025-01-29 m365_results_2025-01-29 m365_results_2025-01-29 m365_results_2025-01-29 m365_results_2025-01-29 m365_results_2025-01-28 m365_results_2025-01-25 m365_results_2025-01-25 m365_results_2025-01-25 m365_results_2025-01-25 m365_results_2025-01-24 m365_results_2025-01-24 m365_results_2025-01-24
I have a CSV/Excel file containing product prices that I need adjusted. All product prices need to be increased by 20%. If the price is $0 then do not update and leave it at $0.
Architectural design - ongoing work: Architectural design of Self storage building and associated infrastructure. Software: • Revit 3D modelling • Lumion Rendering • Autocad • Excel Skills: • Experienced in architectural drafting and design • Knowledge and experience with Australian codes and standards • Full architectural drawing sets including: • Ability to create comprehensive fire safety and evacuation plans • Designing for energy-efficient and sustainable construction o Site plans o Self-storage unit layouts o Floor plans o Elevations o 3D views o Sections o Landscape plans o Traffic management plans o Window and door schedules o Cut and fill plans o Demolition plans o Office and amenity fitout o Construction details • Conve...
...Delivery & logistics businesses ✅ Mobile auto repair & detailing services ✅ Any business with fleet vehicles Deliverables: The freelancer will provide a detailed, organized list in Google Sheets or Excel, including: ? Business Name ? Industry Type ? Company Address ? Contact Person (Owner/Manager/Decision Maker) ? Phone Number ? Email Address ? Company Website Requirements: ✔ Proven experience in B2B lead generation ✔ Ability to source verified, up-to-date contact details ✔ Familiarity with Mississauga/GTA business landscape is a plus ✔ Strong research skills & attention to detail ✔ Experience using LinkedIn, Google, Business Directories, and other tools Budget & Timeline: ? Budget: Open to proposals – please include your rate per X leads ? Deadline...
I need a professional to test my VBA on MAC. You will be testing for macro execution, user interface elements and data processing on MAC as we develop on PC but have mac clients. Skills: - Proficient in VBA - Experienced with testing/running VBA on MAC - Excellent problem-solving skills.
...newcomers from various countries seeking health insurance in Switzerland. Ideal Skills and Experience: - Proven experience in data entry - Familiarity with public services preferred - Ability to handle sensitive data with confidentiality - Experience with database management - Attention to detail and accuracy - Knowledge of health insurance processes and terminologies The data should be entered in Excel format. The project will involve entering between 100 entries for the beginning. The project should be completed within the shortest possible timeframe. Please include the following data validation requirements: newcomers coming in Switzerland and requiring health insurance. The data should be organized by the newcomer's country of origin. Please include accuracy checks ...
I'm looking for an expert in Excel to assist me with some formulas related to numerical data. The primary goal is to help me with summing and averaging calculations.
I'm in need of an Excel expert who can assist with fixing my spreadsheet and importing a proposal sheet. Specific tasks include: - Creating templates - Inserting data - Design and layout I'm experiencing some issues with my current spreadsheet that have not been resolved, so I would also appreciate a review of this. Ideal candidate should be proficient in Microsoft Excel, have experience with spreadsheet troubleshooting, and capable of assisting with proposal sheet preparation.
I'm seeking a native professio...are marketing phrases intended for the web and tools for professionals (like grinders, drills, hammers, etc.). Deliverables: - The translated text must be delivered in an Excel spreadsheet + SDLXLIFF (or TMX). - The job has to be completed by Friday, 7th, at 17:00 CET. Tone: - The translated marketing phrases should have an informal tone. Terminology: - There are no specific terminologies or keywords that need to be kept in English. Ideal Skills: - Strong proficiency in English and Arabic (KSA) - Experience with translating technical and marketing content - Familiarity with DIY tools terminology - Proficiency in using CAT tools (preferably Trados) - Ability to deliver quality work by the deadline. Ensure the translation uses the ...
I require a proficient web scraper to gather contact details from websites. The final data needs to be formatted into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in web scraping tools and techniques - Experience in data collection from websites - Ability to organize and format data into Excel - Attention to detail to ensure data accuracy
I need an expert in Excel to help automate calculations and report generation for my civil engineering projects. Key Tasks: - Automating calculations: This includes a variety of mathematical operations and civil engineering specific calculations. - Streamlining report generation: I want to simplify the process of creating reports from the data and calculations. Ideal Skills: - Proficiency in Excel: You should have advanced knowledge of Excel, including familiarity with its more complex functions and tools. - Civil Engineering Expertise: A strong understanding of civil engineering principles and calculations is crucial. - Automation Skills: Experience in automating tasks in Excel will be key to the success of this project. Please provide examples of similar p...
I'm looking for an Excel expert to create a daily fantasy sports sheet for basketball. This sheet should include current season player statistics, as well as an optimal lineup complete with captain and vice captain. Key Requirements: - Proficiency in Excel - Understanding of basketball and daily fantasy sports - Ability to source and incorporate up-to-date player statistics Ideal Skills: - Data analysis - Fantasy sports strategy - Excel VBA (for automation) Please note, this project is focused solely on the current basketball season.
I'm lookin...need someone who can follow my content and the latest news to create the carousels. Requirements: - Create 3 posts, each with 6-7 slides. - The content of each carousel should primarily consist of images and graphics. - The design should follow a minimalistic and clean theme, using subtle color contrasts and plenty of white space. - The purpose of these carousel posts is educational, so the content should be suitable for teaching my audience about various topics. The ideal candidate will be: - Proficient in using Canva - Able to create visually appealing designs - Familiar with Instagram carousel format - Able to follow and understand my content and the latest news - Understanding of minimalistic design principles - Capable of creating educational conte...
I need someone to help me with data entry on my WordPress site. The task involves transferring data from another site into my WordPress site. The job involves 600 products, specifically car wrap films. Dat...my WordPress site. The job involves 600 products, specifically car wrap films. Data to be transferred includes: - Product descriptions - Price variations - Product Images I have some images, but will need assistance in sourcing additional ones. The data from the source site is in a CSV/Excel format. Ideal skills and experience for this job: - Proficiency in WordPress - Excellent data entry skills - Experience with product data entry - Ability to source product images - Familiarity with handling CSV/Excel files. Please ensure you have the necessary skills before bi...
I'm looking for a detail-oriented freelancer to assist with a simple data entry project. The task involves copying text data from a digital Excel file into online database records. Ideal Skills: - Proficiency in Excel - Attention to detail - Good understanding of text data - Ability to maintain data confidentiality Experience: - Prior data entry experience preferred - Familiarity with handling digital files Other: - Can perform duties during normal Mountain Standard Time working hours - English-speaking Please bid if you can meet these requirements. Thank you.
I have 15 Excel documents containing survey data tables. Each document has multiple tabs with tables. You will need to: - Format all tables uniformly, ensuring they have the same headers and layout - Set the headers to be bold and centered - Adjust the tables to have uniform column widths After formatting, please return the files as: - A neatly formatted Excel document - A merged PDF of all the tables Ideal candidates for this project should have: - Strong Excel skills and experience with data formatting - Attention to detail to ensure all tables are formatted identically - Ability to create a merged PDF from Excel Please note, the headers should be bold and centered, and all tables should have uniform column widths. Ensure the table font style is uniform ...
*** Only a freelancer who can provide me 1 design for free can apply this project**** If you agree to offer a free design, please write "I will provide you 1 page of free design for free" in application form -Creating android app using exist web(Similar as freelancer.com) -New design -Adding push alert feature -Push on/off feature by set time -Upload app on google play store
I need a VBA document designed primarily for report generation. The document should be capable of creating reports that include text summaries, and it should adhere to a consistent font and size throughout. Ideal skills and experience for the job include: - Proficient in VBA programming - Experience in designing documents for report generation - Attention to detail for consistent formatting
1. I will be buidling a new LWC component which whill execute CRMA Query to reterive date (LWC and CRMA Integration) 2. Giving ability for inline edit for opportunity Name, Amount as part of PoC if more fields are required we will exend our PoC 3. LWC will be compatible with Filters which are displayed on CRMA Dashboard 4. Adding LWC to CRMA Dashboard
I'm looking for a web scraping expert who can extract Over/Under lines (all lines , not only the main one) for all MBL (Baseball) and NHL (Hockey) games from the past 5 seasons. The data should be delivered in an Excel (XLSX) format. Key Requirements: - Expertise in web scraping - Proficient in data handling and Excel - Familiarity with MBL and NHL data - Ability to extract specific betting lines The ideal freelancer for this project would be detail-oriented, with a proven track record in web data extraction, particularly in the sports and betting domain. The ultimate goal is to get comprehensive, clean data for analysis.
I want an experienced person to do the following: Finding arbitrage opportunities using *Alchemy mempools* involves monitoring pending transactions before they are confirmed on-chain. This allows you to act on price movements before they finalize. Here’s how you can do it: --- ### *1. Understanding Mempools & Alchemy's Role* • The *mempool* (memory pool) is where unconfirmed transactions wait before they are included in a block. • *Alchemy's Enhanced API* provides access to pending transactions, which can be used to anticipate price changes across *DEXs* before they happen. --- ### *2. Steps to Identify Arbitrage Using Alchemy Mempools* #### *A. Connect to Alchemy Mempool API* Use Alchemy’s *Ethereum Pending Transactions WebSocke...
I'm looking for an AI enthusiast to create a comic using the Hugging Face library. I have a general theme in mind but would love your creative input and expertise in developing a captivating storyline.
I'm in need of a male who speaks Telugu and Hindi fluently. Your job will be to call various barber shops in Hyderabad and gather information about their services, specifically service names and pricing. This will include: - Understanding and noting down the different services offered, such as hair cuts, shaves, head massages, etc. -...Understanding and noting down the different services offered, such as hair cuts, shaves, head massages, etc. - Inquiring about the pricing for these services Once you have collected this data, you will need to upload all of it to the admin panel of my web app. This will involve: - Manually inputting each detail The ideal candidate should be comfortable with: - Data entry - Working with Excel - Using Google Experience in similar tasks...
...address can be filled by the administrator from the back office. o The amount in the wallet will be visible to the customer after refreshing the page. 5. Amount Conversion: o The administrator can fill an amount in USD or EUR from the back office, which will be automatically converted to BTC in the customer's wallet. o This amount will be adjusted three times a day according to the BTC market price using a reliable API. o The total amount in BTC will be converted to EUR and USD based on the market price. Sending BTC 6. Fictive BTC Sending: o The client can fictively send BTC by entering a BTC address. o The client can also fill in an IBAN of their bank account in the BTC address field. o The client has the option to fill in the routing number. 7. Sending Process: o When the ...
I have a Python backend and a React frontend. I need someone to combine both and make my website work. The integrated website should be able to: - Display data using tables and lists - Handle form submissions I also have some existing APIs that need to be integrated into the website. Ideal Skills: - Proficient in Python and React - Experience with API integration - Ability to create simple data visualizations using tables and lists Please note this is currently an unpaid project. I can offer a maximum of 200INR for this task, but am willing to pay more in the future for the right person. If you're interested in helping me, please feel free to reach out.
I have a Word document containing names, emails, numbers, specialties, subspecialties, states, and cities. I need this data entered into an Excel spreadsheet with separate sheets for each category. Key requirements: - Proficient in Excel and data entry - Attention to detail to ensure data is accurately transferred - Ability to organize data into separate sheets by category
...will involve using Excel Solver to tackle various complex problems related to inventory management and demand forecasting. Key Objectives: - Apply linear programming and integer linear programming models to optimize and simulate supply chain scenarios. - The primary goals are to minimize costs, maximize efficiency, and optimize resource allocation. Constraints: - The model must account for various budget, capacity, and time constraints. Ideal Skills: - Proficiency in Excel Solver and mathematical modelling. - Strong understanding of supply chain management, particularly in inventory management and demand forecasting. - Expertise in linear programming and integer linear programming. - Ability to work within specified constraints. Experience: - Proven track reco...
I need alterations made to a Word document containing a receipt or invoice. The specific changes will include modifying text details, changing dates or numbers, and adding or removing items. Ideal skills and experience for the job: - Proficient in Adobe Photoshop - Experienced in working with invoices and receipts - High attention to detail - Able to maintain confidentiality and integrity - Creative problem solver for invoice modifications. Use the format of the existing Word document for the modifications.
I am in need of an advanced Excel developer to create a sophisticated spreadsheet for budgeting purposes. The spreadsheet should have the following features: - Revenue forecast - Budget variance analysis - Deal profitability and margin assessment - Expense tracking: Monitor and categorize all expenses with ease. - Break-even analysis: Calculate the break-even point for budgeting purposes. The spreadsheet will primarily handle manual data entry. The ideal freelancer for this project should have extensive experience in developing complex Excel spreadsheets, particularly for budgeting. They should also be adept at creating user-friendly interfaces for manual data input. Knowledge of financial modeling and data analysis will be a plus.
I am looking for an expert in LabVIEW with experience in developing CAN tools. The primary purpose of this tool is for real-time control. Ideal Skills: - Proficiency in LabVIEW - Experience with CAN tool development - Knowledge in real-time control systems
...Data: I have some initial data and calculations prepared, but it's only partial. - Explanation: I require both steps and final results to be explained to me. Ideal Skills and Experience: - Proficient in Excel and familiar with 2023 National Building Code, Alberta Canada Edition. - Experience in dealing with thermal and structural calculations. - Ability to explain complex concepts in a simple, understandable way. - Hands-on experience with building projects. This is an urgent task, and I would appreciate swift responses. Thank you. The final deliverables should be provided in an Excel spreadsheet. Please provide written explanations of both the steps and final results in a supporting document. The supporting document should contain an in-depth explanation of step...
I'm using Power Automate and Copilot Studio, and need a custom solution for document summarization. I want to automatically summarize any document (Word/PDF) added to a SharePoint document library, without needing user approval for the AI-generated summaries. I want to use a custom prompt for the summary. Key Requirements: - Set up an automated workflow in Power Automate - Use Copilot Studio to summarize Word documents - Ensure the process runs without user input I am new to this and looking for guidance of how this could best be achieved. Plenty of guides but they do not get over the need to have an approval process which i do not want. I don't want to use ChatGPT or Azure AI API as these costs money and copilot is part of my current subscription. Please include: - A...
...ability to handle various data tasks efficiently. Key Responsibilities: - Inputting inventory data into spreadsheets and databases. - Identifying and rectifying any errors in the data. - Organizing and updating records on a daily basis. - Ensuring all information is handled with the utmost confidentiality. Skills Needed: - Proficient typing speed and accuracy. - Basic understanding of Microsoft Excel and Google Sheets. - Exceptional attention to detail. - Self-sufficient and able to work independently. Qualifications: - A high school diploma or equivalent is required. - Previous experience in data entry is not necessary, but it will be advantageous. Ideal candidates will be reliable, trustworthy, and able to maintain privacy of sensitive information. The work will involve da...