Combine column data column vba jobs
I am in the market for a skilled graphic designer with proven experience in logo design and YouTube thumbnails. My goal is to enhance brand recognition through these designs. Specifics of this project include: - Design a company logo that embodies trust and rel...enhance brand recognition through these designs. Specifics of this project include: - Design a company logo that embodies trust and reliability, to foster brand recognition. - Develop eye-catching, engaging YouTube thumbnails related to our business field. Ideal skills and experience: - Proven design experience in both logo and YouTube thumbnail creation. - Strong portfolio showcasing ability to combine graphic design principles with an understanding of brand recognition. - Ability to deliver high-quality work within ...
The objective is to develop an application to manage two devices via WiFi (may be increased in the future) I have two devices: Sauna and red light therapy panel. They all have a touch control panel and can be connected to your cell phone via Bluetooth and Wi-Fi. Many of the providers also offer you the mobile application already developed ...cell phone via Bluetooth and Wi-Fi. Many of the providers also offer you the mobile application already developed (as can be seen in the attached images). The idea is to make a similar application from which the two devices can be managed (set time, lighting, power, etc.). And the history of uses/settings is saved. It could also be evaluated to take the code of the two suppliers' applications and combine them into one, strongly separating ...
I need a skilled animator to bring my educational content to life through 2D character animation. Please view this old educational video: We need the characters to be more dynamic and updated as well as all the animation...achieve high-quality results, you're free to use the tools you're most comfortable with. Ideal Skills and Experience: - Proven track record in 2D animation. - Previous experience with educational content is a plus. - Ability to work independently on storyboarding, animation, and editing. - Strong communication skills to understand the educational content and align animations with it. If you can combine creativity, skill, and a passion for learning, I'd love to see your portfolio!
...need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and ...
I am looking for an experienced developer to create a user-friendly web application. Users will upload two images: a headshot and an image of an item of clothing, and the AI will combine these to create a natural, realistic image of the person in the clothing. Key Features: - User-friendly image uploading: The primary focus of the first version of the web app is to allow easy image upload for users. - Basic options to select the type of clothing fit: Users should be able to provide basic inputs related to the clothing, such as size or fit, before the AI generates the final image. Ideal Skills: - Proficiency in AI image processing and manipulation - Web development experience, particularly in user-friendly interfaces - Understanding of e-commerce and virtual try-on technology is...
...Requirements: Platform: Microsoft Excel and Outlook. Preferred Methodology: VBA for seamless integration with Microsoft Office suite. Other suggestions are welcome if they provide a better solution. Deliverables: Automated Excel Workbook: An Excel file with VBA scripts to automate data entry, courier selection, and order form generation (if chosen methodology). VBA scripts to automate sending and receiving emails via Outlook (if chosen methodology). Documentation: Detailed documentation on how the automation works, including instructions for use and troubleshooting. Testing and Support: Initial testing of the automated system and support for any issues that arise during the first month of operation. Skills Required: Proficiency in VBA for Excel and...
I'm in need of an experienced interior designer to help me visualize my new living room and bedroom in a modern style through 3D rendering. Key Points: - The design should reflect a modern style, with clean lines and minimalism. - The project wi...specifically involve the living room and bedroom. Color Scheme: - I'm envisioning a mix of brown, off-white, bright colors, and luxurious colors. - The design should be luxurious and well-coordinated. Ideal Skills and Experience: - Proven experience in interior design, particularly with modern styles. - Proficiency in 3D rendering software. - Strong understanding of color theory and how to combine various colors effectively. - Ability to communicate and interpret design preferences effectively. ** please refer to the attach...
I'm seeking a creative and t...that's modern, clean and adaptable - A design that balances the fishing theme with a professional, roofing company aesthetic Ideal Skills: - Proficiency in logo design, with a portfolio showcasing a range of styles - Ability to create unique, memorable designs - Strong understanding of branding and visual communication Please upload your previous work samples that showcase your capability to combine seemingly unrelated themes into a coherent and visually appealing logo. Feel free to bring your own creative touch to this project while keeping it aligned with the fishing and roofing elements. Something like the screenshot below but instead of that Text have Reel on one side and Roofing on the other side. I like the coloring. Put a Roof of a ...
I am seeking an experienced PineScript developer to create a custom trend-following strategy. I already have they key indicators and ideas, but need someone to combine all into one indicator and strategy and then automate it to trade on a broker platform. The person must be very experienced in Pinscript because the indictors are using Renko overlay charts and the indicators will be applied to the Renko overlay to make decisions.
Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code
...efficient, and secure PHP page for our agents. Our customer sells products (not online, but in shop). He wants to receive orders from agents. I have an excel file containing the products that he wants to sell. The excel file has 5 columns: 1st columns is for Brand 2nd column is for Model 3rd column is for Color 4th column is for Price 5th colums is for Quantity in Stock We want to realize a simple php page with a form to send an email with the chosen products. We need that someone just fill the database wkth the data we have in excel file (about 350 lines) To access the page we need a login page. We need 2 levels: 1 level: administrator 2nd level: agents One administrator is sufficient More agentes are necessary. ADMINISTRATOR PAGE: The administrato...
We need the following combination of online database and data entry interface from users + a local MS access file. Online Database and web I terface for data entry We want to have multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in table visible) MS Access (local file) Administrator must...
...). The table contains WNBA player statistics, The goal is to extract all columns of this table, which is approximately 7 columns and write it to a CSV file (in the same column format). I'm a beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on websites If you're confident in your web scraping abilities, have good experience with Python, and can ensure accurate extraction of the specified player statistics
Please Sign Up or Login to see details.
...to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is looking
I have two websites that need to be merged with a main focus on consolidating information. The current websites are different in design and themes, and I'm looking for a professional who can successfully merge them into a cohesive, user-friendly site. Key requirements: - Consolidate information: The primary goal is to combine and organize the content from both websites into a single, easily navigable platform. The new website should provide a clear and seamless user experience. - Prioritize by relevance: The content should be arranged in a way that is most relevant to the user. This may involve restructuring and reorganizing information to ensure that the most important details are easily accessible. Ideal skills and experience: - Proficiency in website design and deve...
...output, mainly focusing on efficiency, ease of use and weight. Key requirements: - Designing a high-power dynamo/alternator that can support extensive power needs. - The device should be attachable to a standard bicycle without impacting its performance or aesthetics. - Prioritizing power output over size or weight, meaning the final product can be robust as needed. Your role will be to: - Combine your expertise in electrical and mechanical engineering to create a prototype. - Ensure the final product is not only functional but also practical for cyclists to use. - Potentially provide suggestions on storage solutions for the generated power. Ideal skills and experience for this job include: - Proven experience in designing high-power dynamo/alternators or similar energy gener...
...least 8/10. Deliverables: - Primary Video of 30 seconds in Portrait and Landscape - Secondary Video of 15 seconds in Portrait Resources: 1. Videos are attached. If you do not find them interesting, I can attach more 2. Game Name: "Patterns Puzzle Game" 3. Game Platform: "Android, IOS" 4. Keywords: Relaxing, Interesting, Puzzle, Patterns, Tough 5. Ping me for more details. Key Requirements: - Combine multiple, short videos into one cohesive and engaging piece. - Fast-paced and energetic editing style to captivate the viewer. - Include animations and transitions to keep the video visually engaging. - Add text overlays and captions to highlight key features or events. - Incorporate sound effects and music to build excitement and enhance the visual impact. ...
I'm looking for a talented video creator who can produce an engaging screencast. This video will serve as an introduction for potential investors, showcasing the features and benefits of our software product. Key Requirements: - Combine product introduction with feature demonstration: The video should provide a comprehensive overview of the software, while also illustrating its core features and functionalities. - Attention to detail: Accuracy in presenting the software's UI and functionalities is crucial. - Professionalism is key: The video should be polished and professional, suitable for a corporate audience, including potential investors. Skills Required: - Proficiency in creating screencast videos - Strong video editing capabilities - Ability to present complex soft...
We are in need of a talented designer to create a poster for an upcoming concert we are hosting in Brussels on 26/10/24. The theme of the concert revolves around bagpipes and hunting horns, and so it's crucial that the design captures the essence of these two different instruments. There will be two bands at this even...performers. - Incorporate visual elements such as musical notes and the concert venue to enhance the overall appeal of the poster. If you need any high resolution of the photos, let us know. Ideal Candidate: - Proficient in graphic design with a creative flair. - Experience in designing event posters, especially related to music or concerts, is highly desirable. - Understanding of how to effectively combine text and visuals to create an eye-catching and info...
...Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integration &...
...(Solidity/ERC721) to specifics cryptocurrency markets; I think of a good system and its subsequent easy management; a lot of material needs to be reorganized, offered in English, with a sober and professional style, similar on every website, with the option of being available in every language (Wordpress); the basic contents and plan in matrix at the bottom in (first column general info, each others column basic contents on specific websites/patent); ...not need easy migration (traslation) !!! Please: present clearly your offer better; ...how many days do you need ? ...what kind of trace/flow do you think ? *all my easy action, now start from === old asset - new asset; Aruba / Italia ...next to Hostinger / Lituania .
...works. Key aspects of the project: - The typical turnaround time for such orders is 1-2 days. - You are required to produce artwork with the same quality and similar style (see provided examples). - Our processing time is limited, so timely communication and completion of tasks are crucial. Ideal Skills: - Proficiency in realistic digital art - Excellent attention to the detail - Ability to combine different photos to create the portrait Experience in creating similar works and portfolio showcasing such portraits will be required. Links: Artwork Examples:
I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).
Please collect product information on cars that are equipped with the technology described in the [2. Technology Description] column below. ※Note Please do not collect information based only on the information listed in [1. Background] [3. Reference information] ([1] and [3] are for reference only) 【1 Background】 This technology pertains to a system that utilizes mobile devices in vehicles. Specifically, it combines a smart key system with Ultra-Wideband (UWB) wireless communication to authenticate the mobile device with the vehicle and precisely detect the location of the device. Based on this location, the system determines whether to allow or deny vehicle operations. This aims to enhance security and service quality. However, since UWB communication uses high-frequency bands, co...
I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue(&quo...
...models to extract data from a variety of tax and financial documents. The extracted data needs to be exported into a Google spreadsheet. Additionally, I need an interface for users to easily upload these documents. Key Requirements: - Extract data from various financial documents: primarily focusing on Expense reports, W-2 forms, credit card statements, 1099s, and annuities. - Extract specific data from credit card statements such as Transaction amounts, Merchant names, Transaction dates, and also the ability to convert currency and combine rows. - Extract specific data from bank statements like Account balances, Transaction descriptions, and Check numbers. Ideal Skills and Experience: - Proficiency in Azure document intelligence and trainin...
Please collect product information on cars that are equipped with the technology described in the [2. Technology Description] column below. ※Note Please do not collect information based only on the information listed in [1. Background] [3. Reference information] ([1] and [3] are for reference only) 【1 Background】 This technology pertains to a vehicle control system designed to enable specific operations on a vehicle. Traditionally, there has been a smart system utilizing electronically authenticated keys through wireless communication with the vehicle. However, a new method using sound authentication with a device worn on the user's ear has been proposed. While this device offers a novel way to authenticate with the vehicle, using standard communication protocols allows authen...
I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.
I'm searching for a talented DJ or music producer to combine elements from two songs and create a unique mellow remix. This project requires: - Emphasis on both lyrics and beats from each song. Your creativity in meshing these elements together is crucial. - The overall mood of the remix should be mellow. It is essential that the remix should not be too fast-paced or energetic. Ideal Skills and Experience: - Proficiency in using music production software - Knowledge in music theory - Experience in remixing and blending songs. Your creativity and interpretation of the two songs will make this project a success. Looking forward to hearing your unique spin on these tracks.
Hello, I need mapping a CSV that contains many information and put all words in each column
...Example 2) for our testimonials. We'll use variable data for the testimonial text based on our seller's avatar (see Target Groups image for testimonials). We'd like three different testimonial images: Anglo (white), Latino, and African-American. We will use different images based on the zip codes and the prominent ethnicity in the area. Our business is data-driven so we can target our customers based on problems we know they're facing and have solutions for them. In the Example 1 card, you can see where it says "We can help with: <STATEMENT 1>, <STATEMENT 2>, <STATEMENT 13>. Please see the Targeted Messages image to see some of the variable data that will be placed in this section. We really like the look of Example...
...Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mode of delivery, Drop sequence, PP number, Delivery date, Weight, Volume, Addressee, Name of addressee, Deliver address addressee, ZIP/postal Code, Delivery info, Number of cartons/units, Total ADR. The data is sorted using the “Mode of delivery” information, which allows deliveries to ...
I'm in need of a skilled designer to create a logo for my company that combines text and icon elements. The design should be both elegant and sophisticated. The final product should convey a sense of professionalism and reliability. Ideal skills for this project include: - Experience in logo design - Ability to combine text and icon elements effectively - Understanding of elegant, sophisticated design aesthetics - Ability to reflect professionalism and reliability through design I look forward to seeing your creative solutions.
I'm currently using a Python scraping bot for my project, but I need to make some adjustments. Key ...scraping bot for my project, but I need to make some adjustments. Key Requirements: - The primary modification involves segmenting the scraped data by day. To achieve this, I would like to have a timestamp column added that differentiates data on a daily basis. This will allow me to have a better understanding of the data collected each day. Your Proposal: In your application, please provide a detailed project proposal. I'm interested in freelancers who can clearly articulate how they will approach this task and ensure its successful implementation. Ideal Skills and Experience: - Proven experience in Python scraping bot modification - Familiarit...
...screens - A base design with each lesson (math, science, reading, history), and all the data is linked via Chatgpt (GPT) backend process with an API - Detailed customizable report generation process Ideal Skills and Experience: - Proven experience in UI/UX design, particularly with educational platforms - Strong familiarity with data visualization tools and techniques - Ability to create user-friendly and visually appealing design - Knowledge of integrating graphical representations, such as bar graphs, with user data - Experience in working with APIs and chatbot backend processes - Previous work with customizable report generation features is a plus This project requires a designer who can combine functionality with an intuitive design that meets ...
Need to convert text file to a clean page and remove the colums showing passwords.
I need a professional adept at advanced Excel functions to create a spreadsheet, whi...The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including VBA, Macros, and writing complex formulas, balanced with an understanding of rota scheduling needs. Experience in the healthcare/pharmacy field would be a plus as well. Your understanding of our needs would help us make this project a success. Good work on this project could lead to more opportun...
I need an expert to pull data from my MySQL database, specifically from the Customers and Orders tables, and send it to a Slack channel in a unified message. The data includes text, numeric, and date entries. Key Requirements: - Integrate MySQL data with Slack: I need the freelancer to help me integrate the data entries from the specified tables with a Slack channel. - Collide Entries: The entries from the Customers and Orders tables need to be combined into a single, coherent message. - Include Specific Fields: The message should include specific fields from the MySQL tables. These fields include Customer Name, Order ID, Order Date, Customer Phone Number, Customer User ID, Product Details, and Product Quantity. Ideal Skills and Experience: - Proficient in MyS...
...FAST? SEND A DRAFT TO PM, I'll review it and if I like the work it's yours. Check out the websites and then think about how you could combine all these services into one website, basically that's what I want. The main objective of the project is to develop a website where we combine the features and services of and in one website. DO for this I need a figure so that the developer can follow the design. We will offer both features of the mentioned sites on a single website so we need to combine them in an ingenious way, so I need a designer to create a figma file or similar so that the developer can use it as a guide. we must combine it in ingenious ways. . I need an expert in saas projects Please share your previous related jobs, like beh...
I'm seeking an experienced Excel guru to help create / identify two specific formulas on my spreadsheet. This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to create a formula that co...
I need a simple, single-column WordPress site set up with the following requirements: - The site will need to be built from a provided WP demo content folder, including plugins and theme. - The main content will be of a standard, text and image-based nature. - The site design should be a straightforward single column layout. For this project, you would need: - Proficient skills in WordPress - Experience with SCSS - The ability to set up a local site - Familiarity with migrating WordPress sites Please ensure you can work with the provided WP demo content folder as the basis for the site.
...related to Excel. This task involves the careful extraction of data from Excel into a pivot table. The data in question is financial in nature, and more specifically, the focus is on expenses. Here is what I require: - Just the expenses data extracted from the Excel file and made available for the creation of a pivot table. - You'll need to determine the format of the data in the Expenses column. Your skills and experience: - Advanced knowledge of Microsoft Excel, especially in working with different types of data. - Proven experience in handling financial data, specifically expenses. - Ability to interpret varying formats of data on Excel. - Good problem-solving abilities, given that the specific format of the data ...
I'm looking for a Virtual Assistant with solid experience in Python, JavaScript and VBA, particularly for handling scripting tasks. Ideal Skills and Experience: - Proficient in Python and JavaScript - Previous experience with scripting tasks - Excellent communication skills - Pro-active communication style Main Responsibilities: - Writing and implementing scripts in Python and JavaScript with APIs - Ensuring the smooth execution of various scripting tasks
...statistics, providing an authentic touch without overshadowing the message. - Making sure the script is engaging, thought-provoking, and highlights the importance of reproductive rights effectively. Skills & Experience Needed: - Experience in scriptwriting, particularly radio scripts. - Familiarity with, or willingness to research, modern day issues surrounding reproductive rights. - Ability to combine personal experiences with factual information seamlessly to create a compelling narrative. - Possess sensitivity and understanding for the topic at hand. Be clear in your presentation with the following: What issue you are addressing Why the issue is timely, topical, and relevant to our time and place The ideal freelancer for this project would be someone who can bring emp...
Please make wordpress site as atteched image. 1 column and respoinsive design.※If possible,bootstrap design. Anything is include dummy text and dummy images. I make inquiry and faq,sitemap page by myself and send you wordpress login details. Required Pages:Top page,fx,crypto-ex page,1 currency detail page Please make within $120(absolute requirement) and delivery within about 2 weeks and give me a progress report every about 4 days. I think only the table part is a little more challenging.
...including SwiftUI, Combine, and Core ML. Key aspects of the project: - The application should be compatible with macOS - The primary goal of this app is to increase the functionality of device management for iPhone users. - The application should assist users with entering recovery mode, restoring firmware, and downloading files - Please provide examples of your past work that demonstrate your programming abilities Tasks: - Develop the User Interface: Design a user-friendly interface using SwiftUI. Implement UI components such as progress bars, buttons, and status indicators. - Implement Core Functionalities: Use Alamofire for handling firmware downloads. Utilize libimobiledevice for interacting with iOS devices to enter recovery mode, DFU mode, and perform restores. Use Core ...
...multi-modal sentiment analysis and emotion recognition system. This system aims to analyze and understand human emotions expressed through various modalities, including text, images, and audio. The primary objectives of this urgent project include: 1. Multi-Modal Data Integration: Develop algorithms to effectively fuse information from text, images, and audio sources to capture the holistic context of emotional expression. 2. Text Analysis: Implement state-of-the-art NLP techniques to extract sentiment and emotion from textual data. This involves sentiment polarity detection, emotion classification, and fine-grained sentiment analysis. 3. Image Analysis: Utilize deep learning architectures such as convolutional neural networks (CNNs) to extract features from images and...
...write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriate method) integration in Excel that allows calling the GPT-Invoices model and returning the response in the same cell. Skills Required: Experience with OpenAI GPT models and their customization. Strong understanding of Excel, including VBA or other scripting languages for Excel. Experience with integrating APIs with Excel. Familiarity with cloud storage solutions like OneDrive and handling file structures programmatically. Additional Information: Please provide examples o...
