Pivot table excel vbaJobs
...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.
...dimensions so that the customer can easily understand which product and variant suit their needs. EAN, price, weight, and H * B * L are all there, but we need in the table it should come in and be updated for each variant you choose. Then it should appear Diameter, Cutting length, Fastening, Quality, Geometry, NOBB no, etc. We want it to be available to write it on woocommerce underweight, height, etc. If you enter the value it should appear in the same table as weight, height, etc in the product page of our online store. If you do not enter a value for one of these dimensions of the variant, it should either not appear in the table on the product page, or just be I / A. Appendix for how the layout is in the appendix. If you feel this you can help, contact sander@go...
Design or formulate the financial analysis for a self storage project in order to ascertain its viability.
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æ...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 ...
Skal have lavet en opgave i Regnskab. Skal laves på excel.
Indtastning af ordre - faktura - følgesedler - indkøbsordre. Lave pivot, så tingene kører automatisk.
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.
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.
As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a ...
I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.
I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.
I am in need of a seasoned digital marketer who can proficiently handle SEO, social media management, and email marketing tailored to reach local customers. This role requires a keen understanding of how ...Craft and execute a strategic social media plan to connect with the local customer base * Email Marketing: Develop a captivating and result-driven email campaign The ideal freelancer: * Experience with SEO, social media management, and email marketing * Proven track record of lead generation * Understanding of local market demographics and trends * Strong analytical skills to track success and pivot strategies as needed * Highly creative in developing engaging and innovative marketing strategies. Take your digital marketing skills to the next level in this multi-faceted role. ...
I have a simple python script that interact with an API that takes data from said api and outputs it in a table. The service where I use the API also has a website where I can see in the same table format the exact same data. Pandas know how will help. My problem is that the data from API and from service is mismatching. Your job is too look and identify where the problem is. You will receive both program (simple streamlit app that runs locally) and login details to website to cross check.
3D modeling and two photorealistic renders showing the assembly of the table
I require a professional to format my entire scientific thesis in Microsoft Word. The document needs to be formatted to a high academic level. This will require the following: - Ensuring the entire document is formatted consistently for a professional and cohesive look. This includes font, headings, and spacing. - Creating and formatting a Table of Contents - Setting up headings and subheadings in the document according to the specified style. - Ensuring font, spaces and tables are properly formatted ensuring a professional look. The preferred formatting details are as follows: - Font: 12pt Times New Roman - Headings and Subheadings: Italicized with the same font size Ideal candidates for this job should have: - Solid experience in formatting academic or scientific documents. - ...
I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...
I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...
...from before that told me he could improve the module by take order dates and other dates already in the database to fill in missing data of the graph. Right now the graph just records order and financial information in the database and displays it on the graph. Where there is no data the graph just shows a straight line as shown in the demo screenshot. So I want the graph to show the data that its table is missing by getting this information from the WHMCS database. The end result would fill in the missing data of the straight line and also show the history on the graph from the start of the database, right now it only goes back 3 years because that is all the data it had collected since using this module. Hopefully this makes sense but let me know if I can clear it up. I also ...
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...
Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing value...(e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score, ROC-AUC) • Score Calculation and thresholds • Deployment and Monitoring Tools available: • In use: Microsoft Fabric and Excel (VBA) • ...
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.
I'm looking for a talented graphic designer to revamp the current cover of my parenting book. The current one isn't quite hitting the mark and I'm looking for someone who can bring fresh, appealing ideas to the table. I like this cover, but maybe you can improve it.
I'm looking for a skilled carpenter or furniture maker to create a custom wardrobe with an integrated dressing table. Key Requirements: - Material: The wardrobe should be crafted entirely from high-quality wood. - Interior Features: The wardrobe must include shelves, hanging rods, and drawers for optimal storage and organization. The wardrobe should be elegant in design and functional in use. Please ensure it is sturdy and durable, suitable for daily use. It should be a balance between aesthetic appeal and practicality, ensuring it can comfortably accommodate my clothing and accessories. Ideal Skills: - Experienced in carpentry or furniture making, particularly in creating wardrobes. - Proficient in working with wood and able to translate the design into a quality finished...
