Excel vba select range with variable number of rows and columnsdela

Potrebujem app ki prebere excel in ima možnost vnašanja(import) excel tabel, dostopno mora biti preko mobilne/web aplikacije, imeti mora možnost razporejanja oz dodajanje dela večim ekipam, na koncu mora vse skupaj združiti v skupno tabelo, odšteti količino porabljenega materiala za delo oz voditi zalogo opreme in ločeno voditi količino porabljenega materiala za posamezno stranko, moznost uploada slik za posamezni id stranke, in upload to na pc oz web server

Narisati je treba shemo nadzornega sistema stavbe po nadstropjih in v vsako nadstropje vnesti komponente iz excel tabele - do 100 komponent

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

need help with spreadsheet formula

...looking to create a comprehensive database of self-managed home care providers in Queensland and Australia to facilitate networking within the industry. Key requirements: - The database should include the provider's: - Name - Address - Email - Prime contact Ideal skills for this project: - Proficiency in data collection and database creation - Familiarity with the home care industry in Queensland and Australia - Organizational skills, to categorize the data by region - Excellent attention to detail, ensuring accuracy in information provided The data should be organized by region for easier networking. I may also require the database to be updated periodically. The collected information should be reliable, up-to-date, and include...

...specialized salesperson and lead-generating individual to boost our customer base in the Gardening and Irrigation industry. - **Target Industries**: The primary focus will be on Gardening and Irrigation. - **Services Offered**: We offer a range of services including Garden design and installation, Sprinkler system installation, and Plant maintenance and care. - **Project Goals**: The main objective of this project is to Beautify outdoor spaces, Improve water efficiency, and Increase plant health and growth. The ideal candidate for this role should have prior experience in the Gardening and Irrigation industry. They should also have a proven track record in sales and lead generation, particular...

i have a list of 11,000 car part numbers. need to find the image from each one, if you type the part number in google you'll find the image for that part.

Hi, I’m looking for a skilled FlutterFlow App Developer. Ideal Skills and Experience: - Perfect English and communication skills - Responsible, reliable, and ready to start ASAP - You MUST be independent (No Agency or companies) - Proficient in app development: – FlutterFlow – Good taste in UX design Please send me the links to any related projects you've worked on. Please start your proposal with the words "FlutterFlow Green Boat" so I know that you actually read this. I have a lot of work for the right candidate and there’s a potential for a consistent and long-term flow of work if you can deliver quality results.* Any out-of-range bids will be ignored! Thanks, Byung Chul...

I'm in need of an experienced graphic designer who can help me create several T-shirt designs. These designs are intended for adult humor enthusiasts and should reflect this audience's interests. Key Requirements: - Design Style: While the design should cater to adult humor enthusiasts, I'm open to a range of design styles. From minimalistic to vintage to cartoonish, I'm looking for a creative expert who can bring unique and engaging ideas to the table. - Quantity: I need assistance with creating around 1-5 T-shirt designs. - Original Artwork Files: Once the designs are finalized, I will need the original artwork files to ensure high-quality reproduction when uploaded to our supplier. Ideal Skills: - Strong understanding ...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: - Data Cleaning & Preparation: This includes cleansing the data from any incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. P...

I need a logo designer w...for strengthening the online presence of a brand. My ideal logo incorporates the company name and complements our brand identity with its inviting and approachable design. Key Project Requirements: - Should have experience in creating minimalistic, vintage, and modern logo styles, focusing particularly on 'Friendly' type - Proficiency in creating logos that significantly improve online presence - Ability to include the company name in the logo design creatively Skills and Experience: - Proven experience in logo design, particularly for online brand building - Excellent understanding of color theories, typography, and visual designing - Proven ability to deliver unique and friendly logo...

I'm in 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 effic...

...in need of a seasoned Mechanical Engineer with specific expertise in heat transfer, fluid dynamics, and thermodynamic cycle analysis to assist in the development of a revolutionary solar thermal engine patent prototype. Key Requirements: - Conducting in-depth thermodynamic cycle analysis for the solar thermal engine. - Designing the engine layout and key components to optimize its performance. - Understanding and managing the behaviors of steam vapor and condensate. - Proficiency in analyzing fluid flow, power, and pressure drop. - Knowledge of steam hammer and heat pipe behavior for this application. - Experience with developing engines within the 1-5 kW power output range is essential. ...

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

...knowledge of LUA and experience in scripting anime abilities. Key Requirements: - Proficiency in LUA and ROBLOX scripting - Previous experience with implementing anime abilities in games - Familiarity with animations, visual effects, sound effects, and camera movements The project involves incorporating a range of anime abilities inspired by series such as Dragon Ball Z and Jujutsu Kaisen. The specific abilities will be discussed and shared with you as we progress in the development, so no predefined abilities are required. Your tasks will include: - Scripting the skills and abilities - Creating animations based on ROBLOX style - Implementing visual effects - Adding sound effects - Adjusting camera ...

