Excel vba referencing macros addроботи
Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
"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 ...
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'm looking to add a gallery to my current website to sell my original artwork and prints. The site will primarily feature my comic book and illustration art. Key Requirements: - E-commerce capabilities for purchasing the artworks - User accounts functionality for creating favorite lists The art should be displayed in a grid view with thumbnail images. I want it simple and very basic. And need sales options to be set up. Zelle, Venmo, PayPal and possibly credit card. My website (as is): Hosted on Wix Ideal Skills: - Experience in e-commerce website development - Proficiency in creating user account functionalities and managing databases - Knowledge of website UI/UX design for an art gallery Please provide examples of similar projects you've completed
I'm looking for a professional to help me find, add, and write products for my pet accessories dropshipping store on Shopify. The role involves automating the process as much as possible. Key responsibilities: - Product sourcing: Find trending and high-demand pet accessories for dropshipping. - Product listing: Add these products to my Shopify store. - Copywriting: Write engaging, fun, and playful product descriptions that will resonate with pet owners. - Automation: Implement tools and processes to automate as much of this as possible. Skills and experience required: - Proven experience in dropshipping and Shopify. - Excellent copywriting skills, with the ability to write in a fun and playful tone. - Familiarity with automation tools and processes. - Knowledge of the...
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 regi...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 ...
I need a professional who can add a website link to two areas of my one-page resume in Adobe PDF. Key Requirements: - The link should be placed in the Contact Information section. - The link should be displayed as a clickable button. Ideal Skills and Experience: - Proficiency in Adobe PDF - Experience in editing resumes - Ability to create functional, clickable elements within a PDF document This task is straightforward and should not take long for someone experienced with PDF editing. Looking forward to your bids.
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.
I need an image retouching expert to help with an image editing task. - 4 of the 7 people in the image need to be removed. - A Fire Lieutenant Hat needs to be added to the remaining person. - The same person also needs to be fitted with a Fire Lieutenant Jacket. The final image should be retouched as necessary to ensure a seamless and realistic appearance. Ideal candidates for this project should have extensive experience with image editing software, a keen eye for detail, and the ability to deliver high-quality results in a timely manner.
...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. Ide...
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)
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-structured.
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 language processing - Famil...
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 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 with Admin panel functionalities in web applications.
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 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.
Green House Gas (GHG) Emissions and Economic Growth The objective of writing this is to assess how well you are able to apply theoretical models to issues of GHG emissions and suggest appropriate policy measures. In this essay you would be required to demonstrate understanding of the theoretical models, along with contemporary journal articles, and create a reference list using APA style of referencing. Your analysis should cover in detail the following aspects: a) Explain how greenhouse gas emissions constitute a negative environmental externality using theory and graphical analysis (20 marks) b) Evaluate the relationship between economic growth and greenhouse gas emissions using the Environmental Kuznets Curve hypothesis, demonstrate this relationship graphically using rele...
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...
Main Goal: 1. To create Quotation Appendix 2. Quotation Approval Email, 3. A... 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 compute the final selling price based on certain margin. Extract the per unit price Outputs: 1. Quotation Appendix Creation • Automatically generate a quotation appendix in Excel format, based on the FCM data. Get the per unit price from FCM. 2. Approval Email Preparation • Auto-generate an email text for approval, with the FCM file attached in both Excel and PDF formats for approvers to review and sign. 3. Auto insert these info into a...
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.
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.
...or posting links excessively without context is strictly prohibited. Posts must add value to the platform and appear natural. 3. Customized Text Creation: Each link must be posted with relevant, unique, and well-written text tailored to the platform. Avoid generic content. You may use tools like ChatGPT (free version) 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 Schedu...
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...
I'm seeking a professional who can modify a WordPress plugin for me. The task is to insert a piece of informational text into the body of the plugin. Ideal Skills: - WordPress plugin development - PHP - HTML/CSS The text doesn't require any special formatting. Please let me know your availability and estimated time to complete this task. Check my website :
...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.
