Vba sort column ascending jobs

...Page, Column A -I want to be able to select room type from a dropdown menu, and input the revenue for different room types on the Revenue Target page. Room types are Private Room, Shared Room, Shared Medicaid. Employees Page, Column A -I want to select employee job type from a dropdown menu for each employee. There are 22 employees, and the Employee job types are: Caregiver Med Tech, Caregiver Non-Cert., Kitchen Chef, Kitchen Staff, Nurse, Bookkeeper, Administrator, Director, Admin Assistant, Activity Director, Maintenance Worker, Driver. Also, I would like 4 blank rows at the bottom where I can add new employees if needed. Shifts Page, Column A Row 14 -Change Shift Types to match Employee Job Types above. -Add 10 blank rows where new shifts can be added. S...

I'm looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell will be changed to yellow, an...

...experience in representing it in illustrations is highly valuable. -Description: the twins have spiky upright brown hair and brown eyes. Ranger is wearing a plain Royal blue and black jacket with tan pants and Royal blue and black shoes. He has scars on both his hands. He has one freckle on the Ryder wears a Plain red and black jacket and Royal blue pants. Also Royal blue pants. I want the cover to sort of look like this: Ryder is peeking his head out from behind his bedroom door looking at Ranger who is against the wall with his head in his knees. He has his arms covering his head. A little bit blood is running down his arm. (NOT ALOT!) The dad is standing over him yelling while holding up a rag....

...services like location tracking and generating lists of nearby services. Key Functionalities: - For the location tracking feature, I will need: - Real-time tracking: This will be a core feature of the app - API: Reading from API - Listing nearby services based on some KPI - For the nearby places search feature, I will need: - Filter by category: To enable users to find relevant places - Sort based on property: This will enhance user search experience Ideal Skills: - Proficient in React Native framework - Experience with mapping services - Strong understanding of real-time tracking - Previous work on location-based service apps - Familiarity with custom marker implementation - Ability to create a user-friendly and robust UI I am open to suggestions and ideas on how...

generate panel with graphics, such as, pie, bar column. with asp.net

I'm looking to create a detailed list in Excel from the website AND filtered by clicking on 'Hardware' under 'Products' which is on the left side in the 'Filter' section. The list should have two columns - the first for the Company Name and the second for the Description available on the website. Key Requirements: - Copy the Company Name into Column 1 and the Description into Column 2 of the Excel sheet. - Description should be directly copied from the provided URL. Ideal Skills and Experience: - Proficient in Excel and web scraping. - Attention to detail to ensure accurate data transfer. - Previous experience with similar projects would be advantageous.

Looking for someone to design site and add content to it based on research on other companies and also our brochure. The ideal person needs to have some sort of engineering background or willing to do proper research to do the site right.

I'm currently experiencing issues with the formatting of my blog page that I need rectified with expediency. The primary problem is that the images on my blog are not displaying in the correct manner. Instead of the intended multi-column layout (3-4 columns on desktop), my blog's images are displaying in single line and the entire layout appears squashed to the left on mobile devices. Additionally, new blogs are not updating to the top of the queue as they should, adding to the overall problem. I do have a specific design in mind to address these issues and I would appreciate it if we could adhere to it in order to maintain the unique aesthetics of my blog. Ideal skills for the job include: - Extensive experience in HTML/CSS, JS: able to tackle layout and forma...

I'm in need of an experienced Excel professional to help me build a secure data management system. This system will be used to handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that...customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - Strong understanding of data security and privacy - Excellent communication skills to understand and mee...

I need a web-based contract management application with alerts system to remind me of contract termination dates. Key Features: - Contract Entry System: The application must allow for storage and retrieval of specific contract details which include the contract value, duration, name, start date a...which include the contract value, duration, name, start date and end date. - Sorting Functionality: A key requirement is for contracts to be sorted primarily by their end dates. - Alert Mechanism: The application should notify me noticeably in advance of each contract's expiry date. Ideal Freelancer: You should be a skilled application developer with experience in creating management systems with sort-function and notification features. Understanding of contract management would b...

...and laravel developer who can make changes in mobile application and its backend web admin panel: 1. Need each project description 1 or 2 lines at the very beginning before the containers and need an option in backend panel to enter that info 2. If we go into each interest or project we will see multiple campaigns here first of all i need all this campaigns in a line one after another or in a column and now each campaign will have its own set of pictures which user can see via slide 3. Further i want to change the look and feel of the container i have reference available 4. Secondly each user has its own donation history which you can see right here i want this particular rows showing particular transaction clickable through which user can see their particular receipts relati...

