Vba code for adding data to excelprá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í.
Mám 2 programy (kódy pro mikroprocesor STELLARIS) a potřeboval bych jejich jednoduchou úpravu, podle zadání. Více info pošlu do zprávy.
Mám 3 programy (kódy pro mikroprocesor STELLARIS) a potřeboval bych jejich jednoduchou úpravu, podle zadání. Více info pošlu do zprávy.
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
I want few methods from objective c to java to be translated.
...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 dokumentace, kte...
I'm seeking help with creating line charts in Excel. My dataset is small but involving multiple data series. Requirements: - Generate line charts from provided multi-series data - Ensure the charts are clear and visually engaging - Basic understanding of trendlines and data labels would be a plus, though not mandatory Ideal Skills: - Proficiency in Excel, with a focus on charting - Prior experience working with complex, multi-series datasets - Strong attention to detail and an eye for creating visually appealing charts
K zobrazení podrobností se zaregistrujte nebo přihlaste.
I'm looking for a Shopify developer who can help me customize the layout of my cart page and ensure that it is optimized for mobile use. Key Requirements: - Custom Layout: The cart page needs to be designed to match the aesthetics of my store, providing a seamless user experience. - Mobile Optimization: You'll need to ensure that the cart page is responsive and user-friendly on mobile devices, as this is a priority for my business. Additional Features: - Gift Wrapping Option: I'm interested in adding a gift wrapping feature so that customers can choose to have their items wrapped before shipping. - Special Message and Custom Name Card: It's important to me that my customers can include a special message ...
...project is to build a robot that strikes the right balance between speed and strength, specifically for a high school robotics competition. Key Responsibilities: - Building a competitive robot that can excel in a high school robotics competition - Optimizing the robot for a balance between speed and strength Ideal Skills: - Proficiency in working with Vex V5 parts - Previous experience in high school robotics competitions - Strong understanding of robot design principles Communication for this project is crucial, and I would prefer to have in-person meetings to discuss progress and updates. Please consider that you must be able to meet in person in Connecticut west haven USA. If you're a skilled robotics engineer with a...
I am looking for a detail-oriented professional to assist me with translating my bank transactions from PDF format into a spreadsheet. My accountant needs this data to be organized and easily accessible. Tasks for the freelancer include: • Extracting transaction information from my downloaded PDF bank statements • Compiling this data into an Excel spreadsheet • The project will need to include the date, transaction description, transaction amount, resulting account balance, and transaction category The ideal candidate needs: • Strong attention to detail • Proven experience working with both PDF and Excel files • Fluent in English for effective communication Expectations: &bull...
I need an expert to create a comprehensive Excel report and sheet using the 7QC Tool. The main purpose of this project is to analyse process data, identify quality problems, and improve process efficiency. Key Project Details: - The Excel report and sheet should incorporate data analysis, financial calculations, and performance metrics. - The type of data to be stored in the Excel sheet will be sales data, employee information, and inventory records. The ideal freelancer for this job will have a solid understanding of the 7QC tool, advanced Excel skills and knowledge in data analysis. Experience with managing sales data, employee information, and inventory records within Excel is hi...
Name to incorporate in the logo - Dusty Slate Consulting Slogan to incorporate in the logo - Let us help you clear your slate. Description of the organization and its target audience: Dusty Slate Consulting is a consulting firm that specializes in, Prototype Development, Secure software concepts. Business process optimizations, Security Analysis, penetration testing, and custom application development. We also specialize in systems integration and robotic process automation. If you have an idea that you cannot get made, we can make it happen. My target audience are companies that have ideas but lack the inventive resources to make the ideas happen, as well as small time inventors that need a leg up in getting a prototype built, or help getting it manufactured. I...
I'm looking for a freelancer who can effectively enhance the Wikipedia page of a prominent scientist by adding relevant photos. Ideally, you will: - Have extensive experience editing Wikipedia pages and adhere strictly to its guidelines - Be able to source high-quality, appropriate images depicting key life events of this scientist - Possess good judgement in determining which photos would enrich the biography and engage readers - Ability to ensure all photos adhere to copyright laws and Wikipedia photo guidelines is essential. A keen interest or background in science history could be beneficial but is not required. Proven experience in enhancing Wikipedia pages will be highly valued.
Looking for someone to engineer a shared to-do spreadsheet in Microsoft Excel that supports real-time collaborative editing for our team. The successful candidate should have: * Advanced Excel skills; * Experience creating custom spreadsheets for project management; * Understanding of user permissions in Excel with the aim to allow full control access to every team member; With your help, we'll revolutionize how we tackle tasks as a team. The ideal freelancer for this project should be prepared to propose and implement a solution promptly. Familiarity with Microsoft Teams is a plus.
I'm looking for a full stack developer to make several key improvements and integrations to my existing spreadsheet editor. - **Adding New Formulas:** The first key task is to introduce new formulas to the existing spreadsheet editor. I need a professional who is well-versed in developing and integrating custom formulas to spreadsheets. - **Improving User Interface:** The editor's current interface needs a major upgrade. Your role will include enhancing the visual design to make it more modern and user-friendly. We also need to simplify the navigation within the editor, ensuring it's intuitive for our users. Drag-and-drop functionality is another key aspect that needs to be integrated. - **Integr...
I need a skilled Arabic typist to enter data from PDF, into a single excel table .
I'm seeking a reliable freelancer to import vendor pricing data into Sage. The data is currently stored in a CSV formatted Excel spreadsheet, with data cleaning required prior to import. The project will entail: - Cleaning the vendor pricing data as required - Successfully importing clean data into Sage Ideal Skills: - Proficient in Excel and its functionalities, especially CSV format - Experience in data cleaning - Demonstrated proficiency in Sage, particularly in data import functions - Attention to detail is crucial for this task This task requires a freelancer with the right blend of skills in Microsoft Excel and Sage software to ensure smooth, error-free integration of v...
I'm seeking a skilled Excel developer to help me create a tracking system. Key Requirements: - The system should monitor the month over month membership growth for our community PCPs. - The PCP targets should be identified by name and location. Please note that this needs to be completed as soon as possible. Ideal skills for this project: - Strong proficiency in Excel and data tracking - Experience with creating dynamic systems in Excel - Attention to detail to ensure accurate tracking This will be a key tool for our organization moving forward, so I'm looking for a freelancer who can deliver high-quality work efficiently.
VM CREATION (1 VPS BIND) os CentOS 8 & 9 Stream MINIMAL Direct installation or converted from Cen...(Recommended) panel add install: nginx server VARNICH APACH very important !!!!!snaphopt image creation just servers working (just os) (without admin panel)!!!I want to be able to do restores, for a new installation of another panel, if necessary.! !!! !! !!!!!! link to server add SSL ADD ALL PHP CGI AND FMP (latest 6 versions)PHP AVAILABLE FOR CUSTOMER FOR ALL SERVER ADD PHP VERSION 7.9 PACHT FMMPEG add latest version change SSH22 port verification example: ns1 . add IP.: add a Mac machine adds IP.: adds mac Example of adding HOSTENAME:
I'm seeking a seasoned web developer with an expertise in improving website navigation and site mapping to make my website more user-friendly and streamlined. Specifically, your tasks will include: -Minifying JavaScript and CSS -Compressing JavaScript and CSS -Optomizing SEO Ideally, you should have: - A proven track record in designing and implementing intuitive website navigation - A keen understanding of SEO optimization and its influence on site mapping - Experience in making websites more accessible and user-friendly, particularly in terms of navigation.
I'm searching for a skilled graphic designer to create a clean, text-only logo for my brand. Here's what I envisage: - Colors: The logo should incorporate royal blue or gold, adding a touch of elegance and sophistication. - Logo Style: Minimalism is key - I'm looking for something refined and text-based only. Let's abstain from overcomplicated designs. - Font: Please use a script font style for the text to enhance the elegance of the logo. Ideal skills and experience for this job would include profound knowledge of color theory, mastery of contemporary design trends, and access to up-to-date design software tools. Most importantly, I want a designer who understands the essence of minimalistic and el...
I'm looking for a freelancer to create a line graph in Excel. This graph will be utilized for report analysis, showcasing the trend for a single data set. Key Responsibilities: - Develop a line graph in Excel - Present the data trend effectively - Ensure the graph is tailored for report analysis Ideal Skills and Experience: - Proficiency in Excel, particularly in creating graphs - Prior experience in crafting visuals for reports - Ability to convey data clearly and effectively This project specifically does not entail comparing different data sets, as it solely focuses on illustrating the trend of a single set. The ideal candidate will deliver a polished graph that can be seamlessly in...
Need an Excel expert to create a complex forumula to get desired results from big set of data. Budget is placeholder/estimate. final amount will be discussed during work.
Overview: We are looking for an experienced Java developer to refactor an existing code base to incorporate several design patterns and improve overall code quality. This project involves enhancing the structure and maintainability of the code by integrating various design patterns, such as Dependency Injection (DI) using Google Guice, Listener, Builder, Singleton, and, optionally, Factory design patterns. The ideal candidate should understand these patterns strongly and have experience refactoring legacy code. Key Responsibilities: 1. Refactor Service Classes with DI Pattern: - Utilize Google Guice API to implement Dependency Injection across all service classes. - Ensure that all dependencies are injected and managed by the G...
...involves adding new features to an existing app. The main requirements are as follows: Wallet Customization: The app needs to include a wallet functionality that allows users to trade the coins they earn within the app. Snapchat Integration: Integration with Snapchat should be implemented, enabling users to link their Snapchat accounts and share their achievements or rewards with friends. AI-driven Soccer Game Prediction: The app is linked to an AI system that predicts soccer game outcomes. Users who achieve high accuracy in predictions are eligible for a drawing, with prizes awarded to 10 winners. Adherence to Google Play Store policies is crucial. Targeted Marketing: In the future, the app will be used for targeted...
...professional to develop a Solidworks macro for specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. ...
...following elements: - **Color and Font Customization**: I'm looking to refresh the look and feel of the page through a new and engaging color scheme and font selection. - **Layout and Structure Adjustment**: I'm interested in rearranging the current sections of the page to make it more user-friendly and visually appealing. This might involve adding or removing content blocks, and potentially changing the navigation menu to improve site navigation. MUST HAVE Vertical sliders of 4 pages, page enabled e.g. when I scroll up or down the next/previous slide should be open. Show paging indicator as well. Each slider will have a different background color and also use some relevant gifs in the background for animation. Ideal skills for t...
We are working in adding an addition to the house, rear porch converted to kitchen and dinning area. Need inspected and certificate of clearance to turn in to the city.
I have multiple Excel spreadsheets containing contact information, and I need them consolidated based on a unique index number. The task involves the following: - Data consolidation: Retrieve name and email information from several Excel sheets using a base index number from a primary data file. - Automation: I need this consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - ...
We are currently looking to add several Virtual Assistants (VA) to our team who can assist us with various tasks, including social media posts, research, data entry, and more. We are seeking individuals with a strong background in data entry, Google Drive/Sheets, and similar responsibilities, as outlined in our LinkedIn job posting. While the tasks themselves are relatively straightforward, it is important to note that this will be ongoing, daily work for the foreseeable future. If you have a proven track record of delivering high-quality work, and maintaining consistent performance, we encourage you to apply. Key qualifications and requirements for the role: - Proficient in data entry and experienced with Google Drive/Sheet...
As discussed I have delivered the excel workbook. Thanks!
I'm looking for someone to help me recover the password for an Excel Workbook. It was prepared by an employee who has since left the firm. Note that I am not seeking to have someone recreate this Workbook without the password, but to have the password itself. There are several videos on YouTube about this, but I've had no luck: I've attached the spreadsheet if you want to try. The first person to provide the password will get paid. Just let me know if have it, I'll hire you, and you supply it. PLEASE DO NOT ACCEPT THE PROJECT UNLESS YOU HAVE THE PASSWORD FROM THE ATTACHED SHEET. Key Project Requirements: - Password Recovery: The primary task is to recover the password for an Excel Workbook. ...
...passion for romance novels to help me craft a compelling contemporary romance story of 50k words. You must be able to write at least 12k-20k words per week. - Setting: While I didn't specify, I'm open to discussing the best setting for the story, so your creativity is welcome here. - Conflict: The main conflict will revolve around past traumas, adding depth and complexity to the relationship between the main characters. - Point of view: I'd like the storytelling to be from the first person perspective, to help readers connect more deeply with the protagonist. The ideal candidate should have experience in writing romance novels, particularly with a focus on character development and conflict resolution. A kna...
I'm in need of a professional who can build a tool that can extract data from LinkedIn. The data I'm interested in includes: - Contact information (email address, phone number, etc.) - Profile information (name, job title, etc.) - Connection network (connections, mutual connections, etc.) I'd like the extracted data to be conveniently structured in a CSV (Excel spreadsheet) format. The primary use of the extracted LinkedIn data will be for lead generation. The ideal candidate for this project should have: - Expertise in web scraping and data mining, particularly with LinkedIn - Proficiency in data handling and structural organization - Proven experience with developing tools for lead generatio...
...skilled developer to refine the design and bring it to life. The primary goal is to completely revamp the current web services to a premium level and significantly increase sales. Website & App Development For An Ecommerce Website On Shopify Platform- Multi-Language Features: Technical Details: Implementing multi-language support involves setting up language-specific content, translating product descriptions, and configuring Shopify's language settings. This requires knowledge of HTML, CSS, and JavaScript for custom coding. Adjustable Delivery Price Options For Different Customer Groups: Technical Details: This feature requires integrating Shopify's API and possibly third-party logistics services to automate and c...
I'm looking for a versatile Excel professional. Key Requirements: - Restrict Sheet Access and Hide for specific users - Changes made in the master sheet should be automatically displayed on specific sheet. - When a change is made on the master sheet, the cell should automatically be highlighted in red color. and also reflected in the specific sheet. I am looking for a good english professional . Automatic bidders will be blocked . If you are here type in salut at your beggining of the bid.
...range of issues, from formatting problems to typographical errors. Additionally, there are some images missing or incorrectly placed, so I'd like to correct this as well. Key deliverables and requirements: - Correcting formatting issues to ensure document consistency and readability. - Rectifying typographical errors and spelling mistakes to enhance document quality. - Inserting and/or relocating missing or displaced images within the document. - Adding new content to the document as per my guidance. This task requires excellent attention to detail, as it's essential that the corrected document is error-free and visually appealing. A strong command of the English language is necessary to fix any written errors. Graphic...
I am looking for a professional who can create a mobile application (both on Android and Apple) to manage my current Web Application that was built using Dadabik (). The app will need to be able to utilize the existing APIs from Dadabik to handle various functionalities. It should have a simple and functional design with a login feature, real-time data visualization and the ability to add, modify and delete data. Key Features: - Implement a secure and seamless login system for my Web Application users. - Create a user-friendly interface for real-time data visualization. - Ensure the app can handle adding, modifying, and deleting data effectively. Data Management: - The app should be designed...
I am seeking a skilled professional to assist me in integrating a Visanet QR code and payment link into my US dollars foreign account system. The primary purpose of this is to accept payments online in US dollars from business clients in US dollars in my foreign business account in Australia The project would include: - Setting up a Visanet QR code and payment link for US dollar transactions - Ensuring the system is seamless and secure for online payments - Ensuring the system is user-friendly and accessible for my business clients The ideal candidate will have: - Proven experience in Visanet QR code and payment link integration - Proficiency in online payment systems - A strong understanding of the requirements for...
Tengo un software de facturación al que se le pueden importar facturas en lote subiendo un Excel con un formato concreto de filas y columnas para que sea capaz de reconocerlo y generar las facturas de forma correcta. Necesito poder hacer esto de forma automática, es decir, teniendo un archivo de origen xls en un formato, poder extraer los datos para montar otro archivo xls con el formato que necesita el software de facturación para leerlo correctamente.
