Vba excel change macro macropráce

Potřebovala bych sestavit v Excel nebo v jiném programu algoritmy na manuální zadání nebo načtení přes SD kartu 8mi výstupů z měření na váze Tanita (množství tuku, viscerální tuk, metabolický věk, množství vody, ...) tak, aby se tyto hodnoty převedly do grafické analýzy v podobě grafů, "koláčů" či obrázků zatížení tuku na těle (podobně jak výstup z GMON tanita nebo InBody softwaru). Účel je pro použití pro výstup pro klienty výživového poradce a pro ios systém (MacBook Air). Hledám cenově dostupnou varientu, klidně pro cenovou efektivitu jen v Excelu, ale zajímaly by mě mož...

pasar informacion a excel. pasar informacion a excel

Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.

Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.

...wp_learndash_pro_quiz_toplist wp_learndash_user_activity wp_learndash_user_activity_meta wp_usermeta wp_users wp_wc_customer_lookup wp_wc_order_stats wp_woocommerce_order_itemmeta wp_woocommerce_order_items We migrated the site using a plugin, I created a backup using WP All in One WP migration, and restored it on a clean WordPress installation, that's how I created the staging site. The migration was made to change the theme and keep all functionalities. The live site has a custom made theme built by old developers who built as well the custom plugin connected with LearnDash and WooCommerce. We installed Divi theme of the staging site and rebuilt the whole website, we changed some plugins but mainly the main plugins and the custom plugin are still there on the staging site...

Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.

Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.

datae

datae

Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl

mise en forme

Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket

Napraviti Excel VBA program

Change header, sticky header.

...vytvořená na míru našim potřebám, a úpravy jejích stávajících funkcí, - práci na vývoji nových funkcí (např. s cílem usnadnění administrativní práce v nadaci a tím dosažení významných finančních úspor). Hledaný programátor by měl mít: - perfektní znalost MS Access (tabulky, dotazy, formuláře, reporty), - znalost MySQL, - znalost základů relačních databází, - perfektní znalost programování ve VBA (Visual Basic for Application). Nabízíme: - Možnost komunikace s autorem databáze. - K dispozici bude dok...

Nastavení vytvořených Facebook účtu podle parametrů zadaných v excelu - změna jména, skrytí privatních informací (skrýt zeď pouze přátelé, skrýt kamarády pouze pro přátelů), pohlaví, pohlaví a nastavení nějakých like stránek z Czech Republic. atd. Já pošlu Excel po dohodnutí se na zakázce. První zadání je úprava 300 FB účtů.

I'm an advanced Excel user looking to deepen my expertise with an in-person tutor. I want to focus on: - Macros and VBA - Data Analysis and Pivot Tables - Complex Formulas and Functions Ideal candidates should have a profound knowledge of these topics, combined with excellent teaching skills. Experience in creating customized lesson plans and real-world examples will be a plus. The tutoring sessions should be 4-5 hours per week. The tutoring sessions will take place at my home. The preferred duration of the tutoring engagement is 1-3 months. Tutoring sessions should be scheduled on weekends. The tutor should provide a personal laptop during the sessions. I prefer individual tutoring sessions. Tutoring sessions should be scheduled on weekend afternoons. A focus on stat...

I'm looking for a seasoned data specialist to help me clean and standardize a c...consistency, and standardization based on predefined rules - Provide a cleaned derived outcome - Deliver a fully functional Python script or other dependencies used for data cleaning The data will be provided in Excel format. We have a detailed document outlining our specific rules for data cleaning. The primary focus during the data standardization process will be on maintaining consistency. Ideal Skills and Experience: - Proficiency in data cleaning and standardization - Strong background in handling data and textual data wrangling - Advanced Python programming skills - Experience with Excel - Ability to adhere to predefined rules and guidelines Please note, attention to detail is cru...

