Excel vba user defined functionpráce

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.

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

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

Mám práci navazující na náš dřívější projekt 'Create User Registration/Login web with Map and Categories'

Napraviti Excel VBA program

...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ů.

Hello, Your Request I create a simple application that will communicate with the server. Function application is simple. - User logs (as opposed to server notified) - Key track position (at adjustable intervals Applications sent by gps coordinates to server. I make API that assumes the dates and stored in the database) - START background (applications are minimized, but still sends location information) - Shut down button (Applications will be turned off) The application therefore has access to the Internet and GPS. nothing more

I need a program that will notify you when the sound pops authenticate using captcha systems. One of the boot program, which must function at the server

As an Outlook 2019 user on Windows 11, I'm seeking a Configuration Expert to ensure a consistent user interface with the default Windows design. Key Points: - The main focus is on adjusting the UI to align with the Windows 11 interface - There are no major technical issues, just the need for a visual overhaul - No need to change security or performance settings Ideal Candidate: - Proficient with Outlook 2019 - Experienced in UI customization - Familiar with Windows 11 design language - Good communication skills to understand my preferences Your task is to ensure my Outlook 2019 looks and feels like a native Windows 11 application. I look forward to your bids.

I am seeking an experienced programmer to recode a C++ webview2 sample program to use win32 calls compatible with a Microfocus Visual COBOL environment. This tr...recode a C++ webview2 sample program to use win32 calls compatible with a Microfocus Visual COBOL environment. This transformation involves a focus on maintaining critical user interface functions presently coded within the C++ webview2 sample. Key aspects of the project: - Conversion to Microfocus Visual COBOL - Prioritization and preservation of User Interface functionality Ideal skills and experience: - Proficiency in C++ and Microfocus Visual COBOL - Experience with understanding, adapting, and recoding complex coding samples - Familiarity with using win32 calls - A strong background in UI integration and ...

...GoHighLevel (GHL) CRM for automated text and phone call follow-ups, as well as to an Excel sheet for manual review and further action. Key requirements: - Pixel Integration: Develop and implement a pixel solution that captures lead data. - Real-Time Collection: Ensure the system collects data instantly when a lead lands on the specified page. - GoHighLevel (GHL) Integration: Connect the system to GHL for automated text and phone call follow-ups. - Excel Integration: Enable the system to send collected lead data to an Excel sheet via email. Ideal skills and experience: - Proficiency in WordPress and pixel integration. - Experience with CRM systems, particularly GoHighLevel (GHL). - Knowledge of data handling and Excel automation. - Strong communication skill...

...creating a unique, visually appealing theme that reflects this aesthetic. Given that the main purpose of this website is to display information and a portfolio, the design should be clean, uncluttered, and user-friendly. Job Responsibilities: • Should have intermediate understanding and working knowledge of WordPress • Designing and building the website front-end • Knowledge of front-end technologies including CSS3, JavaScript, HTML5 and jQuery and REST/API integration • To understand and work with various page-layout and eCommerce plugins and to add images, icons, and vectors that function on desktop- and mobile-friendly web pages • Interest in conducting research and learning new things to overcome challenges • Conducting website per...

I'm seeking an experienced Flutter developer to assist in the creation of an Android application. Key Points: - The main purpose of the app is not yet defined. We are open to ideas and suggestions. - We don't have a specific design in mind, so I'll need the developer to lead the design process. - The primary platform for this app is Android. Requirements: - Proficiency in Flutter and Dart - Experience in designing mobile applications - Strong problem-solving skills and creativity - Ability to work independently and think critically

I need a freelancer to help me gather phone numbers from clothing stores in County . You'll be provided with the location and shops to focus on. Key Responsibilities: - Utilize street view to identify shops - Collecting phone numbers of all such shops - Organize and input these numbers into an Excel spreadsheet Ideal Skills: - Proficient in using street view and other location tools - Detail-oriented and capable of data entry - Comfortable using WhatsApp for communication This is a straightforward project, but attention to detail is crucial. Feel free to reach out if you have any questions.

We are seeking a skilled tech writer and content editor who can independently research and create content to support our business by writing Medium posts and creating marketing materials . Key Responsibilities 1. Edit and refine Medium posts to ensure they are engaging, informative, and SEO-friendly. 2. Review and improve marketing materials to align with our company's brand v...and editing. - Good understanding of on-premise and SaaS solutions. - Experience in editing blog posts and marketing materials. - Able to work closely with the marketing team and deliver high-quality, error-free text. Example Topics: - Can AI Really Boost Your Work Efficiency? - Tips for Cutting Office Management Costs - Feature Comparison Is Not All - Comparison of Product A and Product B (function...

