Excel vba error työt
FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...
Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
I'm looking for an expert automation developer who can add workflow validation to my existing project and implement various data validation rules for a new report. Requirements: - Incorporate workflow validation into the existing project. - Implement form...range validation, and cross-field validation for a new report. - Include performance metrics for validation processes. The ideal candidate will have extensive experience in automation development, particularly in implementing various types of validation. Proficiency in applying different validation rules is a must. The existing project is built on a JavaScript platform. Please include customized error messages for each validation rule. The new report should be presented in a tabular format. Please use Selenium for the au...
Hello everybody , all good ? I have clients who would like to perform multiple audit to look at and find possible vulnerabilities in their smart contracts.(SOLANA and EVM), per batch of 20 smart contracts. So I am looking for someone who is familiar with RUST on Solana and SOLIDITY on EVM programming. The goal is to achieve perfect code, that is, to find any error or flaw in the coding to avoid all any future mishaps. If you find any errors in the Smart contracts, I will ask you to provide a solution to fix the problem of course ^^. And for sure, depending on the vulnerability and risk, a bonus may be granted to you. The only condition I ask is only a simple and clear answer, in the form of a form to make it easier to read. # Severity Level (1to4)= # Brief : # Vulnerabilities D...
Are you looking to make a lasting impression with your presentations? Our Professional PowerPoint Creation service offers the perfect solution. Whether you're a business professional, educator, or student, we'll transform your ideas into visually stunning slides that captivate your audience and effectively convey your m...Branding Consistency: If you're representing a brand, we'll ensure your presentation aligns seamlessly with your brand identity. From color schemes and fonts to logo placement, we'll maintain consistency to reinforce your brand image. Professionalism: With our Professional PowerPoint Creation service, you can expect nothing less than the highest level of professionalism. We'll deliver polished, error-free presentations that reflect po...
I don't see the changes. Site in wordpress
...scripts for efficient data extraction or those with a team capable of handling bulk processing. Requirements: • Expertise in Python or other relevant programming languages for PDF parsing • Experience with libraries such as PyPDF2, PDFMiner, or similar tools • Ability to extract structured data accurately (tables, text, etc.) • Handling of different PDF formats and layouts • Data output must be in Excel (.xlsx) format per template provided. Preferred Qualifications: • Prior experience with large-scale data extraction • Strong attention to detail and data accuracy • Ability to process PDFs with varying structures • Team availability for high-volume processing (if applicable) Selection Process: • We will conduct interviews to und...
...EXIST "%SOURCE_FILE%" ( echo ERROR: Source file not found: %SOURCE_FILE% exit /b 1 ) REM Create destination folder if it does not exist IF NOT EXIST "%DESTINATION_FOLDER%" ( echo INFO: Creating destination folder: %DESTINATION_FOLDER% mkdir "%DESTINATION_FOLDER%" ) REM Copy the file to the destination folder COPY /Y "%SOURCE_FILE%" "%DESTINATION_FOLDER%" IF ERRORLEVEL 1 ( echo ERROR: Failed to copy file to %DESTINATION_FOLDER% exit /b 1 ) ELSE ( echo SUCCESS: File copied successfully to %DESTINATION_FOLDER% ) REM Check if the executable file exists before trying to run it IF EXIST "%EXECUTABLE_FILE%" ( echo INFO: Starting executable: %EXECUTABLE_FILE% START "" "...
...Admin: Full system control Staff: View-only for offers and disputes 3. Offer & Stock Management Draft mode for listings Platform-specific data (Fortnite, Valorant, LoL, GTA) Delivery format: [username:password:email:emailpass] 4. Platform Integrations Initial integrations: Eldorado, GameBoost, G2G Stock distribution via queue system Offer ID generation and sales tracking 5. Error Management Local logging for error detection Offer status monitoring Manual marking for sold/problematic offers Project Timeline Estimated duration: 4 weeks + 1 week testing Starts after first payment Completion upon final walkthrough Payment Terms Total Budget: $5040 Milestone payments upon phase completion Additional Notes Both parties will adhere to Freelancer.com's terms. Next S...
I have a Google Cloud Function that works as expected. However, when I trigger it from Cloud Scheduler, I receive a permission error. I need someone who can join via AnyDesk and fix it immediately. Thank you.
...questionnaire with set parameters need to be uploaded on the site for the visitors to take the survey with a description of the survey and its importance. Once a survey is live we need to register the records for 45 days during that time our partner NPOs work locally in promoting and awaring people to take survey. Post 45 days we need to fetch all the information into spreadsheet (Google Sheet, Excel recommend) the using Power BI, python language another team work on analizing the records and forms a detailed illustration for the data. And a well defined resource backed research paper need to publish on the site in the form of blog and a download link for the papers. Based on working description of the company I need a mature design for the website. The work will include &quo...
I'm looking for a professional to help me fill out an Excel sheet for a financial model. The sheet will involve data from the Income Statement, Balance Sheet, Cash Flow, Operating Working Capital, debt, depreciation, amortization, equity, shares, and various financial ratios. The annual report is available for reference. Skills and experience required: - Extensive knowledge of financial modeling - Proficiency in Excel - Ability to interpret and analyze financial statements - Experience working with financial ratios - Attention to detail.
...EXIST "%SOURCE_FILE%" ( echo ERROR: Source file not found: %SOURCE_FILE% exit /b 1 ) REM Create destination folder if it does not exist IF NOT EXIST "%DESTINATION_FOLDER%" ( echo INFO: Creating destination folder: %DESTINATION_FOLDER% mkdir "%DESTINATION_FOLDER%" ) REM Copy the file to the destination folder COPY /Y "%SOURCE_FILE%" "%DESTINATION_FOLDER%" IF ERRORLEVEL 1 ( echo ERROR: Failed to copy file to %DESTINATION_FOLDER% exit /b 1 ) ELSE ( echo SUCCESS: File copied successfully to %DESTINATION_FOLDER% ) REM Check if the executable file exists before trying to run it IF EXIST "%EXECUTABLE_FILE%" ( echo INFO: Starting executable: %EXECUTABLE_FILE% START "" "...
I'm looking for a freelancer who can build a comprehensive dashboard in Excel for tracking employee performance data. Key Requirements: - The dashboard should track 16 key performance indicators (KPIs) related to equipment conditions. - Visual elements should include charts, graphs, gauges, and meters. I already make it but need to enhance and also to add more slides. Ideal Skills: - Proficient in Excel with experience in building dashboards. - Understanding of employee performance and equipment condition metrics. - Capable of creating user-friendly, visually appealing dashboards.
...appointments. Your main responsibilities will include: - Data Entry: Accurately inputting information into Microsoft Excel/Word. - Email Handling: Managing my inbox, sorting emails, and responding to necessary correspondence. - Scheduling Appointments: Coordinating my calendar and setting up meetings. - Travel Arrangements: Booking flights, hotels, and transportation for business trips. - File Management: Organizing and maintaining digital and physical files. - Document Preparation: Creating and editing reports, presentations, and other documents as needed. - Meeting Minutes: Taking detailed notes during meetings and distributing them as needed. I prefer using Microsoft Excel/Word for task management, so proficiency in these programs is essential. Communication will pri...
I'm in need of a professional to edit a sales invoice for me. This task involves 200 products spread across 2 invoices. The invoices must be error-free, as they are intended for eBay verification. Key Requirements: - Use my provided template for the invoices - Maintain the same font and formatting style across both invoices - Format the final invoices as PDFs - Ensure all details are included to make the invoices look legitimate Ideal candidates should have: - Experience in invoice creation and editing - A strong understanding of sales tax - Proficiency in PDF formatting In particular, the following aspects of the invoice need to be verified: - Product details - Total amount Please note that the original invoice was created using Adobe Acrobat, and a template is available f...
Following a recent product upload on my online shop for Rum & Accessories, I've encountered a critical error. I need assistance from a competent professional who can resolve this issue promptly and efficiently. Error Details: - Fatal error: Uncaught Error: number_format(): Argument #1 ($num) must be of type float, string given - Location: /home/u313020711/domains/ on line 114 The issue isn't isolated to a single product; it's impacting multiple items. The error seems to have been triggered after I uploaded a new product, and it's tied to modifications made in the product descriptions. Ideal Candidate Should Have: - Strong expertise in WordPress troubleshooting. - Experience with PHP and WordPress theme development
I'm looking for a freelancer who can analyze and format my sales data into a clear, tabular Excel report. Key Requirements: - Experience with Excel is a must, especially with data formatting. - Familiarity with sales metrics and how to present them in an informative manner. - Ability to meet deadlines and provide a high-quality, easy-to-understand report. The report will primarily focus on total sales, sales by product category, and sales by region.
I'm looking for an experienced Excel professional to compile a calendar for 2025 and 2026. This will include marking work tasks and deadlines, 2nd & 4th Saturdays, Sundays and all Hindu holidays. Key Requirements: - Organize data week-wise in an Excel sheet - Distinctly mark 2nd & 4th Saturdays and all Sundays - Highlight all Hindu holidays and list them in a separate column - Use Conditional Formatting and Pivot Tables to ensure easy readability and proper formatting Ideal Skills: - Proficiency in Microsoft Excel (Formulas, Conditional Formatting, Pivot Tables, etc.) - Data Entry & Processing - Attention to detail - Experience handling large datasets Deliverables: - Well-structured Excel sheet - Clearly marked week-wise data - Properly high...
I'm seeking a meticulous Data Entry Operator to assist with inputting and structuring data into Microsoft Excel. The job will entail: - Transcribing data from a variety of sources including scanned documents, PDFs, and handwritten notes into an Excel spreadsheet. - Ensuring the accuracy of the data and catching any potential errors. - Structuring the data chronologically for easy access and retrieval. - Upholding confidentiality when dealing with sensitive information. Ideal candidates should have: - A good typing speed and a high degree of accuracy. - Proven experience with Microsoft Excel or other data entry software. - An exceptional attention to detail. - The ability to meet deadlines consistently. Project Duration: 1-2 weeks (potential for extension based...
...Hacks the System” banner (sticky, every page) ▸ “Our Story” page that takes 23 seconds to bookmark (SEO: “BoldOne - Wearable Protest against Artist Stagnation”) ▸ Trust badges that look like hacker emblems (0% boredom) **Phase 2 - Detonation ($130)** ▸ TikTok store with 1 viral template (#TechUnderdogSound) ▸ Etsy/eBay integration with “guerrilla descriptors” ▸ Printful API on steroids (error rate <0.5%) **Why you?** ✓ “Powered by [Your Alias]” badge in the footer (karma points) ✓ $100/month marketing budget if successful ✓ 7% referral bonus for every recommended code rebel. **Application blitzkrieg:** [ ] 1 Shopify link that proves: You can do branding and 3s load times [ ] Your security hack for guest checkout...
...Ideal candidates for this project should have: - Extensive experience in payroll and tax form preparation. - Familiarity with W-2C forms and the reasons for their use. - Ability to work meticulously and maintain a high level of accuracy. - Demonstrated track record of precision and attention to detail in payroll tasks. The employee information will be provided in a digital format such as an Excel or Spreadsheet. The W-2C forms should be completed within 2 weeks. The completed W-2C forms should be provided in PDF format. You may use any software you are comfortable with for preparing the W-2C forms. The freelancer should also review the corrected wage information to ensure its accuracy. The freelancer only needs to prepare the W-2C forms. The selected freelancer will be respons...
...com✅ Demand Forecasting: Build SKU-specific demand forecasting models✅ Inventory & Supply Chain Tracking: Automate stock tracking for both raw materials & finished goods✅ Financial & Profitability Analysis: Track fixed/variable costs, discounts, shipping profitability, and payment gateway performance✅ Customer Insights & Demographics: Analyze order trends, geographic sales, and repeat customers✅ Error Handling & Troubleshooting: Identify and correct data discrepancies✅ Customer Service Data Integration: Assist in managing customer inquiries, tracking refunds, and organizing order follow-ups✅ Administrative & Operations Support: Help with managing daily reports, updating spreadsheets, and organizing supplier communications✅ Marketing & Ad Data Analysis:...
...Writing: Assistance with healthcare-related content and research. Data Entry: Accurate and efficient data management. Diet & Public Health Research: Creating reports and articles related to diet and health. PowerPoint Presentations: Creating professional and engaging presentations. Excel Work: Data analysis, charts, and spreadsheet management. Requirements: Strong attention to detail. Relevant experience in any of the above-mentioned fields. Ability to meet deadlines. Deliverables: High-quality, error-free work. Submission within the agreed timeline. Budget: Flexible, depending on the project scope and quality. These projects are long-term, requiring extended collaboration over several months. Communication will primarily be through email. Work should b...
I require an Excel expert to streamline my weekly report process. This involves merging four distinct reports - Maintenance, Operations, Supply Chain Management (SCM), and Finance - into one comprehensive Excel spreadsheet. Key tasks: - Combine the four reports into one Excel sheet on a weekly basis. - Visualize the data trends over time using a bar graph. - Ensure the graph highlights the key trends across the four departments. - Automate the import of data from each of the four reports to reduce manual input. - Develop a dashboard in Excel that displays key metrics and trends in a user-friendly format. - Generate a weekly summary report that provides insights and highlights key findings. - Set up conditional formatting or alerts to flag any significant chang...
Need to cover and update the following points 1: Prevent users from copying and pasting data to the Template file from other files 2: Link the new planning template to VLOOKUP file. Need the Dropdown data validation options on this file to match the Vlookup file that we maintain separately and use for our other templates. 3: Ensure that VLOOKUP file needs to be referenced from original location instead of creating a copy to the folder. 4: Stop workbook links message when file is opened 5: Stop VLOOKUP file closing message when file is closed
...follower 2) RC Bluetooth Control Key Aspects of the Job: - Error Fixing: The majority of the work will revolve around diagnosing and fixing issues in the existing code. - Code Completion: You'll need to finish the remaining segments of code. - Schematic Reference: I have schematics of the module I've designed for your reference,will be provided via chat. The code needs to interface with several hardware components, including: - Infrared Sensors - Ultrasonic Sensors - Motors and Drivers -Bluetooth control from mobile phone. More projects will be provided to the freelancer this is an test project to evaluate the freelancer. Ideal Skills: - Extensive experience with ESP IDF programming - Strong problem-solving skills to deal with error fixing - Ability to work w...
I am looking for a skilled Power BI expert to create a dashboard primarily focusing on sales analytics. Key Requirements: - The dashboard should connect to Excel/CSV files. - It should track revenue by product. Ideal Skills and Experience: - Proficiency in Power BI. - Experience in sales analytics. - Ability to work with Excel/CSV data sources.
Hello. As discussed, I’ll make the dashboard for you.
I'm seeking help with matching date ranges in my data. The data is time-sensitive and needs to be handled with precision. Ideal Skills and Experience: - Proficiency in Excel, particularly with the INDEX and MATCH functions - Strong understanding of date and time data - Experience in data analysis and sorting - Attention to detail to ensure accurate matching of date ranges
I have an Excel sheet containing sales data and I need help converting this information into a parts needed list. The parts list should be organized by dates of sales. Key requirements: - Identify individual components from sales data - Organize parts list by sales dates Ideal skills: - Proficiency in Excel - Experience with data analysis - Attention to detail
...These pages display the same product catalog as the main store. Customers can place orders but not pay directly. Instead, orders are recorded and linked to the seller for later group processing. 3. Order Collection & Export (for Reseller Webshops) Orders placed via reseller webshops should be saved in a separate list. Group leaders (e.g., a coach or teacher) can export the order list as a CSV or Excel file. Once all orders are collected, the leader places a bulk order via the main webshop. 4. Seller Dashboard Sellers log in to see order summaries, total sales, and commission tracking. A referral link generator so sellers can share their shop. No financial transactions on this dashboard—only order tracking. 5. Admin Dashboard & Order Management Overview of all seller...
I see the site differently than Elementor.
I am looking for one to help me fix an error in function (pointer to any conversion
I'm in need of a professional who can assist me with a data migration task. The data is currently stored in another Excel file, and I require help specifically in removing duplicates during the migration process. Ideal Skills: - Proficiency in Microsoft Excel - Experience in data migration tasks - Ability to identify and remove duplicate entries This project is straightforward but requires attention to detail and a strong understanding of Excel.
I need an Excel whizz to help me manage and analyze my inventory data. The primary focus will be on organizing data and setting up formulas to track stock levels efficiently. Key Tasks: - Organizing my inventory data - Setting up formulas for tracking stock levels - Creating visualizations like charts and graphs for easier data interpretation - Providing step-by-step instructions and useful tips I am looking for someone who can also guide me on using advanced Excel functions such as VLOOKUP, pivot tables, conditional formatting, and data validation to streamline this process. Ideally, you will provide me with templates that can save time and enhance productivity in handling large datasets. The ultimate goal is to improve accuracy and generate insightful reports. Skills a...
Bonjour, Nous recherchons une personne experte en Microsoft Excel pour gérer, trier et nettoyer un fichier contenant plus de 50 000 lignes de données (contacts). Ces fichiers regroupent des milliers de candidats et contacts enregistrés au fil des années. L’objectif est de pouvoir croiser les données, filtrer les candidats en fonction de plusieurs critères, notamment leur qualité, le secteur d’activité, ainsi que le poste et l’entreprise pour lesquels ils ont été positionnés. Nous comptons sur votre expertise pour nous accompagner dans cette tâche complexe et stratégique.
