Simple excel vba scriptcông việc

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

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

Necesito hacer un informe desde una planilla de excel con datos de clientes y productos.

I have a google sheet where we put 3 paragraphs of data into 1 cell. I have included an image showing the "reasoning" columns (D-J) which...concatenation. Then a final check to verify that the original = QA check. This is to verify no data was lost. Here is a read only link to the sheet: https://docs.google.com/spreadsheets/d/1TiyKKNjrEHeCrNySmmiD9xWQXTjd1OAh-8fUluSLRR0/edit#gid=420694380 rows 4-509 need to be done. Only work with the new fields, do not edit the original data This needs to be done with formulas, not manually. For an excel/google sheet expert this should be a 1 hour job. To show you have read this posting and have attention to detail, put your favor color as the absolute first word in your bid in ALL CAPS. If you don't do this, your bid wi...

I have 2 unfinished Access/VBA projects. I need assistance to finish the projects. My estimation is 3 working days. Max budget : 100$ Please note that I m also a freelancer. Thanks for you bid

i need someone who is good at writing mathematical scripts this job i need to develop a script to count distinct numbers in the outputted arrays we can specify conditions like min or max etc example -------------- suppose i want to count all distinct numbers in the following sets of numbers i will set a the MIN as 1 and MAX as 100 (but i can change this using boxes to enter min and max) to generate the sets or arrays the program asks us for a starting number, increment and max number note: max number is NOT mandatory when i am counting the distinct numbers i can either 1. count all the distinct numbers between a MIN and a MAX that i specify or if i dont specify then we count between the starting number and the max number. we can declare more than one set and in this case it will ...

I am seeking a qualified ...categorized and formatted into an excel sheet. Key Aspects Include: - Development of OCR model utilizing English language only - OCR model application should be primarily on handwritten letters - Exportation of interpreted data into a structured excel sheet Skills and Experience Required: - Substantial knowledge and hands-on experience in OCR technology - Proficiency in English handwriting interpretation - Understanding of Excel and data categorization - Experience with a diverse age demographic is a plus - Previous work with handwriting recognition technology will be highly valued Using OCR or AI is fine, i just want the best model. Need the ability to upload to the model on a basic test website and see results returned on that website ...

I urgently need a Mac script expert who can help create a piece of software to automatically schedule the installation of virus software. The ideal candidate should have: - Proven experience in Mac scripting - Knowledge in task scheduling - Expertise in MacOS virus protection software The selected freelancer should deliver the complete project as soon as possible. Comprehension of the urgency of this project is key - please only respond if you have the capacity to prioritize this task.

Check the attached video description. First good entry will be awarded. AND we will have a second task that is VERY similar to this that we will award the winner as well.

I am seeking an experienced cold caller ...experienced cold caller to generate leads within the business sector. - Demonstrated experience with B2B cold calling is needed. You will be reaching out to various businesses to promote our products/services. - The main objective is to generate leads that can be converted into customers. - I have a script ready for the cold calls. Fluency and assertiveness in delivering the prepared script would be beneficial, along with the ability to steer the conversation in a productive way while sticking to the script. - Prior experience in lead generation or sales would be a definite advantage. The perfect candidate should have exceptional communication skills and the resilience to handle rejections professionally. Many thanks for c...

We want to automatically update a "Master Stock excel file by either uploading an "Additional" Stock file or by subtracting a "Subtract" stock file. This inventory system would ideally: - use the item code/ID in the additional or subtract files as the key and match or lookup the corresponding ID on the Master file and update the stock by adding or subtracting (depending on the file). - Any items that cannot be uploaded or matched need to be highlighted to the user so they know the item did not upload or update correctly. - We want to be able to repeat this process many times buy adding and subtracting files while automatically updating the master file. - We then want to be able to download the latest Master Stock File whenever needed. Important: It needs t...

need somebody for simple webdesign mockup

I am in need of a customized Microsoft Excel spreadsheet for tracking employee departures. This tool is vital to manage efficiently and effectively the following data: - Employee Full Names - Departure Dates and Times - Bag Pull Information - Airline Information - Flight Information - Room Numbers The employee names should be formatted with both their first and last names for clarity and precision. As well as their guest names. Experience with creating functional and easy-to-navigate spreadsheets is key. Familiarity with airline industry operations or similar would be a great asset. Proficiency in Microsoft Excel is, of course, essential. I look forward to receiving your bids for developing this crucial tool for my operation.

