Save vba excel add일자리

Need to cover and update the following points 1: Prevent users from copying and pasting data to the Template file from other files 2: Link the new planning template to VLOOKUP file. Need the Dropdown data validation options on this file to match the Vlookup file that we maintain separately and use for our other templates. 3: Ensure that VLOOKUP file needs to be referenced from original location instead of creating a copy to the folder. 4: Stop workbook links message when file is opened 5: Stop VLOOKUP file closing message when file is closed

I am looking for a skilled Power BI expert to create a dashboard primarily focusing on sales analytics. Key Requirements: - The dashboard should connect to Excel/CSV files. - It should track revenue by product. Ideal Skills and Experience: - Proficiency in Power BI. - Experience in sales analytics. - Ability to work with Excel/CSV data sources.

Hello. As discussed, I’ll make the dashboard for you.

I'm seeking help with matching date ranges in my data. The data is time-sensitive and needs to be handled with precision. Ideal Skills and Experience: - Proficiency in Excel, particularly with the INDEX and MATCH functions - Strong understanding of date and time data - Experience in data analysis and sorting - Attention to detail to ensure accurate matching of date ranges

I have an Excel sheet containing sales data and I need help converting this information into a parts needed list. The parts list should be organized by dates of sales. Key requirements: - Identify individual components from sales data - Organize parts list by sales dates Ideal skills: - Proficiency in Excel - Experience with data analysis - Attention to detail

...These pages display the same product catalog as the main store. Customers can place orders but not pay directly. Instead, orders are recorded and linked to the seller for later group processing. 3. Order Collection & Export (for Reseller Webshops) Orders placed via reseller webshops should be saved in a separate list. Group leaders (e.g., a coach or teacher) can export the order list as a CSV or Excel file. Once all orders are collected, the leader places a bulk order via the main webshop. 4. Seller Dashboard Sellers log in to see order summaries, total sales, and commission tracking. A referral link generator so sellers can share their shop. No financial transactions on this dashboard—only order tracking. 5. Admin Dashboard & Order Management Overview of all seller...

I'm in need of a professional who can assist me with a data migration task. The data is currently stored in another Excel file, and I require help specifically in removing duplicates during the migration process. Ideal Skills: - Proficiency in Microsoft Excel - Experience in data migration tasks - Ability to identify and remove duplicate entries This project is straightforward but requires attention to detail and a strong understanding of Excel.

I need an Excel whizz to help me manage and analyze my inventory data. The primary focus will be on organizing data and setting up formulas to track stock levels efficiently. Key Tasks: - Organizing my inventory data - Setting up formulas for tracking stock levels - Creating visualizations like charts and graphs for easier data interpretation - Providing step-by-step instructions and useful tips I am looking for someone who can also guide me on using advanced Excel functions such as VLOOKUP, pivot tables, conditional formatting, and data validation to streamline this process. Ideally, you will provide me with templates that can save time and enhance productivity in handling large datasets. The ultimate goal is to improve accuracy and generate insightful reports. S...

Bonjour, Nous recherchons une personne experte en Microsoft Excel pour gérer, trier et nettoyer un fichier contenant plus de 50 000 lignes de données (contacts). Ces fichiers regroupent des milliers de candidats et contacts enregistrés au fil des années. L’objectif est de pouvoir croiser les données, filtrer les candidats en fonction de plusieurs critères, notamment leur qualité, le secteur d’activité, ainsi que le poste et l’entreprise pour lesquels ils ont été positionnés. Nous comptons sur votre expertise pour nous accompagner dans cette tâche complexe et stratégique.

I'm in need of a standard, detailed Chart of Accounts specifically tailored for the service industry. Key Aspects: - Development of a standard Chart of Accounts - Focus on the service industry - Detailed level of account categorization Ideal Skills and Experience: - Understanding of service industry financials ...Aspects: - Development of a standard Chart of Accounts - Focus on the service industry - Detailed level of account categorization Ideal Skills and Experience: - Understanding of service industry financials - Experience in creating detailed Charts of Accounts - Knowledge of standard Chart of Accounts - Strong accounting and financial planning skills. The Chart of Accounts should be delivered in Excel format. Please include specific industry examples or templates...

I am a person who specializes in studying the world of diseases. There is an Excel file about the disease covid19. I want to analyze the data in the file and display it in a clear way through which I can understand the data so that I can use it in my research on covid 19 This project involves statistical analysis. Please apply descriptive statistics to the data. Please include charts to clearly visualize the data. Please include bar charts to clearly visualize the data. Please focus on knowing where the disease is spreading. Please include bar charts to clearly visualize the data. Focus on analyzing the geographical distribution of covid19 cases. The analysis should cover data from the date on which the data was collected..