I'm looking for a virtual assistant to support me in effectively organising my Outlook inbox and streamlining my email management process so no emails are missed moving forward. Key responsibilities: - Sort and organise emails: I need assistance in categorising my emails based on sender, subject matter, and urgency. I would appreciate some guidance on how best to structure this for efficiency. - Help structure and automate my inbox management: I’m looking for someone who can not only organize my inbox but also help me put in place strategies that will streamline my email management process over time. Ideal Skills and Experience: - Proficiency with Outlook: A strong understanding of Outlook and its features is a must. - Proven experience in managing inboxes: Experience ...

I'm looking for an experienced VBA coder who can focus on two main tasks. 1. **Fixing Existing Issues:** - My current VBA code has issues with execution errors and incorrect results. I need solutions to these two problems. 2. **Adding Modifications:** - I'm looking for someone who can add additional features to my existing VBA code. - Good user experience is important too so improvements on the user interface would be very beneficial. Ideal candidates will have an excellent understanding of VBA syntax, debugging, and error handling. Experience with user interface design is also appreciated. The aim here is to produce accurate calculations, formatted data or reports swiftly and easily.

I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Subject Account Name: C...

Get value from one column from another table only. Able to work with ftp. Just this issue

I am in need of an Excel relational database. The database should have the functionality to enter values automatically from an attached worksheet. The entry of these values will be based on specific criteria, more specifically, column values. Required Skills and Experience: - Strong knowledge and proficiency in Excel - Experience in database creation, management, and optimization - Understanding of data entry and data analysis - Proven experience in creating reporting capabilities within Excel. Using the "Reference data" tab, when the value in Column B is entered in the "Example worksheet" the corresponding values should automatically populate - Tariff code, Duty rate, CPF.

I need an experienced professional to sort plugin causing image + text not loading properly. Plugin Link: Only Experts required to solve the problem Need someone who can start instant & complete the work

I'm seeking a proficient Excel VBA coder to create a system that automates data entry from Excel files. The task involves: - Creating a VBA function that can input data automatically into my current system. - Implementing a data sorting feature as part of the data entry process to ensure that all data is easily read and interpreted. The ideal freelancer should have the following skills and experience: - Proficiency in Excel VBA - Experience with automated data entry - A solid understanding of data sorting techniques. This project requires precision and attention to detail. It should not only meet the needs listed above but also enhance data accuracy and save time.

I need a proficient structural engineer who can deliver a General Arrangement (GA) drawing and design verification for a Reinforced Cement Concrete (RCC) beam. The task at hand involves a cantilever carporch of 3.5m x 6m dimensions, destined for vehicle parking. I'm picturing an industrial-style steel beam that will be supported over an existing 250x600 RCC beam, which itself sits atop an RC column. Importantly, the carporch won't be subjected to any extra weight besides the vehicle. Your experience and skills: - Mastery of industrial design style - Proven experience in RCC and steel structure design - Proficient in providing design verification - Knowledgeable in GA drawing - Able to optimize for weight and structural stability Your main deliverables: - A GA drawing o...

I'm seeking an experienced Excel VBA expert to help me automate some basic, repetitive data entry and formatting tasks. Key Requirements: - Automate basic data entry and formatting tasks in Excel - Develop VBA script to ensure automation runs smoothly Ideal Skills and Experience: - Proven experience in developing VBA scripts for Excel - Strong understanding of Excel functions and data formatting - Ability to create automation systems that run seamlessly without user interaction Please note, no user interaction is required for this project. The VBA program should be designed to run automatically once set up. This task is relatively simple but needs to be executed precisely and efficiently. Looking forward to working with a professional who can deliver ...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

I am struggling with incorrect results when attempting to subtract two values in a column of clock times in Excel. My data is in a 12-hour clock format, and I signify AM and PM directly within the time cells. I require an expert in Excel to address this issue promptly. To take on this project successfully, you should have: - Proficient Excel skills - Solid understanding of the 12-hour time format and functions in Excel - Ability to troubleshoot and rectify the problem quickly

...automating the transfer of information between those departments: linking the data, defining "trigger" events, and processing data from various inputs into "smart" trackers. I have a clear outline of what I want to accomplish - what data I need, who I need it from, and how I want the tracking of the inputs to function. My "coding" ability is a limited working-knowledge of JavaScript PDF and Excel VBA. I need someone to provide council and advise on what is possible, what tools or platform would be best for the end product I want to develop, and to advise on any alternatives. Basically, I am in the early stages of a long development process and I need an expert coder to review my outline and provide advise for the best way to accomplish what I want. ...

I'm seeking an Apple Script expert to help me automate a specific task in Numbers. - The task involves splitting a single column of four-digit numbers into four separate one-digit columns. - The split should be done in a sequential order, meaning the first digit of each number will go into the first separate column, the second digit into the second separate column, and so on. Ideal Skills and Experience: - Proficient in Apple Script - Extensive experience in automating tasks within Numbers - Strong understanding of data manipulation and processing