I'm experiencing an issue with my VBA code not running as expected on my Mac with Office 365 version of Excel. I am also receiving error messages when attempting to run the code. I'm in need of a freelancer with a strong background in: - VBA Programming - Excel - Debugging - MacOS, specifically the Office 365 version of Excel Your task will be to inspect my code, identify the issue causing it to malfunction, provide fixes, and guide me through the process to avoid such problems in the future. Your debugging skills will be paramount and your ability to communicate clearly is desired. I expect prompt resolution of this issue, without any loss of original functionality. Please ensure you have the specified skills before making a bid.

Data Entry Project - Microsoft Excel Skills and Experience: - Proficiency in Microsoft Excel - Attention to detail and accuracy in data entry - Ability to meet deadlines Description: I am looking for a freelancer to assist me with a data entry project using Microsoft Excel. The task involves entering data into Excel spreadsheets accurately and efficiently. The ideal candidate should have experience in data entry and be familiar with using Microsoft Excel. Key requirements for the job: - Proficiency in Microsoft Excel - Attention to detail and accuracy in data entry - Ability to meet the deadline of completing the task within a week If you have experience in data entry and are proficient in Microsoft Excel, please submit your proposal.

I will inflict on you about a thousand pictures of cookie cutters I produce, and an excell file where you will have to replace the existing name with the name that describes it and you will also have to divide them into categories.

...Google Apps Script, to create an automation system for my Google Drive and Gmail account. This system should complete the following tasks on a weekly basis: - File Organization: Maintain clean and organized files within Google Drive through well-structured algorithms. - Email Filtering: Properly categorize and filter incoming and outgoing emails in Gmail according to specified criteria. - Folder Synchronization: Regularly synchronize folders between different Google Drive accounts. The automation tasks are expected to run every week to keep my digital workspace thoroughly organized. Interested freelancers should have solid experience in utilizing Google Apps Script for automation, along with a strong understanding of Gmail and Google Drive management. A well-crafted Pyth...

I'm urgently seeking an expert in extracting and interpreting Pine Script codes from invite-only TradingView scripts. My goal is for these extracted scripts to serve as a foundation upon which new trading scripts can be built. The requirements of the project include: 1. Extracting Pine Scripts: You should have a proven track record of successfully extracting codes from locked TradingView scripts. 2. Creating New Scripts: Leveraging the extracted codes to create new scripts will be your primary task. This requires an in-depth understanding of Pine Script and TradingView. 3. Functionality: The new scripts must have a few specific functionalities, namely: - Market Indicators: Incorporate different market indicators to aid in trading decisions. - Automated Tra...

I'm seeking a highly skilled professional to create a script for the GPT Assistants API. The primary functionality is to take data from to separate documents and send it to GPT so that it provides matches and sends back matched data. Given the pressing timeline, I'm looking for someone who can deliver the complete project ASAP.

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

aquí está la d...automatizadas relacionadas con la gestión del pedido. Integración con Excel: El sistema debe poder asignar automáticamente las credenciales y detalles del pedido a un libro de Excel. Esto incluye información como el nombre del cliente y el código del pedido. Automatización con VBA: Ya que utilizo VBA en Excel para manejar estos procesos, el sistema debe ser compatible o integrar esta automatización para facilitar la transición y el mantenimiento. Subida Automática a Google Drive: El sistema debe ser capaz de subir automáticamente el libro de Excel generado a Google Drive. Notificación vía WhatsApp: Una vez que el archivo esté...

I am seeking a data entry professional with strong keyboarding skills and attention to detail. The task involves entering both textual and numerical data into a spreadsheet. The project will entail managing 100-500 records. I need information from webiste to be copied to excel sheet Ideal skills/Experiences: - Proficiency in Microsoft Excel or other spreadsheet software - Strong data entry skills with emphasis on accuracy - Experience dealing with large amounts of data - Must be efficient and organised. Kindly bid if you have proven experience in similar projects and can deliver this task within the given timeline. Accuracy is absolutely critical in this role. Your work will directly impact data-driven decisions and enhance operations.

