Vba code update data excelงาน

...- 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 waste your time and bid If you h...

I’m looking ...Configuration • Configure Apache to block connections made directly through the server’s IP address (including when IP:port is entered in the browser). • Ensure that all traffic and connections pass exclusively through the domain name and cannot be accessed via the IP address. 2. SMTP Setup • Update the SMTP settings to use a different IP address for email functionality. 3. Fix IP Exposure • Identify and resolve the issue where the server’s IP is exposed, making it vulnerable. • Investigate the code (written in Node.js/Express.js) to locate and address any IP leakage. Looking for a skilled JavaScript developer with experience in Node.js, , and server configuration. If you’re available and have the experti...

Update O Screener to new version with additional functionality, change report format.

we are seeking a proficient developer to create a Nodes js code for a Whatsapp bot. that will be combined in our whats-app BOT project. The code will receive user/chat id (XXXXXXXXXXX @) and a JSON defining the questionnaire (see attached sample ), the code will simulate a questionnaire, interacting with clients using various message types: text, images, lists of options, buttons and links. Key Requirements: - Utilization of the Venom API for WhatsApp. (or use wappconnect, whatsapp biz api or similar) - code can handle different types of questions: text-based, image-based, and using list options or buttons or links. - answers will be saved in JSON format (see attached ) - if you use whatsapp biz api, we will supply Token. Ideal Skills and Experience: -

I'm looking for an experienced Dynamics CRM professional who can help with updating functional and technical documents for my system. Key Tasks: - Update the existing Dynamics CRM functional document by comparing it with a new user guide. This should be done in a Word Document. - Update the flow diagram for the processes - Provide a comprehensive list of changes made. - Assist with the creation of a technical document. This will involve using provided details to create documentation covering technical specifics, an architecture diagram, and an entity diagram. - Recommendations for the architecture diagram will be needed. Ideal Skills: - Proficiency in Dynamics CRM. - Experience with technical and functional documentation. - Strong skills in creating flow and architec...

I need a skilled developer to create a desktop Excel and Office 365 online Add-In for me. The primary use of this Add-In will be the implementation of custom formulas. Key Features: - Automate tasks such as data entry, report generation, and data validation. - Custom formulas should support data aggregation from multiple sheets and integrating with external data sources. Ideal Skills: - Proficiency in Excel Add-In development. - Strong understanding of creating custom Excel formulas. - Experience with automating Excel tasks. - Capable of implementing data aggregation and external data integration features. I'm looking for a freelancer who can deliver a high-quality, fully functional Add-In that meets these spec...

... Goal: Create a system where: - A bot pulls contact data (name, phone number, address) from Google Sheets. - Vapi's AI makes automated cold calls dynamically using the data. - The bot updates Google Sheets with call results, notes, and lead status (interested, not interested, follow-up needed). Key Features I Need: - Integration between Google Sheets and Vapi via Make.com. - Vapi bot dynamically references fields (like firstName, address, city, property type, market value, etc) during calls. - Call notes and responses are logged back to the appropriate row in Google Sheets after each call. - Automatic call scheduling based on lead lists. - Status columns in Google Sheets that update automatically based on call outcomes. Skills Required: - (formerly Integrom...

I'm seeking a Freelance Operations Assistant for my expanding home furnishing business. Your primary responsibilities will include maintaining and updating SKU sheets, m...a Freelance Operations Assistant for my expanding home furnishing business. Your primary responsibilities will include maintaining and updating SKU sheets, managing SKUs for raw materials and expenses, and occasionally accompanying me to markets to purchase raw materials. Key Responsibilities: - Maintain and update SKU sheets - Manage SKUs for raw materials and expenses - Occasionally accompany me to markets to buy raw materials Ideal Qualifications: - Intermediate level of Excel - Organized and detail-oriented - Comfortable with occasional market visits If you're reliable and seeking flexi...

I have a Python web scraping code that needs fixing due to a recent update on the website. The code is currently failing at the data extraction phase, specifically with extracting tables and structured data. - Data Extraction: The code is unable to retrieve the necessary data from the website. - Data Type: The focus is primarily on extracting tables and structured data. - Data Usage: The extracted data will need to be saved as CSV and Excel.. Ideally, the freelancer for this project should have substantial experience with Python, web scraping and database management. Familiarity with the site would be a plus. Please provide examples of similar projects you have completed in your bid.

