Vba excel application sum multi cell työt
FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...
Hi, I'm looking for a finnish HR recruiting professional to do job application instructions for young workers. More detailed instructions in Finnish bellow. Eli haluaisin luoda nuorille työnhaku tietopankin. Tämä ensimmäinen projekti olisi ohjeet asiakaspalvelu aloihin hakemiseen. Ohjeet yleisimpiin haastattelu ja hakemus kysymyksiin vastaamiseen ja malli vastaukset. Etsin henkilöä jonka kanssa voisin toteuttaa monta samanlaista projektia!
Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.
Startup-yrityksemme etsii mobiilikehitystyötä. Sinulla on halutessasi mahdollisuus päästä myös osakkaaksi. Kansainvälistymissuunnitelmamme ovat ripeydestään ja laajuudestaan huolimatta useamman ulkopuolisen tahon mielestä uskottavia. Meillä on hyvät perusteet uskoa yrityksemme liikevaihdon nousevan nopeasti seitsennumeroiseksi. Kehityksen on tarkoitus tapahtua HTML5-pohjalta, minkä jälkeen sovellus portataan eri alustoille. Ensimmäisen version tultua valmiiksi meillä on runsaasti jatkokehitystä valmiiksi määriteltynä. Arvostamme osaamista, mielenkiintoa ja kokemusta sekä iOS:stä että Androidista sekä palvelinkehityksestä. Toimivien käyttöliittymä...
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
dsaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
htgfhjgf gfhdddddddn ngfhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhn
I'm in need of a skilled developer to build a web application for me. The main goal of this application is to extract data from APIs and databases to be used for analysis and reporting. Key features: - The ability to securely and efficiently extract data from multiple sources, primarily APIs and databases. - A user-friendly interface for easy data extraction, potentially with functions like search, filtering, and scheduling. - A robust backend system to effectively handle and process the extracted data. - Data storage solutions to keep the extracted data secure and accessible for analysis. Desired Skills and Experience: - Proficiency in web development, with previous experience in data extraction projects. - Strong understanding of APIs and databases, with the abilit...
I am looking for patent lawyer or licensed patent agent to help my Canada patent application: Application claims have Indefiniteness, Lack of Clarity, not comply with section 60 of the Patent Rules. If you can help, please submit your profiles, Thank you.
I need assistance with Excel to create multiple rules for a specific column in my spreadsheet. Here's what the project entails: - Developing rules based on cell formatting - The rules will be used to match multiple cells within the column following 5 specific criteria sets - The rules will be custom formulas specially designed for this task Ideally, you should be expert in handling Excel advanced features, specifically custom formulas. If you have experience in creating complex Excel tasks, that would be an added advantage. The ultimate goal is to automate the process where specific data is matched and inserted in another column.
...a freelancer who can help me to test my web application for compatibility, bugs and user experience. Its a product manager where you can create the Categories and forms to input the information for any product/service. The application uses several user roles and each one has to be tested across all their functionalities. Key points: - I need the application to be tested on various browsers and operating systems. - It's important that the testing is thorough, ensuring that the application's functionality is consistent and reliable across different platforms. - Any issues that arise during testing should be documented clearly, allowing my development team to address them effectively. Ideal skills and experience: - Experience in web application t...
...code Incoming and outgoing calls. Call Transfer (Blind and assisted transfer) Hold Call Transfer Call Attended Transfer Call End Call Conference Call (merge the calls) Video calls Presence and IM features Call history Smart contact list, with address book synchronization for smartphones Audio/video conference calls and scheduled meetings Call transfer and multi-call management (pause and resume) One-to-one and multi-participant conversations Intuitive message delivery status (IMDN) SMS/chat with Message Syncing for all devices (Meaning sms/chats will be synced, so users can see the conversations). Recordings on server (We have APIs to do that and check if user is allowed). BLF Voicemail Plus a few additional features. The ideal developer for this p...
...in-depth Android application security assessment. Skills in the following areas are required: Static Application Analysis: Understanding of tools like PEView, Dependency Walker (for analyzing dependencies in a Windows environment), APKTool, Androguard, or similar. Dynamic Application Analysis: Experience with tools like Process Explorer/Monitor (for analyzing processes in a Windows environment), Wireshark, or comparable tools. Code Analysis & Reverse Engineering: Proficiency in Ghidra, SMALI/BAKSMALI, dex2jar, and similar disassemblers/decompilers for Android code. Key Requirements: Proficiency in Volatility, APKTool, and Ghidra Intermediate level of experience in Android application security assessment. Ideal Skills and Experience: Demonstrated exper...
...- Inventory Management - CRM One must possess robust experience in these areas and be prepared to handle multiple tasks efficiently. I'd appreciate if applicants could showcase their proficiency in Odoo development, preferably through examples of past work. Any relevant certifications or endorsements are a considerable plus. Ideal Skills: - Experience in Odoo development - Ability to handle multi-faceted tasks - Proficiency in Sales, Inventory Management, and CRM modules of Odoo. If you believe you fulfill these criteria, I'd love to hear from you....
I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria
I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.
I am looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The Initiator engages the Creat...
I want a comprehensive application that offers various home services by paying a membership. These include household cleaning, pet walking, carpentry, plumbing, electrician services, and even pet hosting. The primary aim is to connect users with professionals who specialize in these areas. Therefore, the successful candidate should have: 1. Proficiency in cross-platform mobile app development 2. Experience creating service marketplace apps 3. Strong skills in location-based features and real-time scheduling The app should have real-time chat and email functionality for user-professional interaction. Therefore, a background in implementing such communication solutions will be preferred. This project requires: - User and service professional profiles - Option to list, explore, a...
...structure will consist of a basement, ground, first-floor banquet hall, and second to fifth floors with two-bedroom flats. I'm considering the latest technology, modern and minimalist design for the banquet hall and flats. Key Points: - The structure will cover a 240 square yard plot, with specific dimensions for each side (front 35.6, back 36, right side 62.2, and left side 60) - The building will be multi-storey, with a banquet hall on the first floor - The flats on the second, third, fourth, and fifth floors will be two-bedroom - The design aesthetic should be modern and minimalist - Utilization of the latest technology in construction and interior designing would be appreciated - what will be the Ideal skills and experience for this job would include: - Extensive expe...
I'm seeking a professional app designer to create a sleek and user-friendly login interface for an Android app. Below are the key requirements: - **Platform**: The design should be specifically for Android devices. Prior experience in Android app design is a must. - **Authentication**: The login system should be simple, without the need for multi-factor authentication. - **Integration**: While the design should be self-sufficient, it should not rely on any third-party authentication systems. This is a standalone login system. Ideal candidates will have proven experience in Android app design, specifically focusing on login interfaces. Strong candidates will also have a portfolio of relevant work and a good understanding of user experience principles for mobile applications.
I'm seeking a professional app designer to create a sleek and user-friendly login interface for an Android app. Below are the key requirements: - **Platform**: The design should be specifically for Android devices. Prior experience in Android app design is a must. - **Authentication**: The login system should be simple, without the need for multi-factor authentication. - **Integration**: While the design should be self-sufficient, it should not rely on any third-party authentication systems. This is a standalone login system. Ideal candidates will have proven experience in Android app design, specifically focusing on login interfaces. Strong candidates will also have a portfolio of relevant work and a good understanding of user experience principles for mobile applications.
I have a CS-Cart Multi-Vendor site that experienced a severe breakdown following a failed upgrade. This has led to a range of issues from broken layout to persistent error messages. Additionally, after the failed upgrade, the database is out of sync. The site needs urgent attention to get it back on track. Your primary role on this project will be: - Debug and fix the bad upgrade: This includes addressing the broken layout, error messages, and the out-of-sync database issue. - Server Configuration & Security Audit: Given that I've made changes to the server configuration and security settings post the failed upgrade, it's crucial to assess these modifications and ensure they're functioning optimally and not contributing to the site's issues. - Optimization...
...structure will consist of a basement, ground, first floor banquet hall, and second to fifth floors with two-bedroom flats. I'm considering the latest technology, modern and minimalist design for the banquet hall and flats. Key Points: - The structure will cover a 240 square yard plot, with specific dimensions for each side (front 35.6, back 36, right side 62.2, and left side 60) - The building will be multi-storey, with a banquet hall on the first floor - The flats on the second, third, fourth, and fifth floors will be two-bedroom - The design aesthetic should be modern and minimalist - Utilization of the latest technology in construction and interior designing would be appreciated Ideal skills and experience for this job would include: - Extensive experience in architectu...
I'm looking for an experienced developer to create a multi-tenant marketing dashboard for me. This dashboard should mirror the functionalities of another platform I have access to, but with some additional features. The main features of the project include: - Customizable user interface: The dashboard should allow users to customize their views and layouts to suit their needs. - Reporting and Analytics: I need the dashboard to provide comprehensive reporting and analytics features for tracking: - Email marketing metrics - Lead generation metrics - Social media metrics Additionally, the dashboard should be able to integrate with various third-party applications. These applications include: - Google Analytics - Twilio - Facebook - Instagram - Google Reviews The ideal fre...
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
I am seeking a skilled developer to create a comprehensive beauty appointment booking application that will run on both Android, iOS, and the web. As the app will be for beauty appointments, it will require a specific set of features to cater to the needs of both the service providers and the clients. Key Features: - User Registration: Allow both service providers (beauty professionals) and customers to create accounts. - Search Functionality: Clients should be able to search for beauty professionals based on their services and availability. - Booking and Payment: Seamless booking and secure payment processing. - Calendar View for Schedule: A clear and organized view of the availability of service providers. - SMS Reminder: Automated reminders to reduce no-shows. - Partial Section ...
As a growing MNC, I am seeking a business partner with a solid background in sales and marketing. The ideal partner will have experience marketing insurance products to a diverse customer base that includes individuals, small businesses, and large corporations. You should be able to: - Develop and implement effective sales and mar...markets - Drive the growth of our insurance product line Your extensive background in sales and marketing, combined with a robust knowledge of the insurance sector, will be crucial to succeeding in this role. Your commitment to the growth of the company, strong financial acumen, and international business experience are vital to expand our brand footprint globally. Join us and be part of a multi-national company that is taking leaps in the insurance...
This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.
I'm in need of an experienced token developer who can create a versatile set of tokens to cater to various needs. The project encompasses: - Crafting both utility tokens and security tokens to align with the diverse functions and requirements. - Developing stablecoins to ensure stability and reliability within the token ecosystem. The tokens are intended for: - Loyalty rewards: The tokens will serve as a form of incentive for loyal customers, encouraging repeat purchases and engagement. - Asset ownership: These tokens will represent ownership of real-world assets, providing a secure and transparent method for asset transfer and management. In terms of distribution, I'm looking for: - Initial Coin Offering (ICO): The developer should be able to manage the process of launching ...
Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modific...
I'm in need of an experienced architect or interior designer who can create a detailed renovation plan for my old waterfront home in Annapolis, Maryland. The property has gotten into a dilapidated state and I am looking to completely transform it into a modern style while preserving its coastal charm. Key Renovation Aspects - Interior Remodeling: The interior space of the house, w...Excellent communication skills and ability to work collaboratively The selected freelancer will be expected to provide a comprehensive renovation plan that includes cost estimates, timeline, and material recommendations. A keen eye for detail and a passion for creative problem-solving will be highly valued. The winner will also be considered for receiving a contract to produce full plans for a lump su...
...seamless experience. Features desired include: - Search functionality to enable effortless hotel discovery - Booking management to track and manage users' bookings - Incorporation of customer reviews to enhance customer confidence and choices - Integration of online payment solutions for smooth financial transactions - A Room availability calendar for easy checking of room availability - Multi-language support to cater to a global audience - A chat bot for 24/7 customer support - Google map API for straightforward hotel location - AI trip planner for personal and tailored travel planning - A refer and earn model to increase user base - A section for top offers and deals to stimulate user engagement - A voucher system for promotional campaigns and special offers....
I'm in search of skilled songwriters who can write engaging, catchy, and relevant lyrics for a variety of genres. Key Requirements: - Genres: Primarily Rap, Trap, and R&B, but also capable of writing for other categories. - Reference Tracks: I have over 40 reference tracks that I'll need you to work with. - Purpose: The tracks you'll be writing lyrics for are intended for promotional and maybe commercial use down the line. Ideal candidates will have: - A strong understanding and appreciation for rap, trap, and R&B music. - Proven experience in writing lyrics for a wide range of genres. - Ability to creatively adapt and work with multiple reference tracks Of me melodizing and flowing. - A portfolio or examples of previous work that demonstrate your songwriting s...
I'm in immediate ...Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simultaneously without compromising quality. - Excellent time management. Given the volume of work, prioritizing tasks effectively is key. - Strong communication skills. I need someone who can articulate updates and issues clearly and professionally. - Prefer if you can speak Arabic; however, it is not mandatory. This role is perfect for a self-motivated individual who wants to contribute to the success of a dynamic project portfolio. If you believe you are the right fit, I look forward to reviewing yo...
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...
I'm looking for a seasoned full stack developer with expertise in Flutter, React JS, and Node JS to build a comprehensive web application. The project will include, but not limited to: - Building a User authentication system - Implementing real-time notifications - Integrating data visualization tool The ideal candidate will have a proven track record of developing complex web applications. Familiarity with Firebase and Google Cloud is also a plus. Through this project, we aim to create a responsive, efficient and user-friendly platform. Your role will be crucial in achieving this goal. Please provide examples of web applications you have built previously that applied these skills, especially with real-time notifications and data visualization. I look forward to working with ...
Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas
I'm seeking an experienced .NET programmer to add a new feature to my existing application. Specifically, I need a modification to bypass member search by using a querystring. The page concerned is this:- We wish to have a direct url that replaces the process of searching for a member (eg member no 161068) and arrives at page two directly. For example, entering 161068 in the search box and selecting Checkedandvetted then pressing 'review this company' moves the user to page 2- review your experience. This is what we want to achieve with a single url. This is so that we can provide a url like that will do the same as the previous steps. Ideal skills for this job will include: - Strong knowledge
