Excel vba web query macroроботи

Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.

Мені потрібен макрос/скріпт/бот для гри, мені потрібно декілька раз проходити карти, однаково. Це 3д гра, я намагався сам розробити макрос але у мене з'явилась проблема на тому етапі, коли я хочу записати проходження карти Macro Recorder'ом, щоб в мене був макрос на проходження карти автоматичне, але коли я це записую, у мене не записується повороти камерою у грі. Прописувати дії у скрипт у ручну, я не намагався, бо загальне проходження біля 1 години.

Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.

Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.

Transfer news websites advertising texts...

Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией

Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.

I am in need of a meticulous data entry specialist to convert text data from various digital files, primarily PDFs and Word documents, into an Excel spreadsheet. Key Requirements: - Proficient in data entry with a keen eye for detail - Able to accurately transcribe text data from digital files into an Excel format Ideal Skills: - Excellent command of English for comprehension and transcription - Previous experience with data entry from PDFs and Word documents - High level of proficiency in Excel

I'm looking for a data entry expert to help with Excel data entry and formatting customer information. Key Responsibilities: - Entering customer information into Excel - Formatting data for consistency Ideal Skills: - Proficiency in Excel - Experience in data entry and formatting - Attention to detail and ability to meet deadlines Please reach out if you're interested.

"Enhance an Existing Excel Workbook with Creative Design & Marketing Skills Looking for a professional to refine an Excel workbook with existing formulas, functions, and macros. The task involves improving its visual appeal and overall presentation (logo included) without disrupting the calculations. Estimated time: 2-2.5 hours. Task Instructions for Excel Workbook Enhancement Aesthetic Improvement: Enhance the visual appeal of the workbook, making it more professional and polished. Remove unnecessary areas that do not add value for marketing purposes. Workbook Flow: Organize the pages to ensure logical progression and easy navigation. Improve readability and ensure a cohesive structure. Content Review: The workbook contains real data, such as companies, ...

I'm seeking a skilled Excel or Google Sheets expert to create a comprehensive spreadsheet to track my crews in hotels. The data I need to monitor for each crew includes: - Crew names and contact information - Hotel check-in/out dates - Room assignments - Purchase Order (PO) numbers - Job Numbers The spreadsheet should have the following functionalities: - Automatic notifications before the hotel booking ends Ideal candidates should have extensive experience in creating complex spreadsheets with advanced features, and a strong understanding of data management. Please include examples of similar projects you've completed in your bid.

I need an AWS AI Expert with experience in creating chabots connected to PDF, Words, Excels... Also they need to be able to query data from SQL Databases. You need to integrate this in an existing Flask App. I am Python developer and will be supervising your job, just need assistance with this AI service.

I have a Word document (a bibliography) in which titles of articles are set off by characters, a capital A at the beginning and an at sign @ at the end. Thus: Almagia, Roberto. 1914. ALe piu antiche rappresentazioni cartographiche della regione albanese.@ Bolletino Geografica Italiana i want that turned into: Almagia, Roberto. 1914. "Le piu antiche rappresentazioni cartographiche della regione albanese." Bolletino Geografica Italiana The whole document is less than 100 pages and should be a snap if you know how to run macros.

Create a tool that scrapes online business profile reviews for any business I input. Key Requirements: - The tool should allow me to input the name of a business with online reviews - It should capture ALL the reviews in a single excel document like the attached Timeline is 2 to 3 days

I need assistance with an Excel project where I am trying to find unique permutations of mixed data (text and numbers). Key Requirements: - Expertise in Excel, particularly in handling permutation matching. - Ability to work with mixed data sets (text and numbers). - Experience in displaying results in separate columns. I would like the results to be displayed in separate columns. If you have the necessary skills and experience to assist me with this project, please reach out.

...camera. A default user will be provided and other users will be pulled from a specified Excel file on the device. 2. Matching Activity: Users will scan three different QR codes, which the system will match. Each QR code has 4 fields, which the shall be processed and match logically. Add a container to add additional QR codes when a field does not match. once all matches, The user can press a button to save the record as an Excel file. There will be a Photo container that will lookup jpg file in device local folder, if one of the field from QR code is entered . 3. Report Activity: A simple list format for viewing saved data. Data Logged: The application will save user details and QR code data to Excel files in a specific location on the device. Ideal Skills: - P...