File yang ingin di komputerisasikan Pembelian bahan baku Produksi Gudang Penjualan barang Bahasa pemrograman PHP ,HTML, MySQL berikut tampilan untuk web nya

I'm in need of an artistic and talented graphic designer who can create a unique handwritten script logo. This vibrant logo will be finely utilized on print materials and social media. Key specifics being sought include: - Expertise in creating eye-catching handwritten script logos - Ability to design logos that stand out both for print materials and online (specifically social media platforms) - Experience in working without the integration of any particular characters or symbols I prefer a hands-on creator with an edge for uniqueness and style. Please include samples of your previous work, specifically those that highlight your creativity with text-only, handwritten script logos. Looking forward to seeing your work and potentially collaborating.

I need someone to convert 20 PDF files into Excel spreadsheet format. See attached of ONE pdf file (to give you an idea) that needs to be converted to Excel. Secondly, once converted to Excel format, I need a slightly new design (colour scheme and presentation) to the existing design found in the PDF files. If you could create several sample designs of how to represent the data in the PDF files in a different way (style?) in Excel? See attached 1 x sample PDF file to convert I also need the FAQ PDF and the "Quick Start Guide" PDF converted to word documents.

I am looking to have a bash script developed that pulls variables from a remote MySQL database. These variables need to be stored in memory solely for the duration of the script, which will only be run once at the start. No constant refreshing or updating will be required. The main function of pulling these variables from the database is to automate certain tasks. - Must be proficient in bash scripting and MySQL - Experience in database-driven automation is a plus - Should understand the concept of variable use and storage in memory

...Potential to earn significantly with dedication, achieving 3-5+ sales per week. • Remote role with flexibility to work from anywhere. • Supportive team committed to your success and growth. How to Apply: If you're ready to contribute to our business success, apply with your resume, cover letter. Highlight your sales and digital marketing experience, especially with Google Ads, and your ability to excel in a remote work environment in your cover letter....

I am looking for a script to automatically add 7 days to a date in a table. The date format is dd/mm/yyyy and the date is located in the column "Not done late +35D". The result should be a new column with the date + 7 days, called "Not done late +42D". Specifications: The script must work on Microsoft Word. The script must be easy to use and does not require any programming knowledge. The script must be compatible with recent versions of Word (2013 and above). Example:

I urgently require a highly skilled Python programmer PythonScript which was running fine but hosting has update libraries and version. The code needs to be update with latest versions. Budget: $20 Time: 1 day. Ideal Candidate: - Proven track record in Python programming. I look forward to working with a passionate and dedicated Python programmer.

I require an adept CAD freelancer to develop a drawing for a small, basic woodshed with a pinched roof. Although I can't provide exact measurements, I can confirm it's less than 100 square feet. If you're experienced in architectural design and familiar with CAD software, this should be a quick project for you. What I need: - An easy to follow, precise CAD drawing for a small shed - A contemporary and basic design, focusing on the details of a pinched roof - A design considering a solely wooden construction What to include in your application: - Any relevant experience you have with CAD and architectural design - Sample works, if available - Detailed project proposals are not required for this application. Your CAD expertise and experience in small scale and basic desig...

I'm in need of a talented script writer who excels in creating content for explainer videos intended for industry professionals. This video will revolve around explaining a specific concept or process. The successful freelancer should: - Have a firm grasp of formal and professional language, as the tone of the script should suit an audience of industry professionals. - Be experienced in writing scripts for explainer videos and be able to construct a narrative that effectively communicates complex information in a straightforward and engaging manner. - Be able to work effectively within tight deadlines, as this project has a fast turnaround time. If you possess these abilities, I would love to see examples of your previous work in this realm. Looking forward to working...

...a year or more ago. The purpose of the conversation is to check whether the company still exists, whether it is still in the field and why they stopped purchasing. We have prepared a dedicated link for filling in the results of the conversation. I am attaching the excel file with the records, the script of the conversation. (I translated it into Dutch on Google, it must apparently be proofread) The conversation must not be mechanical, the script is only for illustration. I have prepared several questions and answers in case it comes up in the conversation. For the purpose of the conversation, you work at Vista System Netherlands. Some of the records include several people in the same company, it is enough for us if you talk to only one of them. I

