Tidy vba excel clean code 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.
I'm seeking a freelancer who is adept at typing for a task that involves transcribing handwritten notes into Excel. The legibility of the handwriting is average, so this job demands patience, careful observance, and excellent data entry skills. - Your task would be to transcribe the data from handwritten notes into an Excel file. - The content you'd be dealing with primarily includes text. I'd prefer individuals who have previous experience in data entry, especially tasks that require extracting data from handwritten sources, and are proficient in using Excel. Attention to detail is a must, as accuracy is paramount in this job. Your ability to decipher moderately legible handwriting would be a great advantage. Please bring a keen eye for detail, and ...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completi...
I'm looking for an experienced designer to create my business stationery, this includes a visiting card, two envelopes and a letterhead. All files should be in CDR format. I wish for a minimalistic design style to keep everything very clean and to the point. Although the exact dimensions were not clarified, you should ideally be knowledgeable of average industry standards and be able to guide me in this area if needed. Please include your experience with similar stationery designs in your application.
... This logo should combine both text and symbol elements. It should be striking, memorable, and versatile. Key Requirements: - Combination of Text and Symbol: The logo should include both text and symbol components. The two should harmoniously work together to create a cohesive design. - Modern and Minimalist Style: The overall design should have a modern and minimalist aesthetic. It should be clean, simple, and timeless. - Color Scheme: The logo should incorporate both black and white as well as bold and vibrant colors. The use of color should be strategic and enhance the overall impact of the design. Ideal Skills and Experience: - Proven experience in logo design, particularly in creating text and symbol combinations. - Strong grasp of modern and minimalist design principles. ...
Loving Sincerely - Embracing Incest Survivors at Every Stage A Journey of Acceptance and Support for Survivors and Their Loved Ones I am seeking a talented designer for a non-fiction self-help book cover project I'm working on. The book revolves around personal growth and self-improvement themes. Ideally, the cover will capture this essence in an eye-catching and appealing manner. The design must be clean, compelling, and attractive to readers who are in search of personal development content. I need: - Concept generation and cover design - Typography selections - Iconography or images suggestion - A design that emits a personal growth vibe Ideal Experience: - Proven record of creating appealing book covers - Understanding of book marketing and cover psychology - Experie...
I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!
I have a channel where I make EXCEL educational videos, I upload 12 videos a month, between 5 to 7 minutes each. YOU MUST BE ABLE TO : - Have experience in editing videos for YouTube. - Have basic knowledge of Microsoft Office, to be able to edit the videos better. - Be able to edit 10- 12 videos consistently every week (Some will be only 1 minute long). IF YOU WANT TO STAND OUT FROM THE REST SEND US YOUR PORTFOLIO
...management for sellers. Search functionality with filters for property buyers. Real-time chat system between buyers and sellers. Administrative panel for content moderation and user management (if not already in place). Requirements: Proven experience with Adalo's database and app development environment. Strong understanding of database principles and design. Ability to write clean, maintainable, and efficient code. Experience with real estate applications is a plus. Fluent in English, with excellent communication skills for collaborative work. Deliverables: A fully functional backend database integrated with the Adalo application. Documentation of the database structure and setup process. A brief guide on how to maintain and update the database as the app scales. ...
...website is to showcase my work. The design should be clean, modern, and visually engaging to exhibit a range of samples. - Social Media Integration: It's important that the website seamlessly integrates with various social media platforms. There should be visible links to my professional social media profiles. - User-Friendly: The site must be easy to navigate. The design should be responsive and mobile-friendly. - Minimalist Design: I'm looking for a minimalist design, with focus on the content. Skills and Experience: - Strong Portfolio: I'd like to see examples of your previous portfolio website designs. - Social Media Integration: Proven experience in integrating social media buttons and feeds. - Design & UX: Ability to create clean, modern, and user...
I'm in need of a skilled HTML/CSS/jQuery developer who can bring my vision of a modern and minimalist portfolio website to life. The site should be visually striking, user-friendly and fully responsive. Key Tasks: - Design: I need someone who can design a clean and modern layout that is in line with my vision of a minimalist portfolio. - Responsiveness: It's crucial that the developer ensures the site is fully responsive across devices. - Interactivity: Interactive features are needed to engage visitors and make the portfolio more dynamic. The Ideal Developer Should Have: - Proficiency in HTML, CSS, and jQuery. - Prior experience in creating portfolio websites or similar projects. - An eye for modern and minimalist design. - Strong understanding of responsive design pri...
We are looking for a freelancer with strong web scraping experience for an exciting and challenging project. We need to gather specific data from multiple online sources and transform it into useful, structured information for analysis. Responsibilities: Utilize web scraping techniques to extract data from selected websites. Automate the extraction process to ensure accuracy and efficiency. Clean and structure the collected data into readable and usable formats. Integrate the extracted data into a database or spreadsheet as needed. Collaborate with our team to understand specific requirements and ensure the quality of the obtained data. Requirements: Demonstrable experience in web scraping using tools like Python (Beautiful Soup, Scrapy), Selenium, etc. Solid knowledge of HTML, C...
...interactive section where users can share their experiences and rate flights, enhancing the overall user experience Target Audience: The primary target audience for this platform will be budget travelers. The design and functionality of the site should cater to their specific needs and preferences. User Interface Design: The ideal user interface design for this website should be minimalist and clean. A simple, straightforward, and visually appealing UI will enhance the user experience and keep users engaged. Your expertise in web development, particularly in creating meta search engines or travel-related platforms, will be crucial for the success of this project. If you have a good understanding of budget travelers' needs and preferences, it will be a significant advantag...
I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
...should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the given fr...
I need a word document translated from English to Simplified Chinese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
I am in need of someone who can redesign our company's brochures. Our primary objective is to use the brochures for providing product information to our clients in a fresh and engaging manner. The chosen freelancer should be able to visually communicate information clearly using a modern and clean design style. Essential elements to be included in the redesign are product specifications. Ideal Skills: - Brochure design - Graphic design - Modern clean aesthetics - Ability to interpret technical product information. Your task will be to take our existing product brochures and create a new design format that is engaging, intuitive, and aligns with our brand's visual identity. I look forward to seeing your bid. Link to current brochure
I urgently require an audio expert to restore a noisy and distorted track. - You are expected to use audio restoration software and techniques to clean up the sound and make it much better. - The output file should be in m4a format. - You need to be skilled in audio restoration, audio editing software, and have good ears for music and sounds. This task needs to be completed as soon as possible.
I am in need of a specialist to optimize my Amazon product listings for coloring books. The key focus will be enhancing visibility and maximizing customer engagement for my book collection. Here's what I am looking for in a freelancer: - Expertise in Amazon SEO and PPC ads, with a specific focus on product listing optimization. - Experience ...listing. - Suggesting effective marketing strategies tailored to coloring books. - Execute strategies once approved. - Expertise in Amazon's A9 algorithm to optimize listings. Through these efforts, the ultimate goal is to increase the visibility of my coloring books on Amazon, targeting a better ranking in search results, and thereby improving sales. If you have the skills and experience to excel in this role, I would be thrill...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I'm in need of someone with the expertise, resourcefulness and knowledge to draw up an email lead list from public domain databases. The focus of this project is identifying professionals, specifically those with active websites fo...websites for contact. Key requirements: - Extraction of email leads from public domain databases - Target demographic: Professionals of various walks with active websites - Experience with large-scale data extraction - Proficiency in managing information databases Your past work in email lead generation will be beneficial for the successful completion of this project. Your ability to provide clean, organized, and verified email lists will also be very important. Please only bid if you have the experience and know-how to deliver on the stipulate...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in layman's terms Please include any relevant...
I'm seeking a skilled designer to create a minimalistic logo for my import and distribution company. The aim is to have a logo that is sleek, modern, and easily recognizable. Key Requirements: - A minimalistic approach: The design should be clean, simple, and not overly complex. - Including an abstract icon: I'm looking for something unique and creative, a more abstract representation related to the import and distribution sector. - Color scheme: Preference for cool tones, such as blue, green, or purple, which give a sense of professionalism and reliability. Ideal Skills and Experience: - Proven experience in creating minimalist logos - Strong understanding of color theory and the ability to work with cool tones - Creative thinking and the ability to develop abstract ico...
In this project, I am in need of an experienced HTML5 developer who will design a landing page for my website which promotes a product or service. Key Deliverables: 1. Design a modern and crisp landing page that incorporates a very user-friendly interface. 2. Element Requirements - Include a detailed desc...color themes is specific to current website. Also home page will have section with text and image and link that points to new landing page Ideal Candidate: The perfect candidate for this project has experience in HTML5 development, landing page promotion and design, and an understanding of consumer-oriented user interfaces. It would be beneficial if they have an eye for aesthetically pleasing, clean designs, and are willing to collaborate closely with me on the project until c...
I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project req...
2 excel files with VBA macro as per customer requirement
We need a highly skilled individual with extensive experience in ...the modern age with a refreshing touch that reflects our brand. - Revising content and language. Our output needs to resonate with the audience, so a quality copywriting ability is crucial. - Adding visual elements and graphics. You'd pepper appropriate visuals throughout our documents and slides, enhancing understanding and engagement with our messages. The style we envision for this task is clean, modern, and professional. If you have an understanding and feel for our described style, we want to work with you; plus, experience in corporate communication will be highly regarded. Please share your portfolio illustrating similar prior work, if available. We're pumped to give our corporate documentation a f...
I need a designer to create a concise, professional, and clean PowerPoint presentation for a business audience in (Arabic Language ) Requirements: - The presentation should contain less than 10 slides, which are to be engaging and visually appealing while maintaining a professional and clean visual style. Ideal skills: - Proficiency in PowerPoint - Experience in designing business presentations - Understanding of what a business audience expects Please provide samples of your previous work in your proposal.
We are looking for an expert for static site generation using faustj...headless WordPress in a monorepo project. Data fetching is done using graphQL. We already have all required react components for the site, but the components need to be moved into a reusable, independent ui library (including build scripts). We use Storybook which should import components from the ui library. We use styled components as css-in-js solution in our react components. We use graphql code generation to generate typescript types from our fragments. Static site generation should make use of SSR and server components. The coding is more than half done. We are looking for someone, who has already made all the mistakes, and guide us. My backend dev scope the project for 2 days. If it takes longer, we will ...
I need an expert in Microsoft Excel to build an efficient spreadsheet to monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of tracking potential lost revenue due to late service. Skills Needed: - Microsoft Excel - Financial modelling - Adv...
I need an experienced freelancer able to carry out a large-scale sheetrock project. Key tasks include: - Installation of sheetrock across an entire floor - Taping and mudding for a well-leveled and solid construction The final result should have a smooth finish, providing a clean, modern look to the renovated space. The ideal professional for this project has experience in large-scale installations and creating smooth sheetrock finishes. You should be detail-oriented, ensuring a high quality and uniform finish across all rooms.
I am looking for a skilled indivi...Automation: Automatically streamline tasks and workflows to increase efficiency. - Customization Options: Enable customization to cater to various needs within our internal team. Design: The UI should have a clean and professional look, facilitating easy navigation and enhancing user friendliness. Audience: - The app is intended primarily for use by our internal staff only Ideal Skills: - Previous experience in Zoho Deluge based application development. - Proven track record in data management, workflow automation, and user customization. - Strong UI/UX design skills, preferably with a focus in clean and professional interfaces. Bid only if you can demonstrate the necessary skills and experience in Zoho Deluge and meet the requirement...
...our company name Nicksconsultancy to "NC POS." Our current logo and color scheme are attached for reference. Company Name: NC POS Color Scheme: Please use the colors from our current logo (attached). You can find the color codes in the attachment. Design Direction: We are open to creative ideas but would like the logo to convey professionalism, reliability, and innovation. The design should be clean, modern, and easily recognizable. Logo Sizes: We need the logo in various sizes suitable for different purposes, including website headers, social media profiles, and print materials. High-resolution versions are preferred. Additional Information: Feel free to experiment with different symbols or imagery that may relate to the POS industry. However, simplicity is key, and t...
I'm seeking a professional to diligently run through LinkedIn, identifying and documenting HR higher-u...Identifying: I'm targeting senior-level personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding the perfect fit for my requirements. Strong organizational skills, meticulous attention to detail, and proficiency in Excel would be highly appreciated. Overall, a good grasp of LinkedIn-based research would...
I'm seeking a knowledgeable freelancer to construct a traditional, professional resume for my career in the Military/Security field. Ideally, I would like it formatted as a Word document. Key Requirements: - Proficiency in Microsoft Word, ensuring clean formatting and easy modification on my part. - Experience in crafting resumes, specifically in law enforcement and security sectors. - A keen eye for a professional, traditional layout that highlights my experiences and skills. Please include samples of previous similar work in your bid. Your attention to detail and understanding of the Military/Security sphere will be greatly appreciated.
I am looking for an experienced freelancer to design a concept floorplan. My vision is a minimalist, beach-themed layout that is clean, airy and spacious, over 1,000 sq ft. The design should include the following: - Room dimensions - Wall placements - Furniture layouts - Bathrooms - Sauna Experience in CAD and architectural design is preferred, with a portfolio showcasing similar projects if possible. Understanding of minimalist and beach-related design elements is highly desirable. Applicants should have a keen eye for detail, demonstrate creativity, and be able to translate my vision into a practical, aesthetically pleasing floorplan.
I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.