Hello, I would like to have an Unreal Engine 5 map designed. It would be a jungle island (think sort of caribbean inspired) covered mostly in jungle type terrain, a few rivers winding through it, with a mountain range and volcano in one area, as well as the surrounding sea floor. I would like it to follow earth like geography as much as reasonable. I would also like it to be able to be dynamic, with native villages potentially moving around, maybe little charcoal/fishing/hunting/lumber camp type villages dotting the landscape, and the ability to be developed by an exploration group (building port cities, establishing mines, etc.) I'm thinking I would like it to take about an hour to traverse from one end to the other on foot at it's longest point (to encourage travel by se...

Please Sign Up or Login to see details.

I need an expert who can develop a solution which scrubs WeChat for geolocation data on a consistent basis. Key Requirements Include: - Ability to monitor WeChat and extract geolocation data - Continually importing and updating the location data - Ability to sort and organize acquired data Ideal major skills are: - Familiarity with WeChat APIs and data management - Experience in geolocation data extraction - Understanding of data privacy principles and adherence to these guidelines Please include a rough time and budget estimation along with any past experiences dealing with similar projects. I look forward to hearing from you.

I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.

Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.

...localField: 'toUser', foreignField: '_id', as: 'toUserDetails', }, }, { $unwind: '$fromUserDetails', }, { $unwind: '$toUserDetails', }, { $match: matchLanguage, }, { $sort: { createdAt: -1 }, }, { $group: { _id: { $cond: [{ $eq: ['$fromUser', userId] }, '$toUser', '$fromUser'], }, lastMessage: { $first: '$$ROOT' }, }, }, { $sort: { '': -1 }, }, { $skip: startIndex, }, { $limit: limit, }, ]); // Further processing and emitting ...

...second, or third occurrence. The program will enable users to assess the quality of the Part B images and proceed to update both the Part A image and its associated Part B images by selecting and clicking "Next". This iterative process will continue until all images have been reviewed. Subsequently, the program will generate an Excel sheet containing the user's quality assessments in the third column. Overall, the program aims to streamline the evaluation process, allowing users to conveniently navigate and assess image associations while providing a comprehensive overview of their quality assessments for further analysis. - Using Python and CherryPy to develop the tool - Implementing a simple yet efficient user interface for the selection process The purpose of t...

...essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft SQL Server Management Studio, and my system operates on Windows. You would be working an 8hr paid day in the Austr...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

I need a Google App script that can scan a specific folder on my Google Drive for files and process them. The processing should involve an api that will skip tracing by first name and last name, if that returns no results then by company name, or if that returns no results then by property address to find the email. Once the email is located append it to the row in column AW. Once completed, prefix “processed_” to the file name. Api to use: skip force Key Requirements: - The script should be able to scan a specified Google Drive folder for files. - When a file is found, the script should process it by skip tracing. This involves cross-referencing the information in the file with first names and last names, company names or property addresses. - The script should be ...

...and then suddenly stopped working for only the largest file. Through my own tests, I’ve learned that if I remove the 30 columns prior to the last column in the problematic Excel file, it transfers fine, so it’s not a coding issue. There’s either a problem with too many columns or something in one or more of those 30 columns is causing an error when moving the data to the database. Since the website needs to be user friendly, we can’t expect the user to fix the Excel sheet. We also can’t just write code to remove the 30 columns prior to the last column, because all user files might not have the columns in the same order, so a required column might find itself in one of those locations. Based on my test results, one possible solutio...

I'm in need of an experienced photo editor to sort through a large picture file and edit selected images to a professional, bright and vibrant standard. Key Tasks: - Sort a 25.9GB zip file to find the best pictures from a recent photoshoot. - Editing should be bright and vibrant, suitable for professional use (business promotion, marketing). Ideal Skills & Experience: - Proficient in photo editing software, with a portfolio showcasing similar, professional-grade work. - Able to efficiently sift through large files to select the best content. - Understanding of the unique requirements for bright, vibrant professional editing. This project is crucial for my professional image. I'm looking for someone who is reliable, creative and has a sharp eye for what mak...

...relevant date column of the "ORDERMENTUM" tab in the google sheet. See sample production report attached () - this is for the items required by customers on Saturday May 4th. This data is not available to access without exporting it to a csv file. For retail orders we use Shopify but use two apps to provide the data to our production team so that they know when the customer has selected to pick up their order - Zapiet Pick + Delivery to assign an order pickup/delivery date (it does so by adding date tags to orders) and Report Pundit to organise this information into production reports. See an example Report Pundit export for Sunday May 5th (Production - Daily ) This data needs to populate into the relevant date column of the "SHOPIFY"

I need a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong understanding...

