Vba import excel worksheet일자리
...order! Are you a science journalist or scientist with a great idea still in the beginning stages? Or are you stuck closer to the finish line, unsure what you need to do to get your paper up to commercial or academic publishing standards? I can help! I am a widely published writer of nonfiction, journalism, and science research with a wide variety of publications under my belt. I especially excel in first-person investigative journalism, memoir and biography, mainstreaming science for press releases and articles, and polishing scientific papers pre-publication (especially mechanical engineering, biomedical engineering, Sports science, Ergonomics, Biomechanics). I can advise on a wide variety of styles from mass market to specialist publications and especially enjoy 'punc...
VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
I need an Excel list containing all the companies attending an upcoming exhibition. The list should include the following details for each company: - Company Name - Booth Number - Contact Information (whatever is available, website should be enough) - Company Description (in a brief summary) - Country Ideal candidates for this project should be familiar with data collection and Excel. Attention to detail is crucial, as the information needs to be accurate and well-organized. Experience with similar tasks is a plus.
I need assistance in converting a multi-tab Excel file into a detailed table for record-keeping purposes. The data should be organized in the table by category. Key details: - The table should only contain raw data, with no specific calculations or summaries needed. - The ideal freelancer for this project should have strong Excel skills and experience in data organization.
...skills for various projects. Translation: Professional translation services for documents and content. Medical Writing: Assistance with healthcare-related content and research. Data Entry: Accurate and efficient data management. Diet & Public Health Research: Creating reports and articles related to diet and health. PowerPoint Presentations: Creating professional and engaging presentations. Excel Work: Data analysis, charts, and spreadsheet management. Requirements: Strong attention to detail. Relevant experience in any of the above-mentioned fields. Ability to meet deadlines. Deliverables: High-quality, error-free work. Submission within the agreed timeline. Budget: Flexible, depending on the project scope and quality. These projects are long-term, requirin...
I need someone to analyze my order data. I have it in an Excel/CSV file and it contains data for up to six months. Specifically, I want to know: - How many orders were placed on each weekday (Monday, Tuesday, Wednesday, Thursday and Friday) in February and March, and so on for the following months. The final analysis should be provided to me in another Excel/CSV file. Ideal skills for this job include: - Proficiency in data analysis, particularly using Excel - Understanding of order data and e-commerce metrics - Experience in creating clear, concise data reports. Please make sure that your Excel skills are top-notch, as this is the format I want to receive the final results in.
I possess a survey dataset centered on tea consumption and I am seeking a skilled data analyst to assist with its evaluation. The ultimate goal is to gain insights that will enhance the data-driven nature of an article I am crafting base...article I am crafting based on these findings. Key Responsibilities: - Identify correlations between different age groups and their tea consumption habits. - Extract significant insights and trends from the dataset. - Create visual representations (graphs, charts, etc.) to support the article. - Summarize findings in a clear, concise manner. Ideal Skills: - Proficiency in data analysis tools (Excel, Python, R, etc.). - Strong statistical acumen to detect meaningful patterns. - Excellent ability to present findings in a clear and visually appeali...
...should come in an Excel spreadsheet format. Key Components of the Project: - Inventory Report: This should detail our current stock levels, any shortages or surpluses, and projected needs based on current production rates. - Production Metrics: The report should include total units produced, production efficiency, and downtime causes. This will help us pinpoint areas for improvement and better understand our overall productivity. - Provide batch tracking information to trace inventory items through their production stages. - Include inventory turnover rate to assess how effectively inventory is being managed over time. - Include cost analysis regarding holding and ordering inventory to optimize financial efficiency. Ideal skills for this project include: - Proficiency in Ex...
I need to convert data from XML to Excel. I've got an example XML file that can be used as a reference for the conversion. Ideal Skills: - XML - Excel - Data Conversion - Attention to Detail Please ensure that the conversion is precise and matches the structure of the example XML.
I'm an e-commerce seller seeking a proficient Excel specialist who can create formulas and automate processes for my inventory tracking. Key Responsibilities: - Develop Excel formulas and automate processes to enhance efficiency - Create inventory level alerts to prevent stock shortages - Conduct sales tracking and analysis to inform business decisions Skills & Experience: - Advanced Excel skills with a focus on automation - Previous experience in e-commerce inventory management - Proficient in sales tracking and data analysis.
Excel Spreadsheet Template Development I'm in need of someone who can create me an Excel Spreadsheet template that's comprehensive and easy-to-use template for managing sales quotas. I need the design to be clear, neat, and extremely user-friendly. This template will be used to track the performance of 8 customers across 2 product lines throughout the year. What I need: - Develop an Excel spreadsheet to manage sales quotas for 8 customers, each with quotas for 2 product lines (Product A and Product B). - Track year-to-date performance revenue and percentages for each customer. - Integrate monthly forecasts, qualified pipeline, and renewals for each customer. - Ensure the spreadsheet is simple to use, allowing for easy addition or removal of customers and da...
I need a professional to help me recover my crypto wallet and show me the steps. I've installed Bitcoin Core wallet on my Windows machine but unfortunately, I have not backed up my file. Now, I need assistance to import this file into Bitcoin Core so that the program displays the balance and makes it possible to try to find the password. Ideal skills for this job include: - Extensive knowledge of Bitcoin Core software - Experience with Windows operating system - Expertise in wallet recovery procedures Please note, I do not have any clues about what my wallet password might be.
...expectations. • Provide timely and well-documented cost breakdowns for bids, proposals, and budget planning. Qualifications & Skills • Experience in material takeoffs and cost estimation in [industry, e.g., construction, manufacturing, engineering]. • Strong understanding of engineering drawings, blueprints, and CAD models. • Proficiency in estimation software (such as Bluebeam, PlanSwift, Excel, or industry-specific tools). • Ability to work with engineers, architects, and project managers to refine estimates. • Strong analytical skills with attention to detail. • Excellent communication and negotiation skills for working with vendors and suppliers. • Ability to manage multiple projects and meet tight deadlines. Preferred Qua...
I am seeking an Excel expert who can create a master Excel file and a child file with limited columns. The key requirement is that both files need to be synchronized, ensuring that any changes made in one file are automatically reflected in the other. Key Tasks: - Create a master Excel file with specified columns (details will be provided) - Create a child Excel file with limited columns - Set up synchronization between the two files - Use IF formula where necessary to ensure smooth functionality Ideal Skills: - Proficient in Microsoft Excel - Experience with IF formula and other Excel functions - Ability to create and manage linked files - Detail-oriented to ensure accurate synchronization The synchronization should be triggered by any of the ...
I am seeking a skilled WordPress developer to upgrade my existing website. The project involves enhancing the site's design, improving functionality, and ensuring responsiveness across devices. Familiarity with the latest WordPress plugins, firebase, GTM and themes is essential. The ideal candidate should have a keen eye for deta...link to the store visit history page that shows the visitors of a specific store. 3. add graphical elements like a bar chart on the store visit history page to show the first 10 store visits per day. it should be related to the filter. 4. add a category statics page with a date filter and it should have charts like bar, pie and others. 5. detect user city and country from IP. 6. export data as Excel from the store visit history page. my website is c...
I'm in need of an Access database designed specifically for reporting and ana...handle data storage and retrieval while also providing general reporting capabilities. Key requirements include: - Development of custom reports tailored to my operational data needs, specifically Profit and Loss Statements on a per operating unit and collective/all units basis. - Creation of user-friendly dashboards for easy data visualization. - Implementation of automated data import processes involving excel and/or cvs file uploads. Ideal candidates for this project should have: - Extensive experience with Microsoft Access database development. - Strong skills in data analysis and reporting. - Prior experience in designing dashboards and custom reports. - Knowledge of automating data im...
Excel Spreadsheet Template Development I'm in need of someone who can create me an Excel Spreadsheet template that's comprehensive and easy-to-use template for managing sales quotas. I need the design to be clear, neat, and extremely user-friendly. This template will be used to track the performance of 8 customers across 2 product lines throughout the year. What I need: - Develop an Excel spreadsheet to manage sales quotas for 8 customers, each with quotas for 2 product lines (Product A and Product B). - Track year-to-date performance revenue and percentages for each customer. - Integrate monthly forecasts, qualified pipeline, and renewals for each customer. - Ensure the spreadsheet is simple to use, allowing for easy addition or removal of customers and da...
I'm seeking a professional to review and optimize the VB code in my Excel file, which has been modified over the past 20 years. The primary goal is to streamline the code for future users. The code has sections that handle macros and automation scripts. These scripts involve data import, formatting, and report generation. Ideal skills and experience for the job: - Proficient in Visual Basic for Applications (VBA) - Extensive experience with Excel - Previous experience in code optimization for performance - Excellent problem-solving skills, particularly with macros and automation scripts - Ability to simplify complex code for future understanding
I need assistance with integrating my Excel spreadsheet with an API and webhooks to fetch customer data from external sources. I am not quite sure which API service to use, so your expertise in identifying the appropriate REST, SOAP, or GraphQL API will be crucial. Key Requirements: - Understand and implement API integration in Excel - Expertise in identifying suitable API services - Experience in working with webhooks - Proficient in Excel I am looking for someone who can automate the process of fetching this data, allowing for a seamless and efficient workflow. Your experience with manipulating Excel for data processing tasks will be a significant advantage for this project. Please provide examples of similar projects you've completed in your bid.
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.
...Reference for expense categories and summary formats. Milestone 4: Final Review & Revisions ($15) Tasks: Apply final corrections based on feedback. Deliver the completed spreadsheet with all data cleaned, formatted, and summarized. Files to Reference: All project files (including feedback notes, if provided). Final versions of the cleaned data and formatted tables. Guessing python, power query, vba, macros, some AI workspaces or other data analyst tools can make this smooth for you. Need done by Feb 13. Budget is $80 ...
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.
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 need a data entry form with over 100 fields. The form will...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 e...
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 d...experienced data analyst to dissect COVID-19 data. The focus will be on death and recovery rates, 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 date of...
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...
...Include comprehensive inline code comments and external documentation. - Supply a sample integration within a React Native app to demonstrate how to use the function for uploading the MP3 data. Example Usage: Below is an example snippet illustrating how the function might be used within a React Native component to upload the MP3 stream directly to an endpoint: ```javascript // Import the function from your module import { downloadYouTubeMP3 } from 'your-module-path'; // Example usage within a React Native component async function handleUpload() { const youtubeURL = ''; try { // Call the function which returns a Promise that resolves to a stream or in-memory object (e.g., a Blob or Uint8Array) const mp3Data = await downloadYouTubeMP3(yout...
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.
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.
...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...
...company channel. 3. Company Channels & Groups: o A dedicated company-wide channel for announcements. o Ability to 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 &a...
I am seeking a skilled WordPress developer to upgrade my existing website. The project involves enhancing the site's design, improving functionality, and ensuring responsiveness across devices. Familiarity with the latest WordPress plugins, firebase, GTM and themes is essential. The ideal candidate should have a keen eye for deta...link to the store visit history page that shows the visitors of a specific store. 3. add graphical elements like a bar chart on the store visit history page to show the first 10 store visits per day. it should be related to the filter. 4. add a category statics page with a date filter and it should have charts like bar, pie and others. 5. detect user city and country from IP. 6. export data as Excel from the store visit history page. my website is c...
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...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 entry and condition...
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 practices for customer co...
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.
