Excel vbaроботи
Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
I'm seeking an Advanced Excel professional capable of creating comparative analysis charts and graphs for financial data, specifically comparing work progress. Key Requirements: - Remote work capability - Expertise in Excel chart/graph creation - Experience with financial data - Strong understanding of comparative analysis - Excellent ability to visualize complex data Ideal Skills: - Advanced Excel skills - Financial analysis experience - Data visualization expertise - Strong attention to detail - Excellent communication skills for remote work
I'm in need of an experienced MIS Executive to assist with a variety of tasks including data analysis and reporting, database ma...tasks including data analysis and reporting, database management, and automation process improvement. The primary focus of the data analysis will be assessing operational efficiency. Key Responsibilities: - Analyzing operational data to identify areas for improvement - Managing and maintaining databases - Implementing automation for process improvement The ideal candidate should be proficient in Excel, as this is the preferred tool for sales data analysis. Experience with other data visualization tools such as Tableau or Power BI is a plus, but not a requirement. Your expertise should help drive operational efficiency and contribute to overall bu...
I have a sales rate sheet on paper that I need converted to Excel. I also need additional columns showing discounted rates, with the discounts calculated automatically at 12.5% and 15%. Ideal skills for this project include: - Proficient in Excel - Data Entry - Ability to work with physical documents - Experience with creating automated calculations in Excel
I am looking for an experienced Excel professional to create a dashboard for visualizing my sales data. The primary focus will be on utilizing charts and graphs to present the data in an insightful and clear manner. Key Responsibilities: - Develop an engaging and easy-to-navigate Excel dashboard - Use charts and graphs to visualize sales data Ideal Skills: - Proficient in Excel with extensive experience in creating dashboards - Strong understanding of data visualization techniques - Ability to present complex data in a simple, engaging manner
I'm seeking assistance with formatting an Excel spreadsheet for the reconciliation of an Employee Loan account. Key Requirements: - Expertise in Excel, particularly in spreadsheet formatting. - Experience with conditional formatting, table design and layout, and cell styles and fonts. - Understanding of account reconciliation processes. The successful freelancer will help me present the data clearly and effectively, allowing for a smooth reconciliation process. Your input will be crucial in organizing the data and highlighting key figures.
I need someone with access to Refinitiv Eikon DataStream to download data for all UK listed companies over the last 6 years. List of variables will be shared to the selected candidate. The ideal freelancer for this project should have: - Prior experience with Refinitiv Eikon DataStream - Expertise in financial data analysis - Proficiency in Excel Data Format: - I would like to receive the downloaded data in Excel format. Please provide your previous relevant experiences when bidding for this project.
I need an Excel expert to help me modify and randomize my data. The tasks include: 1. Changing all dates in the “Proc Date” column to only Tuesdays and Wednesdays from July 2024 to December 2024, excluding Christmas Eve, Christmas Day, and New Year’s Day. The dates can be random, in no particular order. 2. Updating the phone numbers in the “Phone” column to: (908) 730-8880 for the entire column. 3. Changing the address in the “Address of the Facility” column to: 1630 NJ-31, Clinton, NJ 08809 for the entire column. 4. Altering the ages in the “Ages of the Patients” column to random numbers between 12-89 for the entire column. 5. Modifying the name in the “Facility Name” column to: North Hunterdon Dental Associates for...
I need a skilled Excel VBA programmer to assist in automating tasks in my Excel workbook. The primary task involves sending data from a user form to the relevant worksheet. Key Requirements: - Proficient in Excel VBA - Experience in Excel workbook automation - Ability to organize data by category in the relevant worksheet. The ideal freelancer for this project should have a strong background in automating tasks using Excel VBA and can efficiently categorize data in Excel worksheets.
I am seeking a skilled VBA developer to help automate the generation of financial reports in Excel. Ideal Skills and Experience: - Proficiency in VBA with extensive experience in Excel automation - Prior experience in automating financial report generation is a plus - Strong attention to detail and ability to understand complex financial data
...& Performance: The system must handle a growing number of users, data, and transactions without performance issues. Cloud-Based (Preferred): Ideally accessible from anywhere via web browser. Option for on-premise installation if necessary. Reporting & Analytics: Comprehensive reporting tools for sales, financials, HR, tasks, and other modules. Ability to export reports in various formats (PDF, Excel, CSV). Multi-Language Support (Optional): If feasible, the system should allow localization for different languages. Integration: Potential future integrations with third-party services (e.g., email marketing, messaging APIs, payment gateways). Open REST or SOAP APIs to connect with other systems if needed. 6. Deliverables Technical Proposal: Outlining technology stack, archit...
Retired senior needs help with keeping ongoing matters organized. Would need someone familiar with Word, Excel, willing to train for light duties in QuickBooks. At employer's residence (dealing with Parkinson's and really need some help) Personable, very laid back environment but employer needs help with filing, some calendaring, keeping appts straight etc, Offer needs to hire for a few weeks, maybe less.
...وبيانات سيتم تحديدها لاحقا الفروع: يمكن إضافة أكثر من فرع واحد لاستخدام هذا البرنامج مربع المسار: إنها مجموعة من الأسئلة. يتم تحديد عنوان الأسئلة ويتم وضع أكثر من سؤال واحد ويتم وضع أذونات للإجابة، سواء كان رقما أو كتابة أو تاريخا وما إلى ذلك. يمكنه إضافة أكثر من عنوان واحد داخل كل عنوان. أكثر من سؤال واحد (ستظهر هذه الأسئلة للشخص الذي سيستخدم النظام في شكل مربعات مملوءة (كل عنوان للأسئلة له ملف Excel أو نموذج تصميم خاص به. يتجاوز عدد عناوين الأسئلة 60 عنوانا أو أكثر ويندرج كل عنوان تحته. كل عنوان له وسيلة ولكل عنوان شكله أو نموذجه الخاص الذي يختلف عن الآخر. عند التنزيل، سيتم تزويدك بذلك (سيتم تزويدك بجميع الملفات ونريدك إدخالها مباشرة في النظام) مربع الإحصائيات: يمكنك اختيار أحد الأسئلة التي تم وضعها سابقا في مربع المسارات عن طريق الإدمان ثم تظهر جميع الأسئلة وفقا للعنوان ويحتوي...
I'm seeking an experienced freelancer to compile a detailed list of properties in a specified region. The project involves gathering and organizing property details in a comprehensive and accurate manner. Requirements: - Exceptional accuracy and attention to detail. - Proven experience in data collection and organization. - Proficiency in Excel or Google Sheets for organizing property data. - Ability to research reliable sources. Deliverables: - A well-organized spreadsheet with all the required property details. If you have experience in real estate data collection or similar projects, please provide examples of your previous work.
I'm in need of a proficient Excel expert who can design a custom Excel template for tracking my expenses. The main purpose of this template is to help me with financial tracking. Key Requirements: - Design a user-friendly Excel template with a focus on expense tracking - Incorporate built-in calculations or formulas for totals and subtotals Ideal Skills: - Proficient in Microsoft Excel - Experience in creating financial tracking templates - Strong understanding of expense tracking and budgeting Please, submit your proposal if you can assist with this task.
I need assistance with my Excel template for a UPS franchise. The template currently has projections and assumptions filled out, but I need help refining the future projections and assumptions with a strong focus on sales growth. Key tasks include: - Analyzing and refining future projections and assumptions - Assisting with sales growth predictions Ideal candidates should have: - Strong numerical skills - Proficiency in Excel - Experience with business projections - Understanding of franchise operations - Ability to interpret and analyze data
This is a repost from earlier today, as the job was awarded and then the Freelancer and I didn't agree on terms. I'm seeking an Excel expert to streamline our medical taxi charity's data processing. Currently, we manually track and report our statistics, which is time-consuming and prone to error. The project involves: - Creating an "intake" sheet to capture and automatically distribute data about riders, trips, volunteer drivers, and trends to relevant statistical sheets. - Designing a concise dashboard for our monthly reports, allowing for easy comparison of monthly trends and insights into our operations. - Ensuring the dashboard includes key metrics such as volunteer driver stats, client characteristics, and trip details. -Unfortunately the format for da...
I'm seeking a meticulous research expert to gather competitive pricing on Amazon, Walmart, and Wayfair. The task involves analyzing many product SKUs and descriptions, and in some cases, images. I need the following data for each product: -...Walmart, and Wayfair. The task involves analyzing many product SKUs and descriptions, and in some cases, images. I need the following data for each product: - Competitor Pricing - Unit Sales - Number of Reviews The collected data should be presented in a clear and organized spreadsheet. Ideal candidates should have strong analytical skills, experience with market research, and proficiency in using Excel or similar spreadsheet software. A keen eye for detail and the ability to interpret product images is also a plus. I'm looking f...
...Responsibilities: Design and build three user-friendly, real-time dashboards to track specified KPIs. Connect dashboards directly to DX1 data reports, Excel, and other relevant data sources. Enable real-time data updates to minimize manual data input and imports. Ensure the dashboards support multiple users and allow for direct data entry or seamless integration. Collaborate to ensure the dashboards align with business goals and provide actionable insights. Ideal Skills & Qualifications: Proficiency in Klipfolio, Google Looker Studio, or similar platforms for creating dashboards. Experience with data integration, particularly with DX1 reports and Excel. Strong understanding of sales, customer engagement, and operational KPIs. Ability to set up and manage real-time da...
I am seeking a skilled and Data Analyst to create comprehensive dashboards in Power BI for a financial project. The goal is to visualize and analyze key performance indicators (KPIs) that will help to make data-driven decisions and enhance financial performance tracking. Project Requirements: 1. Data Analysis & Visualization: o Analyze and structure financial data from various sources (Excel, SQL, etc.) o Create dynamic and interactive dashboards in Power BI to visualize KPIs such as revenue, expenses, profit margins, cash flow, and more. o Utilize data models, DAX, and Power Query to enhance the dashboards. o Provide clear insights and recommendations based on the dashboard data. 2. Customization and User Interactivity: o Develop filters, slicers, and other interactive features...
I'm seeking an Excel expert to streamline our medical taxi charity's data processing. Currently, we manually track and report our statistics, which is time-consuming and prone to error. The project involves: - Creating an "intake" sheet to capture and automatically distribute data about riders, trips, volunteer drivers, and trends to relevant statistical sheets. - Designing a concise dashboard for our monthly reports, allowing for easy comparison of monthly trends and insights into our operations. - Ensuring the dashboard includes key metrics such as volunteer driver stats, client characteristics, and trip details. -Unfortunately the format for data collection has changed somewhat from month to month so there will be some manual corrections to be made to align th...
Hi! Usual conditions - four groups so €50 Have you got the excel file still?
I need a professional Excel expert with strong skills in data analysis, macros, and VBA. You will be required to create a sophisticated Excel spreadsheet for analyzing trading data. Key Responsibilities: - Create an advanced Excel spreadsheet for trading data analysis - Incorporate real-time data updates into the spreadsheet - Implement advanced charting and visualization techniques - Design automated trading signals within the spreadsheet Ideal Skills: - Excel: Advanced spreadsheet creation and optimization - Macros and VBA: Proven experience in automating tasks and enhancing workflow - Python: Familiarity with Python for data analysis and Excel integration would be a big plus. Payment: - The designer will be compensated on a daily basi...
I'm in need of custom Excel templates specifically designed for financial reporting. These templates will be used primarily for tracking and managing accounts receivable. Ideal skills for this project include: - Advanced Excel proficiency - Experience with financial reporting - Knowledge of accounts receivable management - Ability to create user-friendly templates
I'm looking for a freelancer who can help me automate the analysis of trading oi and volumes from the NSE using Excel. Key Tasks: - Automate the collection and analysis of NSE trading volume data within Excel - Use statistical analysis techniques to interpret the data The ideal candidate for this job should be proficient in Excel automation, have a strong understanding of statistical analysis techniques, and be familiar with NSE trading volumes.
I need assistance with using mathematical formulas in Excel, specifically 'Sum and Average' and 'Index and Match'. Your role will mainly involve data entry and creating charts. Ideal skills and experience for the job: - Proficiency in Microsoft Excel - Experience with data entry and chart creation - Familiarity with mathematical formulas, specifically 'Sum and Average' and 'Index and Match' - Attention to detail and ability to work accurately.
I'm seeking a proficient web scraper to extract contact details from the provided website. Ideal Skills: - Proficient in web scraping tools and software. - Experienced in data extraction from company websites. - Deliver the extracted data in Excel format.
I am looking for a VBA expert who can develop a solution for generating detailed reports from Excel files for my business case. The primary objective of this project is to automate the report generation process, making it more efficient and less time-consuming.
I'm in need of assistance with data entry into an Excel sheet. The data is of mixed types - both text and numeric. Key tasks include: - Manual entry from various files - Ensuring the data is organized into standardized rows and columns Ideal candidates should have: - Proficiency in Excel - Attention to detail to ensure accurate data entry and formatting.
I am in need of comprehensive data about lodges in the Serengeti ecosystem. This data should include both the latitude/longitude of these lodges and reviews. Your task will be to compile this information into an Excel spreadsheet. The completed data set will be used for a research paper, so accuracy and thoroughness are paramount. Ideal skills and experience for this job include: - Proficiency in data collection and analysis - Experience with Excel - Attention to detail - Ability to understand and meet academic research standards.
...package purchases. • Notifications for payment confirmations. 3. Advertisement Platform • Allow placement of ads for related services. • Dynamic ad slots for targeted promotions. 4. Device API Integration • Support for APIs from various tracking devices (e.g., Cantrack, Teltonika, Tramigo, Fifo, Baanooliot). • Real-time reporting and seamless communication. 5. Reports and Analytics • Graphical, Excel, and PDF report formats. • Exportable data for vehicle status, trip logs, fuel consumption, and driver behavior. • General statistics: number of users, location, sales, geozone activity, overspeed instances. 6. Notifications and Alerts • Email and SMS notifications for critical events. • Real-time pop-ups for geofence breaches, speed ...
I'm in need of an Excel expert to help me create a comprehensive savings tracker. This spreadsheet needs to have a variety of features and capabilities to assist in monitoring and managing my savings. Key Requirements: - The spreadsheet should automatically calculate various components, reducing the need for manual input and increasing efficiency. - It should have a user-friendly dashboard that presents key information clearly and succinctly. Calculations Needed: - The tracker should be able to calculate my monthly savings. - It should also project my total savings over a set time period. Ideal Skills: - Proficiency in Excel is a must, with experience in creating similar spreadsheets highly desirable. - Ability to design intuitive dashboards within Excel. - Str...
Busco desarrollar un módulo para Perfex CRM, orientado exclusivamente a desarrolladores con experiencia previa en esta plataforma. Funcionalidades principales del m...según los requerimientos fiscales locales. Generación de reportes: Crear reportes específicos requeridos por la dirección de impuestos. Los reportes deberán cumplir con plantillas oficiales establecidas (se proporcionarán detalles en formato Excel para mayor claridad). Asegurar que la generación de estos reportes sea compatible con las normativas fiscales aplicables. Nota importante: Este proyecto está dirigido únicamente a personas con experiencia comprobada en Perfex CRM. Proporcionaré detalles adicionales, como los formatos de los report...
I'm looking for an expert to design and implement a tailored solution that will replace my current project management setup, which includes Trello boards, Excel spreadsheets, and physical files. Key functionalities include: - Central Hub for all contacts - Accounts board to manage deals from inception to completion - Integrated management system for contacts, leads, sales, projects - Dashboards Currently, we don't have a dedicated CRM software. Customer and project management is done manually and is becoming increasingly challenging. Therefore, the ideal freelancer for this project should have: - Extensive experience with monday.com. - Strong understanding of CRM systems. - Good knowledge of data analytics and task management tools. - Excellent design skills to create ...
...tariff document. This PDF includes company details, a tariff table (with vehicle types, sizes/capacity, prices, and minimum charges per mile), our logo, and a footer with contact details and a website link. We do not require a redesign of the PDF; rather, we need to link the PDF to an Excel spreadsheet, so that when we update vehicle details, prices, or other information in Excel, the changes will automatically reflect in the PDF. The final deliverables should include the existing PDF document, a linked Excel file, and clear instructions on how to update the file efficiently. The goal is to streamline the updating process without requiring manual edits in Adobe, making it easier for all team members to manage the content. If you’re able to provide this servi...
...confiables. • Experiencia en programas de detección de similitudes como Turnitin o iThenticate: Pueden ser útiles para buscar coincidencias con otros textos. • Competencia en el uso de software para la gestión de referencias (Zotero, Mendeley, EndNote o similar). • Habilidad para buscar fuentes académicas en bases de datos y bibliotecas digitales. • Dominio de herramientas digitales como Word, Excel, y gestores de documentos en la nube (Google Drive, Dropbox, etc.). • Conocimiento de formatos de citas académicas (APA, MLA, Chicago). • Atención al detalle y precisión en el trabajo con textos. • Idiomas: español e inglés (italiano sería un plus). Material de partida: ...
I'm seeking a meticulous freelancer to help me input mixed data (text and numerical) from paper documents into a single Excel worksheet. Ideal Skills: - Proficient in Excel - Excellent attention to detail - Experience in data entry from paper documents - Able to handle mixed data (text and numerical) - Familiarity with OCR software to convert printed or handwritten text into machine-readable data. - Expert in verifying data entries for accuracy and completeness. - Proficiency in organizing and managing files to ensure data is easily accessible. - Basic mathematical skills to handle numerical data accurately. - Ability to handle sensitive information with a high level of confidentiality. The project involves less than 100 pages of data. The preferred deadline for this p...
I'm seeking a skilled Excel professional to design a comprehensive scheduling spreadsheet for managing project timelines. Key Requirements: - The spreadsheet must be created in Microsoft Excel. - It should include drop-down menus that are linked to if/then statements, filling in information on additional sheets as necessary. - The main project timeline sheet will need to capture task names and descriptions, start and end dates, assigned team members, and a tool and material list. - The tool and material items should be linked to task descriptions. The spreadsheet will be designed to be as user friendly as possible. The Goal is to autofill as much as possible and use repetitive task lists to create a material and tool list preparation guide. This is the most difficul...
Seeking data collection specialist fo...3D printed parts (7 different sizes) Comparing quotes across multiple technologies (SLS, MJF, FDM, Metal L-PBF) Documenting prices for different materials (plastics and metals) and quantities (1-1000 units) Creating structured Excel dataset with 9 columns including platform details, manufacturer info, technology specs, and total costs Documenting inaccessible platforms and URL changes Deliverables: Excel file with comprehensive pricing data Protocol document noting platform accessibility issues Timeline: Due by February 15th Required skills: Data collection, Excel, Basic understanding of 3D printing technologies, Attention to detail Note: Some platforms require registration. Experience with automated data collection tools bene...
take mp4 as input, convert mp3 and do RAG , use pinecone to upload vector. and save answers in excel file according to questions in local folder.
As we deal will Convert Anki .apkg to Excel with 10$
What is 167 * 4? Please answer this question to confirm that you’ve read and understood the job description and the requirements outlined. . . I am looking for someone with access to multiple Apollo accounts to extract leads using specific filters that I will provide. The filtered results should total approximately 150,000 contacts. The leads must be downloaded and compiled into an organized Excel file for easy access and use. My budget for this project is $50. If you successfully complete this task, there will be an opportunity for ongoing work with unlimited similar projects every month.
Automate Your Adobe Workflow with Custom Scripts I specialize in developing automation scripts for Adobe applications like Photoshop and Lightroom. I can automate any task possible within Adobe applications, enabling it to be repeated hundreds of times with precision. Whether you need to streamline repetitive tasks, integrate external tools (Excel, Word, etc.), or create a fully-featured automation with a user-friendly interface, Ive got you covered. My scripts save time, reduce errors, and boost efficiency. Each solution is tailored to your specific needs, with fast delivery, clear documentation, and professional support. Lets simplify your workflow and take your productivity to the next level! Every solution is custom-built to your requirements. If you record a video showing the...
Extract data from website and export in excel sheet
I'm looking for a Excel expert who can help me automate the extraction of data from 3 different PDF formats. Requirements: - Create 3 different Power Query scripts to extract both text and table data from PDFs located in a specified folder. - The extracted data should be saved into multiple Excel files. - Implement simple data transformations such as sorting and filtering after extraction. Ideal Skills: - Expertise in Excel, Power Query and PDF data extraction. - Experience in creating scripts for data automation. - Knowledge of simple data transformation techniques.