...in need of someone who can help me gather email addresses, websites, and phone numbers from the links in the attached spreadsheet. It's crucial that the information you provide is accurate and up-to-date. The test of accuracy will be me sending emails and verifying the company. Any wrong details will need to be collected again unless it is beyond your control (e.g. company has closed down etc.) Automated collection will be erroneous as the data needs to be collected in the following way. use the company names or links from the attached spreadsheet. 2. To copy and paste the company name + UK in the Google search box. The company's operation must be based in the UK as similar names may exist in US as well. 3. Or to click company logo...

...well-researched, and clearly demonstrate the financial viability and growth potential of my business. - Strategic Planning: I require a roadmap for my service-based business with clear strategic objectives, market analysis, and competitive landscape. - Operational Guidelines: The plan should also detail operational procedures, staffing requirements, and technology needs. The Nature of My Business Idea: - Service-Based: My business is primarily service-based, catering to both businesses (B2B) and consumers (B2C). Therefore, the plan should be structured to appeal to a wide range of audience including potential investors, partners, and customers. Ideal Skills and Experience: - Proven experience in creati...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

...specialized salesperson and lead-generating individual to boost our customer base in the Gardening and Irrigation industry. - **Target Industries**: The primary focus will be on Gardening and Irrigation. - **Services Offered**: We offer a range of services including Garden design and installation, Sprinkler system installation, and Plant maintenance and care. - **Project Goals**: The main objective of this project is to Beautify outdoor spaces, Improve water efficiency, and Increase plant health and growth. The ideal candidate for this role should have prior experience in the Gardening and Irrigation industry. They should also have a proven track record in sales and lead generation, particular...

...a new Python script for data analysis purposes. The primary goal of the script will be to analyze a dataset that I already possess. The script should be able to handle large amounts of data efficiently, allowing for insightful analysis and visualization. The key requirements include: - Writing new code from scratch - Prior experience in data analysis using Python - Proficiency in Python libraries such as Pandas, NumPy, and Matplotlib If you have a solid background in data analysis and Python, and are able to create efficient, clean, and well-documented code, I'd like to hear from you. Here are details- I have to create a simulation that will find the optimal solution to go around a circuit using the least amount of po...

Hi there. I'm running XCode 15.3 and I need a few pages done with simple, clean storyboards and View Controllers. I use Alamo Fire and Swift, so if you could use that to pull my data via my API links and display it in several pages that would be great. Categories > Collections > Items > Item Details You select one and it shows a list - Item Details is one record from a MySQL db I need each selected item to be a variable in the code of the ViewController so if I use the print function, I can see it at the bottom of XCode. I'll give you the 3 or 4 API webservice links. I can give you a super simple app to put it in too...

...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 a pl...

...lifestyle content creator, my main focus is to increase the number of subscribers on my YouTube channel. Key Requirements: - Goal: The primary aim is to develop a strategy to organically increase the channel’s subscriber count. - Skill: You are expected to have experience in growing YouTube channels, particularly in the lifestyle niche. - Strategy: A well-thought-out plan to boost subscriber numbers is crucial. Your Expertise: - Experience: Prior experience in driving subscriber growth is essential. - Knowledge: An understanding of lifestyle content and its audience would be a significant advantage. - Creativity: Innovative solutions to engage viewers and attract new subscribers are highly desired. Please come forward with your deta...

I'm looking for a skilled font designer who...create a custom font family for me. The theme I'm aiming for is Modern. This font family should consist of 5 or more font styles that offer versatility and cohesiveness. Ideal Skills and Experience: - Previous experience in creating custom font families, especially in the Modern style - A strong understanding of typography and design principles - Experience with both digital and web font formats - Ability to design a range of styles within the Modern theme, ensuring the family is cohesive yet diverse - Strong communication skills to understand and incorporate my vision into the design. The final font files should be compatible with web and digital ...

I'm looking for a skilled and experienced writer who can craft an engaging and informative blog post on investing in stocks. The post is intended for families planning their finances, so it should offer valuable insights and practical advice that this demographic can easily understand and implement. Key points you should cover in the blog post: - Tips for creating a budget: This section should provide practical and actionable advice on how families can set up and adhere to a budget. The guidance should be clear and easy to follow, helping readers to better manage their finances. - Strategies for saving money: The blog post should also outline various strategies families can use to save more effectively. This can range from cutt...