I'm seeking an adept professional with strong Excel and MySQL skills for a project centered around the creation and management of a database. Key Responsibilities: - Creating and managing a new database in MySQL - Entering and updating a mix of numerical and textual data in Excel Ideal Candidate: - Proficient in Excel with experience in data entry and updates - Skilled in MySQL, with a solid understanding of database creation and management - Capable of handling and effectively managing mixed data sets (text and numbers)

Arreglar el excel

I'm looking for an expert in web scraping who can extract product data from two specific e-commerce sites. I need the data to be organized in a well-structured Excel file, categorizing the products into 'product family', 'sub family', and 'product'. Key Requirements: - Extracting the 'Product name' and 'Price' for each product. - Excluding product images; scraping should only focus on product name and price. - Delivering the data in a clear, organized manner in an Excel file. Ideal Skills and Experience: - Proven experience in web scraping, particularly with Shopify and WordPress. - Proficiency in Excel and data organization. - Attention to detail to ensure data is accurately captured and well-stru...

I have a legacy Excel workbook developed over the last decade that I want to transform into a web-based platform. This will involve using the Excel workbook as an 'engine' in the background. The final product should include: - A web-based interface with user logins - Payment processing capabilities for licensing - An Admin dashboard - User analytics features - Integration of some AI elements, specifically natural language processing The platform should also have a user database where project details can be stored, allowing users to handle multiple projects and modify existing ones. Ideal skills for this project include: - Proficiency in web development - Experience with legacy system integration - Knowledge of AI, particularly natural langua...

I'm seeking an Excel expert to create a comprehensive sales commission report. I receive monthly reports from my company, but they don't balance the commission sold versus the commission final at job completion. Key Requirements: - Creation of a report that can be used ongoing, allowing future data input - Each job has three commission payments based on billed/paid - The report should provide as much data as possible Data to be Included: - Sales amounts - Commission percentages - Job completion status - Cost - Price - Margin - Profit - Commission Rate - Commission amount sold - Commission amount executed - Commission due Ideal Skills: - Proficient in Excel - Experience with sales and commission reporting - Ability to create reports for CSV data import I want th...

I'm looking for a freelancer who can create two report templates in Zoho Writer connected with our Zoho CRM data. The templates should be modeled after an Excel report design and tailored for client presentations, hence they need to be professional and easy to follow. The first report is 3 pages long, and the second one is 8 pages long. The templates should include: Essential Elements: - Data feed from Zoho CRM - Conditional formatting for certain text field The ideal candidate will have experience with Zoho Writer and Zoho CRM, as well as a clear understanding of creating business report templates. I've specific branding guidelines that need to be applied to the report templates, so the freelancer should be able to adhere to these closely. Skills needed for this pr...

I'm facing problems with my Laravel application. Specifically, I'm unable to create issues from the Admin panel, as they simply won't save. When I attempt to save an issue, nothing happens at all - the page doesn't reload nor do I receive a validation er...application. Specifically, I'm unable to create issues from the Admin panel, as they simply won't save. When I attempt to save an issue, nothing happens at all - the page doesn't reload nor do I receive a validation error. In addition to this, I also need assistance with importing an Excel file into my database. Ideal Skills and Experience: - Proficient in Laravel - Database management and Excel import experience - Strong debugging skills to identify and resolve issues - Familiarity w...

I'm looking for a professional to create a PowerPoint presentation from my Excel data. The presentation will primarily focus on sales statistics, specifically sales by region. The visual representation of the data will be in pie chart format. Ideal skills for this project include: - Proficiency in Excel for data extraction - Expertise in PowerPoint for presentation creation - Ability to create clear and engaging pie charts - Experience in sales report preparation The final output should be a well-structured and visually appealing PowerPoint presentation that effectively communicates the sales data.

