Excel vba auto add referencesроботи
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
I'm looking for a seasoned Python developer who can assist in two main areas: - Creation o...file will feature data-points in columns. A powerpoint presentation template will be provided for reference. The graphs and tables should be present as per the data-points present in CSV file. Automating the Process This is the secondary part of the job. Once we have are successfully able to convert a CSV data in PPT format, we should create a public secured link to upload the file. It should be auto-converted and file should be ready for download. The ideal candidate should be a proficient Python Developer with a solid understanding of data analysis and automation. If you have prior experience in similar projects or can demonstrate your ability to deliver quality work, I'd li...
...the Pumpfun platform. Responsibilities: Create a bot/tool to manage trading from multiple wallets on the Pumpfun platform. Enable the bot to generate multiple wallets. Configure Solana quantities to buy per wallet. Develop an auto buy and sell bot to make a project appear legitimate with many sales and buys, thereby boosting projects. Ensure speed execution on the first buys to avoid snipers. The initial buys will be made from different wallets in varying quantities, with all transactions going through simultaneously or with a few seconds' difference. Allow for auto-tipping and prioritization in fees. Enable P&L visualization of all wallet investments in one view, allowing the user to check the total bonding curve of SOLs versus SOLs owned in the project. Impleme...
I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.
Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.
El proyecto consiste en crear un mapa de Minecraft que reproduzca fielmente un servidor de GTA RP. GTA RP (Grand Theft Auto Roleplay) es un estilo de juego único donde los jugadores encarnan a un personaje y se sumergen en su personalidad, actuando como si fueran ese personaje. Características Clave de GTA RP: 1. **Dinámicas de Rol**: - Los jugadores asumen la identidad de un personaje creado por ellos mismos y viven su vida dentro de un contexto ficticio junto a otros jugadores. - La interacción puede ser a través de texto o preferiblemente chat de voz para una mayor realismo. - Los personajes pueden ser desde un prominente empresario hasta un extranjero que desconoce el idioma local, una mujer de la mafia, etc. Las posibilidades son...
I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but the use o...
the project is about to create a Minecraft map that faithfully replicates a GTA RP server. GTA RP (Grand Theft Auto Roleplay) is a unique gaming style where players embody a character and immerse themselves in its persona, acting as if they were that character. Key Features of GTA RP: 1. **Roleplay Dynamics**: - Players assume the identity of a self-created character and live out their life within a fictional context alongside other players. - Interaction can be via text or, preferably, voice chat for enhanced realism. - Characters can be anything from a prominent businessperson to a foreigner unfamiliar with the local language, a mafia woman, etc. The possibilities are endless. 2. **Collaborative Storytelling**: - Every player online is roleplaying their own char...
I have a data in my excel sheet. They are from column A - J, 10 column, 4137 rows of data. The data are in mixed string format, which means all long text mentioning about their company. I need to do some data analysis. So i need help in doing NLP for those data to clean and filter the data. I need help in doing NLP for the data and provide me the python code use to do the analysis, I will need like the summaries of the text. For example, for column Funder Purpose the row contain info like "Since the business started, we have been fully relying on our internal fund. We plan to utilize this fund to support our working capital requirement and operating expenses. Based on our business growth progress, we are confident in our repayment capacity." I want the summary as "...
I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT output f...
I'm currently looking for a comprehensive informational article on L shaped reception desks. The article should cover various design options, benefits and advantages of these desks, and provide a general overview of them. The target audience for this article is quite general; it should be something that can be well unders...information and readability, so it would be ideal if the writer can demonstrate a good understanding of the topic and the ability to convey this in an engaging manner. A background in interior design, furniture sales, or a related field would be beneficial. A portfolio with similar articles or work samples would also be a plus. The article should be 1500 words in length. - Article must contain 3 to 5 references to links that will be provided upon awarding...
Currently, I'm using Fluent as my email service provider and need a professional to automate our newsletter and welcome emails. We're a small company with less than 1000 subscribers, looking to improve engagement. Desired Skills: • Fluent CRM proficiency • Email marketing expertise...small company with less than 1000 subscribers, looking to improve engagement. Desired Skills: • Fluent CRM proficiency • Email marketing expertise • Experience with automation of newsletters and welcome emails Responsibilities: • Setting up automation for newsletter and welcome emails • Training our team on how to maintain and update these automated systems Only serious freelancers with solid references are encouraged to bid. Please include evidence of ...
I'm seeking a skilled content writer to craft a detailed and informative article...between residential and commercial coffee tables. Key points to consider: - Research and include the origin and history of coffee tables - Discuss popular styles and designs in the contemporary market - Elaborate on the differences between residential and commercial coffee table considerations - Write in a style that's accessible and engaging for a general audience - Must contain 3 to 5 links as references within the article, they will be provided upon awarding the article Ideal skills and experience for this job: - Strong research abilities - Excellent writing skills, particularly in crafting engaging, informative content - Experience in writing about interior design or furniture is a plu...
A general information article is needed for waiting room chairs. The article should provide insight into the purpose of waiting room chairs and the benefits they provide to a businesses guests. The article is to provide a resource into understanding what sets waiting room chairs apart from other office chairs. - Must be between 1,000 to 1,200 words - Article must contain 3 to 5 references, the links will be provided upon awarding the project More details: This is for a website that provides general information on a wide range of topics. What is the main goal of your article? provide general information on waiting room chairs How soon do you need your project completed? 4 days
I'm in need of a...information for the public. Key Requirements: - The article should cover a detailed explanation of the full function of a boardroom. - It must be educational yet engaging, appealing to a wide audience. - The focus should be on clarity and simplicity, making complex concepts easily understandable. - I will need a turnaround time of 4 days. - Needs to be between 1,500 and 1,800 words - Must use 3 to 5 references in the article that will be provided upon awarding of the project. Ideal Skills and Experience: - Proven experience in creating engaging, informative articles. - Good understanding of business terminologies, specifically boardroom functions. - Ability to simplify complex concepts for a general audience. - Timely delivery and open to feedback for poss...
I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed
I'm seeking a talented writer to cre...engaging and accessible to a wide variety of readers. Key points to consider in this project include: - Covering a broad spectrum of conference room chair topics - from ergonomics and comfort to design and aesthetics - Providing insights on the durability and maintenance of these chairs. - Explain how conference room chairs differ from regular office chairs - Needs to contain 3 to 5 links to references on the subject matter which will be provided upon awarding of the project - Needs to be between 1,200 to 1,500 words Ideal skills and experience: - Prior experience in writing high-quality, engaging content on furniture or interior design - Excellent research skills - Ability to break down complex topics into easy-to-understand, reader-fr...
...valid translation certificate or degree **Tasks**: * Create a account with the client's provided information * Configure the account for shared access * Provide login credentials for the client to access the account * Assist the client in understanding the features of the platform **Selection Criteria**: * Qualifications and experience in translation * Quality of CV and references provided * Ability to pass 's verification process with a valid translation certificate or degree * Competitive pricing for services offered **Additional Terms**: * The freelancer will have access to the account and will be able to use it for their own translation projects. * The freelancer will receive 45% of the earnings generated by me on the platform. This term is non-negotiable
...educating readers about the unique benefits and features of round conference tables. - The article should highlight the distinctive qualities of round tables in comparison to other shapes, particularly emphasizing how these tables promote communication and collaboration, and their versatility in seating arrangements. - Article should be between 1,000 to 1,200 words - Article needs to contain 3 to 5 references to certain websites, which will be provided upon awarding of the project Ideal Skills and Experience: - Prior experience in writing for a general audience and/or about furniture would be preferable. - A good understanding of the benefits of round tables, particularly in the context of conference settings. - Excellent research skills to ensure the content is factually accur...
... Key Components: - Canvas app - Component library - Power Automate flows - Environment variables - Connection references Required Application Information: Freelancers interested in this project should provide a brief description of their relevant experience and knowledge. Ideal Skills and Experience: - Microsoft Power Platform and Dataverse Expertise - C# and .NET Development - Package Deployer Tool Proficiency - Power Apps CLI and Visual Studio Code - Experience with Dynamics 365 SDK - Previous experience in publishing PowerApps solutions on AppSource - Ability to work with canvas apps, component libraries, Power Automate flows, environment variables, and connection references - Strong problem-solving skills - Good understanding of the AppSource platform. Looking fo...
I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry process.
I'm seeking an expert in SMS marketing to help establish and run a robust campaign. Details: - Platform: I plan to use an SMS marketing platform and need help setting it up properly. - Target Audience: The campaign will focus on both ...different audience segments. - Strong understanding of customer acquisition and retention through SMS. - Experience with loyalty programs is a plus but not mandatory. We offer SMS Marketing. Look for Affordable Platform that easy to use and we can reseller back to our customers. scan to enter Qr code chance/ text Win100 to727216269x You are enter to Win $100 gift card and Free Appetizer which need to auto send back to entry SMS subscriber a coupon to use in the restaurant. Do you have reseller white label or ISO program? What level involvemen...
I require an adept senior-level Chartered Accou...adept senior-level Chartered Accountant/Chief Financial Officer (CFO). My ideal candidate will maintain responsibility for: - Rigorous financial reporting - Diligent budgeting and forecasting - Effective cash flow management -Supervision of existing staff to facilitate GAAP processes and timely monthly close processes A deep and demonstrated understanding of auto parts industries is non-negotiable. With your experience, you will add significant value to my company's financial standing and strategic growth. Proven track record in similar roles is highly valuable. You will be working remotely, using the data we provide and other data that you gather to advise our leadership team on all financial matters and the financial...
I'm looking for a skilled Excel expert to create a project tracking sheet with a calendar section that lists weekly milestones. Key Features: - The main sheet is for tracking project progress. It should include: * Project /Task Name * Start Date * End Date * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a project is on targ...
I need a Blender expert to import the Textures I downloaded from my Turbo Squid account for the product (please see what i currently have vs what It should look like). I've had a play around myself with nodes etc, but I'm relatively new to the software and haven't had much success bar the buttons in the middle. I have all the textures as a .tif, I just need them importing and correctly set up so they look the same when rendered.
I'm in need of a Laravel developer to assist with my website. There are a few specific issues I'd like to address, as well as a new feature I'd like to add. Your tasks will include, but not limited to: - Fixing links on the site: Some links on the website are not working as intended. There are also broken links and incorrectly linked pages that need to be addressed. - Implementing user registration and login: I'd like to add user registration and login functionality to the site. This will require a secure and seamless process for users to create accounts and log in. - Implementing search functionality: I'm also looking to have a search feature on the site. Users should be able to search for specific content on the website with ease. The design o...
I'm looking for a skilled software developer to create a Windows-compatible software application. This software should be specifically tailored to help my sales team improve their performance a...with Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software development. - Experience in creating software for sales teams or incentive calculation. - Familiarity with Excel/CSV data import for softw...
I need a skilled PHP/Bootstrap developer to make content alignment adjustments to my existing website. - Layout Changes: The project scope specifically involves tweaking the layout of my site. - Design References: You'll be maintaining the existing website theme as you make these adjustments, so you should be able to follow and work within the established design. - Mockups: I will provide you with detailed mockups of the changes I require. This will form the basis of your work, though I'm open to suggestions and improvements based on your expertise. Ideal Skills: - Proficient in PHP 5.3 - Strong experience with Bootstrap - Ability to follow existing design themes - Good understanding of website layout and content positioning This project is more about fine-tuning an ...
I've already secured a location where I aim to establish a comprehensive soft play and swimming area. The site is all set to accommodate both indoor and outdoor arrangements for the little adventurers, aged between 0-8 years. We are looking at creating an engaging, fun, and safe environment for toddlers and pre-schoolers. Ideal Skills And Experience: - Proven experience in designing ...and swimming pool layout - Ensure safety standards are met at every step - Help design areas that are fun, engaging and suitable for the age group - Assist in selecting the right equipment for the soft play area and swimming pool - Provide guidance on the best indoor/outdoor setup The ideal candidate would have previously successfully implemented similar projects and be able to provide ...
I need assistance in integrating an automatically generated Order ID within my Google Forms. Many people do it so, AT THE END the form, it will generate an ID number that will go into the Google Sheet where the responses go. In this case, I need it to be in form of a Short Question INSIDE THE GOOGLE FORM, Not at the end. So this way, the number generated will be part of the info the client sunbmits like Name, Phone Number, Zip Code, etc. Please ask questions before agreeing to begin.
I ll upload various images under specific keywords. I want members to receive 1 image after texting that keyword in their personal channel. Also i want that image to be deleted in storage so that it will not be forwarded to other member. I also want a channel for my accountant, where he ll be uploading bill in pdf. And i ll get all data in excel sheet.
I'm looking for a professional who can plot GPS coordinates from an Excel spreadsheet onto a map. This map should be easy to interpret, displaying the route taken by a vehicle. Key requirements: - The data provided is in Excel format. - The final map should be a static image file. The main task of this project is to: - Visualize the route taken by a vehicle based on GPS coordinates. - Timestamps are crucial and should be displayed in a clear, understandable manner. - Since I want to see the exact route taken, the map should display addresses corresponding to the GPS coordinates. Although the main focus of the project is plotting the coordinates and timestamps, other features such as: - Distance between points. - Speed of the vehicle. - Estimated time of arrival (ETA)...
I need a script for NinjaTrader 8 that automatically marks a "untested" 60-minute high/low with a labeled line. This line should disappear once the level is tested by price touching it. I will send a video to those interested to show what I am referring to. The script should: - Automatically mark a 60-minute high/low with a labeled line. -The 60 minute high/low will show on ANY timeframe chart. For example, if I'm looking at a 60 minute chart and 5 minute chart side by side, and both have the new indicator on them, the 60 minute lines should be the same on both charts. I will be adding this indicator to many charts and the timeframes will all be different, but they should all pull their lines from the untested 60 minute high/low. - Make the label "H1" un...
I am looking to hire a skilled house painter who is experienced in painting both single and double storey new volume build homes. The successful candidate would be engaged on a casual basis commencing as soon as possible, with the possibility of future work for a reliable candidate. Offering great employment conditions including flexible hours and...candidate. Offering great employment conditions including flexible hours and subcontractor pay rates, the successful applicant will be working alongside one to two other experienced painters at a time, including the owner of the business. The ideal candidate will have more than five years of experience in new-build house painting, a meticulous eye for detail and their own transport. Please provide references for similar past work in your...
I'm looking for a skilled freelancer to create a mantra chart in Excel. This will be a presentation-worthy document, so I'm keen on ensuring that it's well-structured and visually appealing. Key Requirements: - Incorporating text, numbers, and dates into the chart - The chart should feature less than 10 mantras - Ensuring the final output is suitable for professional presentation The task will require someone with excellent Excel skills and an eye for design. A good understanding of data representation would be a big plus. You can expect detailed instructions and guidance from me throughout the project. Feel free to ask any clarifications you might need.
I have a iOS application with a few bugs that needs fixing and adding the function of inviting phone contacts to our app. iOS applicaiton built in: - Objective C - Native App and UIKit I will share the specification document when we speak in freelancer chat.
I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus
I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.
I am seeking a skilled videographer to create educational videos for my LinkedIn and Instagram platforms. The videos should be less than one minute in duration each, maintaining the highest levels of quality. Your job will entail: - Creating engaging and informative educational videos - Being responsible for video shooting and post-pro...responsible for video shooting and post-production - Creating succinct content suitable for social media users Ideal Skills and Experience: - Outstanding video editing competency - Experience in creating educational or tutorial videos - Familiarity with LinkedIn and Instagram video guidelines - Ability to work within a stipulated timeline. Prior experience with similar projects and strong references will make you a top contender for this op...
I'm in need of a programmer who can help me create a Twitter social farming webpage with daily challenges and achievement badges alongside an HTML5 arcade game integration with referral& earnboosters options. ( don't mind using CMS like wordpress/joomla) References () . (@senderlabs/introducing-the-senderdao-points-system-1015e1e584a1) For the Twitter Social Farming Game: - I envision daily challenges to keep users engaged. - There should be a system for awarding achievement badges for specific accomplishments. For the HTML5 Arcade Game: - integrate readymade HTML5 arcade game with points system. (you should recommend a game that can be customized could be from codecanyon or somewhere else ). Points Earning System: - I haven't defined how points should
I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes and turn this data into comprehensib...
I am looking for an 2-d artist NOT LOGO DESIGNER to create a unique heraldic image for me(you will be provided with references). Please look at my attached example for reference so you can see my expectation both in terms of style and complexity. If you are interested, please send examples of your previous work for consideration. (You will not be considered without submitting examples of your previous work, it is not my job to go to your profile and search) Compensation is $50 cad! If this is not enough, I completely understand, no one should be asked to do a job for pay they don't believe is enough. All I ask is you simply don't apply, and instead apply for the jobs that where the pay is agreeable to you.
I'm looking for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note that due to the nature of this...
I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibility issues - Strong un...
I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.