...in need of a Windows compatible automation software that can efficiently handle a range of tasks including data entry, file management, and email/notification management. I need the project completed as soon as possible. Key Requirements: - Windows Compatibility: The software should be designed to run smoothly on Windows OS. - Multiple Task Automation: The software should be capable of automating data entry and processing, file management, as well as email and notification management. - Quick Turnaround: The project ideally should be completed ASAP. Ideal Skills and Experience: - Proficiency in Windows software development. - Prior experience in developing automation software. - Strong understanding of data entry, file m...

I'm preparing for the Azure AI 102 exam and specifically looking for help with the Natural Language Processing section. I need a comprehensive set of practice questions and answers specifically tailored to this area. Key Requirements: - Development of practice questions and answers: These should cover a broad range of topics within Natural Language Processing, aligning well with the exam's requirements. I need help in some questions and answers with right explanations

...will be dedicated to selling a range of products and will need to incorporate various key features to ensure a smooth and secure shopping experience. Key requirements: - The website should have a visually appealing and user-friendly design, with a clear focus on the products. - The primary goal of the site will be to facilitate online sales, so it's essential that the developer has experience in creating successful e-commerce platforms. - It's crucial that the site supports a shopping cart feature, enabling customers to add, remove, and manage their selected products easily. - Customer reviews play a significant role in building trust and credibility. The site must include a review system for customers to share th...

I'm in need of an experienced 3D modeller who is proficient in Autodesk Revit. My project requires: The Conversion of 3D laser scans with BLK360 into high quality, detailed Revit models. The objects is the survey of information of a structure of 335m2 in plan made up of two levels, the first level consists of a structure of 6 columns that are part of a system of frames resistant to moments, on an articulated base. On the second level there are two structures to support the air coolers, in each one there are 4 fans and they are made up of 15 columns working in a system of gantries with concentric braces. The information that the survey must contain is: Geometry, pro...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I'm in need of a physical chemistry expert to help tackle some problems and calculations. The ideal candidate would be able to break down complex physical chemistry concepts and problems into simple, understandable pieces. Key responsibilities include: - Helping to solve a range of physical chemistry problems - Explaining problems in a way that makes it easy for high school students to understand Ideal Skills and Experience: - Strong educational background in physical chemistry - Solid experience in problem-solving in physical chemistry - Ability to explain complex topics in a clear and concise manner Your work will directly contribute to the educational content aimed at high school students. Your expertise is essential in ensuring...

I'm looking for a Python developer to create a simple Dash app that includes a PDF viewer. Key Requirements: - User can upload multiple pdf files in the app. - The user can select which pdf should be displayed in the viewer - the user can enter a text in a text box and when hit submit the app should be able to highlight those texts in the PDF. - The pdf viewer should have search feature, pages and zoom in and out.

One of our clients is looking for a literature search with a view to searching the Pubmed database using the inclusion and exclusion criteria and providing a document containing the output. The details of the literature search can be found in the following link. The candidate performing the job should be skilled in performing medical literature database searches, able to collate the results and write an academic document containing citations style of Vancouver Style. There is no restriction on the number of words. Requirements: - Conduct a thorough search on PubMed focusing on Medical Informatics - Provide a detailed summary of abstracts found in the search - Ensure the search is comprehensive and up-to-date Id...

...automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability ...

...need of a typing test application that focuses on an average typing speed range of 40-60 words per minute. This application should present the user with paragraphs to type. Upon completion of the test, the application should display a comprehensive error tracking and review. Key Features: - Average typing speed assessment: The test should be designed to evaluate a user's typing speed within a specific range. - Paragraph-based typing: The test should present users with paragraphs to type, as this more closely simulates real-world typing scenarios. - Error Tracking and Review: After the test is completed, the application should provide detailed tracking of errors made during typing, enabling users to review and...

...to craft and implement original themes is crucial. This “event” it will be something special organised for a special person. I Key Responsibilities: - Tailoring innovative and captivating event themes under the guideline provided from me - Ensuring that the chosen themes are distinct and memorable for the persons who will benefit about this special event - the person will need to coordinate and engage other advisors necessary for this event (marketing, web designer, etc) Ideal Skills: - Experience in special event management - Adept at creating and implementing custom event themes - Knowledge in the logistics of managing and coordinating a range of vendors - media and web design The rol...

I am currently using R, specifically the ppcor package, to conduct partial correlations on a sizable dataset. Unfortunately, the process is slow and fails to address all columns efficiently. I'm seeking assistance to: - Improve the computation speed - Enhance the handling of columns within my dataset The ideal freelancer for this task should be proficient in R programming, with specific experience in working with the ppcor package or similar tools for statistical analysis. A background in optimizing code for large datasets would be highly beneficial.

