Excel vba import csv file into worksheetpráce
I need an Excel expert to build and automate a user-friendly price sheet for me. Key Requirements: - The sheet should cover various categories: electrical items, labor, markup, taxes, etc. - The price sheet should be easily exportable to PDF & CSV format. Ideal Skills: - Strong proficiency in Excel - Experience in building automated Excel sheets - Ability to create user-friendly interfaces - Understanding of pricing components (labor, markup, taxes) - PDF & CSV export experience The goal is to create a comprehensive, user-friendly, and automatable price sheet that I can use for various categories. Please only apply if you have the relevant experience.
I am in need of a seasone...and monthly reports. These reports will be derived from our job sheets, which are Word documents stored in Dropbox. Key Responsibilities: - Develop an automated system using Power Automate to generate weekly and monthly reports from our job sheets. - Ensure this system sends the reports to our management team. - Present the data in an easily digestible format using Excel. Ideal Skills: - Proficient in Power Automate and Excel. - Excellent understanding of data visualization through graphs. - Experience with interpreting and reporting on employee performance, repeat clients, and staff performance data. As for the data visualization, the type of graphs used will depend on the specific data being presented. Therefore, a flexible and analytical mind...
I'm looking for a skilled Excel developer to create a custom Excel form for me. This form should automate the generation of professionally designed, formal and professional PDF donation receipts. The Excel form will need to collect: - Donor information - Donation amount and date - Custom messages or notes The ideal freelancer for this job should have extensive experience in Excel, PDF generation, and ideally has a background or understanding of creating formal and professional documents. The final output should be a single receipt per PDF.
I need assistance in converting XLS files to CSV format, but with a specific filtering process. - Data Selection: Only certain pieces of information from the XLS files need to be included in the final CSV. - Filtering Process: Data needs to be sifted through based on conditional logic related to its type. This may involve identifying numerical ranges, specific text matches, or certain date parameters. The ideal freelancer for this project should have experience with data manipulation and conversion, particularly from XLS to CSV. Familiarity with conditional logic and data filtering is crucial. Please include relevant experience in your proposal.
...Ability to work quickly and efficiently Strong attention to detail Prior experience with electrical layouts is a plus Compensation Payment is on a per-project basis, determined by the quality and timeliness of your work. Process I will send you the project files (in AutoCAD 2024 format). You will complete the edits and measurements to the required standard. You will then send back the updated file for review. If you meet these requirements and are interested in ongoing work, please reach out with your relevant experience and examples of previous projects....
...batch file created to streamline my Windows 11 installation process. Can you help us with the following project? Please create a batch file to automate Windows 11 installation, software installation, and configuration. Below is a working view of the project. I want to automate these tasks. The video already automates these tasks, but the version of Windows 11 is old and the apps are old, so I would like you to create a new version of Windows 11. Automated installation of Windows 11, automated installation of apps, automated configuration I have version 6.1.1 of this. Reference site Key Requirements: - The batch file should
TENGO UN EXCEL MACRO PARA LA EXPEDICION DE CERTIFICADOS LABORALES LLENOS DE FORMULAS, SIN EMBARGO AL PERDER MI PC SE ME PERDIÓ EL ARCHIVO ORIGINAL Y SE ME DAÑÓ MI ARCHIVO MACRO, PUEDO SEGUIR TRABAJANDO PERO YA NO ES COMODO. QUISIERA QUE ME VUELVAN A HACER MI EXCEL.
I'm looking for a skilled Power BI expert who can automate the sending of my Power BI reports via Gmail on a daily basis. The reports should include data from my ticketing tools in CSV format. Key aspects of the project: - Automate daily Power BI report emails - Use of Gmail for report distribution - Inclusion of ticketing tools data in CSV format Ideal Skills and Experience: - Proficiency in Power BI - Experience with email automation - Knowledge of handling and reporting ticketing tools data If you're interested in this project, please don't hesitate to reach out.
I'm looking for a Power Automate expert to create a workflow that monitors a SharePoint folder for a .csv file. The workflow should open the file, filter it based on text variables in 2 column, and create a new file for each filtered variable save back to SharePoint, attach to an email, and send to email addresses linked to each filtered variable Alternatively, it can paste the results from each filtered variable into the body of an email to and send to email addresses linked to each filtered variable . If possible, only selected columns of the original .csv file needs to be included in the output. Key Requirements: - Proficient in Power Automate - Experience with SharePoint and .csv files - Ability to create automated workflows...
I'm looking for a data analyst experienced with Kibana to sift through my data logs and identify any potential threats of unauthorized access. Key Focus Areas: - Analyzing login attempts and file access records for suspicious patterns. - Identifying and flagging any potentially malicious logs. Time Frame: - The analysis will cover the period between 24th August and 26th August, and on the 4th of September, 2024. Ideal Skills: - Proficient in using Kibana for data log analysis. - Experience with cybersecurity and threat detection. - Ability to identify and interpret patterns indicative of unauthorized access.
Guidelines: 1- Download the Word Document and the excel workbook 2- Watch the Diamonds Video(s) First. I added date it was sold and msrp columns to the dataset. 3- Do not Change the Font or the format. 4- 10% esthetic, grammar, proper formatting and following guidelines 5- Type your answers below the question; make sure you keep the formatting. 6- You may need to brush off on excel formula(s), pivot tables and charts. 7- Paste your output into the proper location of the proper excel work sheet. 8- Your Submission is an excel workbook that details your work based on the workbook Template(s) Some useful excel Tips: • Always, Always, Always give your table a name so you can reference it later as needed. You can either do that when you create t...
AI Cartoonization Expert – Trainer & Consultant We are looking for an AI Expert in Character Cartoonization to **teach and guide** us on professionally converting real-life images into **2D, Pixar, Disney-style, or 3D cartoon characters** using AI tools. ### **Responsibilities:** - Demonstrate how to **convert real human images into high-quality cartoon characters** using AI. - Provide **step-by-step training** on advanced AI cartoonization techniques. - Recommend and teach the use of **professional AI tools** for the best results. - Ensure the output is **highly professional and artistic**, not just basic AI filters. - Share tips on enhancing AI-generated images for a **polished, detailed, and lifelike** appearance. ### **Requirements:** - Expert...
I need a data entry form with over 100 fields. The form will be used for inputting mixed data (text and numbers). The entered data should be able to be synced into 10+ sheets with the push of a button. Requirements: - Design a data entry form with 100+ fields - Mixed data input (text and numbers) - Data synchronisation into 10+ sheets manually with a button Key Skills: - Proficient in Microsoft Excel or Libreoffice Calc - Experience in creating complex data entry forms - Knowledge in setting up data synchronisation - Familiarity with data validation rules Some fields in the form will need validation, so experience with setting up data validation rules is essential. Please reach out if you have the relevant skills and experience.
I'm looking for a freelancer who can help me with a data entry project. The task involves taking mixed data from a spreadsheet and entering it into a specific website. Details: - The data is organized in the spreadsheet as single rows with different fields. - The data types include both text and numerical data. - If an error occurs while submitting a row, the process should skip the erroneous row and log the error for review. Ideal skills for this job include: - Experience with data entry. - Proficiency in using websites for data input. - Ability to troubleshoot minor issues. - Familiarity with logging errors. Please note that the project requires careful attention to detail, as accuracy is critical in data entry tasks.
Estamos buscando un Asistente de Ingreso de Datos detallis...verificar datos en hojas de cálculo o sistemas internos. Organizar y clasificar información de manera precisa. Revisar documentos para corregir errores o inconsistencias. Mantener la confidencialidad y seguridad de los datos. Cumplir con plazos y objetivos establecidos. Requisitos: Experiencia en ingreso de datos o trabajos administrativos (deseable, pero no obligatoria). Manejo básico o intermedio de Excel, Google Sheets y otras herramientas de oficina. Atención al detalle y habilidades organizativas. Capacidad para seguir instrucciones y trabajar de forma autónoma. Si estás interesado/a, envía tu solicitud junto con una breve presentación sobre tu experiencia y dis...
...encouraging and supportive work environment? We are looking for a trustworthy and reliable EA/PA for a philanthropist / filmmaker with an interest in wildlife. The tasks will involve working on ad-hoc projects with the charities, film shoots and assistance with personal matters. The role is not just about organisation - it’s about a long-term partnership. If you have excellent communication skills, excel with logistics, have an analytical mindset and enjoy making this happen, the role is for you. Please note that the role is remote-based and the client is primarily based in Europe. Main tasks Carrying out various personal assignments of the manager related to business: real estate search, insurance, service provider companies; Search for contractors for assigned t...
I need assistance with data entry focused on numerical data sourced from printed documents. The data needs to be entered into an Excel spreadsheet. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry from printed documents - Ability to handle numerical data Please note, this project requires meticulous data handling to ensure accuracy and completeness.
Sending Email and PDF generation from Excel
...Display of Seating Chart: A live seating chart should be available to display on a TV screen at the library branch. This will help new subscribers see which seats are available in real time. 10. Technical Requirements: Frontend: HTML, CSS, JavaScript (React.js preferred) Backend: Node.js with (or Django/Flask if using Python) Database: MySQL or Firebase for storing seat assignments Excel Handling: Google Sheets integration for exporting and updating seat reservations 11. User Roles: Library Owner/Admin: Full access to assign/release seats, manage branches, and add/delete seats. Staff: Can assign and release seats but cannot modify system settings. 12. Expected Outcome: A fully functional seating arrangement system with an intuitive UI. Real-time updates on seat reservatio...
I would like to request the completion of data extraction for all matches of the 2024-2025 season and the integration of this data into the existing file while maintaining the Excel format. Additionally, please provide me with the source code used for the data extraction process. Let me know if you need any further details. Looking forward to your response. Please note that the final deadline for submission is today. Let me know if you need any further details.
I'm seeking an experienced data analyst to dissect COVID-19 data. The focus will be on death and recovery rates, with the ulti...with the ultimate aim of pinpointing the geographical spread of the disease. Key Aspects: - Analyze death and recovery rates from COVID-19 - Identify geographical patterns in the data - Present findings in a clear, accessible format Ideal Skills: - Proficiency in data analysis software (e.g., Python, R, Excel) - Strong statistical skills - Ability to communicate complex findings simply - Ability to visualize and present data in a smooth, easy-to-understand manner Expected outputs: - The file should contain data analysis and graphics that illustrate these analyses. Deadline: - It is preferable to deliver the work within seven days from the ...
I run an export company specializing in herbs and spices, and I'm in urgent need of a professional who can help me find potential importers in North America, Europe, and Asia. Key Requirements: - Identify companies that import herbs and seeds - Focus on finding sales opportunities Information Needed: - Contact details of these companies - Their annual import volume - Current suppliers they are working with This is a sales-driven project, so the more potential leads you can get, the better. Please have experience in market research and sales intelligence.
Sono alla ricerca di un sistema per generare un catalogo prodotti in PDF sulla base di un template popolato con dati archiviati su tabelle Excel o SQL. Allego un esempio del catalogo che vorrei ottenere.
Service Member Excel Tracker. I need an Excel spreadsheet with automated formatting and drop-down lists. Conditional Formatting – The "Action" cell will turn red if more than 3 days have passed since the date was entered. Drop-Down Menus – "Types of Service" in Column B "Reason(s) for Visit" in Column I with all the requested options below: • Army Credentialing Assistance • ArmyUniversity BNCEDP • ArmyIgnitED Enrollment • ArmyIgnitED Problems • ArmyIgnitED Information • ArmyU Credentialing • BSEP Counseling • Chapter Counseling • College Information • Commissioning Assistance • Dashboard • Exception to Policy Counseling • Financial Aid Information • HE Track C...
...(or similar in-memory object). The goal is to allow the MP3 data to be directly uploaded to a server endpoint without saving the file to the user’s device. Key Requirements: React Native Compatibility: The solution must integrate seamlessly into a React Native app for both iOS and Android. Functionality: - Accept a YouTube video URL as input. - Determine and access the available audio-only stream for the provided video (or the best available audio track). - Convert or repackage the stream into an MP3 file if necessary. - Return the MP3 data as a stream or in-memory object (e.g., Blob or Uint8Array) suitable for direct upload via an HTTP request—do not write the file to local storage. Implementation Constraints: - Must be built using pur...
Service Member Excel Tracker. I need an Excel spreadsheet with automated formatting and drop-down lists. Conditional Formatting – The "Action" cell will turn red if more than 3 days have passed since the date was entered. Drop-Down Menus – "Types of Service" in Column B "Reason(s) for Visit" in Column I with all the requested options below: • Army Credentialing Assistance • ArmyUniversity BNCEDP • ArmyIgnitED Enrollment • ArmyIgnitED Problems • ArmyIgnitED Information • ArmyU Credentialing • BSEP Counseling • Chapter Counseling • College Information • Commissioning Assistance • Dashboard • Exception to Policy Counseling • Financial Aid Information • HE Track C...
I'm looking for a skilled Excel VBA programmer who can help me fix my current VBA code. The code is supposed to automate repetitive tasks, but it's producing incorrect results. - Code Fixing: The primary task will be troubleshooting and fixing the existing VBA code. - Automation: After fixing, I will need the coder to enhance the script to automate more tasks in Excel. Ideal candidate should possess: - Proficient knowledge in Excel VBA - Experience in coding for task automation - Problem-solving skills to rectify existing code - Attention to detail to ensure accuracy in results.
As discussed, as you did last year. 1 week deadline
I need a legal letter in English translated into Mandarin. If you’re interested kindly contact the project manager via WhatsApp +1 (289) 791‑2138
I need 50 thousand companies name and Email. This should be only from CHINA region and the companies should be manufacturer. This is on urgent basis The data should be provided in an Excel file format. Focus on manufacturers in the Technology industry. The data should be delivered within 2 days. Please include the following details: Email and company name. No Please include the following additional details for each company: None. The data should be collected from: any site. Ensure all email addresses are verified for authenticity and validity. None. Please ensure the emails are specific to the Manufacturing department.. PLEASE SEND 5000 SAMPLE FIRST TO GET AWARDED THIS IS URGENT SO ONLY REAL PERSON.
I have approximately 56 pages of content in PDF format that needs to be typed out into a .doc file. This document needs to be formatted as a court document, complete with line numbers, footnotes, and other necessary legal formatting elements. The PDF includes all formatting; I need you to replicate it in .doc. Specific requirements include: - Using Georgia, 13pt font throughout the document. - Including both headers and footers in the document, as well as footnotes - Consistently and accurately replicate the citations, including subsection symbol Ideal candidates for this project will have experience with legal document formatting and a strong attention to detail. Please ensure you have a good command of typing and document formatting software. The .pdf is attached....
...40). The sessions should be held on separate dates, March 3-7, 2025, and March 24-28, 2025. May choose to hire for one or both sessions. Pay: $4,000 per session, not to exceed $8,000 total for both sessions. Travel costs will not be provided. Trainee Skill Levels: Attendees have varying levels of experience with Power BI, ranging from basic to intermediate, with many being advanced Microsoft Excel users. The training should accommodate this diverse skill set. Content: The training must cover topics such as connecting to data sources, data cleaning, data visualization, advanced analysis techniques, creating dashboards, and sharing reports. All training materials must be provided digitally at least one day prior to the start of training. The training must also include demos a...
...create department-specific or project-based channels. 4. Direct Messaging & Group Chats: o Employees can chat one-on-one or create group conversations. o Read receipts and typing indicators for real-time communication. 5. File Sharing & Storage: o Upload and share documents (Word, PDFs, Excel, images, etc.). o Cloud storage integration for easy file access. 6. Communication History & Search: o Chat history is saved for future reference. o A search function to find messages, files, or contacts. 7. Notifications & Alerts: o Push notifications for new messages, mentions, and file shares. o Customizable notification settings for users. 8. User Roles & Permissions: o Admins can manage user roles (e.g., employee, manager, admin). o Control acces...
I need assistance with a data entry task involving mixed data (both text and numbers). The data is sourced from digital files in Excel format. Key Requirements: - Proficient in Excel, with excellent data entry skills. - Able to accurately transcribe mixed data (text and numbers). - Detail-oriented to ensure data integrity. - Prior experience in similar data entry tasks is preferred.
I have a basic rules file edited in notepad or similar. I would like to duplicate and modify the rules (name, 5 conditions and 2 values) into the duplicated rules. I have all the data that needs inputting in an excel table. I am happy to enter the required data but am looking for a tool that will create/edit the rules file with the desired amounts. I have a rules file in notepad that needs to be rewritten into an Excel file. The rules are conditional formatting rules and are relatively simple. The data in the notepad file is structured as plain text with delimiters. Ideal Skills: - Proficiency in Excel - Understanding of conditional formatting rules - Ability to interpret plain text with delimiters Experience in data...
I'm looking for a skilled Power BI dashboard developer to assist me in creating a comprehensive dashboard. The primary purpose of this dashboard is to track various performance metrics. Requirements: - Integration with Excel spreadsheets - Visualization of data in the form of charts and graphs Ideal Skills: - Proficient in Power BI - Extensive experience with Excel - Excellent data visualization skills - Strong understanding of performance metrics tracking Please provide examples of your previous work with Power BI dashboards.
I'm seeking an Excel expert to upgrade my existing sheet, initially designed for resource capacity planning, to incorporate varying cost calculations dependent on the project at hand. Key Requirements: - The upgraded Excel sheet should be suitable for project management, particularly in resource planning. - It should allow for the use of multiple labor rates in cost calculations, reflecting the different costs associated with various projects. - The sheet should be able to accommodate changes in cost based on the specific project being worked on, enhancing the accuracy of resource cost forecasting. Ideal Skills: - Extensive experience with Excel, particularly in creating complex formulas and calculations. - Prior experience in project management resource plannin...
I'm looking for a professional who can assist me in sending promotional broadcast messages to my customers via WhatsApp. - Content: The broadcast will primarily consist of promotional off...messages to my customers via WhatsApp. - Content: The broadcast will primarily consist of promotional offers. - Customer List: I already have a ready list of customer phone numbers, so I need someone who can efficiently handle the sending of the messages. - Format: My customer list is in an Excel/CSV file, which I can provide. Ideal skills for this project would include experience with WhatsApp Business API, understanding of promotional messaging best practices, and proficiency in handling Excel/CSV files. Knowledge of data privacy regulations and best prac...
You will get a high-end and robust calendar based entirely on Excel! I have over ten years of experience in automating tasks in Excel using formulas and VBA code, and I know that a few automations at the right spots can simplify your daily routine, save you dozens of hours, and boost your performance while focusing on what matters! In the delivered calendar, you will have the option to customize the categories/personnel that will be assigned the tasks or appointments. Based on the selected version, more features are available, like customizing colors, attaching documents, exporting to PDF, and more.
Se busca responsable de catálogo ecommerce. Puedes ver todos los detalles del rol en el documento adjunto. Las habilidades principales que se requieren son: - Buena capacidad lógica y de razonamiento - Mucha organización y buen manejo de Excel/Google Sheets - Ganas de trabajar y de aspirar a crecer profesionalmente El manejo de Amazon no es un requisito indispensable ya que te podemos formar internamente para usarlo. Es un ecommerce complejo de más de 600 productos personalizables por el usuario y requiere de alguien capaz, con muy buena organización y capacidad de razonamiento lógico bueno. Remuneración: 100% REMOTO. Es una gran oportunidad. Se paga entre 1,200 y 1,500 USD al mes.
I am seeking a seasoned web developer with a strong background in hardware integration and data manipulation for a specific project. The main objective is to connect a touchscreen tablet with an interactive interface to a program based on CSV files, ensuring smooth and efficient communication between both. Key Requirements: - Proven experience in developing touchscreen interfaces (HTML, CSS, JavaScript). - Proficiency in the React frontend framework. - Mastery of the Python (Flask/Django) backend language. - Extensive experience in manipulating CSV files and developing APIs. - Knowledge about device communication via REST API. - Prior experience with tablet (Android/iOS) integration or specific hardware (Raspberry Pi, embedded systems) is a plus.
I'm seeking a data analyst with experience in SQL and Crystal Reports. The task inv...a crystal report to generate monthly Intrastat declarations derived from our sales data. This data is stored in a SQL database and needs to be transformed into Excel format for the reports. Key components of the reports: - Sales data fields: Product information, Transaction value, Date, Invoice No, Customer Name, Item Description, Quantity, Item Amount Value, Nominal Code, SIC, Weight Each, Line Weight Amount, Gross Amount Value, Type, Customer VAT No. - Customer-based segmentation for the reports. Ideal skills: - Proficiency in SQL and Crystal Reports. - Experience with sales data analysis. - Ability to segment data by customer. - Excel expertise for report formatting. Looki...
I'm in need of a data expert who can deliver leads for replica bags shops with specific criteria. Requirements: - The companies should be replica bags shops with an annual revenue between 500,000 an...replica bags shops with an annual revenue between 500,000 and 4 million. - The leads should include the following details for each CEO: First Name, Last Name, Title, Email, Company Name, and Website. - The geographical focus is on North America, Europe, and Asia. - The data should be delivered in a CSV file. Budget: $15 for 100 leads. Ideal Skills and Experience: - Proficient in data mining and lead generation - Prior experience in sourcing data for specific industries - Excellent understanding of CSV file formatting - Ability to deliver accurate and comp...
I'm looking for a professional with extensive experience in MS-Access and VBA to help me fine-tune my existing database. This database tracks the stays (assignments = Ents) of school members (participants = Tln) who are doing internships or foreign courses at specific locations (hosting organizations = AO). Ideal expertise: - MS-Access (2016) proficiency - VBA scripting skills - Data integration troubleshooting - Report generation optimization The project involves: - Modifying the existing forms and layouts - Improving the data integration between tables - Enhancing report generation Most of the tables, forms, queries, and reports are already set. However, some integration points need to be adjusted, and this is where your expertise will come in handy. An extensive do...
I'm seeking a proficient English typist to assist with transcribing scanned images into PDF documents. The tasks will include: - Typing documents from scanned images - Data entry into MS Excel - Copy and paste tasks Ideal candidates should have exceptional typing skills with a knack for accuracy and speed. Proficiency in MS Word and MS Excel is a must, as well as experience with data entry. If you're capable of delivering high-quality work in a timely manner, I look forward to your proposal.
Check below what details I want to add in Partner app.
I need a freelancer to transcribe a research questionnaire into an Excel spreadsheet and populate it with 500 dummy data entries. Key Requirements: - The questionnaire consists of 60 questions, most of them in a Likert scale format and focused on collecting demographic and behavioural data. - The final Excel file should simulate 500 responses to the questionnaire, based on criteria provided Ideal Skills: - Proficiency in Excel - Experience with data entry and data simulation - Familiarity with Likert scale and behavioral research. Please ensure that your proposal includes relevant experience and a brief outline of your approach to this task. Include the word 'Ninja' in your PM.
Need help organizing messy Excel data ? I'm here to assist! With expertise in Excel, I offer professional services to clean, format, merge, and split data, ensuring your files are organized and ready for use. Services Provided: Data Cleaning: Eliminate duplicates, fix errors, and maintain data integrity. Data Formatting: Apply consistent styles, format dates, and more. Data Merging: Combine data from multiple sheets or files seamlessly. Data Splitting: Separate data into categories or individual sheets. Custom Solutions: Tailored services to meet your specific needs. Why Choose My Services? Experienced: Skilled in Excel with a focus on accuracy and efficiency. Timely Delivery: Committed to meeting your deadlines. Client-Centric: Your satisfaction is my p...
I require a form to be converted into a PDF fillable form for internal record keeping. The form is used to collect data on Medical Treatment. The specific fields that need to be included on the form are detailed in the provided document.
I'm looking for an efficient Executive Assistant who can help me manage my daily workflow. The primary focus will be on data management and organization. Key Responsibilities: - Manage and organize data using Microsoft Excel and Google Sheets - Sync my calendar with existing calendar apps Ideal Skills: - Proficiency in Microsoft Excel and Google Sheets - Experience in data management and organization - Excellent coordination and communication skills Good communication skills Good English spoken as well as written