Vba code update sheets excel 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.
Yritykseni myy veneitä, uusia ja käytettyjä. Minulla on nyt yksinkertainen wordpress / elementor pro:n päälle tehty sivusto. Haluan sivustolle esim woocommercella tehdyn tuotekatalogin, jossa erottelen uudet veneet omaksi välilehdekseen, ja käytetyt omaan. Haluan itse pystyä päivittämään sivustoa, olen itse rakentanut nykyisen sivun, mutta kaupan integroimista ulkoasuineen en hallitse. UPDATE: I have a website , I have built it with wordpress 5 and elementor pro. I have basic knowledge about installing and maintaining the website but need help integrating woocommerce and building simple product catalog. For example this website of my competitor has quite simple catalog for used (brokerage) and new boats: Also this one ...
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.
Morjesta mindwakerstudio! Biddaisitko tähän niin päästään hommiin! Deadline on 12.09.2014 Ja budjekti on $100
...restrictions: - Visibility of Microsoft Word and Excel icons on all local users' desktops. - Display of a specific, read-only folder on the C drive on all local users' desktops. The folder is a custom one, please reach out for specifics. The technician must have Windows 11 23H2 to ensure effective troubleshooting. Microsoft's Office 2021 should be included in the XML. Ideal skills and experience for this project include: - Proficiency in creating assigned access XML files for Windows 11 - Familiarity with Microsoft Configuration Designer - Access to Windows 11 23H2 and Office 2021 for effective troubleshooting - Ability to follow specific, detailed requirements attached is the xml file i am working with, i need someone that can edit it in order for word,ex...
I'm seeking a professional to help me integrate "Obfuscar" into my Visual Studio environment and assist with publishing my project. The final published project should include an obfuscated DLL and install without errors. Key project components: Objective 1: - Full obfuscation of my C# code. - Project publishing and ensuring successful installation. Objective 2: - cpp code obfuscation using LLVM Obfuscator on ubuntu - Including support to install LLVM obfuscator and obfuscator should be able to manage all kind of cpp software functionality. For objective 1: To demonstrate the project cycle, you may use this PowerPoint add-in project: and perform the obfuscation. Currently, I can run Obfuscar, but I'm having issues with the manifest file not
I need a freelancer to help me update my email signature and Word header picture. I need the PO Box address line removed from both files Specific Tasks: - Modify my current Word header image - Update my email signature without an outdated address I have all the necessary images ready to go, so no creation work is needed. The ideal candidate for this project should have experience with graphic design and be proficient in editing images for professional use.
I'm looking for an experienced UI/UX designer to help update the user interface and user experience of my existing IOS food ordering application. You'll be working closely with a team of 2 developers. Key Objectives: - Primarily to improve overall user experience on the app. Areas of Focus: - The Home Screen - The Checkout Process - Menu Browsing Design Aesthetics: - A modern minimalistic design is preferred, so an understanding and experience with this style is crucial. Ideal Skills: - Strong UI/UX design background, particularly with IOS applications. - Experience with modern minimalistic design. - Ability to work collaboratively with developers. Please provide examples of similar projects you've completed in your proposal.
I'm looking for a professional to assist with managing my e-commerce company's emails and Excel data entry. Email Handling Tasks: - Responding to customer inquiries - Processing order confirmations - Managing promotional emails Excel Work: - Primarily data entry using a pre-existing template Ideal Skills: - Excellent email etiquette and customer service skills - Proficient in Excel with data entry experience - Able to handle promotional emails professionally - Reliable and trustworthy, able to handle order confirmations accurately.
I'm seeking a professional web developer to create a fully branded website for my Cookie brand. The site should be easy to navigate, visually appealing, and aligned wi...easy to navigate, visually appealing, and aligned with my brand identity. Key Requirements: - Full integration of my custom logo and color scheme, unique typography and icons, as well as branded illustrations and photos. - Inclusion of various sections: Home page, About page, Contact page, Partnerships, Nutrition & Allergy, Catering, Merch. - A user-friendly interface that allows me to easily update the menu and content on the pages as needed. Ideal Skills: - Proficiency in web development and design. - Experience with e-commerce and content management systems. - Ability to translate brand identity into ...
**Project Description: I am seeking a skilled freelancer to transform an existing employee schedule from a basic Excel format into a modern, visually appealing design. The goal is to enhance the user interface and overall aesthetics, making it intuitive and easy to navigate for both management and staff. The redesigned schedule should incorporate interactive elements and be adaptable to various devices, ensuring accessibility and usability. The ideal candidate will have experience in UI/UX design and a strong understanding of creating visually engaging digital tools.
I have dax problem, can be a simple one for experienced power bi person. Basically, I have the ReportingMonth on slicer which is date column. and I have following measures. Count Open this Month = CALCULATE(COUNT(TestData[ID])) Co...CALCULATE([Count Open this Month],DATEADD('TestData'[ReportingMonth], -1,MONTH)) I have these values in KPI visual. Now I need to replace ReportingMonth in slicer to below column. Current/Snapshot Period = IF( TestData[ReportingMonth] = CALCULATE(max(TestData[ReportingMonth]), all(TestData)), "Current Period", FORMAT(TestData[ReportingMonth], "MMMM YYYY") ) Which is text column. Update "Count (Last Month)" measure so it can work when the slicer is changed to "Current/Snapshot Period" i...
Lanolin labels 200 ml & 500 ml We need to update the labels as follows Change the grams to mls, ie 200 mls & 500 mls Remove the Seaguard Australia address details etc and add: Skin Saviour Add the Skin Saviour logo
I need a professional-grade Excel template with dropdown lists to help track visa statuses for employees. The template should have the following fields: - NAME/LAST NAME - PROFILE (Dropdown: RADS or OPS) - CONTRACT TYPE (Dropdown: FT or PT) - VISA PROCESS CALL (Dropdown: yes, not yet) - DATE (blank) - VISA (Dropdown: requested, lodged, granted, renewed) - FAMILY (Dropdown: yes, no) - VISA EXPIRES (blank) - PASSPORT NO (blank) - PASSPORT EXPIRES (blank) - RELOCATION (Dropdown: initial consultation, 5 days package, in progress) - FLIGHT (Dropdown: initial consultation, booked) - IT (Dropdown: requested, not yet) - CONTRACT (Dropdown: signed, approved, amended, in progress) - REPORTING COUNTRY (Dropdown: SCAN, UK, NA) - COUNTRY (Dropdown: AUS,NZ) - OFFICE LOCATION (Dropdown: Noosa, Sy...
I'm seeking an expert in data research who can help me investigate customer data. The primary focus will be on gathering staff contact information for 250 companies. I ... Example of the staff list for first company CRMLS The ideal freelancer for this project should have: - Proven experience in market research, particularly customer data. - Strong analytical skills to interpret complex data sets. - Proficiency in Excel to organize and present the data. The final deliverable should be in the form of detailed Excel spreadsheets that clearly present the researched customer data. Provide First Name, Last Name, Title, Company Address, Company Name, Email, Mobile Phone, Linkedin acount
Just an update from what that you have already done!
I'm seeking a designer to update my logo by changing the font of the main text to a modern style and to apply an analogous color scheme. Ideal skills for the job: - Proficiency in graphic design software - Strong understanding of typography - Experience in modern design trends - Knowledge of color theory and application - Attention to detail
I'm looking for a skilled professional to seamlessly set up Appsump code redemption into our productivity-focused SaaS platform. Key Requirements: - Proficiency in SaaS applications, particularly in the productivity sector - Prior experience with Appsump or similar code redemption platforms - Ability to create a simple and quick user experience for code redemption The ideal candidate will have a strong background in software development and user experience design. The goal is to make the code redemption process as effortless as possible for our users. Please provide examples of similar projects you've completed in your bid.
I need a PowerBI dashboard to monitor project performance. The dashboard should track progress against milestones and budget vs actual costs. The data sources include Excel spreadsheets and various Cloud services. Ideal skills and experience for this job include: - Proficiency in PowerBI - Experience in project performance tracking - Skills in connecting PowerBI to Excel and Cloud services - Expert in data visualization and interpretation -Understanding of budgeting terms - developing a dashboard that can be updated by end user
I need a C# program that uses forms to manage product records in SQL Server. The program should allow users to insert, update, and delete records, as well as search for products. Key Requirements: - Proficiency in C# and experience with Windows Forms - Extensive knowledge of SQL Server - Ability to create user-friendly interfaces Please only bid if you can deliver a high-quality, efficient program. The work will be through AnyDesk.
...Result" and Filter Functionality Goals: - Preserve filter conditions and results when navigating back from a resume details page. - Allow users to modify filters and update results dynamically. Measurable Outcomes: - Filter state remains unchanged when using the "Back to Result" button. - Modified filters display updated results without errors. - Test response times within 2 seconds for navigation and filtering. --- 6. Optimize Website Storage and Plugins Goals: - Identify and remove unused plugins, themes, and items to free up storage. - Share a list of unclear items for approval before removal. - Update all active plugins to their latest stable versions. Measurable Outcomes: - Reduce storage usage without impacting website functional...
I need a skilled developer to create a WordPress plugin that can handle M3U logins and display live TV channels organized by category. The plugin must: - Automatically update daily to pull in fresh content without manual intervention - Require user authentication to access this M3U content Ideal candidates will have extensive experience with WordPress plugin development and a solid understanding of M3U playlists. Please provide examples of similar projects you've completed in your proposal.
...the design cozy and inviting. We also want innovative design ideas that enhance the customer shopping experience. Key Elements We Need Help With: Entry Area: Design a decompression zone with a striking focal point to welcome customers and set the tone for the store. Defined Product Areas: Design dedicated sections for lamps, pillows, and mixed-product displays, using a modular approach to easily update displays. Checkout Area: Create a well-defined and minimalist checkout space that integrates seamlessly into the store layout. Shelving & Displays: Propose innovative shelving solutions for smaller decor items like vases, candles, and figurines. Modern/Boho Vibe: The design should incorporate natural materials (like wood, wicker, rattan) and lush greenery to reflect our modern...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
...for automated order processing. ? Powerful Admin Panel – Manage your business with advanced features. ? Subscriptions – Automate likes, views, retweets, and more. ? Bulk Services Editor – Update all services with a single click. ⏱️ Average Time Calculation – Track order processing time based on history. ? Refill & Cancel Buttons – Easily manage orders even if the provider doesn’t offer it. ? Import & Sync – Import & sync services with providers that use our platform. ? Child Panels – Provide affordable panels for your customers. ? Affiliate System – Grow your customer base with a partner program. ? Update Logs – Keep users informed with service updates. ? Video Promotion – Grow your panel with Yo...
...business to be used on social media, specifically Facebook and Instagram. Key Focus Areas: - Quality and Taste: Highlight the superior quality and delicious taste of our mangoes. - Health Benefits: Showcase the numerous health benefits of consuming mangoes. - Origin and Sourcing: Educate viewers about where our mangoes come from and the sourcing process. - Copyright free background audio/music - Update 1 video to be split into 2 reels + 8 new creative reels with my brand logo/branding. - IP rights for the videos created for me needs to be transferred to me. The ideal candidate should have a strong background in video editing and social media marketing, with a knack for creating engaging, promotional content. Experience in food promotion, particularly fruit, would be a signifi...
I need a skilled PHP/SQL programmer to help me troubleshoot and fix issues in my existing code. I'm currently facing a couple of challenges that need immediate attention. 1) PDF Files Preview Issue: I have PDF files that are not previewing properly on three different pages and a 'save to PDF' page. Some PDFs are displaying while others aren't. All these files are stored in a database table. 2) Setting Up New Database Fields: I need assistance in creating three new fields in my database. This will involve integrating these fields in the front-end and back-end of my existing system. Ideally, I would like to complete these tasks within three hours, though I anticipate we could finish sooner. If you're available now and ready to work with me, please respond w...
I'm looking for a skilled developer to build an app delivering professional services (task management/organisation)...monetary/other value); that information will then need to be collated and presented to other users. Key Features: - Task management capabilities - User-friendly interface - Notifications - Capacity to involve multiple users - Users will input preferences and information will be provided/priorities will be amended based on those preferences - On the 'backend', I want it to create something like an excel spreadsheet, so data can be gleaned and used - Cross-platform compatibility Ideal Skills: - Proficiency in iOS and Android app development - Experience in building apps - Strong UI/UX design skills Please provide examples of simil...
I'm in need of a comprehensive Google Sheets spreadsheet that catalogs all the childcare centres in the Gold Coast. The spreadsheet should be organized by location and include the following details for each centre: contact number, email, name, and address. Ideal Skills and Experience: - Proficiency in Google Sheets - Experience in data collection and spreadsheet creation - Familiarity with Google Maps and similar platforms - Attention to detail to ensure accurate data entry
I'm in need of a freelancer who can help me draft an audit report for a small city. The ideal freelancer for this project should be a seasoned report writer with extensive experience with Microsoft word and excel.
...if needed. 6. Make color black for "please enter your email" in footer subscribe box, so it shows better 7. Product Page changes, please see jpg :: also fix error on viewing products in admin and not able to create attributes 8. Category page changes, please see jpg a. Type 2 product list from b. Make advertise banner slider. copy code from product page. 9. Contact Us Form page /contact a. Move Contact Details down to line up with Write Us b. When user is logged in and goes to the form, autofill data in user's profile in form 10. Track order history not showing all FEDEX tracking data 11. Registration a. On Social Login form, Create Account (registration) should show message for user to confirm registration b. Wording in Create
UPDATE #1: cat need to be the same as the cat in the attachments Manipulate cat photo in different scenario's But it's important that the cat is as realistic as it is in the original photo. So the cat should be recognizable for example - middle age era - cooking - snowboard - cat in different costumes - ... be as creative as you want, but the cat should still look familiar to the original photo
