Format date vba exceldela

Potrebujem app ki prebere excel in ima možnost vnašanja(import) excel tabel, dostopno mora biti preko mobilne/web aplikacije, imeti mora možnost razporejanja oz dodajanje dela večim ekipam, na koncu mora vse skupaj združiti v skupno tabelo, odšteti količino porabljenega materiala za delo oz voditi zalogo opreme in ločeno voditi količino porabljenega materiala za posamezno stranko, moznost uploada slik za posamezni id stranke, in upload to na pc oz web server

Narisati je treba shemo nadzornega sistema stavbe po nadstropjih in v vsako nadstropje vnesti komponente iz excel tabele - do 100 komponent

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

Rad bi izdelal kviz ki bi obsegal razlicna podrocja, za zacetek na primer vprasanja iz racunalnistva, excel-a, podjetnistva,.. V kolikor pa bolje spoznate na kaksno drugo podrocje in se vam zdi da bi bila vprasanja uporabna tudi za ostale, se lahko zmenimo tudi za kaksno drugo podrocje vprsanj. Poleg vprasanja bi bili ponujeni 3-je mozni odgovori, med katerimi bi bil en pravilen. Za vsako podrocje bi imeli vprasanja razlicnih tezavnostnih stopenj, na primer Lahka, Srednje in Tezka. Bonus tocke za: -Vprasanja niso predolga, da ne zahtevajo ravno predolgega branja -Nekaj vprasanj lahko vsebujejo tudi kaksen smesen ali pa nenavaden ponujeno odgovor

need help with spreadsheet formula

I have a JPEG logo that needs the background removed to become transparent. The entire logo needs to be processed. After this, I would like the logo to be delivered in multiple formats: JPEG, PNG, and SVG.

I require an experienced VBA programmer to write a script for my Office 365 Excel workbook. The task is to automate the printing process of a specific worksheet based on a cell value in the 'Component Index' worksheet. Key Requirements: - The 'Component Index' worksheet contains the cell value that determines the number of pages to print. - The script should allow for changing the name of the workbook without interrupting the print process. - The automation should seamlessly integrate with Excel's regular print button. The ideal candidate for this project should be proficient in VBA programming and have extensive experience with Excel 2019 and Office 365. Knowledge of Excel's print processes and handling of workbook events is cr...

Task: - Research outdoor gear/equipment products - Gather: product name, description, price, weight, dimensions, material, color options - Enter data into Google Sheets template Requirements: - Accurate & up-to-date data - Consistent formatting Deadline: 24hours

Hi, I’m Nirajan Neupane, a skilled professional specializing in cybersecurity and computer-related technologies. With a strong foundation in IT and a passion for problem-solving, I also excel in freelance writing, delivering high-quality, well-researched, and engaging content on technical and non-technical topics. Skills and Expertise Cybersecurity and system protection. Writing and content creation for technical topics. IT-related problem-solving and consultation. Research and documentation on advanced computer technologies. Why Work With Me? I bring a blend of technical expertise and creative writing skills to every project. I ensure clear communication, timely delivery, and meticulous attention to detail. My goal is to help clients achieve success with insightful,...

I have a manuscript ready and I need a professional e-book formatter who can also design a vibrant and bold cover for it. Key Responsibilities: - Format the manuscript into a PDF e-book. - Design an eye-catching, bold and vibrant e-book cover. Skills and Experience Required: - Proven experience in e-book formatting. - Strong graphic design skills, particularly in creating e-book covers. - Ability to work with a range of design elements and styles. - Good communication skills to discuss design options. Please note, while I might have specific elements for the cover, currently I am unsure. Therefore, I am looking for someone who can use their creative discretion and propose a range of suitable design options.

I need a seasoned professional to manage the security and maintenance of my WooCommerce website. Key tasks will include regular updates and backups, as well as performance optimization. - Regular Updates & Backups: Ensuring the website is always up-to-date, and that regular backups are carried out to prevent any data loss. - Performance Optimization: Regularly assessing the website's performance and implementing necessary adjustments to enhance speed and efficiency. Given that I'm unsure about the specific tools or plugins currently in use, the ideal candidate would be able to assess the site and recommend the best tools for the job. Skills and Experience: - Proven experience in WooCommerce website management - Excellent knowledge of website security protocols and...

