Vba projects 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í.
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
...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...
I am in search of creative designers who excel at crafting whimsical, cartoon-style characters, specifically, rubber hose characters. While I have skipped specific details about design features and character attributes, I will be open to your individual style and interpretation. Key Requirements: - Proficiency in cartoon-style character design - Strong creative instincts - Ability to incorporate your individual flare while balancing the foundational aesthetics of rubber hose characters Please share your portfolio when bidding, especially any work related to cartoon style characters. This will help me assess if your style could be a great fit for this project.
I need a professional who can help me recover a password for an Excel XLSM file. Key Requirements: - Recover a lost password for an Excel XLSM file - Ensure the process is secure and compliant with standard security practices - Maintain the integrity and functionality of the document post-password removal Ideal Skills: - Proficient in password recovery methods for Microsoft Excel - Experience in data security and encryption - Strong knowledge of Excel XLSM file structure
I'm seeking a skilled professional to create a comprehensive loan statement on an Excel spreadsheet. Key Project Details: - I need all transactions included in the statement, ensuring the document is fully up-to-date. - The statement should not only present the transactions but should also include complex calculations such as interests, balances, etc. - As I'm looking for this as a one-time service, the statement should be designed to be updated annually. Ideal Skills: - Proficiency in Excel is a must; the ability to handle complex calculations is highly preferred. - Previous experience in creating and maintaining financial spreadsheets, particularly loan statements, is a significant advantage. - Attention to detail is crucial to ensure all transactions are accou...
I have a lot of data in a spreadheet. Have a look at attached spreadsheet. I need the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 10 in "auto made" sheet. This row 10 need to be deleted to make the spreadsheet work for my import
...as players progress through the endless waves, keeping gameplay engaging and unpredictable. - Design dynamic environments that evolve and present new obstacles or opportunities as players face more difficult waves of zombie pets. - Introduce periodic challenges and special events within the endless mode to shake up the gameplay and provide additional objectives or rewards for players who excel in their survival efforts. 5. Art and Sound Design: - Create visual cues and feedback that convey the increasing intensity and complexity of each successive wave of zombie enemies as players persevere. - Develop audio cues and immersive sound effects that enhance the tension and excitement of facing relentless zombie onslaughts in the endless mode. - Design striking visual e...
...scraping, data compiling, and spreadsheet management will be greatly valued for this project. Accuracy, timeliness, and consistent daily delivery are crucial aspects of this job. Understanding of automation tools for data scraping would be a big plus. I am looking to collate some data from this website and need an ongoing scrape of this website to set up an ever-updating excel spreadsheet with the fields as per the attached excel file. Go to the website Go to Horse Index A-Z Starting with letter A all the way through to the letter Z Most of the fields will be self-explanatory. Some have been separated. Eg 1st 2nd 3rd Starts
..., only certain locations or only scheduling). Teacher Management Teacher Data Upload: Module to add and update teacher information, including: First and last name Email Phone number Subjects taught (both theoretical and practical) Hourly and daily availability Locations where the teacher is available to teach Intuitive interface for quick data entry with the ability to import data from CSV or Excel files. Tabular view of teachers with search and filter functionalities. Hourly and Daily Availability: Interactive calendar to set daily and hourly availability of teachers. Drag-and-drop functionality for easy time adjustments. Ability to set recurring availability (e.g., every Monday from 9:00 to 11:00). Option to add notes or comments for each availability block. Selection of loca...
I'm looking for someone to curate text and image data for me and compile it into an Excel document on a monthly basis. The successful contractor will have experience with using the Internet to collect data and be able to present it in a structured and organized manner. This data needs to be sourced from reliable sources, checked for accuracy, and edited for quality. The contractor must be able to take initiative and use their own discretion in order to create the best results. Additionally, the contractor will be expected to act in a timely manner, ensuring that the data is updated and ready to use on a monthly basis. This project requires attention to detail and good communication skills.
We are looking to build a long-term partnership with a skilled and dedicated team of developers for ongoing projects involving WordPress and WooCommerce webshops. Our goal is to collaborate with professionals who can deliver high-quality work, adhere to deadlines, and contribute innovative solutions to our projects. Responsibilities: - Develop and maintain WordPress and WooCommerce websites - Customize themes and plugins to meet project requirements - Ensure the websites are responsive, user-friendly, and optimized for performance - Troubleshoot and resolve any technical issues that arise - Collaborate with our team to understand project goals and deliver results that exceed expectations - Stay updated with the latest industry trends and technologies to implement best practi...
...seeking an expert in Excel, OneDrive and email notifications who can develop an automated system for me. This system needs to: - Monitor a specific Excel file within my OneDrive for business for cell value changes. - When changes occur, the system should not send an individual notification for each. Instead, it should group updates together. - These grouped updates should then be sent as a single email to a preselected set of recipients at a specific time interval. - Crucially, the email should not only contain the updated cell values but also their previous values, enabling recipients to easily compare old and new data. Only experienced Excel and OneDrive professionals should apply, preferably with a background in automated data notifications. Familiarity with han...
...extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant columns and sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data MUST be pulled into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows: Order ID, Tracking ID, Product Name, Unit Price, Ship By Date, Deliver By Date, Purchase Date, Ship Date, Payment Method, Fulfillment Methods, ASIN, Quantities, Item Subtotals, Tax Total, Refund Total, Ship...
...time. • Blog section - All type of Users can read, like, share on multiple social media platforms, and add comments on posts (only logged in user), - Admin: content creators can login to write and publish blogs in their desired design and format. Blog contents could be videos hosted on YouTube and other platforms • University data and pages - Admin: o can update university data in bulk using excel or other supported file formats o can update individual university data from university page (separate login for data entry operators, data is published online once validated by a proper assigned user on the admin side) - Public users (no login required) o Can search universities based on key factors such as country, program name etc., - Registered student users (have an acc...
K zobrazení podrobností se zaregistrujte nebo přihlaste.
I'm looking for a talented Excel expert who can create a highly interactive and visually appealing budget analysis dynamic dashboard. - Highly Interactive Dashboard: Develop a dashboard that allows users to interact seamlessly with the data. This includes the ability to navigate between different views, select specific time periods, and drill down into detailed information. - Visual Appeal: Design visually appealing charts, graphs, and tables that effectively communicate key financial metrics. Utilize color schemes, fonts, and layout techniques to enhance readability and engagement. - Monthly and YTD Sheets: Incorporate tables of accounts for 12 months and year-to-date (YTD) sheets into the dashboard. Ensure that data from these sheets can be easily accessed and analyzed wit...
i need someone that can do three projects for me: Adding translations to my current code base of the music player using transloco describing it here: Acceptance Criteria: - Transloco works - all strings have been added to json translation files - spanish and english translations are added - Translations can dynamically change - A setting for changing the language is added - modulized approach Adding Dark Mode: Acceptance Criteria: - Can switch between dark and light mode - have the two main colors of angular material theme defined in a way to be reusable in all components ( changing it in one place will update it in all components) Adding Touch & Arrow Support
I am looking to significantly revamp my home's exterior in order to increase its curb appeal. The remodel should reflect a modern rustic style. The specific changes I intend to make include: - Window replacement: To maintain a un...Designed to integrate seamlessly with the existing structure while adding to its visual appearance. - Stone and siding: Both these elements should be curated carefully to bring the essence of the modern rustic style to life. Experienced freelancers who excel in exterior home remodeling with proficiency in modern rustic designs would be ideal for this project. Critical abilities include an eye for design, detail-oriented work, and the capability to execute window replacements and dormer additions smoothly. Previous experience working on similar p...
I'm in need of a writer to write projects around healthcare Key Requirements: - Good writing and research skills - Proficiency in research methodologies and data analysis - Strong academic writing skills I'm looking for someone who can deliver: - A comprehensive and coherent research - A well-cited and referenced final piece of work
I'm looking for a professional who can help me generate contact information (name, email, and phone) for leads suitable for my direct email marketing campaign. Key Responsibilities: - Develop a robust strategy to identify and collate data from various sources. - Ensure the data is accurate and up-to-date. - Organize and present the data in an Excel spreadsheet format. Ideal Skills: - Experience in sales lead generation. - Proficiency in using data collection tools. - Strong analytical and organization skills. - Knowledge of email marketing best practices. Experience in direct email marketing or a CRM system would be a bonus. The successful candidate will be meticulous and detailed-oriented, with the ability to deliver high-quality, targeted leads to support my marketing ef...
Dear translator, We are a company that develops live streaming and video chat apps. We are looking for native translators in various languages for a localization project regarding the FAQ sections of our apps. We will be sharing a Sheets file with the texts that contains HTML codes and placeholders, Therefore, this project requires a lot of close attention to detail and preferably, past experience working with HTML codes. The file has two tabs. The first one needs to be localized, while the second tab needs to be proofread. The tone of the translations should be friendly, inviting, and informal. The first tab is 1800-words-long, but a considerable amount of the answers has repetitions. The second tab is 932 words-long in English. Ideally, we will be asking you to install at least one ...
EXCEL VBA + EXCEL EXPERT. Please check video attachment and excel file and tell me if you can do this. Quality of proposal cover letter is always #1. Be #1. This will take 1 hour to code and complete if you know what you are doing.
I'm looking for a data analyst to scrape LinkedIn data and create a series of analytics from the information. Linkedin Recruiter or Premium Account will be needed for this task. Output should be presented in Google Sheets or EXCEL.
Hola de nuevo Martín, qué tal estás? Espero que todo bien. necesito pasar algunos datos, son cuentas anuales de una empresa, son cuatro años de datos de 2010 a 2014, cada año tiene seis páginas de datos y cada página tendrá como 10 datos, Te interesa? Un saludo. Sería insertar los datos de los archivos que te adjunto, solo los datos de activo, patrimonio neto y pasivo y cuenta de pérd...todo bien. necesito pasar algunos datos, son cuentas anuales de una empresa, son cuatro años de datos de 2010 a 2014, cada año tiene seis páginas de datos y cada página tendrá como 10 datos, Te interesa? Un saludo. Sería insertar los datos de los archivos que te adjunto, solo los datos de acti...
I require proficient excel skills to create two distinct spreadsheets. The first spreadsheet should focus on an immediate expense breakdown, specifically highlighting repair costs as an individual category. Knowledge in business accounting would be advantageous to ensure accurate representation of financial data. The second spreadsheet requires a CAPEX table, based on an example I will provide in PDF format. Freelancers will ideally have: * Expertise in Microsoft Excel * Background in accounting or financial planning * Detail-oriented and able to follow a provided example * Ability to create easy-to-understand, visually appealing spreadsheets Please assure that the work is precise and completed on time.
tugasnya hanya mengetik macam macam barang yg di beli di tamplate excel yang sudah saya sediakan beserta menghitung rumus sederhana perkalian dan pemjumlahan
I am in need of a proficient Google Sheets wizard who can utilize their expertise in managing and modifying spreadsheets for a specific task. I am interested in adding dynamic drop-downs to the cells in the ranges A1:A1000, B1:B1000, and C1:C1000 in Google Sheets. Key aspects for my project include: - Dynamic Population: These drop-downs must be dynamically populated and each row should maintain its independence from other rows. - Dropdown Values: The values for the initial dropdowns (A1:A1000) are derived from a specific list on Sheet2 of the Google document. - Manual Updates: The values on Sheet2 will be updated manually by the user. The perfect candidate should possess the following skills: - Advanced knowledge in Google Sheets: You must be able to easily navigate Google Sheets ...
Negocio gestionar excel - Importante: conocer ingresos + gastos para obtener el neto. segundo: conocer IVA de ingresos + IVA de gastos para saber cuánto pagar al trimestre y poder anticiparme. tercer: entender los ingresos si es por cantidad de clientes o por modificación de tarifa IVA DE ESPAÑA - COMUNIDAD DE MADRID PONER LOS EXCEL ENTENDIBLES Y BUENA GESTION PARA ENSEÑAR A INVERSORES
...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation of repetitive tasks within A...
I need someone to consolidate data from multiple Excel sheets. The data in these sheets consists of both text and numeric values. The goal is to bring all this data together into a single sheet, while handling duplicates in a distinct manner. Key elements of the project include: - Merging text and numeric data from several Excel sheets into one - Handling duplicate entries by marking them without removing - Organizing the data by grouping it as per the provided sheets separately Ideal candidates should have: - Proficiency in Excel and experience working with data consolidation - Understanding of handling and marking duplicate entries if any - Ability to accurately organize and group data Your task will be to create a consolidated view of text and numeric data from t...
Hi Work-Nix Solutions, I would like to work with you again please on refining the great Excel-spreadsheet that you have helped me to build.
I'm in need of an Excel developer who can aid me in analyzing data, creating advanced formulas and functions, and programming macros. With your expertise, the primary goal is to develop an Excel file that will be used to generate various reports. Ideal Skills and Experiences: - Proficient in Excel data analysis and manipulation - Experienced in creating advanced formulas and functions - Able to implement macro programming - Adept in generating insightful reports from complex data Our goal is to provide you with an exportable dashboard in Excel, a tool that will efficiently display opportunity details per property and provide a dedicated area for your notes. Opportunities that meet the threshold should display the value. The dashboard should be sortable a...
K zobrazení podrobností se zaregistrujte nebo přihlaste.
I am in need of a Senior Financial Analyst to assist with our company's financial modeling, forecasting, and data analysis and reporting. The ideal candidate must be familiar with various financial concepts, data analysis, and proficient in the use of Microsoft Excel, Tableau, and QuickBooks. Key Responsibilities: - Develop and maintain financial models for our operations and future forecasts - Analyze and interpret financial data - Prepare regular reports on financial performance - Utilize Microsoft Excel, Tableau, and QuickBooks for data management and analysis. The candidate must have significant experience in financial modeling and data analysis, preferably in a senior role. The ability to communicate complex financial information in a clear, concise manner is hig...
I'm in search of an individual who is both tech-savvy and creative, capable of designing and editing an Excel-based yearly budget tracker for my department. This document must not only be functional, but visually appealing, making use of our company's branding and in a way that ensures user-friendliness. Key Requirements: - Creating a Comprehensive Tracker: I need a budget tracker that can calculate data and maintain it in a clear and organized manner, reflecting both incoming and outgoing finances. - Visual Appeal: This tracker should not be a typical, boring spreadsheet. It should feature vibrant colors and bold fonts, while still maintaining a clean and simplistic design. Additionally, it should incorporate our company's logo and color scheme to ensure it's o...
...Detection In terms of output, I require the processed videos to generate a Metadata file, which ideally is formatted into an Excel or CSV file. This data should include details such as date, time, classification, and direction. While I do have an Azure account for hosting and I am comfortable with it, I am also open to suggestions on which programming language would be the best fit for this project. The ideal freelancer for this task should possess the following skills and experience: - Proficiency in Python, C++, or Java - Familiarity with Microsoft Azure or similar - Experience in image classification and object detection - Ability to create Metadata files in Excel or CSV format. Remember that while these are the core requirements, I am open to suggestions and m...
I'm in need of a tool that can effortlessly upload text information from an Excel document to a website form on a daily basis. The tool should also facilitate the mapping of Excel columns to the corresponding fields in the website form through a user-friendly interface. Key requirements include: - Daily automated upload of data from Excel to the website form - A straightforward, user-friendly interface for mapping Excel columns to website form fields - Accurate and efficient transfer of text information - A secure and reliable tool that ensures data integrity Ideal candidates for this project should have: - A strong background in web development with experience in form automation - Proficiency in Excel, including working with data extraction and ma...
...inputting it into an Excel spreadsheet. The key aspects of the project are: - **Data Extraction:** This involves comprehensively retrieving data from various websites. Some sites may have more complex structures, requiring the freelancer to navigate and extract data accurately. - **Excel Formatting:** The extracted data needs to be entered neatly into an Excel spreadsheet. - **Advanced Level Detail:** The data extracted should be detailed and comprehensive, including historical data and analytics where relevant. The ideal freelancer should have experience in web scraping and data entry, as well as a good understanding of Excel. They should be meticulous, capable of handling potentially complex website structures, and able to work with a high level of det...
