Vba sort table jobs
We need to create a plugin that will handle the matching of products with the specific types of cars. The types of cars are actually the combination of the following data: CarTypeId - Maker - Model - Year - RoofType Their relationship should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the pr...
I'm looking for an expert in EA (Expert Advisor) to optimize the performance of my current EA system. In particular, I'm interested in: - Enhancing the trading algorithm: You should have a profound understanding of trading algorithms, as this task will require you to optimize my EA's functionality substantially. - Implementing better risk management: Yo...focus on improving the risk management aspect of the trading algorithm. This means you have extensive experience with risk analysis and how it's applied in trading algorithms. Having background knowledge in finance would be beneficial for this task but isn't necessary. However, strong analytical abilities, problem-solving skills, and an eye for detail are a must. Bring your expertise to the table and ...
Design a DJ table as per the sketches and drawings provided.
...plus This project is perfect for someone who is passionate about home decor and has a keen eye for modern design trends. I'm looking for someone who can bring my vision to life in a realistic and impactful way. If you think you're the right fit, I'd love to see some of your past work and discuss this project further. What i exactly want: - 15 designs of vases (for plants, cactus, etc) - All some sort of round shape - 4 of them in a low-poly style - create any design really - Size: Between 5 to 20cm - Results need to be as-is 3d printable and usablte straight away. I need: - Full rights on the results - Files in formats .step, .stl and originating format of your used application. I do not care which one you use to fulfill this job - one zip containing all files. ...
...SEO, and we're eager to expand upon this. The desired candidate would: - Have a deep understanding of Google’s ranking algorithm - Be up-to-date on the latest SEO strategies and trends - Have proven experience in driving traffic, improving rankings, and generating leads/sales - Be based in or have expert knowledge of the Indonesian market. We're excited to see what you can bring to the table and help our business grow....
...challenge lies in acquiring as much relevant data as possible for accurate predictions. Project Scope: 1. Preparation Stage: The freelancer will be responsible for identifying and researching all available sources of space debris data, both free and paid. This includes a comprehensive evaluation of data providers to ensure the data's relevance and quality. The output at this stage will be an Excel table summarizing the research, which will include provider names, links to data or registration, pricing (if it is a paid source), additional requirements from the provider, and descriptions of the data. We anticipate identifying up to 10 data providers. 2. Evaluation and Registration: We will evaluate the providers, register for their services, and handle payments if the data ...
STRICLY NO A.I (there is always spelling mistakes) I'm in need of a professional logo designer for my company, Precision Pipe Repair. The logo will be an abbreviated version, featuring the initials 'PPR' along with a combination of text and symbol. Logo : PPR...have: - Demonstrable experience in logo design, particularly for abbreviated logos - A strong portfolio demonstrating a variety of styles and an understanding of colour theory - Ability to cater to a futuristic and professional theme - A keen understanding of the pipe repair industry and the ability to incorporate this knowledge subtly into the design. If you can bring all these skills to the table and create a logo that meets my requirements, I'd love to hear from you. Please share samples of your pr...
I'm looking for a talented web designer to build a fitness website focusing on a robust online booking system. The priority functionality should be to enable booking for nutritional consultations, meal plans, and workout programs. Ideal Skills: - Proficiency in web design - Experie...functionality should be to enable booking for nutritional consultations, meal plans, and workout programs. Ideal Skills: - Proficiency in web design - Experience with online booking systems - Background in designing fitness or nutrition websites Design Preferences: Given that I have no specific design preferences, I would love it if you could bring your unique ideas and creative instincts to the table. Your portfolio, showcasing your previous works, will play a significant role in this sel...
I'm looking for an expert in packaging design to create a visually appealing and modern box packaging design for my new product - screen wipes. The packaging should be: - In a box format - Small, with dimensions included in the template - Modern and minimalistic in style Ideal skills for this job include: - Graphic design - Packaging design - Experience in creating modern, minimalistic des...packaging design for my new product - screen wipes. The packaging should be: - In a box format - Small, with dimensions included in the template - Modern and minimalistic in style Ideal skills for this job include: - Graphic design - Packaging design - Experience in creating modern, minimalistic designs I'm open to your creativity and suggestions, so feel free to bring your own ideas ...
I need some help with a data model I created in Power Pivot. I have 2 data sets: one is Sales a...sets: one is Sales and the other is Stock. I have added both data sets to my data model and am now trying to create a pivot which pulls data from both tables. My Sales table pulls the data perfectly but the Stock table does not. Some context... When I pulled the data into the data model I added a column which I called DataModelLink. This created a 1 (Sales) to many (Stock) relationship between the two tables. As an example, I tried to pull the data of one particular style which had one line in the Sales table but 2 lines in the Stock table. For this reason, my Pivot is only reading one of two of the lines on the Stock data table. I am happy to share the...
I currently have a PHP script that echo's the value of a MySQL db and results appear 3 to a page using Pagination. I'd like the script modified to filter results. There should be a drop down box on the page with the selections of the drop down corresponding to the table column and when selected only the rows with the value of the column appear while still only displaying 3 to a page with page back and forward controls. In the below example of a db table the drop down box would contain the selections 1, 2 and 3. When the used selects 1 then the page output would only display Bob, Jane and Sarah. This is an already existing page with css in the output. Name Address. number ------------------------------------------------------ bob bris...
...designing logos for existing businesses. Color Preferences: While I have some ideas for the color scheme, I am open to suggestions and would appreciate the designer's expertise in this area. Logo Elements: Since many people call me "DIL", and I use "DIL" with many of my hashtags (Example:--> #DilWithIt), and I am using my name "Dilshad Alvi" as the company name, I would consider incorporating some sort of highlight or bold to "Dil" within "Dilshad". If you are considering incorporating a subtle and tasteful element, such as a stylized knee silhouette or a symbolic representation of prayer, to complement my name in the logo to represent or tie in what I do/people I work with, please ensure it doesn't overcrowd the ...
...evaluation tool (types of survey questions) that would be appropriate for this scenario, given the main outcome. You should include other variables of interest and a data analysis plan. State the variable types and specific analyses needed. Using the data provided (see attachment) , create a tables: Table 1 - demographics based on comparison groups, Table 2 - outcome table other associated variables with comparison groups, and Table 3 Analysis - multivariate analysis of your choice and written interpretation of the analysis. Section 2 - Scenario Two Scenario: Based on scenario 1 in this section, you have been asked to detail the epidemiological background of the outcomes of interest, obesity and physical...
I'm looking for a skilled professional to help me synchronize employee attendance records from ZkTeco ZkTime 5.0 to MSSQL on my local server. This is a daily batch update proces...structured in MSSQL in a way that allows for easy querying and reporting. - The process should be efficient and reliable, with error handling mechanisms in place. Skills needed: - Proficiency in ZkTeco ZkTime 5.0 - Strong experience in working with MSSQL databases - Excellent understanding of data synchronization processes - Ability to work with structured data and maintain normalized relations in a table-based format. Ideally, I'm looking for someone who can implement a robust and automated solution for this task. The successful candidate will be able to demonstrate their previous experience ...
>>Read first<< this is not a project this is a full-time job you will join our team of 14 devs don't bid blindly you will be ignored if you don't reply and start your text with >>Full Time Job << your bid will be ignored bid your monthly salary ask This is a full-time job 40h/w if you are not free don't apply ---------------------------------...where you've focused on these two platforms. Showcase your ability to adapt to different project scopes and requirements. If you can handle this dual-platform project with efficiency, we are looking to form a long term collaboration. Take this opportunity to be a part of an exciting, evolving project, while honing your Wordpress and Laravel skills. I am excited to see what you can bring to the table...
I am seeking a talented graphic designer to create a timeless classic-style logo that will captivate my target audience. The logo should strongly resonate with our audience in order to attract and retain their attention. It is necessary for any prospective freelance designers to deliver: - A highly detailed project proposal. - A clear understanding of traditional design principles. - A unique...target audience attraction. Ideal skills and qualification required for this job include: - Prior experience in designing classic logos. - Solid concepts on classic style branding. - Able to deliver on detailed project proposals. Your proposal should effectively illustrate how your design will engage my intended audience. I look forward to seeing the innovative concepts you can bring to the ...
I am seeking a passionate video editor to create a compelling 30-second video ad for the upcoming release of my game. The main aim of the video ad is to promote the new rele...Utilize the gameplay clips I've taken to create a high-energy, captivating narrative. Ideal Skills and Experience: - Proven experience in creating video ads, particularly in the gaming industry. - Proficiency in video editing software and techniques. - Ability to understand and cater to the preferences of hardcore gamers. I'm looking for a freelancer who can bring fresh and creative ideas to the table, and deliver a high-quality video that will drive interest and excitement for the new game release. I have the video clips ready just need someone to mimick the style of this enshrouded ad
I'm in need of a skilled data miner who can help to extract certain details from a vast range of Shopify products. Your mission, if you choose to accept it, is as follows: - list products that contain non-English writing or words in text and videos - Organise and sort these findings for simple review - Identify and list any products filled with non-English language in the description, pictures or images - Compile lists of products that aren’t currently making top-seller lists - List any products can not be delivered in eight days or less. Please note that tractors and food vans may take up to two months to deliver. - List any products that are not suitable for industrial purposes/non-commercial products. Ensure that the products you are considering are meant for commerci...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
Project Title: "Customer Order Management System" for an online retail business in MS Access. Objective: To develop a comprehensive database system that allows for efficient tracking and management of customer o...Generate sales reports by date, product, or customer. - Inventory level reports. - Customer order history and patterns. Instructions: Based on the given information do the following: 1: Create a DFD using Visual Paradigm. (Note: we have worked on VP in class) 2. Choose Entities 3. Create ERD based on the entities chosen 4. Create tables/files for each entity 5. Enter minimum 3 records in each table. Read the Key Features to create Columns/Fields in the tables. 6. Create ERD inside MS Access and join the tables based on the ERD 7. Create min 3 queries using...
...consumers to view menu options, order meals online, and make reservations seamlessly. Key features of the application: - Menu Display: Should allow customers to easily browse various menu categories and individual meal descriptions. - Online Ordering: Requisite infrastructure for placing orders online, including a secure payment process system. - Reservation System: Must include a highly-efficient table reservation system with instant confirmation. Ideal Skill set: - Extensive knowledge and experience with Flutter app development - Strong fluency in Dart programming language - Proficiency in implementing secure online payment gateways - Previous experience with restaurant or similar e-commerce applications is a plus In your bid, please furnish samples of your previous wo...
...expressions, capturing nuanced emotions such as smirking and pensiveness among others. - Platform: Though the primary deployment platform isn't specified, a PNG format that can openly be edited and used across varied platforms is required. Ideal Skills: - Graphic Design: Expertise in designing refined, elegant, and vibrant PNG emojis. - Creativity: Ability to bring intuitive and refreshing ideas to the table. - Attention to detail: Capability to capture and design nuanced facial expressions accurately. A proven track-record on similar projects or in creating personalized emojis will be highly beneficial. This project demands a keen eye for detail and a knack for understanding and channeling emotions into graphic design. If this intrigues you, place your bid and let's ...
Dough one Sources is looking candidates for Senior 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 – 200 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 kno...
The name of the club is MUSIC 4 MEMORIES. It is to help those suffering with any sort of memory degenerative disease such as Alzheimer's or dementia; through music therapy. I need a skilled logo designer who can swiftly create an engaging logo for a school club, focusing on brand recognition. Requirements: - Experience in logo design, specifically for organizations in the learning/education sector. - Ability to work quickly (ASAP requirement). - A strong understanding of brand recognition principles. Ideal skills: - Graphic Design - Branding - Creativity - Understanding of the school/education sector. **** The idea image is a brain with the brain stem as an instrument. this is just a thought for you to use as inspiration from. I would love to see some unique, out of the ...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
We are in need of an experienced graphic designer, specializing in print, to work on creating promotional signs / posters for different clients. The project is ongoing, so I'm looking for someone who can commit to a continuous workflow. Key requirements: - Proficient in creating engaging and visually appealing sign/poster designs - Experience in print media,...role is ideal for a creative individual who is keen on long-term collaboration and has a strong portfolio in print design. I attached our 2 main products as reference. We individualize these products for each client according to their CI. Please start your application with your birthyear. All other submissions will be declined! AI or computer generated texts need to show 1970. I hope this helps to sort out all the autom...
Here is a brief of my requirement. What I want is when I am creating a collection page, the way I can actually sort the product is either through best selling item, product title, highest price or lowest price, new best oldest and manually. Now we have thousands of product in a collection at the moment hundreds of them. What we want to do is instead of the regular product filter which is available on Shopify, we want to have a custom one with the logic on the basis of either row as or basis on the conversion rate. So we can actually connect this with the Google sheet or we can actually have an identifier in terms of how the product would change their, how would product would look on the collection page in terms of where they are on the collection page basis of an identifier.
I'm in need of a de...Key features of this project include: - Extraction of table data: You should have knowledge and experience working with web data extraction, specifically with table data. - Selection of stocks data: The script should have the ability to select and extract information from the stock table. - Capability for multiple companies: The tool should be versatile to handle data extraction for multiple companies, not limited to just one. Experience in the use of n8n for data extraction from websites, especially in the finance sector, will be a significant advantage for this project. One of the page is: And the table is in the "premium" div. The credentials will be provided to the selected freelancer. The table looks lik...
I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...
I'm in need of an interior designer with experience in modern design aesthetics who can completely transform my living room and dining area. My preference is for a neutral color scheme with whites, grays and browns being the prominent tones. Key Elements include: - A medium sized and mpressive dining table, as I often entertain guests - A comfortable seating area that promotes relaxation, chats, and comfort. - Media Wall - Maximization of natural lighting - an aesthetic that capitalizes on light will be highly favored - Incorporation of features like a console, mirrors, wall art, center rugs, a media wall, and sofas with accent that combine style and utility. Special Attention should be paid to: - Nice, lush curtains that complement the modern aesthetic and enhance the spa...
When button clicked, the field of another table will changed to required. Only FTP no cpanel
Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.
Design and implement one page website. The website shall have a design similar to...libraries or APIs. Something like bootstrap + vanilla JS would be ideal, or bootstrap + jQuery. The website shall have a small database usage feature, in which every time the page is loaded, a new row is added to "leads" table with the following information: 1) Visitor's browser agent string, 2) Visitor's IP address, 3) 0 or 1 depending whether user is using a mobile device, 4) User's name, email, phone number and message if they fill up the contact form and click the "Send" button. Note: In case user send the form multiple times, then this data is overwritten in the same table row. After I accept your bid, you will get server access to the server that h...
...examples is provided in the json format. We plan to have 1000 entries in this json at least. The database includes: Photo (each person will have at least one phone), name, birthday, occupation, transaction table, ... (please see the json file). Animations: when a user scrolls down new information block appears. Layout: The page should start with a photo of the person and a name on the left. See the attached file. In the middle of the page should be a table with trasactions, use a component from react here (or other possible framework): DData for the table comes from the json file. Please add in the bottom after all information from a user sign: Need more info come to us. Please add 2024 to the end of the page. The website should be mobile and
I have a google sheet with 400 exercises. I need to copy them all over to a notion document with a slightly different format. Here is the google sheet — https://docs.google.com/spreadsheets/d/1SCYzmyfXgZfhu4TFkBi0YQzbXjrzl4O-hVyZZ1eo1HQ/edit#gid=0 Here is the notion table (I will provide access to edit) — I need all of the videos from “Jen’s Exercise Demos” copied over with the name, the video url and the howToTips into the correct columns. All of the videos are vimeo links so should have “vimeo” selected in the videoType column Many of the tips have multiple number bullet points, I need there to be 2 lines between each bullet point, as demonstrated in the example rows. Equipment and
...tasks for my project. Although I chose to skip specifying the exact functionalities, the developer should anticipate working on tasks such as: Work on 45 pages, each very simple. There are 3 main page features: 1. View table from DB 2. Create new record in that table 3. Edit record in that table Most the pages are the same, just a different table. A few tables have some other functionality but it's all very easy. All html design has been done already, you just have to add some PHP/MySQL code to make the pages work with the database. You also need to create the DB, table and records. Though most have been created already. You would need to double check them though. I also need the web services to connect the DB to our mobile app. Techn...
Only FTP will be provided. Link 1 column with another table. and amend existing API only
I'm looking for an experienced API developer to help with syncing and scraping data from Confluence. Ideal Skills and Experience: - Proficient in Confluence API - Expertise in data synchronization and data scraping - Knowledge of handling Confluence pages, spaces, attachments, and content images - Able to preserve formatting and filter by date Key Responsibilities: ...synchronization and data scraping - Knowledge of handling Confluence pages, spaces, attachments, and content images - Able to preserve formatting and filter by date Key Responsibilities: - Develop an API integration for data synchronization - Implement scraping functionality for Confluence pages, spaces, and attachments - Ensure the scraped content maintains original formatting - Implement filtering logic to sort...
I'm looking for a talented designer to create a comprehensive brand guidelines document for my real estate company. The primary goal of this project is to ensure consistency in our brand representation across all platforms. Key Deliverables: - A detailed brand guidelines document: This document will serve as a blueprint for our brand identity to be shared with partners, ensuring that ...guidelines for companies - Strong understanding of visual identity, color theory, and typography - Ability to interpret and translate brand values into visual elements - Experience working in the real estate industry would be a plus, but not a necessity. The successful candidate will play a key role in shaping how our brand is perceived in the market, and I'm excited to see what you can bring ...
...Management: The CMS should have the ability to manage users, with a specific focus on admins. - Reporting and Analytics: The system should incorporate robust reporting and analytics features that can offer insights into loan applications and user activity. - Application Rejection: There should be a clear mechanism for rejecting loan applications within the system. - Filters will be required to filter and sort data as per date, status, month. User Roles: - Admin: The primary user role I'm seeking is for admins to manage the system. Rejected Applications: - The system already have a mechanism in place to handle rejected loan applications. Ideal Skills: - Experience with CMS development - Strong understanding of data management and analytics - Proficiency in user management ...
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
We are a health food company. We need to update the table text of our 6 existing products. The lable design and layout do not need to be changed, only some text needs to be modified, and the text font needs to be consistent with the original labels.
I'm in need of a marketing assistant who can bring fresh ideas and creativity to the table. This role will primarily focus on social media management and content creation. Key responsibilities include: - Social Media Management: You will be responsible for managing my Facebook, Instagram, Linkedin, and Tiktok accounts. This includes creating engaging posts, responding to comments, and growing the follower base. - Content Creation: I'm not looking for someone who will just use Canva templates. You must be able to create original and high-quality content in various formats such as blog posts, infographics, videos, and regular social media posts. Ideal candidate should have: - Previous experience in social media management and content creation - Strong copywriting skills an...
Myself and my daughter are getting matching tattoos. We love Billy Joel, and want lyrics to out favourite song. The lyrics we want are - "I'll meet you anytime you want In our Italian Restaurant" There are no album cover or sibgle images we want, but in my mind i wondered if there could be an italian style piazza restaurant table incorporated? We do not want colour just the classic dark blue tattoo colour ink.
I'm looking for a skilled graphic designer to create a unique, dynamic logo for my upcoming automobile brand, BORCELLE CAR SERVICE. The deadline for this project is the 19th of April. My budget is up to $55. Even though I don't have preferences for colors or symbols to be used in the logo, I expect the designer to bring creativity and innovation to the table. Experience in logo designing, especially for automotive or similar industries, will be appreciated. A good sense of color combinations and an understanding of branding impact are essential. Your portfolio will be considered among the major deciding factors. Please bid only if you can guarantee the delivery by the specified deadline.
I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
I'm on the lookout for a talented virtual assistant who thrives on lengthy hours of work and enjoys every second of it! This isn't your usual VA role, though - I'm seeking someone who can confidently handle the following responsibilities: - Social Media Management: More specifically, I need someone adept at Instagram. You'll be responsible for ...that resonates with our audience. Ideal Skills and Experience: - Clear understanding of the Instagram platform and how to optimally engage audience in it - Skills in crafting Instagram worthy content - visuals, captions, and stories - Experience in managing professional instagram account is a plus - Must be organized, communicative, and able to handle long hours of work If this sounds like the sort of work you'd...
I'm in need of a talented copywriter to create engaging and motivational content for a radio spot. The aim of this project is to promote a product or service to a young adult audience, aged between 18-35 years. Your primary goal will be to craft inspiring content that connects with this demographic, encouraging the...forward-thinking. Ideal skills and experience for this project include: - Proven experience in creating persuasive and engaging copy - An understanding of the young adult market - Ability to use language and tone to evoke emotions and drive action - Familiarity with radio advertising is a bonus, but not essential. I'm looking forward to working with someone who can bring fresh and exciting ideas to the table, while keeping the target audience and business...
I'm in need of a skilled freelancer who can put together a comprehensive HR dashboard for me, to be updated on a monthly basis. The project involves: - Collating and organizing data: The dashboard should cover Attendance and leave records, Training and development, as well as metrics like age, experience, tenure, salary and location of our employees. Your ability to structure and organize th...ensuring that the data is up-to-date and accurately represented. Ideal freelancer should have: - Proven experience in HR analytics and dashboards - Excellent Excel skills - Ability to present complex data in a clear and concise manner - Strong attention to detail - Proficient in data management and analysis. I look forward to collaborating with a professional who can bring these skills to th...