I'm in need of a professional who can create a comprehensive Excel sheet for billing and invoices. It should include an expense tracking component as well. Key Requirements: - Design an Excel sheet specifically for billing and invoices - Include an expense tracking component in the sheet Expense Tracking: - The sheet should allow me to categorize expenses - It should track the amount spent on each expense - The sheet should include a column for the date of each expense. - A column for a brief description of each expense should be included. - There should be an option to attach or link expense receipts. Ideal Skills and Experience: - Extensive experience with Excel - Previous work with designing billing and invoicing Excel sheets - Capability to integrat...

Objective Develop a macro for Microsoft Word and Excel that captures comments from a Word document and exports them into a structured Excel spreadsheet. Requirements - The macro should extract the following details from each comment: - Author (name and email) - Date and time of the comment - Comment resolution status - Line number associated with the highlighted main text - Main text that the comment is based on - Section header, if the main text falls within a chapter or section of the document - Page number for the highlighted main text - Subsequent comments or replies, structured in additional columns rather than additional rows Excel Output Requirements - Each comment should be recorded as a single row in the spreadsheet. - Responses to comments should appear in...

보다 자세한 내용을 확인하시려면, 회원 가입 또는 로그인 절차가 필요합니다.

I'm in need of a freelancer who can provide me with daily updates on divorce listings in the Toronto area, delivered in an Excel spreadsheet. Requirements: - The Excel spreadsheet should contain the names of the individuals involved in the divorce and their contact numbers. - The data should be organized, accurate, and up-to-date with daily listings. Ideal Skills: - Proficient in data collection and Excel. - Able to ensure data privacy and handle sensitive information with discretion. - Familiarity with sourcing public information, particularly legal databases, is a plus. Data should be sourced from public records. Please include the property addresses in the listings. Include full addresses with street, city, and postal codes for each property.

I need assistance in entering text data from PDF files into an Excel spreadsheet. Ideal skills for this job: - Proficient in Excel - Excellent attention to detail - Speedy and accurate data entry - Able to follow instructions precisely - Ability to validate and verify data

...mobile application to provide a seamless shopping experience for smartphone users. 12. Payment Integration: Integrate multiple payment gateways to offer flexibility in payment options for customers. 13. Customer Support: Live chat and support ticket system to help customers with their queries instantly. 14. Bulk Uploads: Feature for parts providers to upload large inventories in bulk using CSV or Excel files. 15. SEO Optimization: Ensure all parts listings and sections are optimized for search engines to drive more traffic. The portal will need to handle an inventory of over 100k items and SKUs. A crucial requirement is to have a system where the inventory updates automatically. Ideal Skills & Experience: - Proficient in web development and e-commerce platform creation - E...

...document repositories, and media platforms. Implement Natural Language Processing (NLP) for document comprehension and YouTube transcription. Provide an API interface for querying and accessing the processed data. Support integration with various Large Language Models (LLMs), allowing flexibility in model selection. 3. Data Sources & Integration 3.1 Supported Data Sources Documents: PDF, Word, Excel, Google Docs Cloud Storage: Dropbox, Amazon S3, Google Drive URLs: Web pages, APIs, public datasets YouTube Videos: Speech-to-text transcription & metadata extraction Projects & Repositories: GitHub, Jira, Trello Databases: SQL, NoSQL (MongoDB, Firebase) 3.2 Data Collection Methods APIs: Dropbox API, AWS S3 SDK, YouTube API, Web Scraping OAuth Authentication:...

...involve using Excel Solver to tackle various complex problems related to inventory management and demand forecasting. Key Objectives: - Apply linear programming and integer linear programming models to optimize and simulate supply chain scenarios. - The primary goals are to minimize costs, maximize efficiency, and optimize resource allocation. Constraints: - The model must account for various budget, capacity, and time constraints. Ideal Skills: - Proficiency in Excel Solver and mathematical modelling. - Strong understanding of supply chain management, particularly in inventory management and demand forecasting. - Expertise in linear programming and integer linear programming. - Ability to work within specified constraints. Experience: - Proven track record of using ...

I need an Excel signing sheet created from a single PDF. The Excel sheet should include names and signatures autopopulated from another sheet, as well as the date and time. Please use standard rows and columns for formatting refer to pdf

