Data entry in excel using vbaроботи
Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.
Необхідно розробити веб-застосунок та описати його роботу. Опис має бути в форматі одного розділу бакалаврської дипломної роботи. Більш детальний опис наведений в закріплених файлах.
Рівень володіння англійською — середній та вище Автономний (-на) та вмію приймати рішення Стресостійкий (-ка) та вмію працювати в режимі багатозадачності Маю досвід роботи на посаді персонального помічника від 2 років #ASSISTANT #DATA ENTRY
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Скопіювати інформацію з деяких веб-сайтів Скопіювати інформацію з деяких веб-сайті, Внести діні в таблицю,
Внести дані в таблицю Заповнення таблиць для інтернет-магазину одягу IMPERIAL.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
I need an experienced Excel VBA programmer to modify my VBA Code macros. The job involves enhancing an Excel form and including a 'modify' function. Modify "Agency" file to be like "Testttt" file and include the Modify button. Key requirements: - Modify an existing Excel form - Include a 'modify' function in the form - Improve the overall performance of the form The ideal freelancer would have: - Extensive experience in Excel and VBA - Ability to optimize data modification processes - Skills in designing user-friendly forms The project also involves changing some aspects of the form's appearance: - Removing some fields from the form - Changing the layout of the for...
I'm see...diligent freelancer for a data entry project involving approximately 3,000 companies. The task requires inputting company information into a directory page on a website. Key Responsibilities: - Extracting data from an existing directory website, including: - Company name and address - Contact information - Description of services - Inputting this information accurately into the designated website Skills and Experience: - Prior experience in data entry - Attention to detail - Familiarity with extracting data from websites - Ability to follow instructions accurately Please note, this project does not require any data cleaning or verification beyond basic entry. Therefore, I am not looking for a f...
...have 3 markdown files full of math exercises in French and folder with their answer keys. I would to process them to generate new math exercises with answer key. To do so, we can use a chatbot API like the one from chatgpt. First we need to extract each exercise with its number. For example the first exercise is : Number: "NO2" Exercise: "Si je pense à un nombre, je lui retranche (-12) et je trouve 3. Quel est ce nombre?" Here is the exercise is not well written, so we can use an AI API to rewrite it: Number: "NO2" Exercise: "Si en pensant à un nombre, en lui retranchant (-12), on trouve 3, quel est ce nombre ?" Often there is unnecessary content between the exercises that needs to be removed. Each exercise with its num...
...developed market research responses from surveyors ( promoters only will access 50 max ) with user name and password who will collect data from customers. Key Features: - The app will target one company , so it needs to be user-friendly and accessible. - Although the specific types of survey questions already available and determined , the app should be flexible enough to incorporate various question types like multiple choice, open-ended, and rating scale. - both language English/Arabic the platform - response analysis should be PowerPoint, excel - IOS/ANDROID APP Ideal Skills: - Proficiency in mobile app development with a focus on e-commerce. - Experience in creating survey tools within apps. - Strong understanding of UX/UI principles to cater to ...
Hello Detailing the Proposal for smooth Project Workability is all the data (pnj shared on message) 2. We need to have this well formatted in a professional dashboard look with ease on visual interpretability 4. Filtering Across individual Locations
AI-Powered Dialer with Multilingual Automatic Calling 1. Lead Management Integration with CRM: Import leads directly from our CRM system. Manual Import: Upload leads using Excel files or CSV format. Manual Entry: Allow users to input numbers manually. 2. Call Modes Manual Calling: Enable users to make calls directly through the app. AI-Powered Automatic Calling: AI should initiate calls on behalf of the user, engaging leads in natural, human-like conversations. 3. Multilingual Support Auto-Detection of Language: AI should detect the language spoken by the lead after the initial greeting. Example: If the lead speaks Tamil after "Hello," the AI should switch to Tamil automatically. Language Library: Suppor...
I need assistance with copying and typing printed text from reports. The reports are 1-10 pages in length. Ideal skills and experience: - Excellent typing skills - Attention to detail - Experience with data entry - Ability to accurately copy from printed text
I am seeking an experienced YouTube Channel Project Manager to help set up and launch a new YouTube channel dedicated to rare and unusual short experimental art films. The master project is to create and launch the new channel, offering 500 short films for the Launch to create a substantial initial offering. I need someone based in the UK, to work with the physical hard archive. The film formats are primarily DVDs and USBs, and also some VHS tapes. The DVD films and the VHS films will need to be converted to MP4 format for uploading to the YouTube Channel. *nota bena the small quantity of VHS films can be omitted, (to be converted and uploaded separately later), if not easily possible to do at this stage. Deliverables 1. Provide a written recommended strategy for the overall You...
...convert tabular data from image files into Excel. The solution should include a simple front-end app with specific features. Key Requirements: - The front-end app should allow users to upload image files containing structured data and download the resulting Excel sheet. - The data in the images consists of handwritten format i want data to extracted in specify way numbers are in format of 6688/10 5853/5 and so in . I want numerators should be sorted in one column with title model no and denominator should me in next column with quantity App should have API key as well so that i can integrate ion my existing application the conversion process needs to accurately capture the structure of the data...
I'm looking for a professional who can create a tailored Excel spreadsheet for me. The primary focus of this project is to automate the process of report generation through the use of macros. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel - Proficiency in creating and programming macros - Experience with task automation in Excel - Understanding of report generation processes
I'm seeking a freelancer to assist me in compiling data on the manufacturing industries in China and India. The focus of this project is to gather information on 20,000 companies from each of these countries. Key Requirements: - Data Points: The data should include company names, email addresses (and variations such as 'email 1', and 'mix emails'). - Format: The final data should be delivered in an Excel spreadsheet. Ideal Skills and Experience: - Previous experience in data collection and analysis. - Familiarity with the manufacturing industries in China and India is a plus. - Proficiency in Excel and data management. - Attention to detail and ability to deliver acc...
I'm seeking a part-time professional to assist with administrative and data entry tasks. This role primarily involves working with mixed data - both text and numerical. Key Responsibilities: - Data Entry: Accurately inputting mixed data into the system. - Administrative Support: Assisting with various administrative tasks. - Customer Service: Occasionally addressing customer inquiries. - Scheduling and Coordination: Helping with scheduling and coordination tasks. Ideal Skills: - Proficiency in data entry. - Strong attention to detail. - Excellent organizational skills. - Good communication skills for customer service and coordination tasks.
...responsibility will be data entry. The tasks will primarily involve working with Excel for scheduling and calendar management as well as email sending through outlook. Ideal Skills and Experience: - Proficient in Excel - Detail-oriented for accurate data entry - Good organizational skills for managing tasks - Reliable and self-motivated - Email management: Sorting, prioritizing and responding to emails as appropriate. - Calendar scheduling: Organizing appointments, meetings and events. - Travel arrangements: Planning and coordinating travel logistics. - Job booking: Assisting with scheduling and booking tasks. - Checklists: Maintaining and updating task lists. - Completion rates: Tracking and reporting on task completion rates. The id...
I'm looking for someone to create 2(two) previously named Twitter (X) lists, each containing 500 accounts (so a max of 1000 for the 2 lists). The specific criteria for organizing these lists are in the excel attached. Ideal Skills: - Proficiency in using Twitter - Ability to create and manage lists (you create them with the account you have) - Understanding of social media metrics p.s: Lists would look something like this. Experience: - Prior experience in social media management - Familiarity with Twitter's interface and features - Proven track record of creating organized and useful Twitter lists p.s: Whoever finishes this first, I will give more work as I need more lists done. Make sure you space them out, so twitter does not limit you...
I need assistance entering SKU numbers from Catalog 3 and Catalog 4 into various catalogs. Use Catalog 1 as a reference, but do not use SKU's from Catalog 1. Requirements: - Proficient in data entry - Able to work with PDF format - Attention to detail - Able to accurately transcribe information from images and text - Able to navigate randomly listed information Ideal candidates should be meticulous, able to work under minimal supervision and possess a keen eye for detail. Familiarity with SKU systems and catalogs is a plus.
I'm seeking a developer to create a custom model that will generate Python code based on Vendor online development documentation and our internal best practices. The model should be able to produce code that is 50-60% compli...compatible with Vendor A's export format. Key Requirements: - The system must be able to run offline. - There needs to be a script that takes a prompt as input, similar to ChatGPT, and returns the corresponding code. - The model will be trained using our examples of finished/exported code, which include scripts, modules, and libraries. Ideal Skills: - Proficient in Python - Experience with machine learning and AI model development - Familiarity with Palo Alto online development documentation - Able to understand and implement internal best p...
...trades, providing entry and exit points. Key Requirements: * Strategy Implementation: The bot should utilize a trading strategy with a high success rate (at least 101%). * Market Analysis: The bot should automatically analyze the market and give trade signal * User Interaction: The bot should be semi-automated, requiring user confirmation for each trade. * User-friendliness: The bot must be stable and provide visual indicators for signals and it should match real time of market to platform same time signal Ideal Skills and Experience: * Proficiency in developing Telegram bots * Experience with the IQ Option binary trading platform * Strong understanding of trading strategies and market analysis * Ability to create user-friendly interfaces * Knowledge in ...
...market on the IQ Option binary platform. The bot should operate with 1-minute expiry trades, providing entry and exit quotes. Key Requirements: 1. Strategy Implementation: The bot should utilize a trading strategy aimed at maximizing the win rate, targeting at least a 101% success rate. 2. Market Analysis: It should automatically analyze the market, pinpoint the best investment opportunities, and execute transactions. 3. User Interaction: The bot will be semi-automated, requiring user confirmation for each trade. 4. User-friendliness: The bot must be stable, effective, and have visual indicators for signals and trades to enhance user experience. Ideal Skills and Experience: - Proficiency in developing Telegram bots - Experience with the IQ Option binary trading platform ...
I'm looking for an Excel expert who can assist me with pivot tables and advanced formulas. If you are skilled in creating and customizing pivot tables, using advanced Excel functions like VLOOKUP, INDEX/MATCH, and combining multiple data sources, then you are the freelancer I need. Ideal Skills and Experience: - Proficiency in Excel, particularly with pivot tables and advanced formulas - Experience in creating and customizing pivot tables - Expertise in using advanced Excel functions (e.g., VLOOKUP, INDEX/MATCH) - Ability to combine multiple data sources - Strong attention to detail and organizational skills
I'm seeking a skilled software developer to create auxiliary software that will primarily focus on automating certain tasks. The software will need to handle: - Data Entry: Automating the process of inputting data manually. - Calculations: Performing various calculations based on different numeric inputs. The ideal candidate for this project should have: - Proficient software development skills with a focus on automation. - Experience with creating software for data handling and calculations. - Excellent English communication skills for clear understanding and discussions. Please note that the details of the project will be shared privately. Thank you.
...completing a Data Storytelling Hallmark project. Part of that project includes analyzing data and creating data visualizations. This activity is designed for practice. You will be provided with a sample dataset and will be guided through the steps for analyzing data, interpreting/summarizing data, and creating data visualizations. Open the following Word document and Excel workbook and save them (with your name) to your desktop. You need both to complete the assignment. Follow the instructions included in the Word document to fill in the Excel worksheet and then use those results to complete the bottom section of the Word document. Once completed, please submit both to Canvas. Data Analysis and Visualizat...
The specifics of the Samam Entry Project have not been defined yet. The project could potentially cover various tasks, including data entry and verification, text editing and proofreading, or image and graphic editing. Ideal freelancers for this project should possess excellent attention to detail, strong editing skills, and experience in data entry and verification. Understanding of the finance, healthcare, or education industries could be beneficial, but not necessary.
I'm seeking an Excel expert to create a macro that automates repetitive tasks, specifically data formatting. The primary focus will be on automating conditional formatting. Ideal Skills and Experience: - Proficiency in Excel - Experience with creating macros - Understanding of data formatting - Expertise in conditional formatting - Ability to deliver a user-friendly solution Has a lot similar automation requests, looking for long term cooperation. Details： please see attached files- 1. Column K --> Cargo Control Party Name: Kmart 2. create Column V: Vsl Voy IB 3. match Column U: Outgoing SVVD --> Column V: Vsl Voy IB with the data in (columnA,B --> column C, F )
I need to generate an MFA system using TOTP, with existing users. The process is as follows: they enter the LOGIN page with username and password, then I need two-factor so they can continue if everything is correct. The system is developed in PHP/MYSQL without any type of framework. I only require MFA/TWO-FACTOR to validate as a second step, otherwise they will not be able to enter. Third-Party applications can be used. I need the system to be secure for validation The budget can be variable and we could adapt if we have a good proposal, if you have a demo, send it
Job description Role: Amazon Ecommerce Assistant Are you passionate about e-commerce and digital marketing? Do you have previous experience in managing Amazon accounts? We are a leading organisation in the industry, seeking a dynamic and results-driven individual to join their team as an Amazon Ecommerce Assistant. As the Amazon Account Executive, you will play a crucial role in supporting the management and development of our business relationship with Amazon. Your main focus will be to optimise content, manage the product catalogue, and implement effective promotional plans. If you are ready to take on this exciting challenge and work with a team of driven professionals, then this is the perfect opportunity for you! Responsibilities: • Support the writing a...
I need an experienced Forex trader who can copy trading signals from Telegram into my Pocketoption account. Key Requirements: - Proficient in Forex trading - Capable of promptly copying and entering signals - Familiar with Pocketoption broker - Able to maintain accuracy during high-paced trading - Understands the importance of following signals without personal bias
I need assistance to extract data from a PDF document into an Excel spreadsheet for 200 organisations. The data includes organisation names, emails, telephone numbers, and postal addresses. Key Requirements: - Proficient in data extraction and Excel - Previous experience working with PDF files - Attention to detail to ensure data is accurately transcribed It is essential for the freelancer to have the ability to carefully transcribe the information from the PDF to the Excel spreadsheet without errors.
I'm looking for an Excel expert to create a training management sheet for me. Features of the Excel sheet should include: - Tracking of employee details - Logging of training topics - Scheduling and recording of training dates The primary use of this Excel sheet will be monitoring progress of employees throughout their training. Therefore, the sheet should be designed in a way that makes it easy to track individual progress and overall training effectiveness. Ideal skills for this job include: - Advanced Excel skills (formulas, pivot tables, data validation) - Experience in creating training or attendance tracking sheets - Understanding of training program metrics
I'm looking for an experienced professional to assist with reconciling my business bank account using Microsoft Excel. This task involves reviewing deposits, withdrawals, and transfers. Key Responsibilities: - Bank Account Reconciliation: You will be responsible for ensuring all transactions are accurately recorded and accounted for. - Invoice
...with a Microsoft Access database using VBA. The goal is to retrieve directors' and secretaries' names and store them in a table, using company numbers from another table. Below are the detailed requirements: Requirements: 1- API Connection Setup: Establish a connection to the Companies House API using VBA in MS Access. Let me know what API type and credentials for authentication are needed. 2- Data Retrieval: Retrieve directors' and secretaries' names using the company numbers from an existing table in the MS Access database. Ensure the data is accurately parsed and stored in a new table (Optional). 3- Automation: Develop a VBA script to automate the data retrieval p...
We need to have the 2024 Rate card converted to an Excel sheet. They have discounted rates by 12.5% for Platinum Winter and 15% for Gold Winter, as shown in a column.
I'm looking for a C# plugin for Power BI Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all measures in the selected report and provide optimized DAX code for each. A list of these measures should also be in a combo box. My primary data sources are SQL DB and Excel, so experience with these is crucial. The plugin needs to work with both imported data and DirectQuery modes.
Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.
I am in need of a freelancer that can assist me with copying data from a protected Excel worksheet to a new, unprotected spreadsheet. Details: - I do not have the password to the protected worksheet - I can edit the worksheet, but cannot remove the protection - I need all data transferred from the protected worksheet to the new spreadsheet Ideal skills for this job would include proficiency in Excel, data entry, and an understanding of data confidentiality. As I cannot remove the protection, the freelancer will need to handle this task with discretion and professionalism.
...looking for an experienced data analyst who can help me identify trends in our QI project data. This will involve working with an Excel spreadsheet sourced from Redcap data. It is a NICU breast milk QI project. Data collection includes: Mother's age, mother's race, infant gestational age, insurance type, Breast pump useMilk volume at 3 different time points, volume goal of 500ml/day, Lactation clinic appointment. Scatter plot, run plot, effects of intervention: Yes/no lactation appointment attended, and does this correlate with milk volume. Key Responsibilities: - Analyze data to identify trends related to process improvements - Present findings in an accessible and clear manner Ideal Skills and Experience: - Proficie...
I need assistance with data entry from approximately 170 invoices. All invoices are in PDF format and have a consistent layout. The task involves locating EAN codes in the left section of the invoices, extracting prices and calculating the total sum. Ideal Skills: - Proficiency in data entry - Attention to detail - Ability to follow instructions precisely Experience: - Prior experience with data extraction from invoices preferred.