I'm looking for a data analyst with strong skills in MS Excel, Java, and HTML. The primary focus of this project is to analyze and report on sales data. Experience in data visualization and reporting is crucial, as the results will need to be presented in a clear and coherent manner.

I need a qualified architect or quantity surveyor to prepare detailed architectural and structural drawings along with a comprehensive Bill of Quantities (BOQ) for a residential villa extension in Harmony 2, Tilal Al Ghaf. Scope of work: - Preparing floor plans, elevations, and sections. - Providing structural and steel detailing. - ...elevations, and sections. - Providing structural and steel detailing. - Developing an itemized BOQ for materials and labor. - (Optional) Supporting authority approvals. Requirements: - Proven experience in residential projects. - Familiarity with Dubai authority standards (e.g., DDA, Dubai Municipality). - Ability to deliver within 1–2 weeks. Deliverables: - Complete drawings (PDF and CAD). - BOQ in Excel format. Assistance in comparing recei...

I'm looking for a skilled developer to assist with updating existing test series via an API. Ideal Skills: - API development and integration - Experience with test series platforms - Problem solving and analytical skills Job Responsibilities: - Update existing test series with new questions and answers using the Test Series API - Ensure a smooth and efficient update process There are mainly four things to do- 1)Test series api 2)Current affairs Quiz api 3)Current affairs api 4)Check push notifications Please note, there will be no need to implement specific features in the questions and answers module for this project.

...for our guests. - RSVP Form: A user-friendly, interactive RSVP form is essential for tracking our guest list. - Gift Registry: This will link to our chosen registries and should be easy for guests to navigate. - Photo Upload: A section where guests can upload photos from the event. Special Features: - Photo Gallery: A dedicated space for sharing pictures from our wedding. This should be easy to update and navigate. Ideal Skills and Experience: - Proven experience in creating wedding websites or similar projects. - Strong web development skills, including proficiency in HTML, CSS, JavaScript and relevant web design software. - Able to design with a Classic and Elegant aesthetic. - Excellent communication skills for understanding and implementing my vision. - Experience with inte...

I'm working on a project involving trai...on a project involving training radiotherapy contour images for automatic contouring. I have a ready-made AI code that needs running on a local PC equipped with an RTX 3090 graphics card. I require assistance with: - Verifying necessary software and drivers are installed on the PC - Partially setting up the environment to run the AI code Ideal skills and experience include: - Familiarity with AI code execution - Experience with setting up complex software environments - Knowledgeable about RTX 3090 and associated software requirements - Relevant experience in image processing and radiotherapy would be a plus I need a professional who can ensure everything is in place for the code to run smoothly. Cloud-based exec...

I need assistance from an Excel expert to help me merge data for 120 people over the course of three years. Key Requirements: - Proficient in Excel with extensive experience in data manipulation - Able to understand and work with a single sheet that has different columns for each year - Capable of providing insight into the data to improve understanding and future planning Your expertise will help me understand the data better and plan accordingly for the future.

I'm looking for a skilled Excel expert to create a task management system tailored for team collaboration. The system needs to support a small team of 1-5 members. Key Features: - Task Assignment: The system should facilitate the distribution of tasks among team members. - Progress Tracking: There should be a way to monitor the progress of tasks and projects. - Shared Calendars: A component for a shared calendar is essential, allowing team members to stay informed about deadlines and important dates. Ideal Skills and Experience: - Proficiency in Excel, particularly in creating complex spreadsheets. - Experience in designing task management systems. - Understanding of team collaboration needs. other things required: calendar view deadlines short term , long term plan...

I'm in need of a comprehensive Excel file detailing the top 50 universities in the USA offering PhD programs in Quantum Computing with a focus on AI. The Excel should contain the following: - University name - Details of Professors 1 to 5 including: - Their department and position - LinkedIn profiles - Emails - History of past collaborations or projects in AI - Application deadlines for both Fall and Spring batches - Program specifics I would like this data to be organized in a single sheet with categorized columns for ease of use. Ideal skills for this project include experience in data collection, proficiency in Excel, and knowledge of the field of quantum computing and AI. Previous experience compiling similar data sets ...