I'm looking for a proficient Excel developer with a strong background in trading systems to build an Excel-based trading system interfacing with Upstox. Key Requirements: - The system should support Day trading and Scalping strategies. - The system must include features for Automated trading, Data analysis and visualization, as well as Trade logging and reports. - The system should fetch market data via API integration with Upstox. Ideal Skills & Experience: - Advanced proficiency in Excel, including VBA for automation. - Proven experience in developing trading systems. - Familiarity with Upstox and its API. - Strong understanding of Day trading and Scalping strategies. - Excellent data analysis and visualization skills. Please, include examples of ...

This project is ideal for someone with experience in creating budget spreadsheets, preferably for couples or families. Excel or Google Sheets expert is a must. It would be beneficial if you can incorporate features that enable easy tracking and analysis of our financial habits. Include charts to visualize the data. Include a feature to track and visualize progress towards savings goals. example:

This project is ideal for someone with experience in creating budget spreadsheets, preferably for couples or families. Excel or Google Sheets expert is a must. It would be beneficial if you can incorporate features that enable easy tracking and analysis of our financial habits. Include charts to visualize the data. Include a feature to track and visualize progress towards savings goals. example:

I need a tool that will help me create offers based on an Excel price list. The tool should allow for multiple product selection and have the ability to generate a PDF of the final offer. Key Features: - Multiple Product Selection: The tool should allow me to select multiple products from the price list when creating an offer. - PDF Generation: The final output of the offer should be a neatly formatted PDF. Skills and Experience Required: - Proficiency in Excel and PDF generation - Prior experience in creating similar tools or applications - Understanding of e-commerce product selection and offer creation process is a plus. The PDF output should have a custom layout with specific design elements. The PDF should include offer terms and conditions. The PDF layout should inc...

I need a family budget spreadsheet tailored for a couple. Its primary function is to track income and expenses. The spreadsheet should be able to monitor various types of expenses including monthly bills, daily spending, and unexpected expenses. This project is ideal for someone with experience in creating budget spreadsheets, preferably for couples or families. Excel or Google Sheets expert is a must. It would be beneficial if you can incorporate features that enable easy tracking and analysis of our financial habits. Include charts to visualize the data. Include a feature to track and visualize progress towards savings goals. example:

I'm seeking a seasoned professional to help automate processes related to our 'pinkfish' website project. Key focus areas include: - Data entry: Streamlining input processes to save time and reduce errors. - Email responses: Automating customer interactions to ensure consistent and timely replies. - File management: Ensuring all files are organized and accessible, with minimal manual intervention. The ideal candidate will have experience with Excel/Google Sheets, as well as CRM systems and project management software. Skills in web development and knowledge of e-commerce platforms will be highly beneficial.

I'm looking for a freelancer who can independently manage and accurately transfer information from various sources into an Excel spreadsheet. The specific sources will include paper documents, spreadsheets, and online forms. The ideal candidate should have experience with data entry, attention to detail, and proficiency in Excel. Key Skills Required: - Data entry - Excel proficiency - Attention to detail

The task involves manually drawing and recording polygons for specific rivers and canals. Each polygon must precisely represent the full course a...water surface of each river or canal. • The focus is on 25-30 rivers and canals, (global Importance). • The polygons should be manually drawn using GIS software and then exported as WKT strings. • Ensure the data is topologically correct and corresponds precisely to the actual river boundaries. • The final output should be an Excel file with two columns: • “Name”: The name of the river or canal • “WKT”: The corresponding WKT polygon Deliverables: 1. Excel file () with two columns: • Name (river/canal name) • WKT (polygon geometry in WKT format) or other f...

...devices and screen sizes. - Implement a comprehensive user role and permissions management system. - Integrate third-party APIs for extended functionalities such as shipment tracking. - Implement advanced security measures to protect against vulnerabilities. - UpDATE custom reporting features for detailed insights and analytics. - Update the ability to import/export/update product data via Excel, etc. A detailed task list with over 30 points to fix is available on Trello, and the project is hosted on GitHub. The estimated time to complete this task is about 4-5 weeks. Ideal Skills: - Proficient in PHP and Laravel - Experience with POS and Inventory systems - Familiarity with GitHub and Trello - Knowledge in implementing multi-language support and currency upd...

I'm seeking an Excel professional who can assist with modifying a file and selecting specific data. The task involves saving images in bulk from local files and requires some specific data formatting. Key Requirements: - Data Modifications: Save images in bulk from local files. - Data Formatting: Primarily involves cell merging and alignment. Ideal Skills: - Proficiency in Excel - Experience in data cleaning and formatting - Familiarity with bulk image saving techniques - Attention to detail