I am in need of an Excel expert to meticulously comb through my data and correct errors. The main task involves handling a phone numbers list riddled with duplicates. Key Responsibilities: * Identify duplicate entries in the phone numbers list. * Cleanse and correct information accordingly. Ideal Abilities: * Excellent Excel skills * Ability to spot errors quickly * Prior experience in data cleaning and error correction * Attention to detail is critical This job requires a keen eye and precision. Apply today if you have the necessary skills.

I am seeking a reliable individual with experience in data entry, particularly with entering text data, to assist with my project. Prior work with similar tasks is key, so please be sure to highlight any relevant experience in your proposal. Specific job requirements...entering text data, to assist with my project. Prior work with similar tasks is key, so please be sure to highlight any relevant experience in your proposal. Specific job requirements include: - Enter text data accurately - Must have past work demonstrating proficiency in data entry - Final format of data must be in an Excel spreadsheet The ideal freelancer for this task will have: - Strong attention to detail for accurate data entry - Demonstrated experience with Excel - Proven track record of punctuality...

...freelancer with intermediate Excel skills to accurately and efficiently perform data entry from online resources. - Task: Your main job will be to gather data from specified online resources and input this into Excel. Accuracy is key in this role. - Skills: Your Excel skills should be at an intermediate level. You should be able to use Excel functions efficiently, handle large datasets, and have good attention to detail for data accuracy. - Experience: Previous data entry experience will be highly beneficial, especially if you have performed data entry from online resources. Having familiarity with a variety of online platforms is also advantageous. This project requires diligence, accuracy, and efficiency. The right freelancer will be proficient in ...

I'm looking for a professional who can efficiently input a variety of data types into an Excel spreadsheet. The data will be both text and numeric, along with dates. Key Project Details: - The spreadsheet will contain less than 100 columns and rows. - Data will be sourced from online resources. - Please ensure accurate data entry and review all entries for completeness and consistency before delivery. Ideal Skills: - Proficient in Excel - Attention to detail - Strong research ability and adept at sourcing information online - Accurate data entry skills

I'm looking for a professional with broad experience in AutoCAD 2D drafting and Excel data entry. AutoCAD Drafting: - You will be working on mechanical design projects. - Your primary role will be to convert manual drafts into 2D AutoCAD drafts. - Meticulous attention to detail in replicating these designs in AutoCAD is crucial. Excel Data Entry: - Additionally, your role will also include meticulous data entry tasks in Excel. IDEAL SKILLS AND EXPERIENCE: - Proficient in AutoCAD 2D drafting with an emphasis on mechanical design. - Experienced in data entry in Excel. - Attention to detail is a must. - Experience in mechanical engineering design will be a plus. I look forward to working with someone who can meet these requirements and help me take my ...

I have a flutter app already designed as 4 tabs views with all details, I want to redesign it with a design I already have.

I'm seeking a proficient professional with excellent data management skills. The project involves: - Data entry with primarily text data. - Utilizing Microsoft Excel for this data population task. - Reformatting the entered data into a well-organized database. Ideal Skills: - Proficiency in Microsoft Excel - Experience with data entry involving text-based data. - Familiarity with database design and management - Attention to detail - Strong organizational skills This project emphasizes accurateness and adherence to detail, hence the perfect candidate would be someone highly meticulous with a proven track record in similar projects.

fix a php website issue refer to the video front end working admin not working is because the script is old and server is new php version task 1: i need you be here, and change to 8.3 task 1.a make the front end working task 1.b make the admin working "for all the pages inside" and provide me the username and password after get from db.

Job Description: We are seeking an experienced and dynamic Excel Data Management Coach to provide live coaching to our team. The ideal candidate should be proficient in all aspects of Excel, from basic functionality to advanced data management, and be capable of delivering engaging and informative sessions in Malay. Our goal is to significantly enhance our team's Excel skills for improved data management and analysis within our projects. Responsibilities: - Conduct live coaching sessions in Malay for a group of employees at times agreed upon with the team. - Provide a comprehensive syllabus or course outline that covers all aspects of Excel data management, -from introductory concepts to advanced techniques. - Ensure the course material is engaging, up-to-...