I am seeking a skilled graphic designer with experience in creating attention-grabbing social media posts. The primary goal is to increase product promotion for my range of physical products. Key Responsibilities and Requirements: - Design visually engaging graphics for social media platforms - Create designs that effectively communicate and promote the features of the physical products - Ability to align designs with brand aesthetics - Prior experience in promotional material design will be immensely beneficial. The ideal freelancers for this project will be creative, experienced in marketing-focused graphic design, and have a solid understanding of social media trends. Please showcase your previous work in a similar domain...

...handle a variety of media-related tasks for my project. Your role will encompass: - Advanced Video Editing: Expect to work with special effects, motion graphics, and advanced color grading for a range of video content. - Photoshop Expertise: You'll be responsible for creating, editing, and refining images for both social media content and marketing materials. The core themes of the videos you'll be working with are travel, fashion, and food. Ideal candidates for this role should have a blend of skills and experience that include: - Proficiency in video editing software. - Strong knowledge of Photoshop and graphic design principles. - Previous experience working with me...

...hours, so durability and attention to details are crucial. Your task will involve incorporating a wide range of AI voices (more than four) to deliver a more engaging and dynamic listening experience. Furthermore, I want certain voices to have specific accents to align with the unique characters featured throughout the novel. While the accents aren't currently decided, your input and expertise here would be appreciated. The ideal candidate for this project: - Is proficient in AI voice technology, preferably with a portfolio featuring multiple voice characters. - Has a keen ear for voices and accents, ensuring that each character’s voice is distinctive. - Can deliver a high-quality, 12-hour audiobook production...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

I need a skilled photographer to take a large number of high-quality images of industrial parts at specific location(s). Requirements: - Expertise in product photography, particularly with industrial parts. - Ability to shoot more than 50 photos. - Flexibility to work on-site at various locations. - Proficiency in lighting and composition. - Prior experience in studio or on-site product photography. Please provide a portfolio showcasing your past relevant work when applying.

I'm seeking a creative and talented designer to craft a unique and attractive logo for my roofing company, Reel Roofing LLC. The brand name 'Reel' is a nod to my love for fishing. Thus, I'm hoping for the logo to subtly incorporate elements related to fishing, specifically a fishing reel. Key Requirements: - Incorporate a fishing reel subtly into the design - Utilize the colors blue and green, reflecting a calm and natural aesthetic - Focus on a modern and possibly bold design style Your Work: - Should be original and not based on generic templates - A style that's modern, clean and adaptable - A design that balances the fishing theme with a professional, roofing company aesthetic Ideal Skills: - Proficienc...

I'm in need of a skilled web developer to set up a secured tutoring scientific website. This platform will facilitate online classes, between Students, Instructors and Schools (the field of study will be discussed personally) Student Privileges Student, Instructor and School Registration phase. Where they can setup their accounts and generate their Profile Cards. There are two categories of Student Accounts (School Registered or Free) New Session page: where the student can select Subject & Topic, and mention questions if required. Then, Instructor Selection Phase: An interface to let students select a suitable instructor, for their subjects based on the instructor's predetermined disciplines, then select...

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

create 10 spreads (20 pages), an A5 book or magazine for Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tasks to be covered: Task 1: Research your selection and analyze all needed aspects. Also, Mood Board (your visual research) + Layout plan (Dividers and interactive buttons) as we discussed in the class. Task 2: Design a suitable layout for your selected topic. Use Table, margins, columns, master pages, and paragraph/character style. Task 3: Submit InDesign file (Packaged) and export an interactive digital file (PDF). Task 4: A Presentation on screen, that discusses the project’s concept and process.

...services and schedule events at specific temples or with particular priests. Key Features: - User Registration and Login: The platform should provide a seamless registration and login process to users. - Search and Filter for Priests: Users should be able to easily search and filter for priests based on location, preferred language, and availability. - Booking and Scheduling System: An efficient booking and scheduling system is required. This should allow users to select their preferred date and time for the service or event, receive confirmation and reminder notifications, and make payments online. Ideal Skills and Experience: - Proficiency in front and back-end development - Ex...

create 10 spreads (20 pages), an A5 book or magazine for Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tasks to be covered: Task 1: Research your selection and analyze all needed aspects. Also, Mood Board (your visual research) + Layout plan (Dividers and interactive buttons) as we discussed in the class. Task 2: Design a suitable layout for your selected topic. Use Table, margins, columns, master pages, and paragraph/character style. Task 3: Submit InDesign file (Packaged) and export an interactive digital file (PDF). Task 4: A Presentation on screen, that discusses the project’s concept and process.

...Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: A Sulphasalazine tablets 500mg are on hand. The dosage required is 2g. How many tablets are required? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: C So can you create options like a teacher, you don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one...