Excel macro validate date format 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.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
I am in search of creative designers who excel at crafting whimsical, cartoon-style characters, specifically, rubber hose characters. While I have skipped specific details about design features and character attributes, I will be open to your individual style and interpretation. Key Requirements: - Proficiency in cartoon-style character design - Strong creative instincts - Ability to incorporate your individual flare while balancing the foundational aesthetics of rubber hose characters Please share your portfolio when bidding, especially any work related to cartoon style characters. This will help me assess if your style could be a great fit for this project.
I need a professional who can help me recover a password for an Excel XLSM file. Key Requirements: - Recover a lost password for an Excel XLSM file - Ensure the process is secure and compliant with standard security practices - Maintain the integrity and functionality of the document post-password removal Ideal Skills: - Proficient in password recovery methods for Microsoft Excel - Experience in data security and encryption - Strong knowledge of Excel XLSM file structure
I'm in need of a professional who can convert my PDF files into Word format. The converted Word file should retain specific elements such as headers and footers, tables and charts, and images and graphics. Key Points: - Convert PDF files into Word format - Retain headers and footers, tables and charts, and images and graphics Ideal Skills and Experience: - Expertise in PDF to Word conversion - Proficient in Microsoft Word - Strong attention to detail - Ability to maintain the integrity of the original design and layout - Prior experience in prioritizing and maintaining specific elements during conversion - Efficient in handling short documents (less than 10 pages)
DETAILS: Name: Benjamin Date: 6/23 3:30PM Address: 13 Musket Lane Eatontown 'm looking for a creative graphic designer to help me create a sweet and unique first birthday card for my child. - Design: I'd like the card to feature a Teddy Bear theme, considering it's for a child's birthday. The overall design should be cute, colorful, and playful. - Size: The dimensions of the card should be A6 (105mm x 148mm), keeping it small and compact, yet still visually appealing. - Elements: While I haven't chosen specific elements, feel free to incorporate a Teddy Bear with a birthday cake, balloons, or a party hat to make the design more celebratory and fun. The final deliverable should be in a high-quality, printable format, and I'm open to your c...
We need someone to create a very simple Botpress chatbot. Please read the file attached to this project. Pay is $50 and should not take but a couple hours to complete. I will pay the project max ($30) + $20 bonus if this is done in 1 day. I would like to install this on our wordpress website as a full page bot with a link. We will only respond to people who clearly read the document that is attached to this project. NOTE: So far, I have deleted all bids because no one has actually responded to reading our documents. At the moment, there are 14 bids and all have been disregarded.
...ensuring efficient email communication directly from ClickUp, and setting up an automated invoicing system with Xero. Additionally, we require training and instructional materials to ensure our staff can effectively use and benefit from these new systems. Responsibilities ClickUp Automation: Design and implement automations for task assignments, due date adjustments, status changes, and more. Ensure the system is flexible so that if a due date is changed, the adjustment flows through the entire checklist, maintaining dependencies and task sequences. Set up triggers to initiate automations based on specific actions (e.g., task creation, completion, or status change). Email Integration: Integrate our email system with ClickUp to enable direct email sending from within Click...
...company's current logo to convey trustworthiness and corporate professionalism. -Entries must be presented in 2D format as it would appear on a letter head not as a sign, billboard etc Company Background: -On-Guard Sanitisation specializes in Bio-Hazard Decontamination. Requirements: -Company Name: On-Guard Sanitisation -New Slogan: Experts in Biohazard Remediation -Design Elements: The shield must be the Shield in IMAGE 3 with the biohazard logo in the shield behind the curved stripe filling the whole shield with the biohazard logo. -Font: Must be similar to that of IMAGE 5 -Color Scheme: Continue the current color scheme of blue and green. -Format: Logo must be in a header format. -Style: Modern and versatile, conveying trust and professionalism. Prefere...
I'm seeking a skilled professional to create a comprehensive loan statement on an Excel spreadsheet. Key Project Details: - I need all transactions included in the statement, ensuring the document is fully up-to-date. - The statement should not only present the transactions but should also include complex calculations such as interests, balances, etc. - As I'm looking for this as a one-time service, the statement should be designed to be updated annually. Ideal Skills: - Proficiency in Excel is a must; the ability to handle complex calculations is highly preferred. - Previous experience in creating and maintaining financial spreadsheets, particularly loan statements, is a significant advantage. - Attention to detail is crucial to ensure all transactions ar...
I have a lot of data in a spreadheet. Have a look at attached spreadsheet. I need the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 10 in "auto made" sheet. This row 10 need to be deleted to make the spreadsheet work for my import
I'm in need of a graphic designer who specializes in logo tracing and format conversion. The tasks for this project include: - Tracing my existing, low-resolution logo - Exporting the trace in a vector file format - Making specific alterations in the logo's color scheme The traced logo will be used across both digital media and physical printing, therefore it needs to be of high quality and versatile. Knowledge in various compatible formats for different platforms would be of great benefit. The ideal freelancer for this project should have a strong background in logo design and color theory. Experience with tracing low-resolution designs and converting them into a vector format is crucial. Note that some colors will need alteration; a keen eye for aesthe...
...as players progress through the endless waves, keeping gameplay engaging and unpredictable. - Design dynamic environments that evolve and present new obstacles or opportunities as players face more difficult waves of zombie pets. - Introduce periodic challenges and special events within the endless mode to shake up the gameplay and provide additional objectives or rewards for players who excel in their survival efforts. 5. Art and Sound Design: - Create visual cues and feedback that convey the increasing intensity and complexity of each successive wave of zombie enemies as players persevere. - Develop audio cues and immersive sound effects that enhance the tension and excitement of facing relentless zombie onslaughts in the endless mode. - Design striking visual e...
**Overview:** Seeking a Virtual Assistant with expertise in Romance languages to help translate and format documents. Proficiency in ChatGPT-4, Microsoft Word, and PDFs is essential. **Responsibilities:** - Translate and mirror format documents into Romance languages. - Use ChatGPT-4 for translation assistance and editing. - Handle document formatting in Word and PDF. **Qualifications:** - Linguistics major, specializing in Romance languages. - Skilled in Microsoft Word, PDF editing, and ChatGPT-4. - Excellent grammar and punctuation skills. **Pay:** - $3.00 USD/hour
**Project Overview:** We are seeking a professional video editor to create a dynamic and engaging 30-second video for social media. The video will feature the opening of a box of trading cards and will highlight th...Clearly display the final profit or loss figure. - Include a call-to-action (e.g., "Follow us for more exciting box openings!"). **Style and Tone:** - Energetic and engaging to capture the audience's attention. - Use vibrant graphics and animations to highlight card values. - Incorporate background music that complements the video’s excitement. **Deliverables:** - A 30-second edited video in a format suitable for social media platforms (e.g., Instagram, Facebook, TikTok). - A version of the video with subtitles/captions. - All raw footage and p...
...transformed to the best quality possible. Key Elements: - Restoration: The photos have some wear and tear due to age. I would like the restoration to smooth out any visible damage, such as scratches and spots, without losing the original image's essence. - Enhancement: While restoring the photos, I would also like them enhanced. I would like them to remain black and white and still look old with the date remaining at the top. Delivery: - I'm looking for the restored and enhanced photos to be delivered as digital files. This will be convenient for me as I plan to keep them digitally. Experience and Skills: - Proven experience in photo restoration and enhancement is crucial. Portfolio of similar projects will be a big plus. - Attention to detail and the ability to car...
...(logo and photos can be taken from our website ). A compelling tagline (e.g., "Experience Luxury by the Beach" or "Your Private Paradise Awaits"). Contact information (phone number, website, and social media handles). Colors and Fonts: Use sophisticated and inviting colors. Fonts should be clear and readable from a distance. Size and Format: The final design should be scalable to 16x8 feet and provided in high-resolution format (AI, PSD, or similar). Submission Guidelines: Submit your design in high resolution. Include a brief description of your design concept and how it aligns with the luxurious and exclusive nature of Villa Royale. Ensure your design is original and not infringing on any copyrights. Evaluation Criteria: Creativity and originalit...
I'm in need of a skilled Shopify developer with solid experience in data import from Excel. Specifically, you'll be dealing with: - Product data import into my Shopify site from a URL download of a CSV - Importing simple data, without dealing with variants or complex attributes. - syncing of the products in the CSV with Shopify products would happen every 24 hours automatically - If an existing product on Shopify is not found on the CSV download, its status on Shopify needs to be changed to "draft" or "inactive". The ideal candidate should have: - Strong Shopify development skills - Familiarity with Excel or similar data management tools - Experience with product data migration or import Success in this project would mean a seamless integrati...
...database of all products and services, including descriptions, prices, and images. • Quote Customization: Ability to add, remove, or adjust items and quantities in the quote. • PDF Generation: Convert the final quote into a PDF format for easy sharing and printing. • Email Integration: Directly email the quote to the client from the app. 3. Work Order Management This tool will help manage tasks and ensure timely completion of work orders. Features to Include: • Task Creation: Ability to create new tasks with descriptions, assigned personnel, and due dates. • Due Date Tracking: Alerts and reminders as due dates approach. • Status Updates: Options to update the status of tasks (e.g., In Progress, Completed). • Reporting: Generate...
...scraping, data compiling, and spreadsheet management will be greatly valued for this project. Accuracy, timeliness, and consistent daily delivery are crucial aspects of this job. Understanding of automation tools for data scraping would be a big plus. I am looking to collate some data from this website and need an ongoing scrape of this website to set up an ever-updating excel spreadsheet with the fields as per the attached excel file. Go to the website Go to Horse Index A-Z Starting with letter A all the way through to the letter Z Most of the fields will be self-explanatory. Some have been separated. Eg 1st 2nd 3rd Starts
Need to animate a logo in after effect software mp4 and gif format needed
I'm in need of a Python GUI software to automate sending messages through Google Voice. The software should be able to perform the following functions: - Send messages to individual contacts on Google Voice - Support precise date and time scheduling for these messages -Automated Sending with customized message example: message example {name} and {adsress} -Custom delay settings for each message -Multiple Profile Sender (custom threads) with multiple Proxy support (enable/disable proxy) -Auto login accounts - Auto Skip Terminated Accounts -License system for users -Sending reports Ideal Skills and Experience: - Proficient in Python programming - Experience in developing GUI applications - Familiarity with Google Voice API is a definite plus - Strong understanding of message s...
I'm in need of a Tennessee-based civil engineer to verify and stamp a set of site plans for a residential development. The project is urgent, requiring completion w...engineer with prior experience in residential development projects. - Tennessee certification: A thorough understanding of Tennessee's building regulations and experience with site plan stamping in the state is essential. - Attention to detail: The site plans need to be carefully reviewed and verified for accuracy and compliance with local regulations. The existing site plans are available in PDF format. The successful candidate will need to redraw them as necessary, ensure they meet all necessary requirements, and then provide the stamp of approval. The project offers a competitive rate, reflecting the urge...
..., only certain locations or only scheduling). Teacher Management Teacher Data Upload: Module to add and update teacher information, including: First and last name Email Phone number Subjects taught (both theoretical and practical) Hourly and daily availability Locations where the teacher is available to teach Intuitive interface for quick data entry with the ability to import data from CSV or Excel files. Tabular view of teachers with search and filter functionalities. Hourly and Daily Availability: Interactive calendar to set daily and hourly availability of teachers. Drag-and-drop functionality for easy time adjustments. Ability to set recurring availability (e.g., every Monday from 9:00 to 11:00). Option to add notes or comments for each availability block. Selection of loca...
I am seeking an experienced photo retoucher who can quickly work through a batch of over 330 headshot images. Key Tasks: - Basic retouching, including blemish removal and color correction. - The styling should follow a more stylized look akin to fashion or beauty photography. - The final images should be in JPEG format. Ideal Skills: - Photo retouching and color correction expertise. - Ability to deliver high-quality work quickly. - Proficiency in JPEG format. - Experience in fashion or beauty photo retouching. Please provide your turn around time and your quote for this project. Thank you!
...enhance search engine visibility. Performance Optimisation: Focus on fast loading times through optimised code, image compression, and other performance enhancement techniques. Image Optimisation: Utilise modern image formats and compression techniques to speed up initial page loads. Maintenance and Support: Ongoing Maintenance Plans: Provide plans for ongoing maintenance to keep the website up-to-date and secure. Technical Support Availability: Offer reliable technical support to address any issues promptly. How to Apply: If your team has a proven track record in ReactJS development and meets the above criteria, we’d love to hear from you. Please provide: A brief introduction of your team. Examples of similar projects you have completed. Your approach to clean code p...
...service sticker design that fulfills the triple goal of promoting my brand, enabling easy contact, and tracking service history. -Key Details: 1. Size specifics: The sticker should be designed within an expected dimension of 150mmx150mm, rendering it sufficient visibility. 2. Essential info: It needs to include necessary details like the company logo, contact details (phone, email), service date, mileage, and service description, making it informative and user application friendly. -Required Experience & Skills: The freelancer should have relevant experience in branding and graphic design and proficient in creating engaging sticker designs that evoke brand identity. An understanding of the technical aspect of the services offered would be beneficial. Overall, I&#...
I'm looking for someone to curate text and image data for me and compile it into an Excel document on a monthly basis. The successful contractor will have experience with using the Internet to collect data and be able to present it in a structured and organized manner. This data needs to be sourced from reliable sources, checked for accuracy, and edited for quality. The contractor must be able to take initiative and use their own discretion in order to create the best results. Additionally, the contractor will be expected to act in a timely manner, ensuring that the data is updated and ready to use on a monthly basis. This project requires attention to detail and good communication skills.
A gifted English voice actor is needed to record a voiceover for a project, such as an explanatory video, audiobook, commercial, etc. A engaging voice with flawless pronunciation, intonation, and delivery characterises the perfect candidate. Accountabilities: Record audio at good quality while adhering to the given scripts. Make sure you speak clearly and wi...explanatory video, audiobook, commercial, etc. A engaging voice with flawless pronunciation, intonation, and delivery characterises the perfect candidate. Accountabilities: Record audio at good quality while adhering to the given scripts. Make sure you speak clearly and with proper pronunciation. As needed, offer several takes and variations. After editing, send the finished audio files in the required format (WAV, MP3). C...
...comprehensive manner. - Proficiency in working with survey data: You will be dealing with survey data, so experience in this particular field is highly preferred. - Familiarity with spreadsheet software: The data is in a spreadsheet format, so proficiency in software like Excel or Google Sheets is a must. Your primary objective will be to provide a detailed description of the data which includes calculating the central tendencies, measures of dispersion, and other relevant statistical indicators. You will also need to present this information in a visually appealing format that is easy to understand and digest. I am looking for a freelancer who is not only skilled in statistical analysis but also has a good eye for detail and can communicate complex information ...
We are looking to build a long-term partnership with a skilled and dedicated team of developers for ongoing projects involving WordPress and WooCommerce webshops. Our goal is to collaborate with professionals who can deliver high-quality wor...have a team that meets the above criteria and are interested in a long-term collaboration, please submit your proposal including: - An introduction to your team and relevant experience - Portfolio of past projects related to WordPress and WooCommerce - References or testimonials from previous clients - Your proposed hourly rate or project-based pricing model - Availability for a potential start date and ongoing commitment We look forward to reviewing your proposals and potentially working together to achieve great results. Thank you for your...
...also be able to be added to Outlook email signature. Requirements: - Utilize our existing logo: The animated version should be an extension of our current branding to ensure consistency and recognition among our target audience. - Maintain a professional and sleek style: The animation should reflect the professional image that we want to convey as a company. - Provide the final output in a GIF format: This will ensure the animation can be easily integrated across our digital platforms. The ideal candidate for this project should have: - Proficiency in both 2D animation and logo design. - The ability to adapt an existing design into an animation. - A portfolio showcasing previous work in creating corporate or brand animations. If you have experience in creating engaging and p...
...Responsibilities: Assist in the drafting and editing of research manuscripts Ensure manuscripts meet the submission guidelines of targeted journals Conduct thorough literature reviews and reference management Collaborate with researchers to enhance the quality and clarity of manuscripts Manage the submission process, including addressing reviewers' comments and making necessary revisions Maintain up-to-date knowledge of publication trends and standards in healthcare research Requirements: Proven experience in research publication, particularly in the healthcare field Strong understanding of research methodologies and statistical analysis Excellent writing, editing, and proofreading skills Familiarity with various peer-reviewed journals and their submission processes Abilit...
I'm looking for a skilled freelancer who can create basic architectural elevation drawings and site plan for me. I need a site plan and elevations to submit to the City to ...plan and elevations to submit to the City to covert a carport into a garage. Below is a link of the necessary items to include for the submission: - I'm looking for simple, outline-based drawings. Details such as materials, textures, and landscaping are not needed. - The deliverable needs to be in AutoCAD format. Ideal Skills/Experience: - Proficiency in AutoCAD software - Experience in creating architectural elevation drawings -Experience in basic site plan - Attention to detail and the ability to follow instructions accurately.
...maintenance and updates. - Ensure seamless data synchronization between Google Sheets and the MySQL database to keep the quote system accurate and up-to-date. ** Deliverables: - A fully redesigned WordPress website with a modern look and maintained content. - A fully functional, tested, and bug-free instant quote form. - SEO setup and optimizations, including keyword implementation, meta tags, and link building. - SSL certificate setup and configuration on GoDaddy. - A system for syncing Google Sheets to the MySQL database to streamline updates. ***** Project Timeline: The complete project should be delivered within 1 week from the start date. *** Budget:*** Our budget for this project is fixed at no higher than $200. We are looking for the best combination of val...
...seeking an expert in Excel, OneDrive and email notifications who can develop an automated system for me. This system needs to: - Monitor a specific Excel file within my OneDrive for business for cell value changes. - When changes occur, the system should not send an individual notification for each. Instead, it should group updates together. - These grouped updates should then be sent as a single email to a preselected set of recipients at a specific time interval. - Crucially, the email should not only contain the updated cell values but also their previous values, enabling recipients to easily compare old and new data. Only experienced Excel and OneDrive professionals should apply, preferably with a background in automated data notifications. Familiarity with han...
...from Sales, Orders, Products, Customers, and other relevant columns and sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data MUST be pulled into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows: Order ID, Tracking ID, Product Name, Unit Price, Ship By Date, Deliver By Date, Purchase Date, Ship Date, Payment Method, Fulfillment Methods, ASIN, Quantities, Item Subtotals, Tax Total, Refund Total, Shipping Label, Shipping Cost, Grand Total, Status, Buyer Name, City Name, State, Zip Code, Tax Collection, Tax Respons...
I'm in need of a proficient cold caller to reach out to various types of local businesses, including restaurants, retail stores, and service providers. The primary goal is to gather contact information. Key Responsibilities: - Making cold calls to local businesses - Collecting accurat...information. Key Responsibilities: - Making cold calls to local businesses - Collecting accurate contact details The leads should be submitted to me in the form of an email list. Ideal Candidate: - Proficient in cold calling - Able to converse professionally with different types of businesses - Attention to detail for accurate data collection - Proficient in compiling and presenting data in email format. Please note that the success of this project will largely depend on the quality of l...
I am looking for an experienced web developer to create a multi-format media player for my THC-based website: Here are some key details about the project: - Media Types: The player should support both mp3 and mp4 files. A seamless experience for both audio and video is crucial for my website visitors. - Required Functions: The primary functions I need are Play/Pause, Volume Control, and Playlist Management. The player should be user-friendly and intuitive to operate. - Integration: The player will be embedded on multiple pages of my website. It is important that it functions consistently across all pages and devices. The ideal candidate for this project will have: - Proficiency in web development - Experience in creating media players - Strong understanding of user experienc...
...availability for all the hours any of the linked expert calendars show available time. • Blog section - All type of Users can read, like, share on multiple social media platforms, and add comments on posts (only logged in user), - Admin: content creators can login to write and publish blogs in their desired design and format. Blog contents could be videos hosted on YouTube and other platforms • University data and pages - Admin: o can update university data in bulk using excel or other supported file formats o can update individual university data from university page (separate login for data entry operators, data is published online once validated by a proper assigned user on the admin side) - Public users (no login required) o Can search universities based on...
I am seeking a skilled professional for TIF to DWG conversion of a detailed drawing. - The project's goal is to edit and modify the drawing post the conversion. - The DWG file should be formatted precisely for AutoCAD 2014 compatibility. - Consistency and accuracy are important; the DWG format needs to mirror the TIF file extensively, maintaining every fine detail. Ideal freelancer would bring: - Proficiency in AutoCAD 2014. - In-depth knowledge of TIF to DWG conversions. - Attention to detail to warrant detailed precision.
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