I'm looking for an expert in Microsoft Excel to help me create a visually appealing and functional spreadsheet for tracking PM maintenance checks and notes. The ideal candidate should have a strong background in: - Advanced Excel features: You will need to use conditional formatting and create drop-down menus. - Visual design: The spreadsheet should be easy to read and visually engaging. - Understanding of maintenance schedules: The spreadsheet will be organized by maintenance type, so an understanding of this field would be beneficial. Please, include in your proposal examples of similar projects you've done in the past.

I need to connect my website ( ) buttons and data capture to a MySQL database on Hostinger. I'm hoping to integrate 1 to 2 of my websites into this system. The key data points to c...database on Hostinger. I'm hoping to integrate 1 to 2 of my websites into this system. The key data points to capture include: - User contact details - Paypal Donations - Other Forms of Donation - Petitions Additionally, I need a simple way to export this data. Primarily, I would need to send it off as an Excel file. Ideal Skills for this Job: - Proficiency in MySQL - Experience with Hostinger - Web development skills - Ability to set up data capture from website interactions - Excel data manipulation skills Please provide examples of similar projects you've worked on i...

I'm in need of a flyer for a property sale. The design should be modern and minimalist, aligning with contemporary design aesthetics. Details to be included: - Property features: A concise, appealing description of the property's key features. - Contact details: Clear and easy-to-read contact information. The final design needs to be delivered in a digital format (PDF/JPEG), suitable for online distribution. Ideal candidates will have: - A strong portfolio of modern, minimalist design work. - Experience in designing property sale flyers. - Proficiency in creating digital design formats.

I need an Excel expert to analyze my sales data and generate visualizations. The ideal candidate should be proficient in Excel, with a strong understanding of data analysis and visualization techniques. Key Requirements: - Analyze sales data to determine profits - Create a variety of visualizations including bar charts, pie charts, and line graphs Experience in data analysis and Excel is necessary for this project. I hope to gain a clear understanding of my profits and any related patterns through this analysis.

Urgent German Duo Voice Recording Project (Having a partner is essential) German Voice Recording Duo Needed (Having a partner is essential) I'm looking for a native or fluent German s...or Native level German speakers. - A partner with equal fluency for conversational recording. - Prior experience with voice recording is preferred. - Willingness and availability to complete 10 hours of recordings within the three-day deadline. - Ability to read and deliver pre-written scripts in a natural, friendly, and engaging manner. Technical Details: - Recordings must be delivered in WAV format. - Experience with recording equipment and software is an advantage. Please ensure your bid reflects your ability to meet all these requirements, including the availability of a fluent partner fo...

I need an expert in 3D modelling who can convert a point cloud of a vehicle into a highly detailed, accurate 3D model suitable for manufacturing. Deliverables: - A detailed and clean model of the vehicle. - In DWG format. - Any additional details or annotations relevant to the vehicle's design and structure. Please provide the following details: - Your availability to take on this project. - The expected timeline for completion. - Your pricing structure or an estimated quote based on the scope. - Any additional information or requirements you might need from my end to ensure a successful outcome. I can provide the point cloud file and any additional reference materials upon confirmation. Looking forward to your response.

...for, then you will send me 10 more, etc. don't really like the photos I used in the video, but, this is an idea of the format I am needing for the video. Upcoming videos I am making, I will need the following photos: images that have an elegant feel, imply a rich lifestyle, makes people wish they were living that lifestyle need images of a guy looking at a girl, wanting to talk to her, but he's to shy.. got no game. More details: Which of the following settings should the photos reflect for the elegant, rich lifestyle? Luxury homes or interiors, High-end fashion locations, Exquisite dining venues, Sugar Daddy Dating, Generation Z Dating, Gen Z guys who don't date What information should successful freelancers include in their application? Past wo...

