Excel vba insert date and time in cell jobber
I need a proficient data specialist to assist in integrating my sales data from Excel to Zoho CRM. The ideal candidate should have: - Extensive experience with Zoho CRM - Proficiency in Excel - Excellent data management skills - Ability to ensure data integrity during the integration process - Skills in troubleshooting potential data discrepancies
...robust application using , Contentful, and a database, we will structure the app to include the desired functionalities while leveraging Contentful's content modeling capabilities. Here's a detailed guide for implementing each requirement: Tech Stack Frontend: CMS: Contentful Database: PostgreSQL (or any other preferred relational database) Payment Integration: Stripe Authentication: Backend API: API routes in State Management: React Context or Redux Toolkit Styling: Tailwind CSS or CSS-in-JS Steps to Build 1. Authentication (User Logging) Use for user authentication. Store user details in the database (e.g., PostgreSQL). Integration Steps: Configure pages/api/auth/[...nextauth].js for handling login and session management. Use providers...
...on the hunt for a part-time video editor who can help me spice up my YouTube shorts and Instagram reels. The content is primarily entertainment-focused, and I'm looking for someone who can deliver high-energy edits filled with visual effects. Key Responsibilities: - Edit raw footage into engaging, entertaining short videos - Incorporate high-energy visual effects - Add text overlays and motion graphics as needed - Implement color grading to enhance video quality Ideal Skills and Experience: - Proven experience in video editing, especially for social media - Proficiency in creating high-energy, visually appealing edits - Experience with adding text overlays and motion graphics - Strong understanding of color grading technique...
...enhancing our sales performance. Key Tasks: - Utilize advanced analytics techniques to interpret data and derive meaningful insights. - Create interactive and visually engaging dashboards in Power BI or Excel to monitor KPIs and sales metrics. - Simplify complex data sets into easy-to-understand visuals, facilitating informed decision-making. The final deliverable should be a comprehensive PowerPoint presentation that includes: - Interactive charts and graphs to illustrate our data journey and findings. Ideal Skills: - Proficiency in MS Excel, Power BI, and Data Visualization tools. - Experience in creating engaging PowerPoint presentations. - Strong understanding of sales metrics and KPIs. - Ability ...
Job Opportunity: Manga Illustrator Assistant (Remote, Part-Time) Location: Remote (Preferred candidates based in Asia) Start Date: [2025 January] Are you passionate about manga and have a strong understanding of traditional Japanese manga art? Do you want to work closely with a lead mangaka and contribute to a growing creative project? If so, we have an exciting opportunity for you! We are looking for a Manga Illustrator Assistant to join our team. This is a remote position with excellent growth opportunities and the potential for a higher salary as you develop within the role. Key Responsibilities: Assist the lead mangaka in creating manga panels, characters, and backgrounds. Follow creative direction and instructions f...
I'm looking for a professio...Features: - Calendar Integration: The system should allow clients to select their preferred moving date and time. - Real-time Availability: The system must reflect current availability in real-time to prevent overbooking and to enhance customer satisfaction. - Automated Confirmations: Once a booking is made, the system should automatically confirm the booking to the client. Ideal Skills: - Extensive experience in developing booking systems. - Proficient in integrating calendar systems. - Capable of creating systems with real-time updates. - Previous experience in developing personal services websites is a plus. I am looking for a professional who understands the log...
I'm in need of an online, Python-based software tailored specifically for my company to create and manage purchase orders. This system should provide a user-friendly interface for both Admin and Staff, with features for easy deduction of quantities as orders are processed. Key Features: - Management of Purchase Orders: The system should allow for easy creation and tracking of purchase orders. - User Roles: The software needs to have access levels for Admin and Staff. - Essential Fields: Each purchase order should include fields for Order Date, Supplier Details, and Product Description. - Core ERP Functionalities: The system should cover basic Inventory Management, Vendor Management, and Customer Management. - Vendor and C...
I'm in need of a professional with expertise in Oracle ERP and ZATCA integration, specifically for e-invoicing. The integration should focus on the following key elements: - Incorporating ZATCA's e-invoicing functionalities into Oracle ERP. - Ensuring that e-invoices include critical data elements such as the invoice date and amount. The ideal candidate for this project should have: - Proven experience with Oracle ERP. - In-depth knowledge of ZATCA's e-invoicing requirements. - Strong skills in system integration and data management. I look forward to your proposals.
...that specializes in property recommendations for renters in the real estate market. The primary function of this AI agent will be to assist renters in finding suitable properties. The AI agent should provide: - Available properties: The AI needs to have access to an updated database of rental properties, and be able to filter options based on user preferences and requirements. - Rental prices: The agent should have the capability to provide up-to-date pricing information for these properties. - Neighborhood details: The AI should offer insightful information about the neighborhoods of the available properties, including safety, amenities, schools, public transport, etc. Ideal candidates for this project should have a strong background in...
I'm looking for professionals who can help with installing audio players in three retail stores. These players will primarily be used for playing advertisements and promotional content. Information is provided via proprietary commercial audio streaming system Key Requirements: - Installation of audio players: these will connect to existing speaker and amps - Onsite will provide internet connectivity Ideal Skills: - Experience with audio equipment installation - Knowledge of setting up remote control systems - Understanding of sound distribution in retail environments - IT skill set Installation date is to be confirmed. But will be around mid Jan.
I'm looking for a professional to design and create certificates of authenticity for my luxury wooden workout equipment. These certificates will be included with each product shipped. Key Requirements: - The certificate should detail the product materials and production date. - A complete design and layout for the certificate needs to be created from scratch, as I do not have a specific design in mind. Ideal Skills: - Graphic Design - Product Design - Certificate Design Experience Understanding of luxury product presentation and authenticity certification is a plus. Please provide examples of similar projects you've worked on.
I'm looking for someone to edit my inventory data in Excel. The task involves moving data from one file to a new one with a different layout. The new layout requires: - Reordering columns - Adding new fields - Combining data from multiple sheets There are specific formatting requirements for the new layout, which includes the use of certain cell colors and font styles. Ideal candidates for this project should have: - Extensive experience with Excel - Strong attention to detail - Ability to follow specific formatting guidelines - Experience working with inventory data.
...history, and maintenance records. The API should deliver these reports in JSON format. I am looking for someone to provide APIs for generating reports based on a car's VIN code. Important: The cars are from Europe. I need APIs that offer full details of the vehicle history. Please, those who apply should have experience with APIs from Europe for VIN code reports similar to CarVertical, AutoDNA, and provide me with all the details on where I can obtain these reports. Who offers the API? Those who have such information, please contact me privately. APIs Needed to Generate a Full Vehicle History Report Description: 1. Vehicle Information Check the most important information related to the car: manufacturer name, car type, and model, body type, engine d...
I need assistance with designing a tax invoice in Zoho Books for Saudi VAT. The program is already set up to work with us, but the invoice needs to be customized to meet our requirements. Key Requirements: - Incorporate our company logo and branding into the invoice - Provide a detailed tax breakdown on the invoice - Include our payment terms and conditions Additionally, the invoice needs to contain: - Our customers' contact details - The invoice's due date - An itemized list of products/services Ideal Skills and Experience: - Proficiency in Zoho Books - Experience with Saudi VAT compliance - Graphic design skills to incorporate company branding - Understanding of creating detailed and clear tax breakdowns Please ensure your p...
I need a freelance web developer to creat...Doctor Appointment System. This should have an easy-to-use interface for both patients and admin (doctor/reception) panels. Key Features Include: - Patient Module: Simplified appointment booking, QR code access, WhatsApp confirmations, and unique Patient ID generation. - Admin Panel: Real-time appointment notifications, patient database management, date availability settings, and WhatsApp notifications. The ideal candidate will have: - Extensive experience in web application development - Proven track record of designing user-friendly interfaces - Expertise in secure database management - Familiarity with integration of APIs, particularly WhatsApp's Please provide your quotation, project ti...
I'm looking for a developer who can create a PDF record management system fo...developer who can create a PDF record management system for me. The main requirements are: - Storing and organizing PDFs: The system should be able to store and organize my PDF files efficiently. - Date-Based Organization: The PDFs should be organized by date. This feature should be easy to navigate and user-friendly. - User Access Control: The system should allow for different access levels for different users. This is crucial for maintaining security and confidentiality. Ideal skills for the job would include experience in software development, knowledge of PDF management systems, and expertise in setting up user access controls. Please pr...
...Subscription - Vendor - Status Once the User logs in to the application using his AD account User is going to sync to USER Access and the admin can Assign Custom role. - Email Notification – any user email define here should receive email notification for expiration mention date. With owner filter - email is going to send every 6 months - 3 months and 1 month 2. Dashboard Design I want 3. Inventory • Hardware Category -Owner – Vendor – Model – Serial Number – Description -Purpose – Support Level- Estimated Renewal Cost –Expiration Date - Status • Software – Contain Same of Hardware • Server Hostname – IP Address – Description – Owner – Status • General...
...management, in and out, ending balances and more. 1. add beginning inventory today (yesterday ending inventory) 2. add items that was added for today's inventory 3. add amount deducted today from inventory 4. add reason deducted today from inventory 5. current inventory,cost price, supplier field, item deducted, 6. input button for adding of inventory 7. person who added with date and time 8. approved by by 10. please add yesterday inventory with same content as 1 to 9 (or make like a report with date selection) 11. add download and print function 12. on top add summary for total stock count or total stock quantity and stock value 13. please add filters (such as category), can we add separate filter for raw material 1...
Copywriting, pdf, data entry, excel, word
I'm looking for a Photoshop specialist to help edit some of my PDF documents. - Text Changes: I need various date, time, year, and amount alterations throughout the documents. - Image Adjustments: The job will involve removing or adding elements within images. Ideal skills and experience include: - Proficiency in Adobe Photoshop - Prior experience with PDF editing - Strong attention to detail - Excellent communication skills - Ability to meet deadlines
...team queries and feedback. Key Features: - An intuitive and user-friendly interface that allows easy navigation and information access. - A secure and private environment, with appropriate access controls to protect sensitive information. - A responsive design, ensuring usability across various devices. Define the basic requirements: Basic features: User management: Log in users (admin, employee, etc.). Create a quote(jobe): Enter customer details, products or services, prices, and taxes. Jobs section (airport/ land /sea) Convert to invoice: Convert the Jobs to a final invoice. Manage invoices: View past invoices, edit, and print. Notifications: Alert users about outstanding or unpaid invoices. report for job's & invoice Expor...
I'm looking for an experienced iOS developer to create a simple yet efficient application for tracking my bank history and balance. Features Needed: - The app should primarily allow me to view my transaction history. - The app should categorize transactions by date. - Need the ability to filter transactions by amount. Ideal Skills: - Proficient in iOS app development. - Prior experience with finance-related apps is a plus. - Good understanding of user-friendly UI/UX design.
I'm conducting academic research and need help analyzing survey responses. I need a statistitan that can help me identify and give the correct sample size calculation for the bellow Total population 118 Stratum A) 70 Stratum B) 48 Z-score (default: 1.96) For 95% confidence level) 1.96 Proportion (default: 0.5) 0.5 Margin of Error (e.g., 5%) 0.05 is Finite Population Adjusted Sample Size needed? I need an excel with the formula and the steps broken down to a detailed level
...with a focus on usability, performance, and a modern design. app link Project Scope Platform: Windows 10 and 11 compatibility. Technology Stack: Preferably .NET Framework (WPF or WinForms), though other Windows-compatible technologies may be considered (C++, Electron, etc.). Key Features: Replicate all features of the mobile app (name and features will be provided). Adapt the UI for desktop users (mouse/keyboard input). Integration with Windows features such as: System notifications. File handling (if applicable). Local storage or database support for saving user data. Performance optimization for seamless operation on mid-range hardware. Design: Implement a modern and user-friendly interface, adhering to
...services and products is looking for an APEX Engineer. The selected candidate will be responsible for writing high-quality APEX code to validate the efficiency of their LLM (Large Language Model). The company has established itself as a dominant player in the I.T. industry and a leading Internet media giant. Key Responsibilities: ● Design, develop, and maintain robust, scalable Lightning Web Components (LWC) to enhance user experience within the Salesforce platform. ● Optimize LWC performance, ensuring responsive interfaces and smooth user interactions. ● Implement high-quality Apex classes, triggers, and batch processes for complex business logic, ensuring adherence to best practices and coding standards. ● Integrate with external APIs ...
...eager to excel in the field of copywriting and looking to transition into a professional role. I'm seeking an experienced mentor or a comprehensive copywriting course that can provide guidance, practical exercises, and feedback to sharpen my skills. Here's what I'm looking for: - A mentor with a strong portfolio of copywriting work who can offer personalized advice and tips. - Engaging learning materials that cover the basics of copywriting, including writing for different mediums and understanding target audiences. - Interactive sessions or a course with hands-on activities to practice and improve my writing. - Feedback on my work to help me refine my copywriting techniques and develop my own style. - Insights into...
...finds you well. I am reaching out to outline a comprehensive plan for creating Excel sheets with detailed product information from the following link: Grab Mart Merchant Link. ( ) Project Overview The goal is to compile full product information, including price, product photos (edited with a white background), product weight, and product category. Each category will have its own separate Excel sheet and corresponding Google Drive folder for storing photos. The product name on the photo and in the Excel sheet must match. Additionally, we will need to find barcodes for all products, as none are provided in the link. The total number of products is approximately 2,600. Steps to Complete
...authentication for a specific domain, ensuring secure and controlled access. The booking system will have several key features: - **Booking Limitations**: A maximum of 6 slots can be reserved in a single day, with available slots running from 6 am to 9 pm, each separated by a 3-hour interval. - **Advance Booking**: All slots must be booked at least a day in advance, up until 11:59 pm. Same-day bookings are not permitted after 12 am. - **Date Selection**: The portal should include a calendar feature for date selection. - **Hour Selection**: A drop-down menu will be implemented for selecting hours. - **Visual Indicators**: When a user books a slot, all other slots within a ±3 hour window should be grayed out to indicate they cannot be booked. ...
I need a spreadsheet expert to help me streamline my expense tracking tables with automatic calculations. My spreadsheet contains financial data and is primarily used for tracking expenses. The goal is to make the tracking process easier and more efficient. Ideal Skills: - Proficient in Excel or Google Sheets - Experience with financial spreadsheets - Knowledge of creating automatic calculations - Attention to detail for tracking accuracy - Ability to optimize and improve existing tables Please provide examples of similar projects you have completed in the past.
...talented and experienced freelancer to create a polished, modern, and professional resume for a recent graduate in Business Administration. The resume should effectively showcase his education, internship experience, skills, and interests to help him stand out in the competitive job market. Scope of Work: Design a visually appealing, ATS-compliant resume that highlights key strengths. Include sections for education, work experience, skills, certifications, hobbies, and career goals. Use clear and professional formatting suitable for entry-level positions in marketing or project management. Provide both one-page and two-page versions of the resume in PDF and editable formats. Details to Include: Education: Fr...
I'm looking for a talented graphic designer who can create a modern and sleek flyer for The Word Church. The flyer is to be sized 1024X768 and should prominently feature our 2025 theme: "Upgrade, Elevate, & Excel" (Ephesians 3:20). Key elements to be included: - The text: "The Word Church", "2025: Upgrade, Elevate & Excel (Ephesians 3:20)", "Tony Ray Smith, Senior Pastor", "". - A focus on the theme of 2025: Upgrade, Elevate, & Excel. - Our church logo. - A photo of our pastor. Example IMG_9673 ' Design specifications: - A modern and sleek style. - A dominant blue and silver color scheme.
...system or script capable of recognizing and identifying characters displayed in a YouTube livestream screen. The project involves analyzing live video content and extracting text or character information in real time. Key Responsibilities: Develop a tool to capture and process frames from a YouTube livestream. Implement Optical Character Recognition (OCR) or similar technologies to detect and recognize text or characters within the video feed. Ensure high accuracy in text recognition, even with varying fonts, sizes, and colors. Optimize the system for real-time processing with minimal delay. Provide a solution that can handle dynamic changes in the screen layout or content. Deliver clean, well-documented, ...
I'm looking for a skilled Excel VBA programmer to create a script that will automate the process of copying and pasting data from multiple emails in a specific Outlook folder into an Excel worksheet. Key Requirements: - The VBA code should be able to handle multiple emails, efficiently copying and pasting the relevant data from each. - The code needs to target emails located in a specific folder in Outlook, so familiarity with Outlook's structure and VBA's capabilities in interfacing with it is crucial. - The data from the emails should be pasted into the Excel worksheet in an organized manner. Ideal Skills: - Proven experience with Excel VBA programming - Familiarity ...
I'm in need of a professional who can assist me with entering financial records into spreadsheets and making cold calls. Data Entry: - You'll be entering financial records into spreadsheets. - I have a general idea of how the spreadsheets should look, but I will need your input and expertise to create a clear and efficient format. Cold Calling: - You'll also be making cold calls on my behalf. - Excellent communication skills and a persuasive demeanor are essential. Ideal Skills: - Proficiency in data entry and spreadsheet software (preferably Excel). - Previous experience with financial data is a plus. - Strong communication skills for cold calling. - Ability to understand and contribute to spreadsheet des...
We need to add thousands of products to our ecommerce website. Most of our suppliers do not provide the product images and product documents like specification and installation documents. We need help getting these images and documents from supplier websites. You will be provided with excel files for each supplier with the full list of product for which to get images and documents
I'm seeking a skilled Excel VBA programmer to create a macro for me. The primary function of this macro is to send automated email reminders based on due dates in my spreadsheet. Key Requirements: - Automate email Notifications: The macro should send out reminders as deadlines approach, helping me stay on top of my tasks. - Data Validation: The macro should also check for missing data in my Excel file and notify me accordingly. Ideal Skills: - Proficiency in Excel and VBA - Experience with creating macros for email automation Thank you!
I need a fillable PDF created from an Excel worksheet. The PDF will be used to conduct a survey and will include both multiple choice and short answer questions. Key Requirements: - Convert specified Excel worksheet into a fillable PDF. - Incorporate various types of survey questions (multiple choice and short answer). - Ensure the PDF can be easily returned via email once completed. Ideal Skills: - Proficiency with Excel and PDF creation software. - Experience in designing user-friendly fillable PDFs. - Understanding of survey design and data collection processes.
I need an expert in Excel to assist me in merging two files. The task involves transforming the data in these files before the merge. Ideal Skills: - Proficient in Excel, particularly in data transformation techniques - Experience with data merging - Attention to detail for accurate data handling
...view open and closed alerts: Command: !viewopenalerts Command to view closed alerts within a specific date range: !viewclosedalerts -date. Examples: !viewclosedalerts -2w – closed alerts from the last 2 weeks. !viewclosedalerts -5d – closed alerts from the last 5 days. Option to close all open alerts: !closeallalerts. Leaderboard and User Statistics Displaying a leaderboard: !leaderboard. Viewing stats for a specific user: !stats @traderName. Requirements: Integration with a website to synchronize position data and visualize it. Restrict the ability to open positions to users with specific roles. Support for future feature expansions and potential automation. Additional Details: More details and examples will be provided upon...
I have 6 excel spreadsheets containing attendee information for some small upcoming events. I need the data sorted into groups by age and other specific requests. Additionally, I need some standard data cleaning to be done, specifically standardizing phone numbers and removing duplicates. Ideal skills for this project include: - Strong proficiency in Excel - Attention to detail - Good understanding of data sorting and cleaning techniques Please bid if you can assist with this task.
I need help with reworking an existing venture capital excel model for a new investment. The model should provide accurate financial returns for this investment. Specific Sections: - Revenue projections - Expense forecasts - Return calculations Assumptions to Update: - Market growth rate - Cost of goods sold - Operating expenses New Financial Metrics to Incorporate: - Internal Rate of Return (IRR) Ideal Skills: - Expertise in Excel and financial modeling - Understanding of venture capital and investment analysis - Strong analytical and problem-solving skills Experience: - Prior experience reworking venture capital models - Proven track record of accurate financial forecasting I'm looking for a freelancer who is detail-oriented and...
...Full-Time Location: Remote (Work from Home) Salary: 320 Euro per Month (80 Euro per Week) Job Summary We are seeking a highly motivated and detail-oriented individual for the role of Internet Link Poster. The primary responsibility is to post specific links all across the internet on a variety of websites, forums, platforms, and communities. You must find suitable locations to post these links and ensure they are relevant, well-placed, and stay permanently online. Only links that remain live will count toward your daily target of 160 links. This full-time position will become easier with practice as you learn to identify the best posting opportunities efficiently. Key Responsibilities 1. Posting Links Across the Internet: You are responsible f...
Instagram Account Manag...role is strictly focused on organic growth—NO paid advertising or website SEO. Responsibilities: ✅ Post 1 to 3 times daily with engaging and entertaining content related to our business. ✅ Focus on organic follower growth and increasing engagement. ✅ Interact with relevant Instagram groups, communities, and influencers. ✅ Stay up to date with trends to create fun and valuable content. Ideal Candidate: ✔️ Has experience managing Instagram accounts. ✔️ Knows how to create engaging posts, reels, and stories. ✔️ Understands how to grow a following without paid ads. ✔️ Bonus if skilled in video editing for short clips. If you're passionate about social media and know how to organically grow an Instag...
...enhancing its functionality, and potentially adding new features. The radio schedule / calendar plugin does not seem very Intuitive, practical and lacks. 1. I need an easy way to see / view radio schedules on back-end 2. I need to easily delete / clear recurring scheduled events. Right now if i delete a scheduled rec-curing entry. I gotta go years out and delete manually. It should auto clear if i delete 1 scheduled recurring event. 3. I need an easier way to edit events 4. The radio schedule has a bug where if i select the date on calendar it dont display correct event. Goals: Refine my existing JavaScript calendar plugin (Full ) and address the issues # 1 - 4 outlined above. I want you to make the radio schedule / calendar JS Plugin more intuiti...
Build a Website with Booking System, Marketing Integration, and Customer Data Management Description: We are Kids Cafe - a family-friendly business offering fun activities, party packages, and events for kids. We are looking for an experienced developer to create a website that integrates a robust booking system, customer data management, and marketing tools. Key Features Needed: 1. Website Creation: Design a clean, responsive, and mobile-friendly website. Include sections for: About Us Activities Offered Birthday/Event Booking Activity Pricing and Booking Contact Information 2. Booking System for Activities and Events: Activity Booking: Allow customers to book activity time slots once they arrive at the venue. Include real-time a...
...accountant or bookkeeper to organize and prepare accurate financial statements for my businesses for the 2022 and 2023 fiscal years. All of the statements for each account have already been converted to excel format. You must go through the transactions for each year and properly itemize each transaction and creat the Businesses Financial Statements (PNL & BS) for tax filing purposes. This role also involves reviewing my personal bank account statements to identify any business-related transactions made that should be included such as making a payment for a business credit card, owner investments, and Etc. I need this to be completed ASAP perferably by the end of this week if possible. Key Responsibilities 1. Organize and Classify T...
I need a Data Entry Specialist, preferably with an engineering background, for a 3-hour task. This project i...Entry Specialist, preferably with an engineering background, for a 3-hour task. This project involves: - Transferring mixed data (numerical and textual) from a PDF document into an Excel spreadsheet. - Organizing the data by categories or sections in a clear and user-friendly format. - Applying both totals and averages using basic Excel functions or formulas. The ideal candidate for this task must: - Have a strong proficiency in Excel. - Possess keen attention to detail and accuracy. - Be able to complete the task within 3 hours. Given the nature of the task, an engineering background would be beneficial due to the...
Full-Time (40 hours per week) No teams, individuals only. Please do not apply for you're a real. We're not interested. Location: Remote (Available 9 a.m. to 5 p.m. PST, Monday to Friday) Company Overview: We are a dynamic and innovative software development company seeking a Senior Full-Stack Developer to join our team. As a senior member of our development team, you will play a pivotal role in building cutting-edge web and mobile applications. This is a full-time, remote position requiring an expert in React, Flutter, and other technologies, with a focus on delivering exceptional front-end and back-end solutions. Experience in both React & Flutter are mandatory. Non negotiable. Good English is non negotiab...
I need assistance pulling all followers from my business Instagram account. Specifically, I'm looking for their username, email, and name (if available). Ideal skills for this project include: - Proficiency in data extraction and web scraping - Familiarity with Instagram's platform and its data privacy rules - Experience in data presentation using Excel or CSV formats Please bid only if you can deliver the data as a neatly organized spreadsheet (Excel, CSV).