I want to make an excel FILE template to make sure I have enough enough staff available cover the work duties The staff will provide services according to below Market sessions Saudi Days: Sunday to Thursday Session: 11:00 AM – 3:30 PM Daylight Saving Time: Not applicable UAE Days: Monday to Friday Session: 10:00 AM – 2:00 PM Daylight Saving Time: Not applicable London Days: Monday to Friday Session: Standard Time (October to March): 11:00 AM – 7:30 PM (AST) Daylight Saving Time (March to October): 12:00 PM – 8:30 PM (AST) US Days: Monday to Friday Session: Standard Time (November to March): 5:30 PM – 12:00 AM (AST) Daylight Saving Time (March to November): 4:30 PM – 11:00 PM (AST) I want to make excel template to -plan and track staff...

necesito ejecutar scripts python, estos scripts lo que hacen es : 01 - generarme archivos Excel, modificar módulos dentro del libro Excel, 02 - Subir a la base de datos que los archivos ya fueron generados 03 - Subirlos a Gdrive y obtener el enlace de descarga 04 - subir a la base de datos el enlace generado. todo esto ya esta hecho, lo que necesito poder hacer que mediante un botón en mi pagina web, php, ejecute los script python. Lo he estado haciendo con Flask y Ngrok de manera local.

I'm in need of a Microsoft Power App that connects to an Excel sheet for creating data entries across 6 columns. The data entries will be a mix of text and numeric values. Key Features: - Mixed data types: The app should allow for both text and numeric entries. - Some predefined options: Certain columns will require dropdowns or fixed options for text entries, while others will be open for free text. - No numeric validation: There are no specific rules or range limits for the numeric entries. Ideal candidate should have: - Proven experience in developing Microsoft Power Apps. - Strong skills in Excel, particularly in setting up sheets for data connection. - Ability to create user-friendly interfaces with dropdowns and fixed options. Please include exampl...

I need assistance extracting data from PDF files into a structured Excel table. The data is primarily in table format and the formatting is consistent throughout the document. Ideal skills and experience for the job include: - Proficiency in Excel - Experience with data extraction from PDF - Attention to detail - Ability to follow instructions carefully

Hi there - I'll deliver the file as we've discussed by VBA in Excel. Thanks for your trust!

I'm in need of a Windows-based desktop application that can serve as a comprehensive meal plan tracker. This application should be able to assist in tracking macro nutrients, planning meals via a calendar, and suggesting recipes. Core features should include: - Macro nutrients tracking - Meal planning calendar - Recipe suggestions - Grocery list - Recipe creator - Swap options - Macro and calorie subtotals Ideal candidates for this project should have strong skills in desktop application development, particularly for Windows. Experience with nutrition or meal planning software will be a significant plus. Please include relevant experience with your bid.

I need an experienced professional who can link two separate Microsoft Excel Online sheets. The requirement is as follows: - One-way Data Sync: The first sheet (Sheet 1) should automatically update the second sheet (Sheet 2) whenever there's a change. It's crucial that this sync does not interfere with the sheets' existing functionality, colours, or any other design elements. - Data Type: The primary data being used in these sheets is a combination of text and numbers. Please ensure that the integrity of the original sheets is maintained and their visual aspects remain unchanged post-sync. I am looking for someone with proven expertise in Excel Online and data synchronization. Your bid will be considered more favorably if you can provide examples of similar p...

I require assistance with data entry into an Excel sheet. The data is currently stored in databases and consists of a mix of numeric and textual information. The data needs to be categorized by department in the Excel sheet. Ideal skills for this job include: - Proficiency in Excel - Experience with data entry - Ability to categorize data effectively - Attention to detail - Familiarity with databases

...Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont ...

I'm seeking a dedicated virtual assistant to assist with my e-commerce business. Your primary focus will be responding to emails, managing my Shopify store, and helping with Excel/reporting tasks. Key Responsibilities: - Responding to emails promptly and professionally - Checking off orders and ensuring accurate processing - Updating pricing on Shopify - Adding new physical products to my Shopify store - Filing emails correctly for easy access - Assisting with data entry tasks in Excel and other reporting software Ideal Skills: - Experience with Shopify - Proficient in Excel, particularly with data entry - Excellent English email communication skills - Detail-oriented with a focus on accuracy The ideal candidate should be comfortable working with physical good...