I'm seeking a skilled Android developer to create an app that sends push notifications to our customers. The app should include: - Google Sign-in with Mobile Number Validation: Create a option to change google signin or Mobile Number. Firebase will handle validation. - API for Notifications: Develop an API to send messages, including images, to selected users based on their mobile numbers. - Two Chat Windows: One window for a two-way chat box posting messages to our webhook, and another for sending important notifications. - Predefined Keywords Page: A page containing our product and service-related keywords from our database. - Settings Page: A settings page allowing users to select their ringtone or mute options for both chat windows. - Create a log page displaying a history...

I'm looking for a skilled Data Analyst with expertise in Google Data Studio to create dashboards from Google Sheets data. Key Requirements: - Analysis of performance metrics - Use of Excel/CSV files as data sources - Creation of interactive components in dashboards - Incorporation of custom date range filters - Integration of multiple data sources beyond Excel/CSV - Development of custom report templates - Dashboards/Data visualization Ideal Skills: - Proficiency in Google Data Studio - Strong data analysis capabilities - Experience with Excel/CSV files - Understanding of performance metrics

I am seeking an expert in Microsoft Excel to create a simple yet effective spreadsheet for tracking sales. The spreadsheet should allow me to monitor: - Sales by date - Salesperson (Client names) - Goal percentage in relation to team sales goals The ideal freelancer for this project should have extensive experience in Microsoft Excel, and be able to create a user-friendly, intuitive spreadsheet that meets my requirements. Please, be prepared to demonstrate your prior work in Excel.

...all devices by using responsive design techniques. This ensures a seamless user experience whether visitors are on desktops, tablets, or smartphones. 1.2 Pages Home , shop , Refund policy , Privacy policy Terms of service and other pages will be created according to the categories; there will be as many pages as there are categories and products. 2. Advanced website customization to add content & change design: 2.1 SEO Optimization: Ensure our website is optimized for search engines to increase visibility. This includes using the right keywords, meta tags, and alt text for images. Read SCO section. 3. Secure hosting & maintenance. 4. Live chat & messenger widgets. 5. SSL certificate 6. Add custom HTML code to our website & easily integrate with third-party tools a...

I need an expert in Excel to set up a comprehensive spreadsheet that tracks my retail product inventory, wholesale and shipping costs, sales prices and profits. Key Requirements: - Design an Excel spreadsheet to monitor: - Retail product inventory - Wholesale costs and shipping costs - Sales prices and profits - Implement a functionality to import order data from Faire, my wholesale provider, on a monthly basis. - Create automatic monthly sales and profit reports utilizing the imported order data from Faire. Ideal Skills: - Proficiency in Excel - Experience in designing inventory tracking systems - Familiarity with data import functionalities - Understanding of retail and wholesale cost tracking Please bid if you have the relevant experience.

Automated Pricing Model for CNC & Fabrication – Excel & ERP Integration Project Overview Impress Group is a precision engineering company supplying components globally. We specialize in laser cutting, bending, milling, turning, powder coating, welding, and fabrication and need a fully automated, accurate, and structured pricing model to improve efficiency and consistency in job costing. This project, called Project Alpha, aims to develop a dynamic, rules-based Excel pricing tool that: - Automates the quoting process using simple user inputs from technical drawings - Prevents incorrect quoting by restricting users from quoting parts beyond our manufacturing capabilities - Calculates accurate process pricing for all services - Generates time decimals f...

I need an excel sheet for my chemical inventory. The sheet should have the following columns: - Item/description - Item # - Quantity - Reorder status (some automated cell that when the quantity on hand matches the min quantity then it turns red?) - Vendor - Expiration date - Methods the chemicals are used for - order status and/or Comments The ideal candidate will have experience with chemical inventory management. Please include advanced search and filter options for better usability. I do have an example of an excel sheet we’ve been using that I can share, it’s not organized at all but it’ll give an idea of what information we’ve been tracking.