I'm looking for an expert in Power Automate who can help me with automating data update within SharePoint / Microsoft list I need a simple Power Automate flow designed to update a SharePoint list. This flow should specifically handle updating existing items.. Details: 2 lists. List A: Title and Stock List B: Title (lookup from A), Type (choice with values Add/Remove), Quantity First step will be user adds list of items in list A with stocks (no flow so far) Logic: when a user adds a record in list B, flow will check if type is Add, modify the Stock value for the respective title Example, Item 1 has 1000 stock in list A, add a new item in list B, type Add, Quantity is 100, in this case modify the stock to be 1100 Now, add a new item in list B, type as Remove...

Excel Data Loading : Python coding ************ This project comes with Non-Disclosure Agreement ( NDA ) ************* Expecting to automate Data Loading into Excel Step 1 : There's a VA Excel Plugin which we have subscribed provides the data from their VA website (VA Plugin ) & this data dump gets populated into Excel 2 Data sheets which needs to be downloaded are Standardized Data (SD) & Company Data (CD) Automatically need to Login to Visible Alpha plugin and download the data ( Can skip this part, not needed ) After we get this SD & CD data, with some formula Surprise analysis & Source count both populated in Surprise analysis Sheet Now this is Base or Primary fi...

...50 municipalities (by population) to see if each website has a business directory. c) If a municipality website does have a business directory, scrape/download the business directory for businesses’ contact details. As an example, the City of Mississauga in the province of Ontario has an online directory that lists 14,481 businesses in Mississauga, and allows users to download the list as an Excel file (I have already downloaded info for all of these businesses): Note: some municipality websites don’t have business directories. That’s fine - I just want you to check the top 50 municipality websites and determine which ones do have business directories. So to summarize the

...AI-related insights. Engage with the LinkedIn community by commenting thoughtfully on industry posts and participating in relevant groups. Build a strong network by connecting with AI thought leaders, business owners, and industry professionals. Use strategic hashtags to increase visibility and engagement. Save all content and engagement data in our OneDrive folder for tracking and reporting purposes. Track comments and interactions on LinkedIn posts using an Excel sheet. What We’re Looking For Proven experience managing and growing professional LinkedIn profiles or pages. Strong understanding of AI, technology trends, and personal branding. Exceptional content creation skills with a human, conversational tone. Ability to analyze and use LinkedIn insights to improve...

I'm seeking assistance with managing and organizing data in Excel spreadsheets. Ideal Skills and Experience: - Proficiency in Excel, particularly in handling data entry and organization tasks - Attention to detail to ensure accuracy in data handling - Prior experience in administrative tasks or data entry roles would be an advantage

I'm looking for a skilled developer to update my stock market trading application. The primary focus is on enhancing the stock data features. Key Features: - Stock LTP, Bid/Ask spread, Volume, OI, Change% - Option Chain - Company details - Interactive Bar Charts - Notifications - News updates via Shoony API - User interaction through WhatsApp OTP & messaging The ideal candidate should have extensive experience in developing stock market applications, with a strong understanding of stock data visualization and user interaction features. Proficiency in creating interactive bar charts and integrating with APIs is essential. Excellent communication skills for coordinating the user interaction aspect will be highly appreciated.

I'm working on a project that analyzes traffic flow using quantum computing and deep learning. I need assistance with integrating these two technologies. The project focuses on real-time traffic data. Ideal Skills and Experience: - Proficient in Quantum Computing algorithms - Deep Learning models experience - Strong coding skills - Real-time data processing expertise - Previous work with traffic analysis is a plus

I'm experiencing issues with my Excel code that's leading to incorrect results during data processing. The main task of this code is to help me process data efficiently and accurately. Key Requirements: - Identifying and correcting errors in my current Excel code - Ensuring the code produces correct results during data processing - Potentially improving the performance of the code Ideal bidders should have extensive experience with Excel coding, a keen eye for detail to spot errors and the ability to optimize code for better performance.