I'm looking for a Tally expert who can customize an automation script for me. The script should be able to import various data fields from an Excel file into Tally. At present we have to import the goods receipt data from excel file and material issues from excel file. The automation script should be robust and capable of handling errors and exceptions during the import process. Therefore, detailed error handling is a must. Your expertise in Tally and experience in creating automation scripts will be critical for the success of this project.

Online WhatsApp Sales Representative Https:// We are looking for a motivated Sales Representative to work in the USA timezon...WhatsApp business account. Your Responsibilities: - Manage 50 hot leads each day from Facebook ads. - Follow up with customers from the previous day. - Aim for 1-2 sales per day. - Conduct weekly bulk marketing and promote special offers. - Record sales and customer information in Excel. - Submit daily sales reports. Compensation: - **Base Salary**: $250/month. - **Commission**: 5% on all sales. Schedule: - 6 days a week, 10 hours a day. Requirements: - Strong sales and customer service skills. - Proficient in Excel for tracking and reporting. - Excellent communication skills. If you're ready to help us grow and succeed, we want to hear fr...

I'm seeking a developer experienced with the Quick... I want to be able to monitor: - How quickly orders are being processed - Whether there are any delays in fulfillment The ideal freelancer for this project will have a strong background in working with APIs, particularly the QuickBooks Online API, and will be able to deliver a solution that will save me time and help me manage my orders more effectively. One File show the orderplan today in excel we like to list all order Estimate and then show the green where is the order in trello. every column with green is a list in trello. we need set up trello connection and what list we should list up in orderplan. We have building a system and doing the connection to trello and QB. we need someone take over and finish the orderplan...

...table 4. Sales Dashboard Quotation Creation Process: Inputs Required: 1. Material Code (MatCost) 2. Material Cost (manually retrieved from the web) (MatCost) 3. Factory Name(MatCost) 4. Currency (MatCost) 5. Quantity (MatCost) 6. Discount 7. Incoterms (3536_FCM) 8. Warranty (3536_FCM) 9. Opportunity Number (3536_FCM) 10. Customer Name (3536_FCM) 11. End User (Pipeline) 12. Sales Representative Name (3536_FCM) 13. Special Direct Cost (SPC) 14. Date (FCM_RR) 15. Payment Terms (3536_FCM) 16. Project Name (3536_FCM) Steps: 1. Input Automation • Populate all the required information above into the Full Cost Model (FCM), an Excel template file, automatically. FCM file template will be provided. 2. Price Calculation • Use the FCM to compu...

I'm in need of a detail-oriented freelancer to help with data entry tasks involving financial information into spreadsheets following our existing company template. Key Responsibilities: - Accurately entering financial data into spreadsheets - Utilizing our existing company template for data entry Ideal Skills: - Proficiency in using spreadsheets (Excel, Google Sheets, etc.) - Experience with financial data entry - Attention to detail to ensure data accuracy - Ability to follow specific guidelines and templates This is a great opportunity for a data entry specialist with a background in finance. Looking forward to your proposals.

I need a freelancer who can extract data from structured tables in a PDF and input it into a spreadsheet. The ideal candidate should have experience in data entry and be proficient with Excel. Attention to detail is critical to ensure all data is accurately transferred.

...target entry price to allow flexibility in fast-moving markets. • This ensures that positions are entered even when slight price fluctuations occur. 2. Unique Positioning • The bot must ensure that the same cryptocurrency cannot be added to the portfolio more than once while an existing position for that cryptocurrency is still active. • Verification Logic: ◦ Before placing a position, the bot will query the wallet directly via WebSocket (/contract/position) to verify if there is already an active position for the cryptocurrency. ◦ If an active position exists, the bot will ignore the corresponding call from Redis DB1. ◦ If no active position is found in the wallet, the bot will proceed to retrieve the relevant entry details from Redis to execute the position. 3. O...

Je souhaite répertorier sur un fichier excel tous les restauranteurs d'une région (en France) qui sont également présents sur les réseaux sociaux (instagram principalement). Il me faudrait donc : - Nom du restaurant - Adresse - Téléphone - Lien sur les différents réseaux Si ceux-ci ne le sont pas, cela ne m'intéresse pas.

