Vba excel filter data sum columJobs
...produktfeed-import til Excel via Make Projektbeskrivelse: Vi er på udkig efter en dygtig freelancer med erfaring i automatisering og databehandling, som kan hjælpe os med at automatisere importen af forskellige produktfeeds fra flere leverandører direkte ind i et Excel-ark ved brug af automatiseringstjenesten Make (tidligere Integromat). Opgaver: Opsætning i Make: Opsætte automatiserede workflows i Make, der importerer produkter baseret på specifikke EAN numre fra en liste, vi har tilgængelig i en særskilt fane i Excel-arket. Dataselektion: Sikre, at kun produkter, der matcher EAN-numrene på vores liste, bliver importeret. Dataimport: Automatisk import af følgende produktdetaljer til Excel: ...
Hej, Jeg har behov for en Expert, som kan udvikle en kalender for mig. Jeg har et rengøringsselskab, hvor vi få udleveret et kalender fra vores kunder. Alle kunder har forskellige fridag, men de fleste har helligedage som lukkede også er der enkelte der har ekstra feriedage, så de skal også indtastes. Herudover vil jeg indtaste, hvor menge timer medarbejderne har enkelte dage, så jeg kan beregne hvor timer der skal udbetales. Eksempelsvis har en kunde 20 arbejdsdage, hvor medarbejderen arbejder dagligt 10 timer, så i alt skal der udbetales 200timers løn.
I have an invoice template, i need to add a second page to it that have instead of the columns Beskrivning Antal Enhet à pris Moms Moms kr Belopp should have 10 columns. I have attached the invoice template. So i need a second description page to this template.
Design or formulate the financial analysis for a self storage project in order to ascertain its viability.
Jeg har brug for noget grafisk design Jeg skal have opsat 3 sider med billeder fra nettet til et moodmap. Ca. 4 billeder pr. side. De 3 sider skal have forskellige stemninger og billederne skal behandles let fx med filter. Der skal logo på. Det er for en spillefilm og skal bruges til en fondsansøgning. Det skal afleveres i en komprimeret pdf så det fylder mindst muligt.
Jeg har brug for en ny hjemmeside Bare bygge den Internetbutik Skal sælge gavekort på min webshop på shopify og have betalingsmodul fra pensopay på samt 4 API opkoplinger diverse social media integration samt adwords og trustpilot, Excel fil fra bestilling skal sendes til produktionssted
Jeg skal ha lavet et database program hvor jeg kan indføre forskellige data hver dag. Skal helst kunne køre som app på både android og ios, ios i første omgang Jeg skal selv kunne skrive og lave nye data der skal indføres. Der skal være et pænt layout og være meget nemt at gå til Der skal være en backend, hvor man selv kan tilføje og rette i de ting der skal indtastes. Der skal ikke være begrænsninger for hvor mange indtastninger man kan lave Alt skal kunne konverteres og udskrives i pdf og excel Der vil være småting der skal ændres og tilføjes løbende, så det skal være en der kan arb på projektet noget tid
Skal have lavet en opgave i Regnskab. Skal laves på excel.
Jeg har brug for en ny hjemmeside Designe og bygge den Lille virksomhedshjemmeside Tænkte at begynde sum Zoneterapeut, i fritiden :)
Jeg har brug for en ny hjemmeside Designe og bygge den Lille virksomhedshjemmeside Tænkte at begynde sum Zoneterapeut, i fritiden :)
På side 1. (ark – ’kontobevægelser’) er der i kolonne D indsat beløb (kr.), - pkt. C Værdien i pkt. C (side 1) ønskes overført til pkt. C (side 2) - arket ’2017’. Der skal indsættes en formel i pkt. C, arket ’2017’ (side 2) som overfører værdien fra pkt. C (side 1) til pkt. C (side 2). Dette gøres ved: • Det aktuelle ark som værdien i pkt. C (side 1) skal overføres til findes ud fra datoen i pkt. B (side 1). Værdier fra kalenderår 2017 overføres til arket ’2017’. Værdier fra øvrige kalenderår eksporteres til de respektive ark/kalenderår. Dvs. værdier for kalenderåret 2016 indsættes i ark &r...
Jeg skal have sorteret forskellige studerende på nogle kurser, som de hver især har rangeret. Ikke alle kurser kan have alle de studenter der søger, hvorfor dem med størst præference skal fordeles hertil. Der skal ligeledes udarbejdes en userform, da der er flere dataset at vælge imellem.
Vi har brug for hjælp til at opbygge i MS Excel rapport, som via Jetreport henter debitor / salgs data fra Microsoft Dynamics NAV 2009 R2 - SQL database.
Hej, Jeg leder efter nogen til at løse et par matematikopgaver. Opgaverne er vedhæftet og mit budget fremgår af dette projekt. Opgaverne skal løses i et regneark (gerne Microsoft Excel). Deadline er 5 dage efter projektet er uddelt. Se nedenstående vedhæftninger.
Hej, jeg søger en som kan lave et design til et træningsprogram. Jeg har et design som I kan gå udfra, når I kontakter mig på mail. Håber i kan hjælpe. Mvh. Martin Nielsen
Vi ønsker at få en pris på at få oversat den engelske LOD manual inkl. excel workbook til dansk.
Vi ønsker at få en pris på at få oversat den engelske LOD manual inkl. excel workbook til dansk.
Whatsapp channels & active numbers for any country available for sale. I have full database of whatsapp for across the world. I can even filter any list of mobile numbers Whatsapp secure password protected channels are also available for sale
...skal der kunne uploades dokumenter (word eller pdf) 4) Det skal være nemt for andre brugere at finde frem til ovenstående dokumenter 5) Brugere skal kunne downloade dokumenterne 6) Brugere skal kunne rate dokumenter (f.eks. stjerner fra 1-5) 7) Dokumenter skal kunne sorteres via forskellige filtre (årstal, forfatter, navn etc.) 8) Der skal være toplister over bedst ratede dokumenter i hver "filter"/tema 9) Hver bruger skal have begrænset plads til at gemme dokumenterne tilknyttet deres personlige database. 10) Bruger skal kunne købe sig til ekstra plads for at gemme yderligere dokumenter 11) Brugerne skal betale for at downloade dokumenterne 12) brugerne skal kunne se, men ikke downloade dokumenterne gratis via hjemmesiden (...
project for dangersystem dangersystem dangersystem
Jeg har vedblivende arbejde relateret til vores tidligere projekt 'Application that can upload excel sheet to sql table'
Solve excel problem using excel solver
Jeg skal lave en prissammenligningsside. Jeg har samlet alle priser hos en forhandler og skal nu have fundet de samme produkter hos andre forhandlere. Jeg har lavet et excel ark hvor jeg liste alle URLs til den primære forhandler. Det er så jeres opgave at gå ind og finde det tilsvarende produkt hos de andre forhandlere og indsætte links i Excel arket. For at produkterne er de samme skal I tjekke at billedet er ens. Hvis I ikke kan finde det pågældende produkt skal der bare skrives 0 i cellen. Se vedhæftede fil for hvordan templaten ser ud. Det drejer sig cirka om 1000 produkter og 10 forhandlere, der skal tjekkes
Jeg har vedvarende arbejde relateret til vores tidligere projekt ' Looking for a user-interface for Excel'
Take excel spreadsheet & upload via talend to REST service. Might have to work via multiple sheets. Rory to pass on details.
I am in need of a Senior Financial Analyst to assist with our company's financial modeling, forecasting, and data analysis and reporting. The ideal candidate must be familiar with various financial concepts, data analysis, and proficient in the use of Microsoft Excel, Tableau, and QuickBooks. Key Responsibilities: - Develop and maintain financial models for our operations and future forecasts - Analyze and interpret financial data - Prepare regular reports on financial performance - Utilize Microsoft Excel, Tableau, and QuickBooks for data management and analysis. The candidate must have significant experience in financial modeling and data analysis, preferably in a senior role. The ability to communicate complex financial informatio...
I'm seeking a skilled professional to create a comprehensive loan statement on an Excel spreadsheet. Key Project Details: - I need all transactions included in the statement, ensuring the document is fully up-to-date. - The statement should not only present the transactions but should also include complex calculations such as interests, balances, etc. - As I'm looking for this as a one-time service, the statement should be designed to be updated annually. Ideal Skills: - Proficiency in Excel is a must; the ability to handle complex calculations is highly preferred. - Previous experience in creating and maintaining financial spreadsheets, particularly loan statements, is a significant advantage. - Attention to detail is crucial to ensure all transactions are accou...
I have a lot of data in a spreadheet. Have a look at attached spreadsheet. I need the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 10 in "auto made" sheet. This row 10 need to be deleted to make the spreadsheet work for my import
...as players progress through the endless waves, keeping gameplay engaging and unpredictable. - Design dynamic environments that evolve and present new obstacles or opportunities as players face more difficult waves of zombie pets. - Introduce periodic challenges and special events within the endless mode to shake up the gameplay and provide additional objectives or rewards for players who excel in their survival efforts. 5. Art and Sound Design: - Create visual cues and feedback that convey the increasing intensity and complexity of each successive wave of zombie enemies as players persevere. - Develop audio cues and immersive sound effects that enhance the tension and excitement of facing relentless zombie onslaughts in the endless mode. - Design striking visual e...
...skilled Shopify developer with solid experience in data import from Excel. Specifically, you'll be dealing with: - Product data import into my Shopify site from a URL download of a CSV - Importing simple data, without dealing with variants or complex attributes. - syncing of the products in the CSV with Shopify products would happen every 24 hours automatically - If an existing product on Shopify is not found on the CSV download, its status on Shopify needs to be changed to "draft" or "inactive". The ideal candidate should have: - Strong Shopify development skills - Familiarity with Excel or similar data management tools - Experience with product data migration or import Success in this project would mean a se...
...text content from a specific website on a daily basis. The scraped data should be compiled and delivered in a spreadsheet. Key requirements include: - Daily scraping of text content from the designated website - Compilation and formatting of this data into a spreadsheet Your experience in web scraping, data compiling, and spreadsheet management will be greatly valued for this project. Accuracy, timeliness, and consistent daily delivery are crucial aspects of this job. Understanding of automation tools for data scraping would be a big plus. I am looking to collate some data from this website and need an ongoing scrape of this website to set up an ever-updating excel spreadsheet with the fields as per the attached excel file. Go to t...
...authentication flow to ensure user data protection. User registration through Google account, streamlining the sign-up process. Account and Subscription Management: Each account can manage one school, which can have multiple locations (campuses). Admin dashboard to manage subscriptions and assign school management capabilities to each account. Ability to sell subscriptions, where each subscription corresponds to a single school with its own set of locations, teachers, and resources. Role-based access control: Admin Role: Full access to manage the school, including locations, teachers, classes, and schedules. Manager Role: Limited access to manage specific aspects of the school (e.g., only certain locations or only scheduling). Teacher Management Teacher Data Upload: Modu...
I'm looking for someone to curate text and image data for me and compile it into an Excel document on a monthly basis. The successful contractor will have experience with using the Internet to collect data and be able to present it in a structured and organized manner. This data needs to be sourced from reliable sources, checked for accuracy, and edited for quality. The contractor must be able to take initiative and use their own discretion in order to create the best results. Additionally, the contractor will be expected to act in a timely manner, ensuring that the data is updated and ready to use on a monthly basis. This project requires attention to detail and good communication skills.
I have a substantial amount of survey data, all neatly organized in a spreadsheet. I am looking for a professional with experience in descriptive statistical analysis to help me make sense of it. Key requirements are as follows: - Expertise in descriptive statistical analysis: You should be able to generate valuable insights from the data and present it in a clear and comprehensive manner. - Proficiency in working with survey data: You will be dealing with survey data, so experience in this particular field is highly preferred. - Familiarity with spreadsheet software: The data is in a spreadsheet format, so proficiency in software like Excel or Google Sheets is a must. Your primary objective will be to provide a detailed description of the d...
...Profile Creation: The app should allow users to create accounts and set up their profiles. - Search and Filter for Therapists: A user-friendly search functionality should be implemented to help users find therapists that meet their specific needs. The app should be designed for iOS, Android, and Web platforms, therefore the candidate should be proficient in developing for these platforms. Experience with building secure and reliable messaging systems, video calling functionalities, and user authentication is highly desired. The ultimate goal of this app is to provide a safe and reliable platform for users to seek professional help, so the app should be designed with a high level of data security and privacy in mind. A background in developing similar applications or und...
...seeking an expert in Excel, OneDrive and email notifications who can develop an automated system for me. This system needs to: - Monitor a specific Excel file within my OneDrive for business for cell value changes. - When changes occur, the system should not send an individual notification for each. Instead, it should group updates together. - These grouped updates should then be sent as a single email to a preselected set of recipients at a specific time interval. - Crucially, the email should not only contain the updated cell values but also their previous values, enabling recipients to easily compare old and new data. Only experienced Excel and OneDrive professionals should apply, preferably with a background in automated data notifications. Famili...
Project Details $30.00 – 250.00 USD I'm seeking an analyst proficient in harnessing the Amazon Seller API to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant columns and sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data MUST be pulled into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows: Order ID, Tracking ID, Product Name, Unit Price, Ship...
I'm seeking a Power BI expert to create a Territory Map of both Zip and State. Key Project Requirements: **Mapping:** Your task involves creating the map with both zip and state information. **Data Update:** The map should be updated periodically, not in real-time. I'm using ARCgis in Power BI to create maps. I can create a good map based on zip codes, or based on state, but I can't seem to figure out how to combine the two. Our CA territory is divided by zip code, but some states are considered one territory. So, I need to apply first a filter by zip code, and then a layer based on state on top of that. Attached is the territory map by zip code that I created with Power BI. I need it to look like that but with New Mexico, Arizona, and Nevada fully c...
