Project vbnet excelроботи
Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
... and boost conversions. Dedicated to helping businesses grow their online presence and achieve measurable success. in-depth market research and competitive analysis to identify trends and optimize campaigns. , execute, and monitored multi-channel campaigns, including SEO, PPC, social media, and email marketing, resulting in 20% increase in lead generation. advanced Excel skills to analyze campaign performance, creating insightful reports for clients. visually appealing and professional presentations using PowerPoint to communicate marketing strategies and results effectively. engaging content for websites, blogs, and social media, increasing audience engagement by 15%. websites and landing pages for search engines, driving 40% growth
i have the excel file you need to analyse the data and I want to you create advanced PowerPoint presentation presentation it need to be present to the big forums, primarily aimed to the top management. The presentation should reflect a professional and corporate style, with clear, concise content and well-structured slides. Ideal Skills and Experience: - Proficiency in PowerPoint - Experience in designing corporate presentations - Excellent understanding of corporate language and presentation etiquette - Ability to condense complex information into clear, digestible content - Creative approach to maintaining viewer engagement within a professional context.
I need assistance with my business bookkeeping, with under 400 bank transactions across two accounts. All data is available in Excel sheets exported from my bank accounts. - Clean up and categorize the transactions. - Prepare a Profit and Loss (P+L) statement for the year 2024. The P+L statement will help me assess the financial performance of the business in 2024. I prefer using Excel for this task. Ideal candidates should have: - Proven experience in bookkeeping and financial analysis. - Proficiency in Excel. - Ability to categorize transactions at a basic level (e.g., income, expenses). - Capability to prepare a P+L statement without specific formatting requirements.
I need an existing Excel document converted into an updated fillable PDF. I have an original fillable PDF available for comparison. The project requires: - Updating form fields and layout - Adding new sections or fields The design elements from the original fillable PDF should be retained. The original fillable PDF is in Adobe Acrobat PDF format. Ideal skills for this project include: - Proficiency in Adobe Acrobat - Experience creating fillable PDFs - Strong attention to detail - Ability to work with Excel data
...achieving over 20% returns in the past month. - Profound knowledge and experience in options trading, specifically with the mentioned strategies. - Python programming expertise, with prior experience in developing trading programs. -Program must be continuously running and historic and live data should be from free api sources. (Or cost of service is considered against the month returns). -Daily dated excel file outputs of trades, costs, and gains preferred (not required) -Strategy must work with a max. account size of $30,000 (no margins). Summitions must be made by Feb. 1 and competition starts Feb 3. After all submitions, programs will be ran in paper trading account. Best performance over 20% gains after a month, wins. The last week, the top 3 will be live accounts and wi...
...developer to help automate the extraction of data from screenshots. The project involves two key tasks: Screenshot Cropping Script: Develop a script to crop screenshots and isolate the relevant data sections, focusing on the area below the column headers. The cropping areas may vary slightly between different screenshots. OCR Data Extraction and Excel Conversion: Use OCR tools (like Tesseract) to extract text from the cropped images. Convert the extracted data into a structured format, and save it into an Excel file, with each piece of data placed into corresponding columns. Requirements: Proficiency in Python (Pillow, OpenCV, pytesseract). Experience with OCR for text extraction from images. Ability to work with Excel files using Python (openpyxl, pandas...
I'm in need of a Java programmer who can create a small program for me. The program's purpose is to convert a PDF file into an Excel file in a tabular format. Key Requirements: - The program should be able to extract all data from the PDF and convert it into Excel. - The conversion should be straightforward, without any data processing or formatting applied to the Excel file. Ideal Skills: - Proficiency in Java - Experience with PDF to Excel conversion - Familiarity with data extraction from PDFs This is a simple project, but it requires attention to detail to ensure all data is accurately converted.
Hello. It's supposed to generate teams based on data from multiple sheets, but it doesn't work like I need. When I run the script it gives me an error and I can't solve it, can you help me?
I'm looking for an Excel expert to optimize my spreadsheet for data analysis. The primary purpose of the Excel sheet is to optimize sales price calculations. The project requires the optimization of the sheet to facilitate specific analyses and reports, including sales price calculations. Skills and Experience: - Advanced Excel skills - Experience with data analysis - Ability to create and optimize complex spreadsheets Please provide examples of previous similar projects you have worked on.
...audience is potential employers, recruiters, and clients who are looking for a skilled and experienced Data Entry Specialist. I want to attract opportunities in industries such as finance, healthcare, and technology. Key Skills and Experience: - Data entry and management - Attention to detail and accuracy - Organizational and time management skills - Proficient in Microsoft Office, particularly Excel, Word, and Access - Experience with data entry software and systems, such as CRM and ERP - Strong typing skills, with the ability to work quickly and accurately - Ability to work independently and as part of a team Achievements: - Consistently met or exceeded data entry productivity and accuracy standards - Successfully implemented data quality control measures to improve data ac...
I'm working on my final year engineering project and I need to implement an offline feature. The project should be able to make certain content available without internet access, specifically Excel sheets and reports. Key Requirements: - The system should allow for editing and saving changes to these offline Excel sheets and reports locally. - Once back online, the system should ensure data synchronization. Ideal Skills: - Experience in software development with offline capabilities. - Proficiency in working with Excel and data synchronization techniques. - Understanding of engineering project requirements.
I need someone to match data between two Excel files and integrate relevant information into File A. Key Requirements: - Compare product names in File A and File B - Fill File A with corresponding data from File B (specifically UNIT SIZE, GST RATE, HSN CODE as per their product names ) Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data matching and integration. I look forward to your proposals.
Usaha kami bergerak dibidang kuliner yang berlokasi di pluit. Kami sedang membutuhkan karyawan tetap untuk membalas chat customer via whatsapp, marketplace dan merekap order yang masuk setiap harinya. Persyaratan karyawan : - Wanita 20-30 tahun - Memiliki pengalaman menjadi admin onlineshop minimal 1 tahun - Rapih, teliti dan cekatan dalam bekerja - Memahami microsoft excel - Bisa menggunakan whatsapp dan marketplace dengan lancar. Untuk selengkapnya akan dijelaskan saat interview *Jam kerja jam 8.30-5 sore. Setelah jam 5 sore tetap harus membalas chat dari rumah.
I'm looking for an Excel spreadsheet that can help me track my daily sales, inventory, exports, imports, and expenses. Key Requirements: - Daily input fields for sales, inventory, export, import, and expenses - Monthly summary calculations for total sales, expenses, inventory balance, profit and loss, and exports/imports across multiple outlets - Detailed tracking capabilities for each product and product categories The ideal freelancer for this project would be well-versed in Excel, particularly in creating spreadsheets with complex formulas and functions. You should also have experience in designing user-friendly interfaces within Excel to make data entry straightforward and intuitive. Since the number of outlets is uncertain, the spreadsheet should be...
Do assigned excel tasks, design and support my freelance gigs on fiverr
Data Analysis Project Using SQL, Excel, and Power BI Dashboard Description: I am looking for a skilled data analyst to assist with a project that involves data processing, analysis, and visualization using SQL, Excel, and Power BI. The project will require: Data Extraction & Cleaning: Extract and clean data from multiple sources using SQL. Ensure the data is accurate, complete, and properly formatted for analysis. Data Analysis in Excel: Perform statistical and trend analysis. Create pivot tables, charts, and perform calculations to uncover insights. Power BI Dashboard: Build an interactive and visually appealing Power BI dashboard. Include key performance indicators (KPIs), filters, and drill-down capabilities for detailed insights. Delive...
I have PDF files containing text data that needs to be transferred into an Excel spreadsheet. The final output will require the application of custom styles in the formatting. Ideal skills for the job include: - Proficiency in Excel - Excellent data entry skills - Attention to detail - Experience with custom formatting in Excel
I'm looking for a corporate strategy expert to develop an action plan for my collection department focusing on expediting dispute resolution. The primary goal of this plan is to enhance the efficiency of our dispute resolution process. Note - i have the excel file i can show you the data but not shareable you need to analysis the data and provide me the strategy and action plan. Key Requirements: - Analyze current collection & dispute resolution processes - Identify potential bottlenecks causing delays - Propose actionable strategies to streamline these processes Skills & Experience: - Proven track record in corporate strategy development - Experience within a collection department is a plus - Strong problem-solving skills - Excellent communication and presentation a...
I'm seeking a VBA macro expert who can help optimize my code for faster execution. The macro is currently used for generating reports from data stored in Excel sheets. The main goal is to reduce the runtime of the macro to improve efficiency. Ideal Skills and Experience: - Proficiency in VBA programming - Experience with Excel-based data manipulation - Skills in code optimization and performance improvement - Ability to enhance code readability for future use Freelancers who can deliver a fast, efficient solution will be prioritized.
I need a comprehensive list of Defence canteen dealer contact numbers from specific cities in Madhya Pradesh - namely Bhopal, Indore, Gwalior, and Bhind. The information needs to be meticulously compiled into an Excel sheet. Ideal Skills and Experience: - Proficient in internet research and data extraction - Excel spreadsheet skills - Ability to work independently and self-motivate - Previous experience in similar data collection tasks is a plus.
I'm seeking assistance with specific small tasks in Excel that may require the use of VBA coding and formulas. Key Requirements: - Creating macros to streamline processes - Using the macros for data validation and cleanup Ideal Skills: - Proficient in Excel with extensive knowledge of VBA - Experience in creating macros - Capable of performing data validation and cleanup tasks
I need help with data entry into my CRM system. The data consists of customer contact information, which is currently stored in Excel spreadsheets. Please note that the specific CRM system has not yet been determined, so flexibility and adaptability are key for this project. Ideal Skills: - Proficient in data entry - Familiarity with various CRM systems - Strong attention to detail - Excellent knowledge of Excel - Good understanding of customer contact information
Project Description: I am looking for a skilled professional to guide me through analyzing data in Excel in a structured and professional way. My goal is to improve my Excel proficiency and learn practical techniques while working on my existing data. What I Have: • An Excel sheet with data ready for analysis. • Basic knowledge of Excel. What I Need: • A professional to guide me step by step in: • Data cleaning and preparation. • Using advanced formulas and functions. • Creating pivot tables and charts. • Analyzing trends and insights. • Other relevant professional techniques based on my data. Requirements: • Expert-level proficiency in Microsoft Excel. • Ability to teach and explain co...
...in office tools such as Word, Excel, Google Sheets, and will also have skills in data security and the use of Adobe InDesign. Responsibilities: - Enter, verify and update data accurately in databases or documents. - Organize and structure files and databases for optimal accessibility. - Use tools such as Microsoft Word, Excel, and Google Sheets for data management. - Respect data security protocols to guarantee the confidentiality and integrity of information. - Create or modify graphic documents and media using Adobe InDesign. - Produce detailed reports and share them with relevant teams. - Collaborate with other departments to ensure smooth data communication. Technical skills: - Advanced knowledge of Microsoft Word, Excel and Go...
...mortgage foreclosure overages leads, with thorough skip tracing. Currently, my focus is on six counties in my state: St. Louis City, St. Louis County, Lincoln County, Jefferson County, and Warren County. However, as my business expands, so will the scope of this project. This is an ongoing opportunity, with added cash bonuses for quality work. The data I require for each lead includes: - Name and last known address - Phone number and email - Property details and foreclosure status - Date of foreclosure All leads must be delivered in an Excel spreadsheet. Accuracy is paramount, and I'm looking for someone who can grow with my company. Ideal skills for this job include: - Proficiency in skip tracing - Experience with mortgage foreclosure overages - Exceptional attenti...
We currently use MS Fabric to house Procore analytics; however, bidboard does not have analytics and we must download an excel file. I'd like to set up a Lakehouse to manually import these excel files and then give our data analyst access to query the information. As a bonus it would be nice to be able to set up this information to share with Salesforce. This would be our first bit of outside data that we would be able to collaborate with our Procore data so I'd like some help setting it up correctly the first time. I'd also like to set it up with the Powerbi model so that when we add a new excel file it removes duplicates and I am able to slice by month, quarter, year. and custom date range.
I'm looking for a financial tracking solution that automatically links and consolidates my expenses from my credit cards and bank accounts in both Argentina and the USA into a single Excel sheet or similar. Key Requirements: - Automatic linkage of all my checking, credit card and savings accounts. - Consolidation of expenses into a clear, comprehensible format. - Support for specific banks from Argentina and the USA. Ideal Skills and Experience: - Proficient in financial software and Excel. - Experience with linking bank accounts and credit cards for expense tracking. - Knowledge of specific Argentine and USA banks. - Ability to present data in a comprehensible format.
I'm looking for a Microsoft Excel expert to create a macro-enabled workbook for me. This workbook should have the capability to calculate CRC8 and CRC16 on user-specified hexadecimal strings. Key Requirements: - The CRC8 polynomial is x8 + x2 + x + 1. - The CRC16 polynomial is X16+X12+X5+1. - The workbook should be semi-automated, meaning it prompts users at certain stages but doesn't require constant interaction. - I want the hexadecimal strings to be inputted in user-specified cells upon execution, rather than fixed cells or a designated input sheet. As an example, this input string 20 00 00 C1 58 99 7D 3B 9F 00 01 yields a CRC8 value of 51 (all in hex) This input string 31 AF 20 00 00 C1 58 99 7D 3B 9F 00 01 51 yields a CRC16 value of FE 81 (both can be checked usi...
I'm seeking assistance with a project that involves overseeing operations and coordinating logistics. This includes managing a system where users can log in, upload documents, and access shared resources. Key Responsibilities: - Oversee login system which includes standard email and password login and Multi-factor Authentication (2fa) for enhanced security. - Facilitate the upload of various document types including PDF files, Image files (JPEG/PNG), and Excel sheets. - Manage access to uploaded documents, ensuring they're available to designated specific user groups. Ideal Skills: - Experience in operations coordination. - Proficiency in managing document systems. - Understanding of security measures in login systems. Please note, a crucial part of t...
...marketplace, can distribute his songs via our platform and get daily & monthly reports on his tracks using official SPOTIFY API. User can also pay to order a custom artwork for his album/single. Can withdraw his stream earnings and so on. Must be done a complete & custom back-end to handle users modules such as distributed songs, stats and so on and admin modules such as earnings, reports, stats, excel exports, invoices and settings. Payments gateway, social logins etc must be integrated and implemented. Multi languages support. Laravel 8 & latest tecnologies must be used. Supporting cross website and devices. Eloquent Master & Seo friendly. Modern stylish & material design website. Must be used only up-to-date libraries. Must be provided an API to connec...
I have a project requiring data extraction from a PDF file and input into an Excel spreadsheet. The data includes: - Text - Numbers - Tables The challenge is that each page of the PDF has a different layout. Your tasks will involve interpreting the varied formats and accurately transferring the information into a single sheet in Excel. Ideal Skills: - Proficient in data entry - Excellent attention to detail - Familiarity with Excel and PDF handling - Able to interpret varied data formats Experience: - Previous experience in data extraction and entry - Able to complete task in timely manner A big factor in winning this contest will be who gets me the data back by 5pm EST 1/19/2025 or sooner
I have 2 different sheets in one workbook. I need to lookup item number in the first one on the second one, and return the count qty. I am struggling because on many, it is bringing in the exact same qty. I will also need a sum on both sheets to make sure they match the original data source.
- online exam software -user & admin not open -not opening in moblie
I'm in need of a meticulous professional for mI am writing to express my strong inte...mI am writing to express my strong interest in the Data Entry Specialist position at ByteCraft. With my exceptional attention to detail, strong organizational skills, and passion for data accuracy, I am confident that I would be a valuable asset to your team. anual data entry from digital files into Word documents. Key Requirements: - Proficient in handling digital files, especially PDFs and Excel. - Excellent attention to detail to ensure accurate data entry. - Familiarity with Microsoft Word for formatting documents. Ideal Skills: - Previous experience in manual data entry. - Strong organizational skills to manage and sort data effectively. - Ability to meet deadlines without compromis...
I'm in need of a meticulous professional for manual data entry from digital files into Word documents. Key Requirements: - Proficient in handling digital files, especially PDFs and Excel. - Excellent attention to detail to ensure accurate data entry. - Familiarity with Microsoft Word for formatting documents. Ideal Skills: - Previous experience in manual data entry. - Strong organizational skills to manage and sort data effectively. - Ability to meet deadlines without compromising on quality.
...tailored to our business needs. You will be responsible for designing, implementing, and testing applications, ensuring they integrate smoothly with our existing systems. Collaboration with our team is essential to deliver valuable solutions. If you have a passion for problem-solving and a track record of successful Power Apps projects, we want to hear from you! You will be taking an existing Excel formula spreadsheet and converting it into a portal for external access. Consideration of the following is essential: Features of Power Apps Portals External User Access: Power Apps Portals are specifically built to provide external users access to select data and capabilities within a custom application, without requiring them to have a full user license for Dynamics 365 or Pow...
Crear base de datos personalizable para introducir datos y consultar mediante busqueda especifica de palabras. Crear base de datos, para poner en servidor. Php mysql. Front end y backend, puede ser en laravel , CodeIgniter o cualquier. Usuarios. Admin y usuario invitado, en niveles. Ti...que se podra personalizar en el menu o en el codigo fuente. 2 secciones principales, primera, introduccion de datos, segunda buscador de palabras clave, indicando donde y cuantas hay en coincidencia. Y que se pueda acceder, ya sea en nueva ventana o lo mas practico. Pero que no se pierda la busqueda. Posibilidad de impresion en pdf, a valorar coste. Posibilidad de exportacion de datos, en doc o excel, a valorar. Visor de inagenes de datos adjuntos. Cualquier duda. Se prepara idea en grafico. Y text...
I'm seeking a proficient Excel specialist to consolidate multiple spreadsheets into a comprehensive master template. The current spreadsheets contain real estate tracking data and your task will involve: - Merging data on property values, insurance replacement costs, and financial statement information. - Implementing key formulas to facilitate future analysis. This includes: - Sum totals for each category - Average values across properties - Percentage changes over time The ideal freelancer for this project should have advanced Excel skills, particularly with formula implementation and spreadsheet consolidation. Experience with real estate data would be a significant advantage. Please ensure that the master template retains all necessary formulas f...
I need an Excel sheet for tracking vacation plans in my department. The sheet should be divided into three categories: resident, specialist, and consultant, each having its own separate sheet. The tracking should be done on a weekly basis for 2025 Key Features: - Under each category, there should be a count of the total remaining persons available. - I need to track for each person: their name and the dates of their vacation. - The sheets should use specific colors for each category: Red for residents, Green for specialists, and Blue for consultants. Ideal Skills: - Advanced Excel skills and experience in creating complex spreadsheets. - Knowledge of color coding and formatting in Excel. - Excellent attention to detail to ensure accurate tracking.
Quiero poder ordenar de manera alfabetica la lista de estudiantes, pero que estos al ordenarse mantengan las notas que tienene en las otras columnas. para esto ocupo una macro. tambien otros arreglos en macros diferentes.
Project Description: We are looking for a skilled freelancer to create individual product catalogs for our raw material suppliers by surveying their websites. The project involves researching and organizing product data, including pictures and descriptions, into a professional catalog format. Project Scope: 1. Review the websites of approximately 10 suppliers (the exact number may vary). 2. Extract and organize the following information for each product: • Product Name • Product Description • Specifications (if available) • Packaging Sizes (if applicable) • Images (downloaded from the website or product sheets) 3. Prepare one catalog per supplier, ensuring clear formatting and organization. 4. Deliver the catalogs in Excel, PDF...
I've developed a construction management workbook in Excel that requires some enhancements. The enhancements include improved data analysis tools, a user-friendly interface design, advanced reporting features, and syncing with QuickBooks. I also want to integrate a construction schedule into the workbook. Specifically, the types of data analysis tools I want to improve are custom formulas, pivot tables, and data visualization techniques such as charts and graphs. Ideal Skills and Experience: - Expertise in Excel, specifically in creating and modifying workbooks - Experience with construction management tools or software - Proficiency in designing user-friendly interfaces - Knowledge of QuickBooks for potential syncing - Ability to create advanced reporting features -...