I'm looking for a professional with profound expertise in Excel and data handling to assist me with hashing and encrypting mixed data (text and numbers) within the software. Key responsibilities include: - Hashing and encrypting mixed data using AES (Advanced Encryption Standard) - Ensuring the primary purpose of data encryption revolves around maintaining data integrity Ideal skills and experience for the job: - Mastery in Excel with a strong background in data handling - Proven experience with AES encryption - Strong understanding and capability in ensuring data integrity through encryption Please provide your relevant experience and examples of similar projects you have completed in your proposal.

I'm looking for an experienced Power BI specialist to revamp my current dashboard. The primary purpose of this dashboard is to facilitate reporting and analysis. Key Requirements: - Proficient in Power BI - Experience with data visualization - Ability to create engaging charts, graphs, maps, and tables Current Data Sources: - Excel files - SQL databases - APIs Your Role: - Enhance the current dashboard for better reporting and analysis - Connect and visualize data from the specified sources Ideal Skills and Experience: - Expertise in Power BI - Strong background in data analysis and visualization - Ability to create user-friendly and informative dashboards

I'm in need of a proficient Excel spreadsheet for quoting mechanical engineering parts. The spreadsheet should include automated calculations to streamline the quoting process. Ideal skills for this project include: - Advanced Excel capabilities - Understanding of mechanical engineering parts - Experience in creating quotation spreadsheets. - Ability to create and troubleshoot complex Excel formulas. Please ensure that your bid reflects your expertise and previous work in this area.

Hi Oleh, Please change the color of the beige ottoman to brown like the attached reference.

I need assistance reviewing a 900-page PDF document to extract and summarize project milestones into a high-level summary. The milestones need to be organized in chronological order by specific dates found within the document. Your task will include: - Identifying key project milestones from the document. - Creating a high-level summary of these milestones in excel spreadsheet format referencing the page numbers of documents into a contents column once documents rearranged into chronological order - Organizing the scanned documents chronologically according to the dates of the milestones found in the documents Ideal skills for this project include: - Proficient reading and comprehension skills. - Ability to distil complex information into concise summaries. - Experience with project...

I have a C# HTTP listener application that queries a Milestone server to retrieve the status of CCTV cameras in XML format. I need help modifying and formatting the XML output. Key Requirements: - Change the structure of the current XML output - Add new elements to the XML output - Remove existing elements from the XML output - Reformatting date and time fields within the XML output Ideal skills for this project include: - Proficiency in C# programming - Experience working with HTTP listener applications - Familiarity with XML formatting and modifications - Ability to reformat date and time fields as specified

I need assistance with a dynamic programming problem from Kattis. The specific problem is the coin change problem. I'm using Python for this, so familiarity with this programming language is essential. Ideal Skills: - Strong understanding of dynamic programming concepts - Proficiency in Python - Experience with algorithmic problems, especially from Kattis - Ability to explain complex concepts in a simple way

Please check the pdf document and the STEP file. Don't change anything else than the slot. The first perfect entry wins.

I'm seeking a long-term Odoo developer, ideally a junior with 1-2 years of experience. The primary focus of this role will be on custom module development. Key Responsibilities: - Design and develop customized Odoo modules - Collaborate on various ongoing projects Ideal Skills: - Proficiency in Odoo - Experienc...experience. The primary focus of this role will be on custom module development. Key Responsibilities: - Design and develop customized Odoo modules - Collaborate on various ongoing projects Ideal Skills: - Proficiency in Odoo - Experience in custom module development - Problem-solving skills for bug fixing and maintenance - Understanding of system integration - experience on pos customization, excel reports , upgrading DB This is a long-term position with an hou...

I need a Windows computer fully configured and set up with the same software and settings as my existing one, at a different business location. Key Requirements: - Install and setup crucial software: Dropbox, Excel, Windows, Outlook - Replicate network configurations, user profiles, and preferences from the original computer Ideal Skills and Experience: - Proficiency in Windows computer setup - Experience with software installation and configuration - Knowledge of network setups and configurations - Understanding of user profile and preference replication