I'm in need of a highly skilled Excel professional to create a customized spreadsheet for managing our stainless steel kitchen items. This spreadsheet should not only track our inventory, but also automatically calculate prices based on various factors. Key Features: - Automatic pricing calculations per meter for each item, as well as for single items. - An easy-to-use inventory tracking system. - A system for manual data input as our inventory grows. - Accommodation for fixed amount price adjustments reflecting market fluctuations. - Versatility to handle different pricing for different units of measurement, specifically meters. Ideal Skills and Experience: - Proven expertise in creating intricate, user-friendly Excel spreadsheets. - Comprehensive understanding of inv...

I'm looking for a skilled Excel expert to create a bespoke spreadsheet for our stainless steel custom kitchen items. Key Requirements: - The spreadsheet should automatically calculate prices per meter per item as well as for single items. - It should have an inventory management system. - There should be capabilities for price adjustments reflecting market fluctuations. - I need to manually input the data for each item over time. - The spreadsheet should accommodate different pricing for different units of measurement. Ideal Skills and Experience: - Extensive experience with creating complex Excel spreadsheets. - Strong understanding of inventory management systems. - Previous work with pricing calculations based on varying units of measurement. - Ability to create u...

I need a Google Sheets expe...complete a student awards spreadsheet I've started. The goal is to create a system that allows schools to easily enter student awards, assign awards based on a level system (bronze, silver, gold, platinum, diamond, School pin), and then automatically mail merge to print certificates. The spreadsheet should store the following information for each student: - Name and ID number - Award level and date - Teacher's name and comments Ideally, you have experience with Google Sheets and script coding, and can help me solve the issues I have encountered. Your skills should include understanding of: - Spreadsheet design - Google Sheets coding - Mail merge process I am looking forward to finding a freelancer who can help me finalize and op...

I need a professional who can convert my scanned PDF bank statement into an Excel. I have been trying to do it via a python script and while I can extract the text the data is not being pasted into the correct columns. My script is not accounting for the fact not all columns are populated. The primary purpose for this conversion is data extraction for analysis. The data should be organized in the Excel file by column from the statement. Specifically, I need the following columns from the bank statement to be included: Date, details, Debit €, Credit €, Balance €. Ideal Skills: - Proficient in data extraction and analysis - Experienced in Excel script creation - Detail-oriented to ensure accurate data conversion

I need a freelancer to enhance my spreadsheet by adding two new text columns, C and D. Using the first tab, PLCMON, as a template, these columns should be labeled 'Pass/Fail' and 'Comment' respectively. Key Requirements: - Insert the new c...new text columns, C and D. Using the first tab, PLCMON, as a template, these columns should be labeled 'Pass/Fail' and 'Comment' respectively. Key Requirements: - Insert the new columns into the spreadsheet - Populate column C with 'Pass' or 'Fail' - Place the text 'Comment' at the top of column D - Utilize the first tab, PLCMON, as a reference for data placement Ideal Skills: - Proficient in Excel or equivalent spreadsheet software - Strong attention to detail - Ability to...

I need assistance with opening and creating a .cfm file for file conversion. The .cfm file will be processing text data, and I need certain multimedia data converted to PDF format. Ideal skills and experience for this job: - Proficient in .cfm file handling - Experienced in text data processing - Capable of multimedia to PDF conversion - Familiar with file conversion techniques - Attention to detail and accuracy

Contract Explanation for Professional Design Services This contract outlines the agreement to hire a professional designer to enhance the provided image. The designer will transform the image into a sleek, modern, and professional design that aligns with contemporary aesthetics. The following key elements will be addressed: Scope of Work: Enhance the visual appeal of the image while mainta...prior to commencement. Revisions: Up to two rounds of revisions will be included to ensure client satisfaction. Ownership and Rights: Upon full payment, the final design and all associated rights will belong to the client. This contract ensures clarity and mutual agreement between both parties, fostering a successful collaboration. Let me know if you'd like this drafted in a more formal document...

I need assistance with data entry, specifically with text data. Ideal skills and experience for the job: - Proficiency in typing and data entry - Attention to detail to ensure accuracy - Experience with handling text data Note: The source of the text data and the final format for the data have not yet been determined. Your flexibility and adaptability will be key in this project.

I have approximately 3000 rows of data spread across three Excel 365 sheets. I need someone to extract, link, and manage this data for me. The final deliverable will be a detailed report in Excel. This report should include: - Data summaries - Trends and patterns - Comparative analysis There's no need for complex formulas, but the ability to identify and highlight these aspects of the data will be crucial. Your expertise in data management and proficiency in Excel will be key to the success of this project.