I'm seeking a skilled developer with extensive experience in Laravel 11. I need modifications to my existing code to incorporate: - Private call functionality with call masking (this should involve masking both caller and receiver numbers) - SMS sending with OTP (One Time Password) - Video call capabilities The call masking feature will require third-party API integration, so familiarity with relevant APIs is a plus. The ideal freelancer for this job should have a strong background in Laravel, experience with API integrations, and knowledge of implementing call and SMS features in a web application.

...Implement a real-time live chat feature for customers to receive immediate assistance and support while browsing or making purchases. - Advanced Search Filters: Incorporate advanced filtering options (e.g., by skin type, brand, price, etc.) to help customers quickly find the products they need. - Implement SEO best practices to help the store rank higher in search engine results. - Allow customers to save products to a wishlist for future reference or purchase. - Integrate social media sharing options to allow customers to share products on their social networks. - Ensure the store is fully responsive and functions seamlessly on mobile devices. The ideal candidate should have a strong background in e-commerce website development and experience in integrating customer review syst...

I need a seasoned developer with expertise in React Native, Node.js, and MySQL to connect various components of my e-commerce mobile app. Key Tasks: - Connect registration and login to the app - Link the cart to orders and their backend - Integrate Somalia payment methods: EVC Plus, Sahal, Zaad, eDahab, credit card, and COD - Add a wishlist feature where users can save items they are interested in purchasing later. - Set up push notifications for order status updates and promotional offers. Payment Process: - The payment process should be triggered at checkout User Authentication: - The current user authentication method is via phone number and SMS verification. Please ensure this is seamlessly integrated with the aforementioned components. Ideal Skills: - Proficiency in ...

I'm looking for an Excel expert who can assist with data analysis and report generation. The task involves working with large datasets, creating dynamic reports, and ensuring data accuracy. You will primarily be working with financial data. Your tasks will include: - Analyzing and cleaning up large data sets in Excel. - Developing and automating custom reports using advanced Excel functions. - Creating Pivot Tables, Charts, and Graphs to visualize data. - Developing macros for repetitive tasks and data automation. - Working with VLOOKUP, INDEX MATCH, and other advanced Excel formulas. - Ensuring the data integrity and accuracy of reports. - Providing clear and concise documentation of the work performed. The ideal freelancer should be proficient in advan...

Excel et Word me permet de saisie vous donner et vous permet de faciliter les tâches de la saisie en vous focalisant sur la saisie de donner vous êtes à effectuer les différentes tâches plus rapidement et plus facile

Ubicación: 100% Remoto Jo...seguimiento. Soporte en marketing digital: gestión de redes, contenido básico y campañas. Optimización de procesos internos y documentación de procedimientos. Requisitos Experiencia en administración, operaciones o marketing digital. Capacidad para gestionar varias tareas sin perder el foco. Habilidades de investigación y negociación con proveedores. Conocimientos básicos de herramientas digitales (Excel, CRM, marketing digital). Actitud resolutiva, autonomía y mentalidad estratégica. Experiencia previa en trabajo remoto o habilidad para autogestionarse. Qué ofrecemos Trabajo 100% remoto con horario flexible. Un rol dinámico con impacto real en el negocio. Op...

I need a professional who can extract and compile the dimensions of all the girders from my Tekla Structures model of a Foot over Bridge. The necessary details include the length, width, and height of each girder, as well as its material type. The final output should be an Excel spreadsheet containing these details for every girder in the model. Ideal skills and experience for the job: - Proficiency in Tekla Structures - Excellent data extraction and organization abilities - Proficient in creating and managing Excel spreadsheets - Understanding of civil engineering concepts related to bridge construction - Strong knowledge of structural steel components and their properties

I need a skilled Excel expert to help me with my formulas. I'm specifically working with mathematical and text functions. My main goal is to enhance my data analysis capabilities. Ideal Skills and Experience: - Proficient with Excel - Strong understanding of mathematical and text functions - Experience with data analysis

...ATTRIBUTES EXPERT MAGENTO 2 "ATTRIBUTE SET" EXPERT MAGENTO 2 PRICE RULE EXPERT PRODUCTS IMPORT EXPERT EXCEL EXPERT Please do not bid if you're not a genuine expert that can import thousands of products every week. Tasks and Responsibilities: - Be super organized. We will be sending you documents: please sort them in a way that will make it easy for you to revert to these documents whenever needed. We use Office 365 / OneDrive to organize our documents. - You will be importing using excel or CSV or, if you're a true expert: you may even use XML. You will need to maintain these files. If we find out that an attribute was not defined, we want to make sure it will be easy for you to add the attribute and reimport the products adequately. ...

