Vba code to filter data by date in excel jobs
I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.
Code Upgrade for BuddyBoss App Customization
...based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level of expertise in Power BI, financial analysis, and data visualization. If y...
Hello Andre, sorry for replying this late. After reading your requirements, I can make a shorter version of your needs over here, to see if I'm understanding your request right or not: Objective: Redesign the input page for your users (manufacturers) to document their supply chain process, making it more user-friendly and easy to follow. Current Problem: The existing input page has become overly technical and difficult to navigate. Deliverables: Figma file for desktop and tablet view, that includes a high-quality design and all design components Style: Blue-ish color scheme, professional style If everything is correct, you can accept my proposal and I can start asap ?
I'm in search of a skilled graphics designer with a knack for creating captivating nature-themed designs. The ideal freelancer for this project should be able to: - Create visually appealing graphic designs for t-shirts The shirt is for a very specific trip. It should include a background map of the American West and show the places we visit with an image of each. The images should be in the same style. I should be colorful and have the date 2024 it should include, Las Vegas Zion National Park, Bryce Canyon national park, Salt Lake City, Jackson Hole, Grand Teton National Park, Yellowstone National park, Battle Of the little Bighorn, Mt. Rushmore National Park, Badlands National Park, Denver, Arches National Park, Canyonlands National Park, Mesa Verd...
I need a capable and experienced writer to research and write about an IT-related topic for me. Key requirements: - Expertise in relevant IT fields such as Blockchain technology, Artificial intelligence, or Internet of Things - Strong research skills to ensure the content is informative, accurate and up-to-date - Ability to write in an engaging yet professional manner
I'm in search of an eCommerce expert who's adept at building eCommerce stores, and familiar with a range of eCommerce platforms. My store is focused on a modern design aesthetic. Key Requirements: - Proficiency in eBay, Shopify, Amazon, and Print-on-demand platforms - Experience with modern design elements for eCommerce stores - Ability to manage and provide insights on other platforms, as needed - Ability to create exciting listings, select fresh products for clients and assist with keeping storefronts up-to-date The perfect candidate should have a strong portfolio of eCommerce store projects, a deep understanding of the varied platforms I'm working with, and should be able to suggest and implement design choices that ali...
...goal of the project is to develop an automated system that generates high-quality content related to beauty, cosmetics, skin and hair products, and makeup. This system must: Collect content from various sources (URL, RSS, XML) configurable by a Super User. Filter and process such content using artificial intelligence (AI) to improve it. Automatically publish enhanced content to a WordPress blog and various social networks. Provide an intuitive administration panel for managing system sources and configurations. Technologies and Tools Used Backend: Django Frontend: React Database: MySQL or PostgreSQL Monitoring: Prometheus and Grafana Containers and Orchestration: Docker and Kubernetes This project is already validated by AI tools to...
I need a skilled developer to assist me in generating NFT art using code for the Solana blockchain. A specific feature I'd like is the use of Hash Lips as the source for the art generation. Im having trouble with the programs, looking for someone to walk me through it
I am looking for an artistic designer who is familiar with the vibrant and iconic style of Romero Britto, to create a modern, bespoke logo for my son's bar mitzvah. Key Features: - The logo should include my son's name (Justin), and the date of the event prominently (11/23/24) - The color scheme should consist of blue, yellow, green, orange, and red. Preferred Skills: - Knowledge of and, preferably, previous experience with Romero Britto's style. - Strong portfolio in logo design, particularly for personal events or in a bold, modern style. - Attention to detail to incorporate the listed elements seamlessly. I look forward to your unique interpretations of the task, and to making my son's bar mitzvah even more...
I'm looking for a skilled photo editor who can remove the existing date from a picture and insert a new one, as well as incorporate a text or logo to the image. Key Requirements: - **Date Replacement**: You'll need to completely remove the old date from the picture and add a new one in its place. - **Text or Logo Placement**: The text or logo should be elegantly placed on the image, in a manner that doesn't overshadow the main subject. Ideal Freelancer: - Proficient in photo editing software like Adobe Photoshop or GIMP. - Experienced in working with image manipulation and text overlay. - Attention to detail to ensure a seamless blend of the new date and the existing image.
I'm in need of a Hispanic themed vintage-inspired label design for a food product. The label should include both nutritional facts and ingredients list. The product is a Hispanic spice mix you add to food. Fun Info about product: Birria Taco Seasoning emerged from the kitchens of Jalisco, Mexico, and is based on the hearty, heavily seasoned stew served at Jalisco-area celebrations, like weddings or baptisms. Traditionally, birria was made with goat’s meat, but today, it is primarily made with braised beef or pork. It is still served as a stew, though it’s now often served on a cheese-stuffed taco that’s crisped in the fat skimmed off the braising liquid. A consommé comes on the side for an extra boost of juicy flavor. Design - 5x6 myla...
I'm seeking a expert to seamlessly integrate the Gemini API within my existing app. This integration needs to facilitate real-time updates on specific information. Key Project Details: - The primary focus of this integration is to enable real-time chatbot updates and basic reporting. - The API should provide up-to-date data when I request a report. - This isn't for automating trades or portfolio performance monitoring but specifically for keeping the chatbot informed with the latest updates. Ideal Skills and Experience: - Proficiency in with a proven track record of API integrations. - Deep understanding of the Gemini API and its capabilities for real-time data. - Prior experience in developing chatbots or simil...
I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am cu...
I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround
Title: Automated Data Retrieval from Websites Using CRM and CID Numbers Description: We are looking for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract
I'm looking to establish an E-Learning marketplace analogous to and , utilizing features similar to what offered by pinlearn.com. I need three types of user accounts: students, tutors, and admins. The features for each are: For Students (as a minimum): - Ability to search and filter tutors - Capability to book one-on-one and group tutoring sessions - Possibility to leave reviews and ratings - Sign up for subscriptions - Integration with Bigbluebutton tool - Payment options through Stripe Connect, Google and Apple Pay, among other methods - Calendar synchronization with Google and Apple. For Tutors (as a minimum): - Functionality to create and manage profiles - Ability to set availability and schedule - Receive...
I'm in need of a skilled freelancer who can assist me in collecting contact information for recruitment companies specifically operating in Saudi Arabia. Those companies are NOT necessarily based inside Saudi Arabia, could be based anywhere in the world, but they recruit for companies/entities inside Saudi Arabia. Please note that I do not need recruitment people in certain sectors such as Oil, Gas, IT, Engineering, Aviation, Procurement, Transportation, Architecture and Finance. Everyone else is yes needed. Key Requirement: You will need to find the contact name, position, email and LinkedIn account for each and every recruitment/HR/Headhunting person within each company. This could be anywhere between 10 to 30 people per company. -...
...Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of ...
Hello, I need convert a PDF invoice to Excel to import to our invoices software
I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.
I have a Python notebook containing well-structured code that effectively translates a sample of a large dataset from English to Arabic. However, the current code cannot handle the entire dataset due to its size. using : model_name = 'Helsinki-NLP/opus-mt-en-ar' Tasks: - Modify the existing Python code in the provided notebook to translate the entire dataset from English to Arabic. - Ensure the translated data is saved in two formats: Comma-Separated Values (CSV), and Apache Parquet (.parquet) - Provide the CSV and parquet files after saving (most run and give results)
I am in need of a specialized WordPress developer with experience in Excel operations and data showcasing. Key tasks: - Create a WordPress page that extracts numeric and text data from an Excel sheet. - Implement highlights and color-coded information on the webpage for better readability and understanding. - The data on the Excel sheet will be updated on a monthly basis, hence the website should be able to fetch the data automatically upon any modifications. Ideal skills: - Proficiency in WordPress and Excel integration - Experience in creating visually appealing data showcases or infographics - Strong understanding of data extraction and display technologies The aim is to...
I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is e...
I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am cu...
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
I'm looking for someone who can design a sophisticated budget template for me in Excel. This template should: - Track both income and expenses - Project weekly outcomes - Compare actual amounts to budgeted amounts - Include more than 20 budget categories - Incorporate graphs and charts for visual representation. Skills necessary for this project will include advanced Excel knowledge and experience with financial modeling. The ideal candidate will have previously worked with complex budget templates and be comfortable creating a user-friendly interface. You should know how to devise a system that simplifies input and keeps data organized and easy to understand. Your ability to turn raw numbers into straightforward graphs and c...
I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.
I am in need of a comprehensive Excel sheet that does calculation. Data entry is not too complex; it includes dates, dropdowns and formulas. Requirements: - Design an Excel sheet that calculates basic arithmetic operations, performs statistical analysis, and handles financial calculations. - The form should be user-friendly and able to accommodate the moderate complexity of data entry. - I need an expert who can create a clear and concise interface for the user, making data entry and subsequent calculations easy and efficient. It would be great if the freelancer has experience with: - Excel design for calculation purposes - Data entry form design - Experience in basic arithmetic operations, statistical analysis, and f...
Please Sign Up or Login to see details.
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
I'm in need of an Excel expert to enhance my files. The tasks include: - Removing duplicate rows - Fixing formatting issues - Merging two sheets into one Additionally, I would like to incorporate a corporate branding style in the file, utilizing appropriate colors and logos. Ideal Freelancer: - Proficient in Excel with experience in data cleaning - Skilled in formatting and merging multiple sheets - Familiar with incorporating corporate branding within Excel
I'm looking for an efficient data entry professional to input a variety of data into Excel for me. The required data includes: - Text data - Numeric data - Date and time data The main purpose of this data entry is to facilitate data analysis and the creation of reports. There are approximately 100-500 data entries in total. Ideal Skills: - Proficient in Microsoft Excel - Excellent attention to detail - Strong analytical skills - Previous experience with large volumes of data input
In celebration of my son's sweet sixteen, I'm seeking out talented animators to bring to life a unique and memorable gift. This project comprises of the following needs: - A fun and playful animated video. The tone should be light-hearted and amusing, adding a special touch to the birthday surprise. - The core feature of the video should be a custom caricature of my son. Creativity is encouraged whilst ensuring that the caricature is likable and recognizable. - Incorporate pictures of my son strategically throughout the animation to add a personal touch. However, ensure it remains subtle and tastefully done. - Photos right from his birth till date will be shared and need to be incorporated in the video Successful candidate...
...design concept in mind for a certificate that I need created in an Adobe PDF format. Please use this design and copy this design attached. Change the dog picture to the cat picture attached Change dog name Poncho to the cat's name MILLIE Change the dog owner to the cat owner: HANNAH MIEHE Registration Date change to: MAY 20TH, 2024 ADD/keep THE LOGOS ATTACHED TO THE CERTIFICATE TEXT EDIT above I will provide you with all the necessary assets for the design, including a photo and my brand logo. Your role will be to incorporate these into the certificate in a way that aligns with my concept. Ideal skills and experience for this project include: - Proficiency in Adobe Photoshop and Illustrator...
I need a detail-oriented and efficient freelancer to assist me with a data entry project. The specifics are as follows: - The project requires entering a combination of numeric and text data. - The goal is to have the data organized in a clear and coherent manner. The format of the data is likely to be in spreadsheets, although it may vary. Proficiency in Excel and Google Sheets will be essential for this task. Previous experience in data entry with formulas will be considered a plus. The ideal candidate will be able to deliver high-quality work in a timely manner.
I'm in need of a skilled developer to create a text-based GPT (Generative Pre-trained Transformer) specifically for analyzing excel outputs and give answer according to user pre-defined questions.
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30...
...a brand new Arabic podcast focusing on news and current affairs. My vision is to build a strong online presence across multiple platforms, including YouTube, Facebook, Twitter, and TikTok. I aim for this project to be the first successful podcast of its kind, connecting the community from New York to Egypt. Key Requirements: - Arabic fluency and understanding of cultural nuances - Proficiency in audio production and recording - Experience in podcasting or radio production - Social media management or marketing skills - Ability to create engaging content for different social media platforms - Knowledge of current affairs and news reporting - Familiarity with the podcast landscape and trends Your role will be to help me: - Develop a podca...
We are looking for a talented and experienced SEO copywriter to join our team. This role requires a deep understanding of SEO best practices, excellent writing skills, and the ability to produce engaging, informative, and high-quality content. Responsibilities: Write and edit blog articles that are informative, engaging, and optimized for search engines. Conduct keyword research to identify high-potential keywords and topics. Optimize existing blog articles to improve their search engine rankings. Develop content strategies to increase organic traffic and improve user engagement. Collaborate with the marketing team to ensure content aligns with overall brand strategy and goals. Stay up-to-date with the latest SEO trends, tools, and...
...skilled web developer to create an engaging e-commerce website that possesses the following features: - Product Search and Filtering: A strong, user-friendly search and filter system is crucial to help customers swiftly locate products of their interest. - Customer Reviews: A platform for customers to leave reviews on our products. This feedback is vital for our business growth. - Shopping Cart: An easy-to-use shopping cart feature for customer convenience. For the payment options, we'll discuss this aspect later as I'm still considering the best choices for my customers. Hence, the web developer should have the ability to incorporate different payment options. Ideal candidates should have solid experience in e-commerce platf...
As a growing company, we've fully set up our QuickBooks Online but it's in need of a thorough review and ongoing management. We're looking for a QuickBooks expert who can help in the following areas on a monthly basis: - Setting up sales and expenses - Managing stock - Budgeting Your responsibilities will involve keeping the system up-to-date, ensuring financial data consistency, and providing insights to support our decision-making process. The ideal candidate for this role would be an experienced accountant with previous QuickBooks Online experience. Knowledge of other accounting tools and financial acumen are also a plus.
I'm looking for a dedicated virtual assistant to assist me with simple data entry tasks. The data will be provided in handwritten notes. Ideal Skills and Experience: - Proficiency in data entry - Ability to handle simple copy-pasting tasks - Experience with handwritten notes data entry is a plus - Attention to detail and accuracy - Excellent time management skills - Familiarity with tools like Excel or Google Sheets for organizing the data Please note that while the tasks are straightforward, attention to detail is crucial. I'm looking for someone who can deliver accurate and timely results.
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
...integer in the Pojo Class: @JsonProperty("intensity") private Integer intensity; public Integer getColor() { return color; } public void setColor(Integer color) { = color; } and in parser class (INTENSITY, ((), 0)); The problem is sometimes the Api giving the color value as string not as interger but only on on checkbox config we add and this already defined in java if(checkVariant is true) then consider it string and parse it what i have to do to fix my code based on that condition so i can parse the string value this way: updateProperties("color", ((), )); how i can solve this issue so in case checkVariant
I'm in need of a specialised makeup artist, primarily for a special event catering towards adults. Venue-gwalior (lashkar city) madhya pradesh. Date of event- 9 july 2024 The Specifics: - The event specifically targets adults so the themes, tone and overall approach should be sophisticated and professional. - A natural makeup style is preferred. It's essential that the makeup enhances the inherent beauty of each individual rather than overpowering it. Ideal Skills and Experience: - Extensive experience in special event makeup services. - Proven ability to deliver natural makeup styles successfully. - Experience working with adults and understanding their skincare needs and aesthetic preferences. In your bid, pl...
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 prod...
I need an expert in Python for maintenance tasks on some existing code. Key Tasks: - **Bug Fixing:** This code has some bugs that need to be identified and fixed to ensure its proper functioning. - **Code Optimization:** Your expertise is crucial to streamline and optimize the performance of the existing code. Ideal Candidate: - Proficient in Python - Experienced in code maintenance - Skilled in bug fixing and code optimization.