I'm looking for an Excel expert who can create a pivot table for me. The main purpose is reporting on customer data. Specifically, I want to gain insights into expenses per category. Ideal Skills: - Proficient in Excel, particularly in using Pivot Tables - Experience in data analysis and reporting - Ability to interpret and present data in a clear and concise manner Please bid if you can assist with this task.

I'm seeking assistance to format a 49-page Word document and check it for specific issues before it's submitted as a professional report. Key tasks will include: - Text formatting - Layout formatting - Applying styles and templates In addition to formatting, I need the document to be checked for: - Grammar and spelling errors - Consistency in formatting The ideal freelancer will have: - Extensive experience in the use of Microsoft Word and document formatting - A keen eye for detail to spot grammar and spelling issues - Ability to ensure consistency in formatting throughout the document. This is a crucial task as the document is intended for professional use, so it needs to be polished and error-free.

We are seeking a professional who can help us boost our visibility on LinkedIn and X. This will involve creating suitable posts for our company and making connections, as well as keeping everything up to date. - Post Types: We expect our LinkedIn and X account to share industry news and our company's achievements. - Connection Prioritization: Your main focus should be on potential clients. We want to expand our network with individuals and companies that could potentially use our services. - Posting Frequency: Posts should be made twice a week. Key responsibilities: - Improve engagement on my posts - Connect primarily with potential clients - Share industry news and insights to drive interaction Ideal skills and experience: - Proven track record of boosting X and Lin...

I'm seeking a professional graphic designer to create a unique, minimalist gardening logo for me from scratch. The design should be entirely original and not derived from any internet sources or templates like Canva. It must be delived in format .png, .pdf, .jpg, .ai, .svg Key Requirements: - Usage of Abstract Shapes: The logo should incorporate abstract shapes in a subtle, clever way. - Neutral Tones: The colour palette should be composed of neutral tones. A moodboard will be provided to guide the colour choices. - Sans-Serif Typography: The logo text should be in a clean, modern sans-serif typography style. The project includes a complete IP and copyright agreement, ensuring that the logo will be fully owned by me upon completion. The total fee for this project is $50. The...

Potrzebuje wykonać pobranie danych ze strony na której dane są publiczne - nie są niczym zablokowane. Jest tam 150000 firm. Działających - mających status aktywnych jest około 110000 firm. Dane mają zostać mi przesłane w pliku excel jeżeli będzie więcej niż jedna dana lub w pliku innym jeżeli uda sie tylko stworzyć baze z adresem e-mai. Dodatkowe informacje zanim złożysz ofertę: - strona jest w języku polskim - wymagane zrozumienie co i gdzie się pobiera, - wszystkie dane mają ten sam standard umiejscowienia danych co jest ułatwieniem (schemat ułożenia danych jest taki sam) - najważniejszy jest dla mnie adres e-mail - gdyby nie można było pobrać innych danych to mogę oprzeć się na mailach ale adres e-mail czasem wymaga kliknięcia "pokaż e-mail" - inne dane kt&oacut...

1- Task is to visit Maritime And Logistics College De Ruyter physically and take 6-7 geotagged photos of the name board of the institutes captured from outside the building and preferably inside too. Download app for geotagged pics from the link: www.gpsmapcamera.com...name and contact who can tell you whether the institution existed or not) 6- Please ensure that the name on the document matches the name on the signboard of the authority you visit. If there is a different name, ask them for the reason for the discrepancy. ask them to write one line explanation on the form or provide BRC. 7- Check the forms before leaving the site, ensure that the start date, end date, and designation are the same on both the form and the certificate. 8- Check all the fields are properly fi...

I am looking to have a excel spread sheet created for my small buisness, I already have my branded business logo so I would also like that to be featured on the spreadsheet, I am looking for a basic 1)Profit & loss spreadsheet 2) General Ledger Spreadsheet 3) Balance sheet. I have P&L Templet along with a General Ledger Templet I can provide for reference if needed. the spreadsheets I have will need a few adjustments but are pretty basic. I am also open to some templates you provided for reference if you have any Thank You