I'm seeking a professional to design an educational PowerPoint presentation. The exact subject or intended audience is yet to be defined, hence versatility and adaptability are vital. Key Responsibilities: - Brainstorming creative educational contents - Creating engaging and educational PowerPoint slides Skills and Experience: - Prior experience in educational content creation - Exceptional PowerPoint and graphic design skills - Creativity and an understanding of learning strategies - Flexibility in subject matter coverage - Able to work with minimal guidance and broad parameters. Your proposal should illustrate your experience in educational content creation and showcase your ability to create an engaging, visually appealing PowerPoint presentation. Please share examples ...

i have a game that i want to rollout to production for 100% users. please help me

Develop a whistleblowing management platform for Spanish companies to efficiently handle reports of misconduct, ensuring compliance with current regulations. The platform should manage reports as tasks within the organisation, with defined states, assigned responsibilities, and status updates for the reporter. Additionally, it should include a Business Intelligence (BI) panel with detailed statistics on generated and managed reports. User Interface (UI) Report Form: An intuitive interface for reporters to submit their reports anonymously or with personal details. Reporter Portal: Access for reporters to track the status of their report using a unique code. Task Management for Reports Task States: Each report should go through various states (e.g., Received, Under R...

...management. - Expert knowledge of various safety threats and first-hand experience in planning for and mitigating these issues at events. - Excellent crisis and crowd control management skills. - Relevant qualifications in safety and emergency management NEBOSH ICG as minimum - excellent communication management - experience in generating reports - advanced Microsoft skills particularly in (words, excel and power point) Your role will be pivotal in ensuring our events are safe, enjoyable and error-free. The ideal candidate will anticipate issues before they arise and resolve them swiftly when they do. Your proficiency in maintaining safety at massive events will be the key to a long-term partnership. Location: KSA Period: 3 months (extendable) Commencing approx: Aug-Sep 2024...

...configurable conditions. It should facilitate easy data input from Excel and offer detailed comparisons, with the ability to export results to Excel. Offer Creator: The freelancer should create functionality for users to customize sales offers by selecting and modifying purchase conditions, adjusting margins, and generating offer views exportable to Excel. Order Recording: Develop a user-friendly interface for recording orders by selecting sales and purchase offer IDs, entering customer-requested details, and generating informative tables for efficient processing. Inquiry: Enable users to upload customer lists for comparison with purchase prices, configure margins, and calculate selling prices directly. The module should support export to Excel for ...

...left and right on the screen. Here are the key details and requirements: Key Features: - Animation of a simple dot moving left and right on the screen - Integration with Zoom API for seamless operation in Zoom - Capability to control the speed of the dot's movement - Feature enabling the dot to be superimposed over the video of the therapist or provide a background image. You can copy the basic function of this website. (click the link that says, 'use the basic version for free'. Design Preferences: - The moving dot should be a simple, unembellished design but option to change colour and size. Ideal Skills: - Proficiency in app development, particularly for Zoom - Prior experience with EMDR therapy or similar mental health applications will be a plus - Strong...

I am in need of an expert in B2B lead generation to help me with a specific project. The task involves targeting a local area for potential angel and private investors for an H.M.O in the health sector. Key Job Requirements: - Identify and co...potential angel and private investors for an H.M.O in the health sector. Key Job Requirements: - Identify and compile a list of 50-100 angel or private investors from the local area. - Investors must have a previous history of investing in the health sector. - Delivery of the leads in an Excel spreadsheet format. Ideal Candidate: - Proven experience in B2B lead generation. - Good knowledge of the health sector and investment trends. - Excellent research skills. - Proficient in data management and Excel. - Strong communication and ne...

I'm in need of a web-based multi SKU inventory software that primarily focuses on real-time inventory tracking. This software will be utilized by our warehouse staff to ensure products are correctly logged and easily retrievable. Key Features: - Real-time Inventory Tracking: The primary function of the system is to keep a close eye on the stock levels. - User-Friendly Interface: The software should be intuitive and easy to use for our warehouse staff. Integration: The system should have the capability to integrate with our accounting software. This is essential for keeping our financial records accurate and up-to-date. Ideal Skills and Experience: - Proven experience in developing inventory management software. - Familiarity with real-time inventory tracking. - Abilit...

I'm seeking an experienced ethical hacker with an acute focus on specific target areas. The ideal candidate should have proficiency in: - Network penetration testing - Web application security testing - Social engineering testing Although not clearly defined at this point, there will definitely be specific targets for the ethical hacking focus. Such targets will be further clarified upon commencement of project. Your versatility and adaptability would be essential for this role.

...are the key aspects of the project: - Compatibility: The mobile app should be compatible with both iOS and Android platforms. - Primary Function: The primary function of the app will be OCR (Optical Character Recognition). This means the app should be able to recognize and extract text from images. - Data Extraction: The OCR function should be specifically designed to extract text from images and past that text in new screen and make search in that text for list of words if it in that text make it highlighted with different screen for user to write list of the text must be translated to user selected there must be user profile and sign and payment with stripe .the OCR from api or OCR library. Ideal skills and experience for this job would i...

I need a seasoned developer to urgently build an e-commerce Wordpress site. Key attributes: - Proficiency in e-commerce website construction - Strong expertise in WordPress - Proven ability to deliver high quality work under tight deadlines Specifics: - The website's core function is to host an online shop. - It must include product listings and a functional shopping cart. - The completion is required as soon as possible. I look forward to receiving your bids. Skills in rapid development and an eye for design will be highly regarded.

I'm looking for an experienced Excel Power-BI professional to assist me with various tasks. Key requirements: - Proficiency in Excel Power-BI. - Demonstrated experience in data analysis, dashboard creation, and report generation. - Ability to work with minimal supervision. I will share more details in via chat box. Only interested person placed a bid Thanks

I need a skilled Flutter developer to create a transport app. The app's primary function is to track vehicle locations, primarily used by drivers. Key Requirements: - Develop a user-friendly and efficient app for drivers. - Implement real-time vehicle tracking capabilities. - Ensure the app can notify drivers about their current location. Ideal skills: - Proficiency in Flutter framework. - Strong experience with app development. - Capable of integrating real-time tracking features. - Knowledge of handling notifications in-app. Please note, the primary usage of this app is for tracking, notifications and the driver interface, with a focus on simplicity and ease of use.

I'm seeking a Django and Python Fullstack developer who can lend their expertise to my application project. The chosen freelancer should excel in creating: - Robust user authentication and authorization systems - Seamless database integration - Responsive design that adapt to various devices I have certain design ideas but I would highly appreciate guidance to help realize these concepts. The freelancer should possess a strong grasp of user-centric design and prove instrumental in translating these concepts into a streamlined, functional, and easy-to-use interface. Ideal skills: Python, Django, Database Management, User Interface Design, User Experience Design, and Responsive Web Design. It's a bonus if the candidate has a knack for making t...

I'm looking for a skilled web designer to revamp the current user interface of my website. The primary focus of this project is to improve the overall user experience. The key areas of the website that need to be redesigned include the layout and navigation. In terms of specific functionalities, I am looking to incorporate a sticky navigation bar for easy access. Key points: - Redesign the layout and navigation of the website - Implement a sticky navigation bar to improve user experience - Focus on enhancing the overall usability and accessibility of the site Ideal skills and experience for this job include: - Proven experience in UI/UX design, particularly for websites - Strong understanding of modern web design principles and best practices - Proficiency in re...

I'm in need of a skilled web designer to create a custom website layout for my project. Key requirements: - Custom Design: I do have a specific design in mind, and I'm looking for a designer who can bring it to life. - User-friendly: The website should be intuitive and easy to navigate. - Responsive: I want the site to look and function well on both desktop and mobile devices. - Clean and professional: The design should be clean, modern and professional. Ideal skills and experience for this project: - Proficiency in graphic design and web development - Strong portfolio of previous website design work - Ability to understand and implement client's design vision - Good communication skills to ensure the project meets the set standards and expectations. I...

I am in need of a competent product designer who can design an optic wash with the main function of cleaning eyeglasses. While key features were not specified for this project, it would be helpful if the designer has past experience or expertise in creating compact, energy-efficient, and multi-functional designs. Similarly, although I didn't specify what types of glasses the optic wash should cater to, a design that can cater to various types of eyeglasses such as prescription glasses, sunglasses, and reading glasses would be appreciated. Skills and Experience: - Product Design - Understanding of optical equipment would be a bonus - Proven track record in similar projects - Creative thinker and problem solver - Knowledge in manufacturing processes and materials

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

...conducting variance analysis. - Skilled in implementing break-even analysis. - Previous experience in creating comprehensive business financial forecasts. The end goal of this project is to have a detailed yearly overview of my business's financial health, with a focus on identifying trends and outliers, and ensuring our financial strategy is aligned with our business goals. Ideal Skills: - Advanced Excel proficiency. - Expertise in financial analysis and forecasting. - Strong analytical and problem-solving skills. - Excellent communication and reporting abilities ( need it finished by today )....

I'm in need of an expert in Excel for a project centered around statistical data analysis. Key Requirements: - I require someone able to handle statistical analysis in Excel. - The data is large and will require a high level of accuracy and attention to detail. - Since the data source is not specified, you should be flexible and able to adapt to varying data types. Ideal Skills and Experience: - Proficient in Excel, especially in handling large data sets. - Experience with statistical analysis in Excel. - Previous success in providing accurate data analysis. Please note the source of the data is not explicitly mentioned, so experience with different data types is a plus.

1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page 4 Send the new URL of the subpage change to the created group through the telegram machine

I'm seeking a skilled programmer with experience in Moodle and JavaScript to develop a simple yet crucial feature for our Moodle platform. The task involves writing JavaScript code to enable ...for Moodle. - Familiarity with API integrations, preferably ChatGPT or similar. - Strong communication skills to ensure seamless collaboration and understanding of the deliverables. - Attention to detail and ability to ensure data security within the Moodle platform. It's essential that the final product allows the audio files to be stored within Moodle after transcription. This feature should be user-friendly, efficient, and secure. If you're a programmer with these skills and experience, I'll be happy to discuss further details and work closely with you to bring this p...

I am seeking a skilled mobile app developer to create an Android app focused on stock management. Key Features: - The primary function of this app is inventory tracking. It should allow users to monitor stock levels, product movement, and manage inventory with ease. Work - Create Retailer Account Create Stock Payment received Return to Origin Add User Manage Permissions Manage Retailer Requirements: - Proficiency in Android app development - Prior experience with stock management applications - Familiarity with inventory tracking systems A successful project will require a developer who can create an intuitive user experience and implement a robust inventory tracking system.

I am seeking a skilled craftsman to create a visually stunning, mysterious and intriguing dress featuring autonomously moving metal snake scales. This project is uniquely engaging and will require someone with specialism in electrical engineering and a sense of creating something new. Key Project Requirements: - Scales must have the ability to move up and down in...it to be collaborative and educational. Ideal Skills: - Expertise in metallic crafting as attention-to-detail is crucial. - Mechanical skills necessary to build and incorporate mechanical components that trigger scale movement. - A keen eye for art installations with a focus on projecting mystery and intrigue through work. - Problem-solving ability to make this mechanical, moving art piece function smoothly and inde...

I need a freelancer who can seamlessly import several Excel sheets into my ERP system, ERPnext, without the need for data validation. The data includes items, journal vouchers, invoices, and stock entries. Key Requirements: - Importing 3+ Excel sheets for Items and Stock Entry, and likely more than 3 for JV and PDC. - Understanding of ERPnext data import structure. Skills Required: - Proven experience with ERPnext data import. - Advanced Excel skills for handling large datasets. - Attention to detail and accuracy in data handling.

...data to a database. Here are the specifics: - **Export Data:** The form's data should be exported in Excel format. - **Client Communication:** The data collected needs to be sent to the client as a PDF document. - **Form Fields:** The form should include fields for 'Contact Information', 'Service Request Details' and 'User Feedback'. This project also includes the task of taking a form I already have in PDF format, and converting it to a WPForms. Please note that this form is quite complex, so experience with custom fields and complex form layouts is desired. Ideal candidate should have: - Strong command of Wordpress, specifically WPForms - Experience with exporting to databases and Excel - Proficiency in generating PDF docume...

I'm seeking a talented professional to create a short, engaging video that will function as a logo reveal/website announcement for my wine online store, www.vinty.co.za. Key Points: - **Objective:** The primary goal of this animation is to encourage viewers to visit the website. It needs to be engaging, fun, and reflect the playful, tongue-in-cheek brand tone of Vinty. - **Style:** I'm specifically looking for a motion graphics animation. This style is preferred to reflect the brand's character and appeal to the target audience. Ideal Candidate: - Proficient in motion graphics - Experience in creating engaging and fun animations - Able to bring a brand's tone to life through visual storytelling Feel free to share any relevant portfolio pieces you have that ...

I need a data entry specialist to clean a dataset to be used for reporting and analys...the inconsistencies, errors, and duplicates in the dataset to make it suitable for reporting and analysis purposes - Ensuring the dataset is properly formatted and organized for its intended use Skills and Experience: - Proficient in data cleaning with a keen eye for detail - Experience with Excel and data entry is a huge plus - Strong understanding of data maintenance and organization - Ability to follow data cleaning guidelines and ensure data integrity The final dataset should be delivered in Excel format. The successful candidate for this job will have a deep understanding of data cleaning, excellent attention to detail, and the ability to deliver a clean dataset suitable for report...