Vba generate report 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.
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 have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
I have an Amazon security audit and they require a Penetration Test of my windows desktop application. What I need is a automated tool to test and provide a report that shows my application does not have security issues and is not accessible from the web. There is no end-point to my application as it is not web facing and is a stand alone application. This is to satisfy Amazon security review. I'm looking for a skilled professional to conduct a penetration test on my Windows desktop application. Key Requirements: - Conduct a automated penetration test specifically tailored for a Windows desktop application. - Ensure the test covers all potential vulnerabilities and security risks. - Provide detailed reports on the findings, including any exploits, weaknesses, and area...
...Entities: The project involves five main entities: students, admin, class, exam, hall, and scheduling. - CRUD Operations: The system should allow for Create, Read, Update, and Delete operations for the mentioned entities. Admin User Features: - Access Control: The admin user should have the ability to control user access and manage permissions. - Reports Generation: The system should be able to generate exam scheduling reports. I will provide you with the Swaggy API list for this project. The deadline for this project is Saturday night. Ideal skills and experience: - Proficiency in React - Previous experience in building CRUD applications - Understanding of user access control and reporting functionalities - Ability to work with provided APIs - Deadline-oriented with excell...
I'm seeking a professional who can help me with pre-employment vetting specifically focusing on employment checks. Key Points: - I need a comprehensive employment verification report for potential employees. - The report should include basic details such as dates of employment and job titles. Ideal Skills and Experience: - Proven experience and expertise in conducting employment checks. - Attention to detail for ensuring accuracy in the reports. - Excellent communication skills to facilitate smooth interactions with past employers. - Strong understanding of employment laws and regulations.
I'm looking for a skilled software tester to help with the beta testing of my latest software program. Key Requirements: - The software program is designed for Windows operating system, so you need to be well-versed with this environment - The main focus of the testing should be on the performance an...program is designed for Windows operating system, so you need to be well-versed with this environment - The main focus of the testing should be on the performance and speed of the program Ideal Skills and Experience: - Previous experience in software testing, especially beta testing, is highly preferred - Strong understanding and experience working with Windows OS is a must - Ability to analyze and report on software performance and speed, providing actionable recommendations ...
I'm looking for a skilled software tester to help with the beta testing of my latest software program. Key Requirements: - The software program is designed for Windows operating system, so you need to be well-versed with this environment - The main focus of the testing should be on the performance an...program is designed for Windows operating system, so you need to be well-versed with this environment - The main focus of the testing should be on the performance and speed of the program Ideal Skills and Experience: - Previous experience in software testing, especially beta testing, is highly preferred - Strong understanding and experience working with Windows OS is a must - Ability to analyze and report on software performance and speed, providing actionable recommendations ...
I'm looking for a talented developer to build a web-based POS system with a focus on insightful daily sales reporting. Key Features: - Web-based POS system: The system should be accessible through the website itself, offering an intuitive interface for easy use. - Daily Sales Reporting: It's crucial that the system provides detailed and comprehensive daily sales reports. These reports should be easy to read and interpret. - Customization: The system should allow for future customization and integration of additional features, as the business grows. Ideal Skills: - Proven experience in developing POS systems, particularly web-based. - Strong understanding of sales reporting and data analysis. - Ability to create user-friendly interfaces. Please share relevant experience, and p...
I'm looking for a professional email marketing agency that can manage an email campaign for me. Essential skills/experience required: - Proficiency with email service like mailchimp or similar - Previous experience in email marketing, particula...skills/experience required: - Proficiency with email service like mailchimp or similar - Previous experience in email marketing, particularly in promoting products - Ability to send follow-up email Key deliverables: - Sending out 350 emails using our email id - Creating and sending follow-up emails - Providing a detailed report on the campaign's performance Please note, I have a template for the emails already. I also have the database of the people to send out in excel format - company name, email, first name and last ...
...Limassol, Cyprus • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Please see the attached file for the site visit guideline. You are only required to deliver the pictures, video & observations and are not expected to put together a report like the Sample Report. Note: Milestone will be released the following week after the site visit to give us time to organize the report and contact you if we need additional clarification....
I'm in need of an experienced digital marketer who can create a high-quality TikTok video ad for my personal account. The primary aim of this video ad is to generate leads and bookings for my hotel apartment business. I specifically want this ad to target business travelers, so understanding their preferences and requirements is crucial. Key Requirements: - The style of the video ad should be informative and straightforward. It should clearly and concisely communicate the benefits and unique selling points of my hotel apartment. - The video ad should be engaging and relevant to the target audience. The ideal candidate should have a good understanding of the preferences, interests, and behavior of business travelers. - Prior experience creating successful TikTok video ads, wit...
I'm on the lookout for a diligent freelancer to help in testing the gameplay balance of our latest PC game. The core focus of your responsibilities will be: - **Gameplay Testing:** Deep dive into the gameplay, ensuring the mechanics are engaging and balanced. - **Balance Issues Identification:** Critically analyze and report on gameplay balance. This involves playing through the levels, understanding the game mechanics, and identifying areas that feel too easy or too challenging. - **Feedback & Suggestions:** Provide constructive feedback on how to improve gameplay balance. Your insights will be invaluable in tuning game mechanics to enhance the player experience. **Ideal Skills and Experience:** - Proven experience in PC game testing, particularly gameplay aspects. - Kee...
...marketing expert who can help me boost my sales through social media platforms. In particular, I'm looking for someone who can create engaging image posts to capture the attention of my target audience. Key Responsibilities: - Devise and execute strategies to promote sales effectively on social media - Create compelling image posts that resonate with my target audience - Regularly analyze and report on the success of the sales-boosting campaign Ideal Skills and Experience: - Proven track record of successful sales campaigns - Strong understanding of social media platforms and their nuances - Proficiency in creating engaging visual content, particularly image posts - Excellent analytical skills to measure campaign performance If you have a knack for sales, a passion for e...
I'm in need of a skilled designer to create a high-converting landing page. Initially, I'll need one landing page to assess the quality of your work. If it meets my expectations, this will be an ongoing project with a new landing page needed every week. Key requirements: - Design a single, high-quality landing page that is optimized to generate leads. - Be able to deliver consistently on a weekly basis. - Understand the principles of user experience (UX) and design a page that maximizes conversions. Ideal freelancer: - Proficient in landing page design, particularly for lead generation. - Capable of delivering high-quality work on a weekly basis. - Experience with UX/UI design and conversion rate optimization is a plus.
I'm on the lookout for a diligent freelancer to help in testing the gameplay balance of our latest PC game. The core focus of your responsibilities will be: - **Gameplay Testing:** Deep dive into the gameplay, ensuring the mechanics are engaging and balanced. - **Balance Issues Identification:** Critically analyze and report on gameplay balance. This involves playing through the levels, understanding the game mechanics, and identifying areas that feel too easy or too challenging. - **Feedback & Suggestions:** Provide constructive feedback on how to improve gameplay balance. Your insights will be invaluable in tuning game mechanics to enhance the player experience. **Ideal Skills and Experience:** - Proven experience in PC game testing, particularly gameplay aspects. - Kee...
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
I'm on the lookout for a diligent freelancer to help in testing the gameplay balance of our latest PC game. The core focus of your responsibilities will be: - **Gameplay Testing:** Deep dive into the gameplay, ensuring the mechanics are engaging and balanced. - **Balance Issues Identification:** Critically analyze and report on gameplay balance. This involves playing through the levels, understanding the game mechanics, and identifying areas that feel too easy or too challenging. - **Feedback & Suggestions:** Provide constructive feedback on how to improve gameplay balance. Your insights will be invaluable in tuning game mechanics to enhance the player experience. **Ideal Skills and Experience:** - Proven experience in PC game testing, particularly gameplay aspects. - Kee...
I need a professional who can analyze the logs of my Apache PHP-FPM server and help me troubleshoot errors. The main focus of this task is to identify and resolve any issues that might be impacting the performance of the server. Key Requirements: - The ...troubleshoot errors. The main focus of this task is to identify and resolve any issues that might be impacting the performance of the server. Key Requirements: - The ideal candidate should have a solid understanding of Apache PHP-FPM logs and their structure. - Good troubleshooting skills are necessary to pinpoint the root causes of the errors. - Ability to present the analysis results in a detailed report is crucial. The main goal is to ensure the server is running smoothly and efficiently. The server use Centos 7, Apache a...
I'm looking for a seasoned field marketer who can successfully drive lead generation in the Healthcare industry. Primary responsibility: - Generate qualified leads Method of lead generation: - Field marketing Skills and experience necessary for this role: - Proven experience in field marketing and lead generation - Proficiency in navigating the healthcare industry - Exceptional interpersonal and communication skills. Please detail your experience with Field Marketing and lead generation in the Healthcare industry when submitting your proposal.
One of our clients is looking for a literature search with a view to searching the Pubmed database using the inclusion and exclusion criteria and providing a document containing the output. The details of the literature search can be found in the following link. The...style of Vancouver Style. There is no restriction on the number of words. Requirements: - Conduct a thorough search on PubMed focusing on Medical Informatics - Provide a detailed summary of abstracts found in the search - Ensure the search is comprehensive and up-to-date Ideal Skills: - Proficiency in using PubMed - Knowledge and understanding of Medical Informatics - Ability to summarize and report on the search results Please ensure that you have experience in this area before bidding on the project.
I'm in need of an experienced social media manager and content writer who can help me boost my online presence. Key Responsibilities: - Manage social media accounts (platforms to be...content that reflects the voice and tone of my brand. I am open to suggestions for content topics, but expect the freelancer to be able to create content that is engaging, relevant, and shareable. Ideal Skills and Experience: - Prior experience in social media management - Proven track record in content writing - Understanding of SEO and online marketing - Creative thinker with the ability to generate new ideas for content - Good communication skills to work closely with me on our content strategy Please apply with work samples that demonstrate your ability to manage social media and write en...
...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen co...
I'm on the lookout for a diligent freelancer to help in testing the gameplay balance of our latest PC game. The core focus of your responsibilities will be: - **Gameplay Testing:** Deep dive into the gameplay, ensuring the mechanics are engaging and balanced. - **Balance Issues Identification:** Critically analyze and report on gameplay balance. This involves playing through the levels, understanding the game mechanics, and identifying areas that feel too easy or too challenging. - **Feedback & Suggestions:** Provide constructive feedback on how to improve gameplay balance. Your insights will be invaluable in tuning game mechanics to enhance the player experience. **Ideal Skills and Experience:** - Proven experience in PC game testing, particularly gameplay aspects. - Kee...
I'm on the lookout for a diligent freelancer to help in testing the gameplay balance of our latest PC game. The core focus of your responsibilities will be: - **Gameplay Testing:** Deep dive into the gameplay, ensuring the mechanics are engaging and balanced. - **Balance Issues Identification:** Critically analyze and report on gameplay balance. This involves playing through the levels, understanding the game mechanics, and identifying areas that feel too easy or too challenging. - **Feedback & Suggestions:** Provide constructive feedback on how to improve gameplay balance. Your insights will be invaluable in tuning game mechanics to enhance the player experience. **Ideal Skills and Experience:** - Proven experience in PC game testing, particularly gameplay aspects. - Kee...
I'm seeking a sales consultant with expertise in the hotel industry to generate leads and drive sales, primarily from hotel owners. Key Objectives: - Lead Generation: The main goal of this project is to identify and attract potential customers specifically from the hotel industry. Your prior experience in sales in this sector is essential in understanding the nuances of this market and effectively generating leads. - Lead Conversion: While generating leads is important, converting them into actual sales is equally crucial. You should be proficient in sales techniques and understand the hotel industry well enough to effectively convert leads into customers. Ideal Candidate: - Prior Experience: A strong background in sales, particularly in the hotel industry, is a must. You sho...
...but distinct (random choice of colours) for each pair. After pressing a key a third image will be displayed containing the first image pasted to the second image on a black background. For this, the image registration algorithm will be implemented, which calculates the geometric affine transformation based on the least squares method. Inverse mapping with bilinear interpolation will be used to generate the resulting image. When a key is pressed, two other images are selected and the process is repeated. - Skills Required: A robust understanding of computer vision and experience with image stitching methods are vital. This comprises knowledge of fitting, blending techniques, and various algorithms to ensure the smooth blend of two separate images, in OpenCV. Please note: - I requ...
I'm searching for an outstanding social media marketer who can focus on Facebook and Instagram for a lead generation campaign. Your main objective should be: - Generate leads I’d appreciate it if you have: - Demonstrated ability in creating effective social media strategies - Experience managing successful lead generation campaigns on Facebook and Instagram - Knowledge of how to target and engage the 26-35 age group If you have the right skills and experience, I would be happy to discuss the project further.
I'm in need of an experienced freelancer who can provide employment verification services. The role of the freelancer would be to verify the employment dates and job title of a candidate. The results of the verification should be presented in a written report. Key responsibilities include: - Verifying employment dates and job title - Ensuring accuracy and reliability in the verification process - Compiling all the verified information into a clear and concise written report I'm looking for a professional with: - Previous experience in employment verification - Strong attention to detail - Excellent written communication skills - Understanding of the importance of confidentiality in this process The ideal candidate will be able to deliver accurate and timely resu...
I'm in search of a skilled social media marketer who can use their expertise and experience to help generate leads for my business. Key Responsibilities: - Strategize, develop, and execute social media campaigns across Facebook, Instagram, and Twitter - Drive engagement with our target audience - Implement lead generation techniques to convert followers into potential leads - Track and measure the effectiveness of the campaigns to ensure they align with our lead generation goals Ideal Candidate: - Proven track record of lead generation through social media - Proficiency in Facebook, Instagram, and Twitter marketing - Understanding of various social media analytics tools - Strong communication and interpersonal skills - Creative thinker with the ability to develop innovative ...
Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.
I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.
...security perspective - Audit the configuration and setup of network appliances (routers, switches, firewalls) for security best practices - Review and optimize the SIEM (Security Information and Event Management) solution's use cases for quality, coverage, and effectiveness - Conduct a comprehensive Digital Forensics and Incident Response (DFIR) assessment, including producing a detailed incident report - Provide recommendations for enhancing DDoS mitigation capabilities, incident response processes, and overall security posture - Collaborate with client stakeholders, including IT security teams, network administrators, and executive leadership Qualifications: - Minimum 5 years of experience in cybersecurity consulting, with a focus on DDoS protection, incident response, a...
...but distinct (random choice of colours) for each pair. After pressing a key a third image will be displayed containing the first image pasted to the second image on a black background. For this, the image registration algorithm will be implemented, which calculates the geometric affine transformation based on the least squares method. Inverse mapping with bilinear interpolation will be used to generate the resulting image. When a key is pressed, two other images are selected and the process is repeated. - Skills Required: A robust understanding of computer vision and experience with image stitching methods are vital. This comprises knowledge of fitting, blending techniques, and various algorithms to ensure the smooth blend of two separate images, in OpenCV. Potential freelancers...
I'm in need of a thorough background check of a potential employee in Malaysia. This requires searching for and providing information on criminal convictions, arrests, and sentences. Key Requirements: - Check for Convictions, Arrests, and Sentences: The primary aim of this screening is to u...law enforcement, or private investigation would be beneficial. - Discretion: Given the sensitive nature of this task, utmost discretion and confidentiality are mandatory. - Thoroughness: A keen eye for detail is required to ensure no stone is left unturned in this search. I'm looking for a professional with proven experience in similar tasks to ensure the accuracy and comprehensiveness of the report. Please provide relevant experience in your proposal. IF Record found Screenshot ...
We're a dynamic agency specializing in helping businesses stand out on YouTube. We're currently on the lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniq...techniques specific to YouTube. - Proficiency in utilizing analytics tools to drive decisions and enhance content performance. - Strong creative skills for developing eye-catching thumbnails and titles. - Passionate about the YouTube platform and staying up-to-date with the latest trends and algorithm changes. If you're ready to join a results-driven team and help businesses across various industries excel on YouTube, we'd love to hear from you. A perfect opportunity to apply your SEO exp...
On-page: Improve the header, mobile version, and add a footer. Create blogs similar to but we'll provide the keywords. In your bid, mention how many blogs can you provide with the bid price. 200 Do-follow High Quality backlinks from PR3-Pr4 Sites with at least DA 30+: A final report will be provided by you with links, website name, DA and PR values on a list. Error Free list Note: No backlink from social media sites, forum, comments, directory, listing, or SEO driven site.
...website and handle the digital marketing aspects of my project. Website Design: - I'm looking for a clean, professional, and user-friendly design that is optimized for lead generation. - Experience is must for management once website is done. Digital Marketing: - I'm seeking support for Google Ads and possibly other digital marketing tools to increase visibility, drive traffic, and ultimately generate leads. - Any additional suggestions or strategies to enhance the overall digital marketing strategy are welcome. Ideal Skills and Experience: - Proven experience with lead generation through websites - Strong knowledge and experience in Google Ads - Expertise in other forms of digital marketing is a plus, though not required. Please note: The digital marketing ser...
I'm in need of a skilled web developer to set up a secured tutoring scientific website. This platform will facilitate online classes, between Students, Instructors and Schools (the field of study will be discussed personally) Student Privileges Student, Instructor and School Registration phase. Where they can setup their accounts and generate their Profile Cards. There are two categories of Student Accounts (School Registered or Free) New Session page: where the student can select Subject & Topic, and mention questions if required. Then, Instructor Selection Phase: An interface to let students select a suitable instructor, for their subjects based on the instructor's predetermined disciplines, then select date/time according to Instructor's calendar availability...
Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code
