Excel macro to generate insert statements 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.
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.
Project Title: Website Rebranding and Marketing Campaign for Agile Coach Project Description: We are looking for a skilled and experienced freelancer to undertake a comprehensive website rebranding project for our client, an Agile Coach. The objective is to revamp the existing website to align with the client's LinkedIn profile and create a cohesive brand identity. Additionally, the freelancer will be responsible for developing a targeted marketing campaign to promote the client's abilities as an Agile Coach. Project Scope: 1. Website Rebranding: - Conduct a thorough analysis of the client's existing website and identify areas for improvement. - Develop a new website design that reflects the client's personal brand and aligns with the...
...professional to help me extract contact details from the Australian Institute of Architects website. Their website address is: There are 566 architect contacts for Sydney, NSW, Australia within 100km. I requirements: - Extracting: I require the following contact information to be extracted: Business Name, Email, Phone number, Full address separated by suburb, postcode and state. - Formatting: All extracted data should be structured and organized into an Excel spreadsheet. Ideal Skills: - Web Scraping: Proficiency in web scraping tools and techniques is essential. - Data Entry: Experience with data entry and extraction. - Attention to Detail: Accuracy in capturing and organizing contact details is crucial. - Excel Proficiency:
...pages should be specifically tailored to generate leads for my B2B SaaS company that caters to the technology industry. Key Requirements: - Experience with B2B SaaS landing pages in your portfolio is a must. - Proven track record in designing high-converting landing pages. - Proficient with Unbounce software. - A clean and professional design aesthetic. - Ability to work under tight deadlines. Your main goal will be to design these pages with a clear focus on lead generation. While there are many elements that can help in achieving this, I'm particularly interested in your ability to integrate essential components. Key Tasks: - Design 3 high-quality landing pages. - Ensure these pages are optimized for lead generation. - Implement any ne...
...want it to switch to local language based on IP, not have a separately translated set of pages. • Would prefer webflow, open to wordpress • Need it to be easy to edit from a non-html or non-technical person. 2. Key Features • Mobile and Conversion-First Design: The site will be optimized for mobile users and designed to facilitate easy conversions. • Super Fast Load Times: Implement best practices in web development to ensure the site loads quickly across all devices. • High-Converting Key Pages: • Homepage: Designed to attract and guide visitors to conversion points. • Book a Demo Page: Simplified scheduling process integrated with Calendly. • Contact Us Page: Clean, easy-to-u...
Hello. I have a multiple page excel spreadsheet, but I need it to have more flexibility. It is for a 10 room facility, and it's purpose is to show projected revenue based on room type, employee job type, and schedule. The current spreadsheet has 10 rooms with two room types. Also there are 11employees with 6 job types. Your task will be to change the current spreadsheet to 40 rooms, 3 room types. and 22 employees with 12 job types. Changes to be made to Revenue Targets Page, Column A -I want to be able to select room type from a dropdown menu, and input the revenue for different room types on the Revenue Target page. Room types are Private Room, Shared Room, Shared Medicaid. Employees Page, Column A -I want...
I'm looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell w...
As a WordPress developer, I'm looking for someone to build a website for our textile products meant for the hospitality industry. The main aim of this project is to create a website where we could list our products to generate enquiries from potential clients. The website should have a user-friendly contact form that specifically collects the user's name and email, along with their message. Ideal skills and experiences for this job include: - Strong proficiency in WordPress and its plugins - Prior experience in developing product listing websites - Expertise in developing user-friendly contact forms - Knowledge of the hospitality industry would be a plus
Necesito crear una un excel con formulas que me calculen los montos acumulados segun una tasa de interes
Generar un reporte con tablas dinámicas nivel general y específico de una base de datos de 10,000 usuarios; se requiere mostrar presupuesto ocupado de 2023 y lo que va 2024; por diferentes áreas cómo se ha gastado el presupuesto, lo que se busca es un reporte como el del llamado ejemplo; pero con la información mostrada en base de datos; visualizar presupuesto utilizado por mes, y por usuario a nivel área.
Good I am making a script for a client in python, where I am building a program where the program will generate me 100 weekly emails at most, these emails must have a phone number associated with each of them a number, ie emails have to be valid, the customer wants to receive and send mails, I am looking for creation of server to receive and send mails with emails created by the python app. emails are created randomly and just like passwords with a custom domain. I speak a little English so if you know Spanish we would understand each other better.
...easy access to rulebooks - Installation of an egg session counter - Ability to trade Pokemon within teams - Automatic speed list generation for players and chosen Pokemon - Incorporation of a loyalty/friendship tracker - A user-friendly system for sorting, adding, and removing Pokemon from parties - A quest log/reminder feature for victory points - Capability to generate Fakemon within established rules Built in pokemart with the GM To easily adjust prices and what not along with ability to setup specials/deals Ability to set up towns (EX Team flow enters twist tree, changes quest log, changes mart?/ mystery eggs?) Ability to easily subtract and add combat stages Etc. (Both players and mons) with a button press Pre Programmed...
Description: We are seeking a digital marketing expert with experience in healthcare consulting to join our team. As a digital marketing expert, you will be responsible for developing and implementing effective marketing strategies for our healthcare consulting business. You will utilize your expertise to drive brand awareness, generate leads, and increase conversions. The ideal candidate should have a strong understanding of the healthcare industry and be familiar with the latest digital marketing trends and techniques. Responsibilities: Strategy Development: Develop and refine a digital marketing strategy that aligns with our business goals, focusing on specific revenue streams: Post-operative MLD Brazilian MLD Cosmetic Acupuncture Celluma light therapy and rental ...
I am looking for a social media expert to help promote my garden room design and build business to homeowners. The primary goal is to generate leads. Key Tasks: - Create and manage paid social media campaigns, primarily on Facebook and Instagram - Plan and post content that showcases completed projects and testimonials from satisfied customers - Monitor and optimize campaign performance to drive lead generation Ideal Candidate: - Experience in social media marketing, particularly lead generation - Proficient in leveraging paid social media, particularly on Facebook and Instagram - Skilled in creating compelling visual and testimonial-based content - Adept in analyzing campaign data and refining strategies for optimal results - Familiarity with the home ...
I'm looking for a skilled Excel expert to automate the formatting of a spreadsheet from a Quickbooks export. Key Requirements: - I primarily need the freelancer to set up and automate formatting in my Quickbooks Excel spreadsheets. - The final formatting should be both visually appealing and easy to read for the end user, we will provide guidance on what the end result should look similar to. Ideal Skills and Experience: - Strong proficiency in Excel, especially with automating processes and conditional formatting. - Previous experience working on projects involving data visualization and presentation. - A good eye for design to ensure the data is clearly differentiated and visually engaging.
I have a project that involves data entry from an Excel file. The data needs cleaning and formatting before entry, and the end goal is data analysis. I am looking for a freelancer who can help me with the following: - Excel Data Entry: Transfer data from an Excel file into a designated system. - Data Cleaning & Formatting: Ensure the data is cleaned and formatted correctly before entry. - Data Analysis: Help in structuring the information in a way that facilitates analysis. Ideal skills for this project include experience in data entry, Excel, and data analysis. Looking for a reliable and detail-oriented freelancer to complete this task efficiently.
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I require an experienced data cleaning specialist who can proficiently handle Excel spreadsheets. My project involves tidying up datasets related to customer, product, and financial data, though different types of data might need to be scrubbed too. This data cleansing task involves a lower volume dataset of less than 1,000 records. Key tasks include: - Identifying and correcting any inaccuracies. - Identifying and handling missing data. - Assuring the consistency of datasets. The ideal freelancer should have strong skills in spreadsheet management, a keen attention to detail, exceptional data analysis abilities, and a solid understanding of customer, product, and financial data. Experience in Excel and a proven track record in data cleansing are a ...
...individual who can help me scale my digital products, particularly my vendor list for entrepreneurs. I'm aiming to make sales in a week through a strategic ad campaign. Below are some key details about this project: - **Target Audience:** My main focus is on entrepreneurs, small business owners, and online shoppers. Your ability to tailor ads to these groups is crucial for the success of this project. - **Main Goal:** The primary objective of this ad campaign is to generate high-quality sales leads. Your approach should be sales-driven with a clear aim to convert leads to customers as efficiently as possible. - **Preferred Platforms:** I'm open to using a variety of platforms to run these ads. Specifically, Facebo...
I am looking for a detail-oriented professional to assist me with basic data entry tasks in Excel. The primary responsibility will be to input data such as names and addresses into an Excel spreadsheet. Key Responsibilities: - Inputting basic data into Excel spreadsheet Furthermore, the project requires data verification. This means ensuring that the data has been accurately entered. You will be required to cross-reference the inputted data against the source material to detect any discrepancies or errors. Ideal Skills & Experience: - Proficient in Excel - Attention to detail - Strong data entry skills - Familiar with data verification processes - Previous experience in basic data entry This project is quite straightf...
...competition. The software should be able to handle the registration of a large number of athletes and update itself based on the simultaneous outcomes of the various matches. The software should have the following capabilities: - Registration Management: It should provide a smooth process for athletes to register. I'm looking to gather basic information, such as their Name, Surname, and phone number. This database should be easily accessible and modifiable. - Real-time Match Result Updates: The software should be able to update the match results in real-time. This function is crucial for the smooth running of the competition and to keep the audience informed. - Automatic Match Schedule Generation: It would be ideal if the software could automa...
...looking for a skilled professional to assist me with various customer support, operation, and management tasks. - Handling Customer Inquiries: Please be prepared to manage customer inquiries through phone calls, email, and live chat. - Managing Customer Databases: This project requires proficiency in maintaining databases across various platforms including CRM systems, Excel spreadsheets, and online database platforms. - Analyzing Customer Feedback: An ideal candidate will have experience in analyzing customer feedback to help our services grow. The ideal freelancer for this project should possess: - Proven experience in customer support and management - Excellent communication and interpersonal skills - Proficiency in using various CRM systems, Excel...
We are looking for SEO for our mental health therapy practice (on and off page seo). We've tried several different SEO companies in the past. The website is: STLmentalhealth.co...website is: and we are a mental health therapy practice in St. Louis, Missouri, USA (we help people with anxiety, depression, stress, relationships, and grieving). The keywords we are most interested in are: st louis therapy, st louis therapist, st louis counseling, st louis mental health, therapist near me. We would also like DA to increase. We would like to generate more traffic as well. Lastly, we would like for our information to show up towards the top of local search on google (within 25 miles of Creve Coeur, Missouri, USA). Please let me know your thoughts and the cost. Tha...
I am looking for a savvy digital marketer who specializes in Facebook and Instagram marketing. The aim of this project is specifically to generate leads and ultimately increase sales. This marketer needs to have a proven track record in this capacity, ideally reaching consumer audiences (B2C). Key Responsibilities: - Develop and optimize effective lead generation strategies on Facebook and Instagram - Creation and managing of Facebook and Instagram profile - Understand our target consumer audience and tailor campaigns accordingly - Monitor and track performance of campaigns, adjusting as necessary Ideal Skills/Experience: - Proven experience in Facebook and Instagram marketing - Proven experience in social media marketing with demonstrable results in lead generati...
I am looking to escalate my social media presence with a focus on Facebook and Instagram. Consequently, I aim to generate more leads and sales and ultimately foster business growth. My strategy involves: - Content Creation: I require expertise in creating a range of content types, with an emphasis on image posts, video posts, and blog posts. Exceptional creativity and a strong sense of aesthetics are crucial. - Lead Generation: The core objective of this project is enhanced lead generation and sales. Therefore, a deep understanding of strategies to engage and convert social media users into customers is necessary. Ideal Candidate: - Profound experience in social media and digital marketing, particularly Facebook and Instagram. - Proven track record in generati...
I'm looking for a skilled Google SEO expert to help me increase my website traffic, enhance my online visibility, and generate leads through local SEO strategies. Key Responsibilities: - Improve my website's search engine rankings specifically on Google to increase website traffic. - Enhance online visibility in the local area, targeting local customers. - Develop and implement lead generation strategies through SEO. Ideal Candidate: - Proven experience in Google SEO with a successful track record of improving website traffic. - Expertise in local SEO strategies to target specific regions and audiences. - Adept at lead generation through SEO techniques. - Ability to analyze website performance to make data-driven decisions. - Experience...
generate panel with graphics, such as, pie, bar column. with asp.net
I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of tic...
I need emails from these companies of CEO ot anyone else working in financials, sales, or partnerships. Data scraping from rocketreach of the emails of the people that you can find with relevance from these companies in the image. Excel sheet with company name in the rows and in the 3 columns full name, email and position in the company
Data entry operator and my work very clear
I'm in search of a dedicated and skilled individual to conduct thorough and thoughtful product research for me. The job entails researching products across a variety of categories on Amazon, with the aim of identifying promising product ideas. These ideas should meet the following criteria: - High demand: Products with a demonstrated and sustained demand on the platform - Low competition: Products that aren't overly saturated on Amazon - Profit margins: Products that offer substantial profit potential - 100% successful launches in past 90-180 days Your task will be to generate 5 such ideas for me, presented in an organized and easy-to-understand manner. Ideal skills and experience for this job include: - Proven experience in product research, idea...
I am seeking an Instagram manager who can assist in niche targeting for my project...am seeking an Instagram manager who can assist in niche targeting for my project. Our audience comprises of both males and females, specifically in the age group of 20-34 who are passionate about anime. To successfully help with this project, below are some skills and experiences that would benefit: - Previous experience in Instagram management - Familiarity with the anime culture - Understanding of youth trends among young adults - Ability to create appealing, anime-themed content - Good grasp of the Instagram algorithm for targeting specific niches Your main role will be to generate engaging content that resonates with our audience, maintain activity, and attract followers...
I'm looking for an experienced professional in Excel to create a custom financial tracking template for me. Bonus if compatible with both google sheets and excel. Key Elements: - The template needs to include sections for tracking income and expenses. - Additionally, I need sections for debt repayment tracking and Year To Date (YTD) tracking. - The template should be designed in a way that it is easy to update monthly Ideal Skills: - Proficiency in Excel and experience in creating financial tracking templates. - Knowledge of financial principles and ability to design a user-friendly, visually appealing template. - Attention to detail and ability to customize the template to meet my specific requirements. ...
we need a packaging insert design for our "JAKAX" Amazon brand which is cushion , pillow brand This design should be in golden color throughout. Totally four pages, I have given the necessary content on all four pages. I have given below what changes are required on any page but I want a better design. You can use small images and emojis to make it attractive to look at. I have also given below the QR code and my brand logo to be attached. NOTE ; Each pages should be A5 size ,All pages should be printed in A5 size. I have given the necessary changes page wise as follows Page 1: Add a line that says "sit back relax and enjoy" and use images and emojis to make the first page look good. Page 2: The second page is a letter from a...
I am looking for a seasoned web application developer to build a dynamic time registration/working day application from my project requirements and sketches. Key Application Functionalities: - Clock in/out: Users should be able to clock in and out, accurately logging their working hours. - Timesheet Generation: The application should automatically generate comprehensive timesheets. - Leave Requests Management: Users should be able to manage their leave requests seamlessly. - User Management: Including user registration, login, roles and permissions, and user profile management. User Management Features: - User Registration & Login: Ensure robust user registration and login functionality. This should be based on email and should also include a 'forgot...
...with excellent graphic design abilities to create effective campaigns, with the goals to notably increase website traffic and generate high-quality leads. Ideally, the successful candidate should have a proven track record in executing high-budget ad campaigns effectively, with appreciable results. Key responsibilities: - Identifying target audience and devising digital campaigns that engage, inform and motivate - Designing and creating highly engaging visual ad content - Regularly monitor and optimize the campaigns for maximum performance Requirements: - Solid knowledge of website analytics tools (e.g., Google Analytics) - Experience in setting up and optimizing Google Adwords campaigns - Strong analytical skills and data-driven thinking - Up-to-date with...
I'm looking to create a detailed list in Excel from the website AND filtered by clicking on 'Hardware' under 'Products' which is on the left side in the 'Filter' section. The list should have two columns - the first for the Company Name and the second for the Description available on the website. Key Requirements: - Copy the Company Name into Column 1 and the Description into Column 2 of the Excel sheet. - Description should be directly copied from the provided URL. Ideal Skills and Experience: - Proficient in Excel and web scraping. - Attention to detail to ensure accurate data transfer. - Previous experience with similar projects would be advantageous.
Excel Chart Re-Design for University Work Allocation System We are looking for somebody to complete the development of an excel-based teaching allocation database for a relatively large university department (approx 100 teaching staff). We currently make use of an excel template that roughly cross-references university courses with teaching staff and allocated time commitments for specific tasks. This is quite a complex information array, however, with so many staff members and courses (approx. 120), especially where multiple staff members are co-teaching courses with different task responsibilities. While our current template achieves its desired information management purpose, in its present state its structure is relatively complex and not user-frien...
Looking for an expert who can bring my educational content to life with vibrant, engaging 3D animations. The animations should be a blend of character-based and abstract to maintain viewer interest. Key Requirements: - Skilled storyteller through 3D animation. - Experience in character-based and abstract animation. - Excel in conveying complex information simply and clearly, ideally within an educational setting. - Ability to work collaboratively, ensuring your creations align with my vision. Enhance your bid with relevant work samples, especially animations used for educational purposes. I am excited to see your creativity at work!
...accountant to assist with the following: - Financial Statements Preparation: As part of the role, you'll be responsible for preparing accurate and detailed financial statements for my business. - Tax Preparation: You should also be well-versed in tax preparation, ensuring my business is compliant with all tax obligations and regulations. To apply for this role, I require that you submit past work samples showcasing your experience in similar roles. Please ensure your application is detailed and highlights your expertise in accounting. I prefer communication to be done via email as it's my preferred means of contact. Ideal skills and qualifications for the job: - Proven experience in financial statements preparation - Extensive bac...
I am looking for a Racket deve...LL1 grammar. The main goal of this project is to develop a simple grammar for parsing and code generation. Key Requirements: - Proficient in Racket: You should be well-versed in Racket programming language. - Grammar: Experience in developing grammars, especially LL1, is essential. - Code Generation: The ability to generate code based on the parsed grammar. - Complexity: The language to be developed will be simple in nature, with less than 10 rules. This project will involve: - Crafting an LL1 grammar for the simple language. - Implementing the parser for the grammar. - Developing a code generator based on the parsed language. If you have experience in Racket, grammar, and code generation, and are interested in this project, I...
I'm in urgent need of an efficient solution to print Barcodes and QR codes directly from an existing printer. This solution will aid in the swift management of my inventory, product tracking, and ticketing procedures. Key aspects: • Barcode/QR Code Generation: I need the ability to generate a wide range of barcodes and QR codes to meet different needs. • Printer Compatibility: As I already have a barcode printer, the solution should be compatible with my existing equipment. • Fast Turnaround: The project completion is needed ASAP. Quick delivery of the solution is of essence to my operation. Ideal skills for the job would be expertise in barcode generation, understanding of inventory and ticketing systems, and familiarity with vari...
