Excel vba if statement based on cell value 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 aj...
Etsinnässä pikaisella aikataululla kehitääjä joka taitaa Ruby on Rails ohjelmointikielen. Projekti alkaisi aikalailla heti ja vaatii tekijältä kokemusta kyseisestä teknologiasta. Työmäärä n. kolme työpäivää / viikko. laskutus sovittavissa tuntikirjanpitoon pohjautuen per tunti. Kehittäjältä vaaditaan kykyä työskennellä itsenäisesti ja kykyä hallita dokumentaatio. ------ Searching for a Ruby on Rails developer for one of our clients ongoing development. The project will start immediately after finding the right person. Required expertise: experience with Ruby on Rails (level: excellent). Three working days / week. billing negotiable based on...
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.
Moi! Mulla olis reilu 585 sananen suomeks kirjoitettu personal statement yliopistohakua varten mutta mä en millään kerkee sitä kääntää englanniks nyt kun on yo-kirjotukset tulossa kovaa vauhtia kuukauden päästä. Kiinnostaisko mokoma duuni ja paljon pulitat kyseisestä hommasta? :)
Moi! Mulla olis reilu 585 sananen suomeks kirjoitettu personal statement yliopistohakua varten mutta mä en millään kerkee sitä kääntää englanniks nyt kun on yo-kirjotukset tulossa kovaa vauhtia kuukauden päästä. Kiinnostaisko mokoma duuni ja paljon pulitat kyseisestä hommasta? :)
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.
CSS fix on WP site2CSS fix on WP site2CSS fix on WP site2CSS fix on WP site2CSS fix on WP site2CSS fix on WP site2CSS fix on WP site2CSS fix on WP site2CSS fix on WP site2CSS fix on WP site2
free register work and earn moneyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy
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.
Hei, Haluaisitko kääntää työhakemukseni suomesta englantiin? Tarvitsen käännöksen opintotehtävääni varten, opsikelen yliopistossa ja sen takia teksti edellyttää tieteellisestä rakennetta. Deadline on jo perjantaina... Ystävällisin terveisin, Simon Rundlöf
...separate div. This is crucial as it helps to visually indicate that there is more content available to the user, without overloading the initial view. Key Requirements: - Detecting Div Height: The solution should have a mechanism to recognize when a div's content surpasses a specified height. - Organizing Overflow: The overflowing content should seamlessly and automatically move to a different div on the same page. - Visual Indication: It's important that the system's behavior clearly communicates the presence of additional content to the user. Ideal Skills and Experience: - Proficiency in HTML, CSS and JavaScript. - Experience with front-end development and user interface design. - Ability to create a responsive solution that maintains the aesthetic and functio...
I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...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. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...
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 f...
I need a skilled freelancer to install and configure Dolibarr for our company's productive site on our intranet. Here are the specifics: IA definition: (below you can see my own) - We need the inventory management, manufacturing, service contracts and human resources management features to be properly configured. - The system must be set up for 1-10 users to access on our intranet. Customizations and integrations: - We may require custom reports or dashboards, although the specifics for these are not yet entirely defined. - There may be other custom integrations needed as the project progresses. Ideal Skills and Experience: - Proficient in Dolibarr installation and configuration - Previous experience in setting up Dolibarr for small businesses - Strong ...
...software system that will help me identify profitable betting opportunities and detect positive expected value (EV) bets within the sports betting market and also arbitrage bets, live positive EV bets and live arbitrage bets on the websites specified in the attached file. The formulas for Positive EV bets can be found on the following website. The software needs to compare the odds to the odds of , obviously following the adding of the vig (pinnacle's profit margin) to the odds, in order to receive the true odds: The software needs to run as a website that only I can access, with a similar layout to that of , as seen on the picture attached. I will also need you to send me the source code following the completion of the
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!
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transf...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 appreciate...
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-f...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 plus The final image should be a natural looking photo of the person in the uploaded...
I'm looking for a talented developer to build a web-based POS system with a focus on insightful daily sales reporting. Key Features: - Web-based POS system: The system should be accessible through the website itself, offering an intuitive interface for easy use. - Daily Sales Reporting: It's crucial that the system provides detailed and comprehensive daily sales reports. These reports should be easy to read and interpret. - Customization: The system should allow for future customization and integration of additional features, as the business grows. Ideal Skills: - Proven experience in developing POS systems, particularly web-based. - Strong understanding of sales reporting and data analysis. - Ability to create user-friendly interfaces. Please shar...
I'm seeking a telemarketing professional to assist me in generating quality sales leads for my commercial building cleaning services. Key Responsibilities: - Conducting outbound calls to businesses within the commercial building cleaning services sector - Establishing rapport with potential leads and effectively communicating the value of our services - Qualifying leads and setting up appointments for our sales team Ideal Skills and Experience: - Proven experience in telemarketing and lead generation, particularly in the B2B space - Excellent communication and negotiation skills - Familiarity with the commercial cleaning industry would be an advantage - Ability to work towards targets and manage a CRM sales pipeline This project is vital for our business growth and I'...
I'm looking for a proficient professional who can effectively scrape leads from LinkedIn, Facebook, and Instagram and all over the intern...and Social media leads. * Collecting specific data - Name, Job title, Company, and Location, email and phone numbers Ideal freelancers for this project should have: * Extensive experience in data scraping, especially on the platforms mentioned above. * Proficiency in data mining techniques and possessing advanced analytical skills. * Understanding of ethical data scraping practices. * Strong attention to detail - ensuring all data is accurate and up-to-date. * Proven track record of delivering quality leads in a short timeframe. Get in touch if you're up for the task. I value clear communication and timely delivery. Lo...
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transf...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 appreciate...
...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 and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, a...
...to PC, focusing on an engaging pixel art style that can stand out in today's market. My concept combines intense gameplay mechanics with a visually appealing retro aesthetic, aiming to capture both nostalgia and innovation. For this project, I need a skilled team to turn this vision into reality. **Key Requirements:** - **Game Development:** Proficient in developing action games for PC, with a portfolio showcasing similar projects. - **Pixel Art:** Exceptional skills in pixel art creation, able to craft detailed and unique characters, environments, and effects. - **Programming:** Strong background in coding, familiar with engines and languages suitable for PC game development (e.g., Unity, C#). - **Creative Input:** While I have a clear vision, I value creativity and...
...YOU TO LEARN ✻ No. You aren't dreaming. I value intelligence and problem-solving ability over experience. I'd prefer to work with someone who is clever and learns quickly rather than someone experienced but is not very intelligent and/or does not solve problems scientifically. Would I hire an Isaac Newton or an Albert Einstein even if he had no programming experience? Of course I would. ✻ TESTS ✻ You must pass several difficult logic tests to work with me. The first logic test you complete for me will be an unpaid logic test. In other words, I would not pay you any money whatsoever if you were to pass the first logic test. However, I would pay you $25 (Twenty-Five Dollars) if you were to pass the second logic test, and $50 (Fifty Dollars) i...
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.
We're a dynamic agency specializing in helping businesses stand out on YouTube. We're currently on the lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniques to improve the ranking of our videos in search results. - Conduct comprehensive keyword research and optimize video content accordingly. - Enhance the appeal and engagement of our videos through creative thumbnail and title optimization. - Dive into analytics and user engagement data to constantly refine and improve our strategies. Ideal Candidate: - Proven experience in YouTube SEO, with a track record of improving video ranking and visibility. - In-depth knowledge of keyword resear...
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
I'm looking for a talented 2D animator who can create 3 engaging and entertaining videos, each lasting between 45-60 seconds. The primary goal of these videos is to captivate and entertain the audience. Key Responsibilities: - Develop 3 separate videos in a minimalist animation style - Ensure the videos... Video 3 - What happens when the MYGA guaranteed period ends: This is an excellent opportunity to showcase your creativity and animation skills. If you're confident in your ability to produce high-quality, engaging content in this style, then I'd love to hear from you. This could lead to on going work with us.
...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 line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the ...
...Knowledge in creating secure web forms - Experience in agent-based systems would be a plus Please bid for this project if you believe you have the skills and experience needed to deliver a high-quality, 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 ...
...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 be able to see and edit all after importing with an interface you will create in ...
I'm seeking a reliable, friendly companion to keep me company on a daily basis while my husband is away on a work trip from July 18th 2024 - July 26th 2024. The arrangement is for 24-hour hangout sessions. Key Tasks: - Help me care for my animals (I have 8 cats, 2 dogs and a ferret) such as: feeding, walking, cleaning litter boxes. - Engage in home-based activities: I allow smoking in my garage and I have an Xbox and a PS5. Listening ti music and watching anime is a plus! - I currently do not have a license so helping me run errands would also be appreciated. - Be present and supportive: While this is not a traditional job, I value good company and would appreciate someone who can be a positive presence in my daily routine. Ideal Candidate: - Friendly and...
I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong attention to detail and accuracy are highly va...
Create a bright and bold 12' x 40' billboard to effectively promote our B2B Virtual Assistant service. This design should turn heads, deliver a clear message, and drive results! Use the below information to craft the best billboard you can do! You may utilize some of the copy provided or create your own copy based on the information provided. Company/Service Information: • We are a US-based staffing agency that provides Virtual Assistant Services to micro-, small-, and medium-sized enterprises worldwide. • Our Virtual Assistants come from all over the world. • We have been in business for more than a decade. Our services: • Admin Support • Business Support • Marketing Support • Technical Support Industries we serve: &bu...
I require a straightforward, user-friendly spreadsheet that calculates energy savings based on specific input. My needs are very particular. Here are the key aspects: Input Specifications: - It should only take one input: an initial savings value representing the savings our product offers. Calculation Requirements: - I expect the spreadsheet to perform calculations for both percentage and dollar amount savings. Results Format: - The results should be shown as simple numbers; I don't need them displayed as percentages or any graphical representations. The freelancer fit for the task should be proficient in spreadsheet software and have experience in building similar savings calculators. A good understanding of energy savings would be advantageous.
Necesito crear ficheros XML para ser importados a un ERP (software contable y de producción basica), generados en base a: 1. Una tabla de Excel con información a ser importada. 2. Una estructura XML predeterminada para la creación de ordenes de producción 3. Unas condiciones que hay que cumplir para que se pueda generar correctamente el fichero XML Probablemente una vez realizado el proyecto, se podría se necesitar realizar algunos ajustes o cambios puntuales, que en todo caso serán pagados. El diseño tiene que ser modificable en Visual Basic Busco seriedad, profesionalidad y mucha rapidez.
We are seeking dynamic individuals to join our real estate team in the roles of Sales Agent, Marketing Coordinator, and Sales Associate. Key Responsibilities: * Arranging sales calls and client meetings * Assisting with lead generation and sales support * Going above and beyond in all tasks, working ha...Ideal Skills: * Exceptional communication and interpersonal skills * Rich experience in sales or marketing * Ability to work independently and collaborate effectively as a team * Capability to manage team, associates, and clients Candidates who bring a great work ethic and strong leadership skills will find an excellent career growth opportunity in our team. We value individual contributions and teamwork in achieving our company goals. If you fit the bill, then we'd ...
I'm looking for an experienced developer to create a new cryptocurrency based on the Bitcoin blockchain platform. The ideal candidate should have a strong understanding of blockchain technology and the ability to develop a secure, scalable, and fast transaction processing system. Key features and functionalities: - Secure transactions: The new cryptocurrency should prioritize and ensure secure transactions to protect the interests of users. - Scalability: The network should be designed to handle a growing number of transactions without compromising its performance. - Fast Transaction Processing: To enhance user experience, the new cryptocurrency should be capable of processing transactions quickly and efficiently. Kindly note that I have no specific design or branding ...
We are in search of a s...extracting and understanding content from PDF files - Strong problem-solving skills and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need access to final git repository Project Completion: 2 weeks This project is an exciting opportunity to work on a cutting-edge software integration and development. If you have the right skills and enjoy a challenging, innovative project, I&...
I need a talented designer who can help me create a visually appealing home page on Shopify. My key focus is to showcase my brand identity. Required Skills & Experience: - Proficient in Shopify - Excellent design skills - Experience in creating a brand-centric homepage - Understanding of user experience principles I have a mockup created in Canva. I need it designed in Shopify for the home page Please include "I am a shopify expert and can do this" to be considered.
I'm in need of a User-Generated Content (UGC) creator who is skilled in creating engaging short video clips and stories/reels for Instagram. Here's what I'm looking for: - Based in Indonesia - Intermediate level of expertise - Strong proficiency in the creation of short videos and Instagram reels/stories - Ability to plan, execute and deliver content consistently - Knowledge of Instagram trends locally and globally - Can Promote Digital Product Taking these into account, freelancers with a track record of creating attractive UGC, especially in the context of Instagram are welcome to bid. Previous work samples will be highly appreciated. Become a part of my project and let's elevate our Instagram presence together.