I need an experienced designer to update an Adobe Illustrator .ai file. The changes are primarily focused on text: - Updating existing content or wording. - Ensuring the new text is correctly placed and formatted. I have the new content ready to be inserted, so your role will primarily be replacing old text with new. Ideal skills and experience for the job include: - Proficiency in Adobe Illustrator. - Strong attention to detail. - Experience with graphic design and file editing.

...will take record of the events in the text file. “File update notes: The text file should be written to a folder as per the folder path provided in the interface. If there is no existing file, it can be written to a new file with the date and time and a filename suffix(configurable in interface). So filename should be Each of the entry should be written to a single line in the text file in the format: <Current_System_Time>|<Mediaplayer_current_playing_time>|Music_Filename/Song_title/Track_Name.” The main application functionality is below. The home page will display the list of events captured after installation, the data will be larger so will need to implement pagination and swipe to refresh the data logic. Individual delete button fo...

I'm looking for an Excel expert to create a sophisticated form for data input and validation. Key Requirements: - The form will primarily be used for entering and validating text and numbers. - It must include dropdown menus for selecting options at various points. Ideal Skills: - Extensive experience with Excel form programming. - Ability to create user-friendly and efficient data input systems.

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

I'm in need of a comprehensive, themed/customizable chess application compatible with Linux. This application should allow users to play with Stockfish, with friends, and online. Key features should include: - Support for tournaments and puzzles - Game analysis by Stockfis...games and support for both application and web interfaces. The ideal freelancer would have a strong background in game development and a deep understanding of chess mechanics and theories. Experience with creating Linux compatible applications is a plus. Creativity in design is key, as I want a unique, themed/customizable interface rather than a standard chess design. Note: Players rating elo update by match win or loss. Analysis game Import export game pgn FEN import export Online 1 to 1 play Turnament c...

...store data across 7,500 towns in the USA . The freelancer will be responsible for scraping the following information from Google search results: - Store name and address - Contact information - Website (if any) - Contact person's name (if available) The towns / cities names will be provided in an Excel sheet, and the freelancer will need to: Search for auto parts stores in each town via Google. Scrape the relevant data (store name, contact number, address, website). Compile and organize the scraped data into an Excel file. Requirements: Experience with web scraping and the use of tools like Selenium, BeautifulSoup, or Scrapy. Experience using Google Custom Search API or SerpApi to extract structured results from Google searches. Proficiency ...

... We're seeking a proactive freelance Sales Development Specialist to help drive our growth by generating quality leads and enhancing our outbound sales efforts. What You’ll Do: - Identify and engage decision-makers in targeted industries primarily in Malaysia - Conduct outreach through cold calling and multichannel marketing - Qualify leads for business automation and AI solutions - Track and update CRM records with precision - Meet weekly metrics, including touchpoints, qualified leads, and appointments set What We Offer: - Flexible scheduling with at least 10 hours weekly (2-4 hours daily) - Competitive incentives for leads that result in closed deals - Potential for increased hours and long-term opportunities based on performance What You Bring: - Proven experien...

I'm in need of a Google Sheets expert to help me troubleshoot and enhance my current sheet. Key Tasks: - Fixing errors in existing formulas - Creating new, complex formulas The primary focus areas for these formulas are: - Data analysis and reporting - Project management Ideal candidates should be well-versed with Google Sheets, have a strong analytical background, and be able to create intricate formulas.

As a building company, I need a comprehensive Excel spreadsheet for quoting purposes. The spreadsheet should cater to both commercial and residential buildings and should include all necessary aspects for quoting. Key Features: - Inclusive of all trades: plumbing, electrical, roofing, tiling, etc. - Incorporation of all structural purchases - Detailed breakdown of individual wages with hourly rates - Everything needed to quote on commercial and residential buildings in Australia - All Excel workings need to be in metric measurements - A single, unified template for all quotes Ideal Skills and Experience: - Proficiency in Excel - Understanding of building trades and associated costs - Familiarity with commercial and residential building processes in Australia - Expe...