...creative freelancer, adept in 2D traditional animation, and capable of creating engaging storylines for children. The project involves conjuring the entire script based on the concepts mutually discussed and subsequently crafting YouTube-ready cartoon videos tailored specifically for children. Skill Requirements: - Proficiency in 2D traditional animation - Experience with scriptwriting for a young audience (children oriented content) - Ideas to create engaging, educational, and fun content - Knowledge of YouTube content guidelines for kids - Experience in a similar role will be highly preferred. This project will challenge your creative script-writing skills and your expertise in making captivating 2D traditional animations. Exciting opportunity to influence young ...

I'm seeking an expert in VBA coding, financial dashboard design, and crafting Power BI presentations. This project's focus is to: 1. Develop VBA coding 2. Design interactive and dynamic financial dashboards 3. Create an engaging Power BI presentation The ultimate goal of the dashboard and presentation is to: • Thoroughly analyze financial data • Visualize the company's financial performance in a compelling manner • Present clear and concise financial insights The types of financial data that will be included in the dashboard and presentation encompass: • Revenue • Expenses • Profit/Loss • Cash flow • Budget Ideal candidates possess in-depth experience with VBA, financial dashboards, Power BI, and prove...

We need an online Virtual assistant to help us with our company tasks such as social media posts, research data entry etc... The tasks are very simple, however, this will be ongoing, daily work for the foreseeable future. Must be reliable and consistent in order to be successful in this role.

Basically solve this: TLDR; I have upgraded an old project from Ionic 4 to Ionic 7 and cannot solve all the errors I am facing. Help me solve this one, I will probably throw some more at you until this project is up and running (with Ionic 7) again.

I'm looking for a skilled typist to assist with my cartoon writing session on Wednesday 3/27/24. - You should have your own laptop and have excellent typing skills and accuracy. - Y...cartoon writing session on Wednesday 3/27/24. - You should have your own laptop and have excellent typing skills and accuracy. - Your role will involve typing up dialogue, narrative descriptions, and details of characters' actions and settings from the cartoon. - For each session, you'll be typing up about 5-15 pages of content. A background in creative writing or experience with script typing will be a huge plus. Good understanding of cartoon storylines is essential. Attention to detail is key, as the typed documents will serve as the main basis for the cartoon'...

...- Collaborate with the team to choose compelling cases and brainstorm creative angles for storytelling. - Write scripts efficiently, communicating complex ideas clearly and concisely. - Keep track of sourced materials and ensure accuracy in research and storytelling. - Stay updated on trends in the true crime genre to find fresh and engaging content. - Incorporate relevant evidences within the script Requirements: *Experience in writing, especially in the true crime genre, preferred. *Strong research skills, especially online, to find hidden gems of true crime content. *Attention to detail and a commitment to factual accuracy. *Ability to handle dark subject matter with sensitivity and respect. *Good communication skills, able to convey ideas quickly and efficiently. *Be able to...

I'm looking for an experienced freelancer who can create a dynamic and detailed Excel spreadsheet to break down the scenes of a screenplay, identifying specific elements of each scene (e.g Location, Characters). **Requirements:** - The ability to input details including Location, Time, Characters involved, and whether the scene is interior (INT) or exterior (EXT). - The spreadsheet should be structured to allow sorting options. This function is crucial for organizing the scenes in various orders, such as Chronological, by Scene Number, or other categories as needed. **Ideal Skills and Experience:** - Basic Proficiency in Microsoft Excel or similar spreadsheet software - Previous experience in creating spreadsheets for screenplay analysis or similar projects would...

Using the pictures attached, please turn this design into a pyQT5 python script, nothing else is required. The picture in the background, is also attached below. Please make sure it matches the design perfectly. Use clean code, and keep style sheet seperate to the widgets however they should still be in the same python file. To make sure you read the job description please mention 'XBOT' in your application Thanks

I need 24 hours of your expertise in internet research to pinpoint distributors in the USA for Pergolas & outdoor furniture, the core products I aim to feature on my website. Finding these distributors is challenging, and your ability to uncover them would be invaluable. Upon identification, please add them to the provided Excel list, noting the number of brands they represent. Be aware that access to some sites might require a 'dealer login'. This task is an initial step towards a regular monthly assignment focused on supplier sourcing. Initially, my goal is to identify 1-2 very good distributors to kickstart the process. I would ask you to research 24 hours in 3 milestones, and each 2 days send me an excell with an update of about 8 hours of work. It could be that ...