...to assist with migrating my rental properties from Excel spreadsheets to Xero. Key Responsibilities: - Build a comprehensive chart of accounts - Configure Property, Plant, and Equipment (PPE), depreciation, mortgages, rental income, prepaid income, etc. - Set up classes in Xero to manage income from different properties - Configure the system for two property owners - Migrate data for a total of five properties Challenges: The main challenge I face is ensuring Xero is configured correctly to handle my particular needs. Ongoing Support: After the initial migration is complete, I would require occasional support to troubleshoot and assist with any issues. Current Categorization: Currently, all my rental property transactions in Excel are categorized by property. I...

I'm looking for an Excel specialist who can automate generating reports with macros and integrate this process with Outlook. Skills Needed: - Advanced Excel proficiency, especially in macro automation. - Strong understanding of report generation. - Experience with Outlook integration. This is a crucial task for improving my productivity and streamlining my reporting process. Please provide examples of similar work you've done in the past.

I need a skilled WordPress developer with expertise in the Adifier theme. The primary focus will be enhancing the site's functionality...developer with expertise in the Adifier theme. The primary focus will be enhancing the site's functionality, particularly related to user profile features. The project involves transferring 29,000 members and 1,500 classified ads from our old PHP site to the new Adifier Wordpress site. Username, first name, last name, email address, phone number and city need to be transferred to new site from an excel spreadsheet. Ideal skills for this job include: - Expertise in WordPress and Adifier theme customization - Proficiency in PHP and MySQL for data transfer - Experience with user profile feature enhancement - Excellent problem-solving and tr...

I'm experiencing a host of issues after attempting to change my WordPress website's URL from a subdomain to the root. The problems span across the entire site, affecting blog posts, the portfolio, and more. Issues include: - Blog posts and portfolio not functioning properly post-migration - General site dysfunction I've already verified that both my WordPress and Polylang settings are correctly configured for the new URL. The ideal freelancer for this project should have extensive experience with WordPress, Elementor, and Polylang. They should also be proficient in troubleshooting issues related to URL migrations. The goal is to get the website fully operational at the root, with all sections and links working properly.

... Google Pay). Cash on Delivery (COD). Shipping options with cost calculation. Promo codes and discount coupons. Order Management Real-time order tracking. Notifications for order status (email/SMS/WhatsApp). Easy returns and exchange requests. User Dashboard Order history and invoice downloads. Wishlist management. Saved addresses for faster checkout. Account settings (profile update, password change). Admin Panel Add/Edit/Delete products and categories. Manage inventory levels. Track orders and process returns. Manage users and their roles. Access sales reports and analytics. Configure promo codes and discounts. Additional Features Multilingual support. Responsive design (optimized for mobile, tablet, and desktop). Currency converter for international buyers. Social media integr...

I'm seeking a skilled professional for data migration, specifically moving product data from Excel to SQL. Key Requirements: - Proficient in Excel and SQL - Experience in data migration - Familiarity with handling product data - Able to ensure accuracy and integrity during the migration process

I'm looking for an Excel expert who can assist me with data analysis tasks. Key Responsibilities: - Perform data sorting and filtering tasks - Conduct data analysis to derive insights Ideal Skills: - Proficiency in Excel - Experience in data analysis - Attention to detail for sorting and filtering tasks

I'm looking for a data analyst who can interpret my sales data and visualize it effectively. The primary objective of this project is to compare performance across different time periods, regions, or products. Ideal skills and experience: - Proficiency in data analysis a...data and visualize it effectively. The primary objective of this project is to compare performance across different time periods, regions, or products. Ideal skills and experience: - Proficiency in data analysis and interpretation - Experience with sales data - Skills in creating clear, insightful visualizations - Ability to compare performance metrics effectively - Advanced skills in Microsoft Excel for data manipulation and analysis. - Experience with statistical analysis to identify trends and patterns...