...customization of a generic OpenCart theme. The ideal candidate will have a strong portfolio demonstrating previous OpenCart projects, along with the ability to maintain confidentiality and adhere to signed NDA and IP agreements. Key Responsibilities: - Install and moderately customize a generic OpenCart theme - Modify the Menu, Home Page, and other pages to suit our digital products and services - Update site content to reflect our products, services, and blogs - Replace Banners and other images in the store (we will provide these) - Set up Categories, Subcategories, example products, and Blogs. We will provide help setting these up. Ideal Skills and Experience: - Extensive experience with OpenCart installations and customizations - Previous experience with digital products a...

I'm lo...The BOT should perform the following tasks: - Create new help desk tickets - Update existing tickets - Check ticket status The authentication method for the Webex BOT is still undecided, so I would appreciate your advice on the most suitable option. When creating a new help desk ticket, the BOT should capture the following information: - User details - Issue description - Priority level The BOT should also be able to capture user details from the Webex account that is currently logged in. Ideal Skills and Experience: - Proven experience in developing Webex BOTs - Familiarity with Connectwise Manage - Knowledge of different authentication methods and their implementations - Ability to capture and process user data from Webex Please reach out if you can ass...

I'm looking for a professional who can help me find the PHP script for that websites that provide free social media engagement, specifically Instagram and TikTok such as: Instagram Likes Instagram Story Views Instagram Followers Instagram Video/Reel/IGTV Views Instagram Saves TikTok Video Views TikTok Video Likes TikTok Video Saves/Favorites TikTok Video Shares Some samples:

Busco un profesional en Power BI para desarrollar un reporte visual e interactivo basado en un archivo Excel con varias hojas (denominadas "Lam") que ya contienen datos calculados. Requerimientos: Conectar y cargar el archivo Excel. Crear gráficos interactivos (barras, líneas, tablas) para mostrar acreditaciones, canjes, saldos y porcentajes de redención. Incluir filtros y segmentaciones para explorar datos por hoja, fechas o miembros. Diseñar un tablero visualmente atractivo y fácil de usar. Entregar el archivo Power BI (.pbix) listo para usar. Adjunto el archivo en excel y un ejemplo hecho en power bi

I need assistance converting an Excel calculator into a calculator that I can embed in a Word document, so that when the word document is turned into a PDF the calculator still works and is editable by the user. This could be done using Python to create the calculator. I can see two scenarios to achieve this:- 1 The Word document will be regularly updated , so the calculator should be embedded in the word document. 2 The calculator could be embedded in a separate pdf and the word pdf and calculator pdf merged each time the word document is updated. Requirements: - Integrate an editable calculator into the PDF that performs basic arithmetic Ideal Skills: - Python - Ability to create interactive elements within a PDF - Attention to detail and ability to follow instructions accura...

I need a professional who can create an Excel report in a dashboard format tracking the performance of our management. The report should encompass: - KPIs (Key Performance Indicators) - Financial performance - Employee productivity Ideal candidates for this project should be proficient in Excel, with experience in dashboard creation and performance reporting. Strong analytical skills and understanding of management metrics will be a plus.

...pentagram stars must not be distorted. All 8 pentagram stars of each star pattern have to be perfectly shaped pentagram stars. The final lines/objects have to be perfect aligned without round borders of the lines/objects. I expect a clean design with minimal amount of nodes on every Layer. I am using inkscape and SVG-File and Layer compatibility to inkscape is absolutely necessary. Thank You! +++ UPDATE COMMENT +++ PLEASE NOTE: The line objects on Layer 1 (blue, 50mm) and Layer 2 (yellow, 20mm) have to be also drawn with hairline thickness and with the nodes as shown in illustration 5 and as described in the requirements. It is not OK if you just draw these blue and yellow lines with a 50mm or 20mm line thickness. These "lines" have to be so to speak 50mm and 20mm h...

I'm looking for a skilled WordPress developer to help me edit my website, https://Foreclosedonandmad.com. The tasks include: - Replacing existing company name and address with new text - Editing testimonial information - Adding a new logo and 2 other images at the top of the page - Removing unneeded icons Ideal candidate should have a strong background in WordPress, web design and customization. Experience with modifying testimonials on a website is a plus.