Need to split a line break in a column into own rows without overwriting other data. So it needs to be inserted in between current rows. It is three documents with today approximately 60 000+ rows each. Where it is inserted, the other column needs to be filled with the same value as above.

...should be user-friendly, visually appealing, and capable of showcasing a wide range of products. - Integrate multiple payment gateways, including credit card, PayPal, and other options. - Provide real-time tracking of orders from purchase to delivery. - Enable users to save items to a wishlist for future purchases. - Feature a section for customer reviews and ratings on product pages. - Implement push notifications for order updates, promotions, and app news. - Provide multi-language support to cater to a wider audience. - Add advanced product filtering and sorting options to enhance user navigation. Ideal Skills and Experience: - Proficiency in Flutter is a must. - Previous experience in developing E-commerce applications will be highly advantageous. - Strong understandi...

I'm looking for a skilled professional to create a Power Automate workflow for me. Key Requirements: - The workflow should run daily. - It will pull data from an Excel spreadsheet and update/add rows in another table based on a primary key column. - If a primary key from the source table does not exist in the target table, a new row should be added. If it does exist, the corresponding row should be updated. Ideal Skills and Experience: - Proficiency in Microsoft Power Automate. - Strong experience working with Excel. - Ability to work with primary key columns and understanding of their usage in data synchronization. Please bid if you're capable of delivering this project efficiently.

I'm looking for someone to type a 45-page legal document into Microsoft Word for me. The document needs to be in standard legal formatting. Ideal Skills and Experience: - Proficient in Microsoft Word - Familiar with standard legal formatting - Attention to detail to ensure accuracy - Ability to meet deadlines - Strong proofreading skills t...template that I will provide. A standard Non-Disclosure Agreement (NDA) must be signed. The work must be completed within two weeks. Please use Times New Roman font in size 12 for all content. The document should include a table of contents following my instructions. The NDA will be sufficient for handling confidential information. The document should be single-spaced. Sample will be provided. Please save the final document as a Micro...

Project Title: Excel Macro-Based Inventory Management System for Diamond Trading Project Description: I am looking for an experienced Excel VBA (macro) developer to create a comprehensive inventory management system tailored for my diamond trading business. The system should be user-friendly, efficient, and capable of handling dynamic data with automated calculations. Key Requirements: 1. Modules: - Cash balance -Purchase and Sales records -Upcoming receivables and payables - 2. Automation Features: - Automated calculations for inventory updates based on parcel changes. - Dynamic addition and deletion of rows with real-time data updates. - Scrollable history for easy tracking of past transactions. - Backup and restore functionalities (preferab...

I need an Excel spreadsheet generated from my access machine which includes user details, sorted by department. Details to be included: - Name - Department - The ideal freelancer for this task should have: - Proficiency in Excel - Experience with data extraction from access control systems - Ability to sort and organize data effectively Please ensure the final output is user-friendly and ready for printing.

I need a persuasive and urgent salesperson to sell my vacuum-packed fruits and vegetables. The target market is primarily corporate entities and busy individuals seeking healthy food options that save them time on preparation. Key Responsibilities: - Conduct in-person sales visits to potential customers - Sell products directly - Employ a hard-sell approach - Meet or exceed established sales targets - Conduct product demonstrations to highlight features and benefits Desired Skills and Experience: - Proven experience in direct sales - Exceptional persuasive and communication skills - Previous experience selling food products preferred - Ability to target and engage corporate entities and busy individuals

I'm looking for an Excel & Office 365 expert to help me with Running Macros. I got Excel file link shared through Onedrive and i open it through Excel Desktop app but am unable to run macros. I tried enabling trust center settings dose not work. I wont be able to share file you need to explain me how to do this over a call.. Please note, this is a straightforward task with a budget of $10.

More details: What type of data do you need to extract from your private website? Text data What format do you need the extracted data to be in? Excel Do you need any specific data processing or cleaning before the data is saved? Yes, advanced data processing

Need a form where the customer can pick options to build a quote for renovating residential rental inventory

I need this done right now Entered numbers not adding up My Excel file has issues where manually entered data is not updating. There are no error messages appearing, but this problem is causing significant inconvenience.