...skills for various projects. Translation: Professional translation services for documents and content. Medical Writing: Assistance with healthcare-related content and research. Data Entry: Accurate and efficient data management. Diet & Public Health Research: Creating reports and articles related to diet and health. PowerPoint Presentations: Creating professional and engaging presentations. Excel Work: Data analysis, charts, and spreadsheet management. Requirements: Strong attention to detail. Relevant experience in any of the above-mentioned fields. Ability to meet deadlines. Deliverables: High-quality, error-free work. Submission within the agreed timeline. Budget: Flexible, depending on the project scope and quality. These projects are long-term, requirin...

Please RE-DRAW the IF YOU DON’T LIKE MY ATTITUDE image. (See attached image) *** NO AI PLEASE *** you will be banned from contest. KEEP EVERYTHING EXACTLY THE SAME EXCEPT: Please change “1-800-EAT-SHIT” to “1-800-PARADISE” Please FULLY RE-DRAW the image (not just copy/paste) as we need a clean, crisp new image on a transparent background. Please make final image at least 14” wide and hi-res suitable for printing (300dpi). Put ALL items grouped on SEPARATE LAYERS (so we can move/re-size). PLEASE MAKE IMAGE SUITABLE FOR USE ON BOTH LIGHT AND DARK BACKGROUNDS. TRANSPARENT BACKGROUND PLEASE. Thank you :)

I'm in need of a detailed research into undergraduate Economics programs across 25 colleges from the USA and UK. The data should be meticulously organized into an Excel sheet. I will give the list of colleges that I need this information for. Key aspects to focus on: - Admission Criteria: What these colleges look for in terms of marks/grades, SAT scores or other standardized tests, and any college-specific tests. Additionally, include information about required essays and subjects to be taken in school. - Program Details: Course curriculum details of the Economics programs offered by these colleges. - Tuition Fees: Detailed information on the tuition fees for the Economics programs at each college. After the initial research on the USA and UK, I plan to expand this project ...

I am seeking a skilled VBA/Excel programmer to develop an inventory program within excel that will allow the following: 1) allow me to add products into a components inventory database using a form Fields are: Vendor, SKU, UPC, Status, QTY STOCK, EXP DATE, Category, Brand, Component Name, Component Description, Size, DIMS, Gross Wt, Case Count, Case Cost, Unit Cost, Component URL, Product Image 2) Bundle Design Tool - a graphical design form that allows me to add different components to build a bundled product. Fields are: Bundle Name, Bundle Desc, SKU, Theme Category, Inspired By, QTY STOCK, STOCK STATUS, Target MSRP, Target Cost Website URL, Shipping Weight, Dimensions Components List/Cost Analysis: in the form there will be a list that will show the added...

change pricing on the 4 flyers

I have a comprehensive architectural design ready, including floor plans and MEP. The floor plan is already converted into a light gauge steel structural frame in Revit. I need a skilled professional to assist with the following tasks: - Integrate plumbing, cladding, electrical, etc. into the LGS design using the arc...to the weight of the build Ideal candidates should have extensive experience with Revit, a strong background in modern interior design, and a solid understanding of Indonesian building regulations. Attention to detail is crucial, not only for the aesthetic elements, but also for the technical specifications and budgetary considerations. read this carefully and give me an accurate quote, do not change your price after we talk. agree on price and i can send you the ...

Job Description: Excel Advanced Formula Specialist Job Overview: We are seeking an Excel Advanced Formula Specialist to join our team. The ideal candidate will have expertise in advanced Excel formulas, functions, data analysis, automation, and reporting. This role involves developing complex formulas, optimizing spreadsheets, and ensuring efficient data handling for business decision-making. Key Responsibilities: Develop and implement advanced Excel formulas (e.g., INDEX-MATCH, VLOOKUP, XLOOKUP, SUMIFS, COUNTIFS, IFERROR, INDIRECT, OFFSET, ARRAYFORMULA). Create and manage pivot tables, charts, and dashboards for data visualization. Automate tasks using Excel VBA (Macros) and Power Query to improve workflow efficiency. Clean, structure, and analyz...