On error goto vba 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.
Hi, I am looking for somebody to fix the way combinations load on load on my prestashop website. When somebody changes a combination it jumps and error message appears. The price doesn't recalculate until you go to the basket. You can see what happens in one of the products here: Experiance in prestashop required.
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í.
Vytváříme personalizované dřevěné předměty a potřebujeme zvýšit povědomí o značce, o produktech, zvýšit followers.
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...
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 have a real estate development company, and I'm looking for a dedicated Excel expert to help me streamline my expense tracking process. Key Requirements: - I already have a template set up and in one of the tabs I have a CSV statement import. Your primary task will be to create a formula that can automatically pull data from a statement import into the relevant property tab. - The data should be ordered by date to ensure clarity and easy reference. - I have created a macro to change the debit figures to negative amounts in the spreadsheet. - I am open to changes/ideas on if it requires a different setup. Ideal Skills and Experience: - Advanced Excel skills are a must. You need to be comfortable working with complex formulas to manipulate data. - Experience...
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 in search of a robotics expert with advanced experience in working with Vex V5 parts. The goal of this 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 ha...
...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: • Maintain rigorous data accuracy • Finished product will closely replicate the information found in the original bank statements using...
I need help with a .dwg file saved via AutoCAD 2020. I'm having trouble opening it using my AutoCAD 2030 due to an error message stating "the file was saved by an application not developed or licensed by Autodesk". I require an expert skilled in resolving such compatibility issues or someone who can provide a viable workaround. Ideal candidate should have: - Proficiency in AutoCAD, specifically versions 2020 - Excellent problem-solving skills - Experience with file compatibility issues between different AutoCAD versions
I'm seeking a skilled REDM game developer, who takes a particular interest in creating a Roleplay server on the REDM network. Expertise in developing game mechanics are key for this project. The primary task involves: - Developing a Roleplay server game. - Incorporating customizable characters, multiplayer functionality, and an in-game economy system. A successful freelancer will have a good understanding of how to create immersive and engaging Roleplay environments, and experience in implementing character customization options, multiplayer functions and economy system into such a game. Candidate should possess expertise in REDM server game development and game design principles. A proven track record in similar projects will be advantageous.
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 highly beneficial.
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 need a skilled Arabic typist to enter data from PDF, into a single excel table .
K zobrazení podrobností se zaregistrujte nebo přihlaste.
I am in need of a professional academic translator with expertise in th...Sciences is preferred to ensure accurate and contextually appropriate translations. - English to Turkish Translation: The project involves translating academic documents written in English into Turkish. Proficiency in both languages is essential to maintain the integrity of the content. - Attention to Detail: The translator should be meticulous in their work, ensuring that the translated documents are error-free and convey the original meaning accurately. Ideal Skills: - Proven experience in academic translation, particularly in the field of Social Sciences. - Academic background. - Native Turkish Speaker. - Fluency in both Turkish and English. - Strong attention to detail and commitment to producing high-qua...
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 vendor pricing data.
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.
1and1 did it to me again. A maintanance migration on their end lead to my websites (About 5 Wordpress and 2 php script sites) going down. I get some database errors and then on a few, I get dns errors. I feel like it might me the cache and cdn's just catching up with it. Key Issues: Seeing these errors on diff sites Error Message: "Error establishing a database connection" Error Message: "DNS_PROBE_FINISHED_NXDOMAIN" Plesk Access Issues: Inability to log in to the Plesk control panel Observations: Timing of Errors: The server was operational until 12:08 PM- (that was my last email received) server migration completed at 7:39 AM. - so thats a few hours after migration the server was working fine. Current Server State: T...
I am in need of a skilled technician who knows all about the GoPro 12 setup and usage. Even though I'm not experiencing any specific issues or error messages during the setup, I still need help using it to its full potential. The ideal candidate is: - Well-versed in working with GoPro 12s - Capable of providing training for use and function - Able to offer general tech support I hope to gain a sound understanding and knowledge of this device, including all its features, after our session(s).
I'm looking to develop an interactive and user-friendly website for my on-demand car workshop. This platform will primarily offer car repair, car maintenance, and tire replacement services. Key Features: - **Online Booking System:** The website needs to have a seamless online booking system. Customers should be able to easily select the service they need, choose a suitable time, and make a reservation. - **Service Pricing Information:** Transparent pricing is essential. I want all service costs clearly listed on the website so that customers know what to expect without any hidden fees. Design Preferences: - **Clean and Modern:** The design should be minimalistic, appealing, and easy to navigate. Prioritizing a clean and modern look is crucial. The ideal candidate fo...
I'm in need of someone who undrestands Windows Certificate Authorities. I am trying to setup Windows Hello For Business but am getting a KDC error: The client has failed to validate the domain controller certificate for SERVER.DOMAIN.local. The following error was returned from the certificate validation process: The revocation function was unable to check revocation because the revocation server was offline. Key Requirements: - [Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions] - This environment requires me to control the input. This means I can only give you view only of the server.
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 integrated into a report.
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.
I'm in need of a skilled developer to create a web-based accounting app mimicking functionalities of excel for my business. Key Features: - Accounting functionality: This app must allow me to insert product details and their price, record the amount they were sold for, and at each day's end, it must generate a profit and loss table. - Inventory tracking: The application should effectively manage my inventory, keeping a track of products, their quantities, and changes over time. - Customer Database: The app should store customer information in an organized and easily accessible manner. - Invoice Generation: It should also have the capability to generate invoices for customers. Design Aesthetics: The preferred design is minimalistic. It must be clean, clear and user-frien...
AutoSSL installation and configuration for CentOS Web Panel for a lifetime.
...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. I have an Excel sheet to automate PN and description creation ...
I'm experiencing some frustrating problems with my Outlook email. Specifically, I am unable to send emails, which is disrupting my personal and professional communications. Shockingly, this issue is not resulting in any error messages, which leaves me baffled as to the root of the problem. The ideal freelancer for this job has: - Expertise in troubleshooting Outlook issues - Understanding of common reasons for Outlook sending failures - Skills to implement effective solutions without error messages as guides - Keen to provide insights on preventing similar issues in the future I'm seeking an effective, swift resolution so I can return to efficient email communications.
I'm looking for an experienced and knowledgeable SQL Server professional who can help me resolve a connection issue I'm experiencing. - **Connection Method**: I'm currently using Windows Authentication to connect to the SQL Server. - **SQL Server Version**: I'm using SQL Server Management Studio 20. - **Error Message**: When trying to connect, I receive an error message indicating that the connection has failed. Ideal candidates for this project should have: - Extensive experience with SQL Server, particularly with the version I'm using. - Proficiency in troubleshooting connection issues. - Strong communication skills to guide me through the resolution process.
...reliable tools such as , , , or similar. • Provide a backup email address for each contact (for the same person or an alternative contact). • Ensure a high level of accuracy; a maximum of 10% error rate is allowed. Beyond this, a proportional reduction in the price will be applied. • Complete a quick trial to demonstrate your ability to perform the task effectively. Payment Terms: • Payment will be released once the collected email addresses have been validated on our side. • A proportional reduction in payment will apply if the error rate exceeds 10%. Deadline: • The task must be completed within a maximum of 5 days. Application Instructions: • To ensure you have read this post fully, please start the first sentence of your mes...
I'm in need of an experienced PHP+Android developer to assist in integrating a Recharge API. Key Responsibilities: - Implementing necessary API endpoints - Ensuring proper error handling and input validation - Creating a seamless integration between the app and the API Experience: - Proficiency in PHP, Android, and API integration - Strong understanding of error handling and validation best practices - Prior experience in implementing payment gateways or similar API integrations would be an added advantage Please bid if you have the necessary skills and experience to deliver a robust and user-friendly recharge system.
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. - VBA Scripting: Ability to write and impleme...
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 ...Key qualifications and requirements for the role: - Proficient in data entry and experienced with Google Drive/Sheets. - Demonstrated reliability and consistency in previous roles or projects. - Strong attention to detail and organizational skills. - Ability to meet deadlines and perform consistently in an ongoing work environment. If you believe you possess the necessary skills and qualities to excel as a Virtual Assistant with our company, we would love to hear...
I'm looking for a Epic Bridges consultant to help with the review of an interfa...interface specifications document. I'm only looking for 2-3 hours of assistance to start. If things go well, and I need more assistance then I will expand the project scope. Key Responsibilities: - Assisting with outbound interface - Troubleshooting and handling errors effectively - Providing guidance on best practices Ideal Candidate: - 2-5 years of experience in Epic Bridges - Proven expertise in dealing with inbound interfaces - Strong command over outbound interfaces - Proficiency in error handling and troubleshooting - Detail-oriented, self-motivated, and excellent communication skills. Please provide your relevant experience and a brief overview of how you would approach and...
As discussed I have delivered the excel workbook. Thanks!
...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. Ideal Skills and Experience: - Expertise in Excel Password Recovery - Flexibility
I'm encountering the error 0xc0000142 when attempting to run my Photoshop Beta software on my Windows 10 machine. This error is preventing me from using the software. Key tasks and requirements: - Identify the root cause of the error 0xc0000142, particularly in the context of Windows 10 and Photoshop Beta. - Implement the necessary fixes to eliminate the error and ensure the software runs smoothly. - Provide insights on any potential conflicts between the software and the operating system that may have led to this error. Ideal skills and experience for this project: - Proficiency in troubleshooting Windows 10 errors. - Proven experience in resolving software-specific bugs, especially within the Adobe software suite. - Strong understa...
Compré un modelo particular para dolibarr hace años y actualicé de 4.0.0 a 7.0.1 el 14 de junio de 2018... ahora necesito actualizar nuevamente a Dolibarr 17.0.4... El problema es que cuando quiero enumerar los terceros/terceros empresas se activa: "Error fatal: TypeError no detectado: tipos de operandos no admitidos: cadena - int en /srv/vhost/:5480 Seguimiento de pila: #0 /srv/vhost/(631): print_barre_liste() #1 {main} lanzado en /srv/vhost/ home/html/presupuestos/htdocs/core/lib/ en la línea 5480" He instalado el tema md-ux. Puedo enviarte el modelo y debes instalarlo en tu propia instalación Dollibar. NO ENVIARÉ acceso a mi base
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 generation - Strong communication skills and a good understanding of client nee...