I am looking to update my CRM database with a couple simple excel tasks in a macro. See tabs in excel sheet as I download these when needed, and upload the new DataBase values when needed. • Household Id is unique to a household • Id is unique to a person. • You can have many people in a household 1st Task: I would like to update “Manual Household Last Note” in the Last Note Report Excel Tab to the most recent date from any of the people inside a household associated with their Household Id. Place in same date format. – Purpose: this will show me recent activity of anyone in the house when I run my report from my CRM. I would like to make this in an excel macro that I can use again in a few months. Repo...

I'm looking for a designer to create classic and elegant digital wedding invitations for me. The invitations should be in a format suitable for sending via WhatsApp, and should include a clickable link for RSVPs as well as some interactive elements. Ideal skills for this job include: - Graphic design - Experience creating digital invitations - Proficiency in creating interactive elements - Understanding of classic and elegant design aesthetics go to This is something that I would like happy yo discus. Project needs to be complete by April 2025

I'm seeking a designer who can update my logo by changing the silver lettering, badge, and borders to gold. Currently, the logo is in a JPEG/PNG format, and I'll attach the other formats as well. Ideal Skills: - Proficient in digital design, particularly logo modification - Quality understanding of color matching and design consistency Please note, the logo will need to maintain its visual integrity post alteration. I'm looking for quality work that can be delivered in a timely manner.

...5m,10m,15m,30m,45m,1hr,2hr,3hr,4hr,1d) : I want to build a live flowable dashboard scanner/screener based on this indicator (ICT Concepts [LuxAlgo]) where it will flash a continous flow of alerts whenever price of a symbol/ticker show +OB or -OB or whenever price enter/touch (sellside liquidity zone, buyside liquidity zone). so the flow of alerts flashing in the dashboard will look like this: date, time of occurence, ticker, occurence type, timeframe of that occurence show the last latest 200 alerts off my prespecified watchlist symbols and predefined timeframes: 20250119 , 18:53 , AAPL , -OB , 5m 20250118 , 03:22 , TSLA , buyside liquidity , 1hr 20250118 , 00:12 , NFLX , sellside liquidity , 4hr ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... then once I click o...

I need assistance with a PDF document where dates are in the DD/MM/YYYY format. Ideal freelancer should: - Have experience with editing PDF documents - Be able to understand and efficiently change the dates as required.

I need someone to create printable labels from an excel sheet. The labels will be used for products and should include the following details: - Product details - Expiration date - Ingredients list - Price - Others These labels need to be designed to fit on letter size (8.5 x 11 inches) sheets. Ideal skills for this project include proficiency in Excel and label design software, attention to detail, and experience with product label design.

...(provided) to replace MFC classes and update look and feel of windows/frames/borders and to enable tabbed windows • Activate track map window and plot GPS track bitmap • Allow mixing of y-axis for channels with same scaling • Add function to change plot order • Fix X-Y plot conditioning • Fix bug when some channels are not plotted  • Save/open desktop layout  • Fix maths wizard • Add sort by name/date etc. to open file dialog • Add bit masking to show bit status for on/off values • Add drag of y-axis to change size • Allocate colours to channels automatically • Add function to choose speed channel for distance calculation The current software can be installed, it is attached to the project so that it can be vi...

I need a skilled VBA programmer to help me add a macro to my existing Excel file. The macro needs to automate some of my repetitive tasks, specifically: - Data entry: I want to streamline the process of inputting data into the spreadsheet to save time and reduce errors. - Data analysis: I need assistance with automating some basic analysis to derive insights from the data. The data for these tasks will primarily come from user input within Excel. Ideal skills and experience for this job include: - Proficient in VBA programming with a strong portfolio of Excel automation projects. - Excellent understanding of data manipulation and analysis within Excel. - Ability to work with user-generated input and create a seamless automation experience. I...