...experienced MS Access developer to assist with my form development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic functionalities - Previous experienc...

I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns for each piece of information.

...user-friendly, with key features such as: • User Profiles: Create robust and detailed profiles for users to showcase their products with precision. • Messaging System: Implement a reliable in-app communication system for seamless user interaction. • Payment Integration: Embed secure, versatile payment options for easy transaction handling. • Location-Based Services: There should be a feature to sort items by location or city, allowing users to buy from local vendors. • Buying and Selling: Users should be able to easily list their handmade items, food, or accessories for sale and browse others’ listings for purchase. Experience in developing marketplace mobile apps is key. Knowledge of modern design principles and experience with payment gatew...

...SCRAPE THE DATA. PYTHON SCRAPPER DON'T NEED I'm in need of a VBA developer who can help in creating a small code for scraping contact details from a specific website. The task involves creating a button in an Excel file that triggers the scraping process and saves the extracted data back into the same Excel file. Note : Project budget is only 6k because it will take max 2-3 hour for experience developer Key Requirements: - Scrape contact details from - Specifically, scrape Owner Name & Address - Implement a function where a user clicking a button triggers the scraping process - Save the extracted data back into the same Excel file Ideal Skills & Experience: - Proficient in VBA programming - Experience with web scraping - Familiarity with

We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: - Track product movements (Received from Dock, Moved to Location, Picked, RTS) - Forecast demand accurately - Calculate reorder points precisely (Flag Products that are low in stock) - Distr...Sequens is Location, Part, QTY) - Ensure daily inventory updates are possible (Inventory has to be LIVE) - Add a dashboard for visual view of KPI's and results The ideal candidate will have proven experience in ERP Excel design, particularly within the field of inventory management. Expertise in IR Scanning layout will be strongly favored. Knowledge needed. - Excel Formula Mastery - Pivots Tables - VBA...

I'm in need of an intermediate level automated meeting minutes solution on Excel 2016. This project requires expertise in Excel and VBA and knowledge of data categorization. Key requirements include: - **Template Generation**: The tool should be able to generate a meeting minutes template automatically. - **Categorization**: Information in the meeting minutes should be categorized by attendee. Date Task owners Points discussed New Ideas generation' related System Process People Technology others Ideal skill set for this project includes: - Proficiency in Excel, particularly Excel 2016 - Experience in VBA/Macros for Excel - Previous work with data categorization and template generation Looking for someone who can deliver a robust, user-friendly solution that s...

Linking of dropdown with another column. Work with ftp only.

Please read my requirements: (make a table of 5 columns) 1. Name of Journal: I need a List of double-blind peer-reviewed Journals of International Law. Provide the journal's website and email address in this column. 2. Publication cost: The journal's publication cost APC must be cheaper or free. Please write the publication cost per page. Don't mention any journal that exceeds thirty dollars per page. 3. Status: The journal must be Indexed with Research Gate, Google Scholar, Academia, JSTOR, etc. 4. Ranking: Mention the international ranking of the journal. 5. Nature of journal: Legal articles, academic research papers, international law areas, including human rights, international trade, international humanitarian law, peace, security, and conflict. **Please Organ...

I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.

I am seeking a detail-oriented freelancer to input text and numerical data into 3 small Excel spreadsheets, containing 1 column each. 2 spreadsheets for emails, one called Minnesota, one called Midwest. 1 spreadsheet of inventory numbers. See attached. Only emails are needed. Inventory is on yellow paper Ideal Skills: - Proficient in Excel - Attention to detail - Knowledge of data organization and management Highlight the entries that you are not sure of, or the handwriting is to difficult to read. English fluency in a must.

I am seeking an experienced .NET developer to build a highly dynamic REST API using the .NET 8 framework. The API will be designed to manage interactions with a database using a single, generic controller capable of handling all database tables. This project will involve implementing advanced features such as column selection, filtering, sorting, pagination, and complex table relationships like aggregations and master-detail references. Core Requirements: 1. API Framework: The API should be developed using .NET 8. I am open to using either OData or GraphQL for the API architecture, depending on what the developer finds most suitable for the project requirements. Alternative suggestions are welcome for discussion. 2. Generic Controller: The API should feature a single, generic cont...

I'm looking for an experienced designer to create a unique and abstract logo for my business. Here are the essential project details: The company name is Ameriflex inc. The company is centered around the textile industry so we would like to incorporate some sort of thread fiber woven materials into the logo - Logo Colors: The primary colors for the logo should be blue and red. These colors reflect the identity of my business. - Logo Style: The design should be abstract. Although it represents a business, it must not be boring or uninteresting. - Emotions to Convey: I'd like the logo to convey an energetic and professional vibe. I want my customers to see my business as dynamic, attractive, and reliable. Ideal candidates would have substantial experience in graphic desi...