...Automatically register surplus or shortage in inventory after stocktaking. Provide the ability to update and modify inventory data in the future to adapt to evolving business needs. Data Collection: Record detailed information about products, including product cost and the latest updated price. Allow continuous addition or modification of product-related data, such as prices, costs, and other specifications. Required Reports: Generate detailed reports on the current inventory status. Provide reports highlighting excess or shortage in stock based on stocktaking results. Analytical reports including information such as the total cost of the current inventory and overall stock value. Exportable reports (e.g., in Excel or PDF format) to facilitate perfor...

...careers, simulate interviews, and hire specialized services. The total project duration is 30 days, with weekly progress tracking and deliverables. 2. General Requirements 1. Code Quality and Maintainability: The code must be modular, clean, and well-documented. Each module or functionality should include explanatory comments to facilitate future modifications. Adhere to coding standards (e.g., Clean Code) and organize the code into reusable modules. 2. Control and Ownership: All credentials for servers, APIs, databases, and integrations must be created and shared exclusively with the client’s email. The complete source code, documentation, and configuration files must be handed over to the client at the end of the project. 3. Project Managem...

...Automatically register surplus or shortage in inventory after stocktaking. Provide the ability to update and modify inventory data in the future to adapt to evolving business needs. Data Collection: Record detailed information about products, including product cost and the latest updated price. Allow continuous addition or modification of product-related data, such as prices, costs, and other specifications. Required Reports: Generate detailed reports on the current inventory status. Provide reports highlighting excess or shortage in stock based on stocktaking results. Analytical reports including information such as the total cost of the current inventory and overall stock value. Exportable reports (e.g., in Excel or PDF format) to facilitate perfor...

I'm looking for a detail-oriented and resourceful individual to find high-quality products for our dropshipping store specializing in pet supplies (dog, cat, and small pets). The ideal candidate will search for trending, affordable, and reliable products on AliExpress, collect relevant product data, and organize it in an Excel spreadsheet for easy reference.

I'm in need of a dynamic excel sheet that will assist in managing the daily and weekly activities of our vehicles. This sheet should be able to track various aspects such as: - Maintenance schedules: Keep tabs on when each vehicle is due for maintenance. - Fuel usage: Monitor fuel consumption over time to identify any discrepancies or patterns. - Trip logs: Record details of each trip for future reference. The ideal freelancer for this project should be highly proficient in Excel and have experience in creating dynamic, interactive spreadsheets. They should also have an understanding of vehicle operations and be able to incorporate relevant features into the planner. Key features of this planner should include: - Automated scheduling: The sheet should be able to auto...

I'm experiencing a conflict between the Jupiter X Core plugin and the Elementor sidebar widget on my corporate site. This issue is preventing me from using Elementor to edit and update my website. I need a coding expert to fix the code that's causing the clash between these two plugins. Ideal Skills: - Proficient in PHP, JavaScript, and WordPress development. - Extensive experience with Elementor and Jupiter X Core. - Strong debugging and problem-solving skills. I require custom code modifications to resolve this issue. The goal is to make the necessary changes to the plugins so they can work together seamlessly. I prefer to be updated whether on the way to fix it and when the issue has been successfully resolved. Please let me know if you can assist with ...

...native, Windows, macOS, Linux, iOS and Android app? The new program should support the following features by default: 1. Multi-tenant application. (Meaning that the Application will be used by many different companies around the world with different currencies, localization settings etc. Each different customer (company) that will buy the software, will have its own database to save the company data (customers, inventory, jobs, settings and more.) 2. We will sell the software as a SaaS model where each customer (company that will buy the program) will be charged by the number of users using the program concurrently. So each customer (company that buys the software) will have from 1 to as many users they will decide to buy.) 3. Each user that will log-into the system will hav...

...with CS-Cart Multivendor, customizing themes, implementing responsive design changes, and ensuring seamless updates through the "My Changes" add-on for long-term maintainability. Responsibilities: 1. "Invest Now" Page Update: * Update the "Invest Now" menu link to point to dispatch= instead of dispatch=products.newest. * Design the new "Invest Now" page to include filters displayed on the right-hand side for better user experience. Please make sure any change you implement using the "My changes" add on and not directly within theme files so that when we update "vivashop" it doesnt affect the site. Requirements: * Proven experience with CS-Cart Multivendor development and customization. * Familiarity wi...