...to assist with text creation. Daily Targets: Successfully post a minimum of 160 links across the internet each day. Important: Only links that remain live and online will count toward your daily target. Links that are removed, deleted, or flagged will not be considered. Tracking and Reporting: Maintain a well-organized record of all links posted. Submit proof of work at the end of each day in Excel format, listing all successfully posted links. Work Schedule: Days: Monday to Friday Hours: 8 hours per day Skills & Requirements: Attention to Detail: Accurately track posted links and ensure they stay live. Efficiency: Achieve the daily target of 160 live links consistently. Online Familiarity: Ability to navigate various websites, forums, directories, and communities. Writin...

I'm looking for a comprehensive Excel budget sheet tailored for personal finance. It should help me track monthly expenses, savings goals, and debt repayment. Key Features: - Track monthly expenses: The sheet should have a clear layout for tracking all monthly expenditures. - Monitor savings goals: I want a section that helps me visualize my progress towards different savings targets. - Debt repayment tracking: I need a part of the sheet dedicated to my debt, with space for each individual loan or credit line. Built-in Formulas/Functions: - Automatic expense categorization: The sheet should have a method for categorizing expenses, ideally automating this process based on pre-set criteria. - Savings goal progress calculation: A built-in function to calculate how close I am to...

...Summarization: o During the system initialization, if necessary, all documents will be indexed and summarized into a CSV or database-friendly structure for quick access. o AI will handle the document indexing process. 3. Advanced Search Functionality: o The system will allow users to input a custom scenario or query. Based on this input:  The system will identify and return the most relevant document(s) from the database.  It will provide recommendations and insights related to the user’s query, leveraging OpenAI’s API and the system's internal knowledge base. 4. File Upload and Custom Summarization: o Users will also be able to upload their own documents. o The system will generate two distinct types of summaries for these documents:  A concise overv...

...include: Company Logo (provided upon project award) Consistent and modern design formatting Clear and organized layout for easy readability The design should reflect a professional and contemporary look that aligns with our brand identity. Both price sheets should be formatted for easy editing in the future (preferably in Microsoft Excel or Word). Requirements Proven experience in graphic design or document formatting Proficiency in tools such as Microsoft Excel, Word, Adobe Illustrator, or similar Ability to integrate branding elements (logo, color scheme, etc.) Quick turnaround time (please specify availability in your proposal) What We Provide Current price sheets Company logo and branding guidelines Deliverables Two separate price sheets (Distributor and Customer) in...

Llevo aplicaciones para manejo de negocios de diferentes clientes. Requiero que la persona tenga conocimientos en Bases de datos, Excel y, sobre todo, Appsheet. Algunas App ya están armadas y tengo que hacerles mantenimiento, testing y mejoras, otros proyectos debemos comenzar a construirlos. Solo se requieren algunas horas semanales, totalmente flexible!

Necesito un experto para solucionar y resolver problemas con las fórmulas de suma/resta en mi hoja de cálculo financiera de Excel, particularmente en la hoja de ingresos. Habilidades ideales: - Dominio de Excel - Fuertes habilidades matemáticas - Atención al detalle - Capacidad para resolver problemas - Experiencia con hojas de cálculo financieras

Excel expert to analyze my data. Your goal will be to provide insights from my data, so experience in identifying trends, performance metrics and conducting predictive analysis is a plus.

I'm seeking an Excel expert to analyze my data. Though specifics weren't provided, the ideal candidate should: - Have a strong background in data analysis - Be proficient in Excel - Able to derive insights from data - Capable of cleaning, transforming and aggregating data before analysis - Be proficient in performing statistical analysis in Excel - Expertise in creating and manipulating Pivot Tables - Utilize complex formulas and functions for in-depth data analysis - Create data visualizations using Excel charts and graphs - Capable of integrating data from multiple sources - Skilled in generating comprehensive reports based on the analysis - Ensure data accuracy through validation techniques - Identify and analyze trends in the data over time - Expe...