...Business" is scheduled for February 4, 2025 at 6 PM. The flyer should cover the following: - Class topics: Setting up Your LLC, Health Department Requirements, UDAF Requirements, Licensing Fees, Inspections, Everything you need to know to launch your food business. - Registration link - Contact info: "Text Us At:" phone # website Please ensure the final files are in editable Photoshop .psd format with every layer editable, allowing me to modify it for future classes. - Successful entries will incorporate our logo and color scheme from our website www.sharedkitchen.network. - Use images of food and minimalist graphics, in line with our brand. Ideal skills for this project include graphic design, familiarity with Photoshop, and an understanding of modern cle...

I'm in need of a script that can scrape price and stock information from Amazon on a scheduled basis. - Data Export: The script must export the scraped data into a CSV, Json format. - Frequency: It should check for updates on an hourly basis. - CAPTCHA Handling: The script must be capable of handling Amazon's CAPTCHA challenges, as this is a requirement. The script should be able to monitor approximately 5,000 to 10,000 items in one go. Ideal candidates will have experience with web scraping, particularly with Amazon, and be familiar with handling CAPTCHA challenges. Proficiency in developing scripts that can run on a scheduled basis is essential.

Subject: Recruitment of Skilled Garment Technicians for Fashion House in Cairo, Egypt To: [Headhunter Name: Freelancer] From: [Name: Yousef Borhan Name], Maram Borhan - Wedding + Night Dresses, Fashion Designer] Date: [22nd. January 2025] Project Overview: [Maram Borhan - Wedding + Night Dresses, Fashion Designer] is a prestigious housfashione specializing in the design and production of high-end custom-made nightwear and wedding dresses for discerning clientele. We are seeking to expand our skilled workforce in Cairo, Egypt, and require the assistance of a reputable headhunter to identify and recruit four highly talented female technicians. Position Requirements:  * 2 x Pattern Makers:    * Proficient in utilizing industry-standard pattern-making software (e.g....

I am looking for a data scraping expert to help me scrape some websites. Please note that the specifics of the project, such as the format of the scraped data, the types of websites to scrape, and the frequency of the scraping, have not yet been finalized. Ideal Skills and Experience: - Proficient in data scraping tools and techniques - Experience with data analysis and processing - Familiarity with different data formats (CSV, JSON, XML) - Ability to work flexibly and adapt to project changes

...retrieve the paypal link generation request from our desktop program securely, store the request detail in his local mysql database and process(handle) the request to generate the paypal payment link and return it back as a string to the desktop program. 2. Also, when the payment link is paid from the customer the WEBAPI must be able to capture this event (via the paypal callback event) and save the date/time/transactionid/paypal response and any other info we might need to know so we can know from our desktop program if the certain payment link that is lined to a specific company invoice is paid or not. 3. We need to record the payment attempts and capture its details to the webapi database. For example if the customer try to pay the invoice from the payment link and the paymen...

Basically I have this single 1 .doc File. In this file, there are 2 "words/sentences" that need to be changed. They appear in the document maybe just 3-4 times.... 1. - one is a code for a product, like ABC1234 2. - one is the description of this products like "Cat Epithelium" ... I already have an Excel file with all the 750 different variants... Can somebody help me out here? THanks

...com/ - A 'CAMERA 24/7' logo positioned at the top left - A sentence with a 'THIEF' logo at the bottom stating: "VISITE CE CHANTIER EN SCANNANT LE QR CODE, IL N'Y A PAS D'OUTILS DE VALEUR A L'INTERIEUR" (Visit this construction site by scanning the QR CODE, there are no valuable tools inside) Please ensure all text is in French, unless the file is provided in an editable PSD format. The final PSD file must be editable, allowing me to make adjustments as necessary. Experience with Photoshop and graphic design is essential, as is the ability to understand and apply branding elements from my company, SP Batiment. Please take some time to explore my website to better understand our construction and renovation business, and to align the ...

I am in need of an experienced research paper writer who specializes in the Science & Technology sector, specifically in Environmental Science. The paper should be a comprehensive case study focused on the topic “Decarbonizing...specifically in Environmental Science. The paper should be a comprehensive case study focused on the topic “Decarbonizing Urban Transportation: A Case Study of Montreal.” Ideal candidates should have: - Extensive knowledge and experience in writing about Environmental Science and Urban Transportation. - Proficiency in research paper writing - Ability to present complex information in a digestible format - Experience in writing case studies - Strong understanding of academic writing standards and requirements Find the attac...