Excel vba create pivot table in existing sheet 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...

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.

I want to create a website with the same design of this website for a good price I want a good quality of creation and the fastest only in 10 days

I want to create a website with the same design of this website for a good price I want a good quality of creation and the fastest only in 10 days

Create/Manage Create/Manage a PPC Campaign jockey a PPC Campaign jockey

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.

I NEED A LOGO CLIP DONE JUST LIKE THE OTHER MAJOR PRODUCTION COMPANIES HAVE. WATCH VIDEO BELOW!!!!! USING MY YOUR TV LOGO.. UNDER THE LOGO ADD TEXT ( A HISTORY ENTERTAINMENT COMPANY) I WANT A WHITE BACK GROUND VERY SIMPLE VERY PROFESSIONAL!!!

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.

lojnjg gyguuuuuuuu gg jbjiiihhtft kiyoio

2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.

2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.

Offline typing job,data entry job

I'm looking for a freelancer proficient in Excel for a simple data entry task. The work involves straightforward copytyping of numeric information into an excel sheet. Key requirements include: - Accurate data entry skills - Proficiency in Excel - Attention to detail The project doesn't involve any complex formulas or advanced functions. It's a relatively straightforward task that requires precision and focus. Your role will be to ensure all data is accurately entered into the spreadsheet in a timely and efficient manner. A keen eye for detail and a methodical approach will be crucial for successfully completing this project. Please note that the data entry will be in the form of standard tables, so experience...

Create a PDF and Excel exporter download for both tabs Specifications and Questions (8hours) (160 USD) Layout for the mains page (4 hours) (80 USD) Documentations (1 hour) (20 USD) Plugins (16 USD Excel) you will buy directly from Bubble in your account Plugin (100 USD PDF) there is al alternative plugin (20 USD)you will buy directly from Bubble in your account

I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.

I need an Excel expert to enter a set of numbers and dates into an Excel sheet, and perform some basic calculations. - Data Typing: You'll need to be comfortable working with both numbers and dates, as these will be the primary data types that need to be entered into the sheet. - Calculations: There are two specific calculations that need to be performed on the numbers: - Summation: You will need to calculate the total of all the numbers. - Average Calculation: You will also need to find the average of all the numbers. - Date Formatting: The dates I will provide need to be formatted in both date and time format. This means you should be adept at formatting cells in Excel to ensure the correct display of dates and times. Ideal ...

I'm in need of an experienced PHP developer to assist in enhancing my project with specific focus on design modifications and functionality enhancements. Key Tasks: - Design Modifications: The project requires a design overhaul to improve aesthetics and user experience. This includes updating the layout, color scheme, typography, and overall visual elements. Your ability to create appealing, modern designs that align with our brand is crucial. - Functionality Enhancements: There are certain functionalities within the project that need to be revisited and improved. Your role will involve identifying areas for enhancement, suggesting necessary changes, and implementing these updates effectively. You should be well-versed in PHP development and capable of op...

...specific improvements to my existing PHP application and enhance its integration with QuickBooks Online. CURRENT: We have a QuickBooks Online application that syncs invoices from QuickBooks Online to two MySQL database tables (order headers and order lines). This application works correctly but we want to add a condition to the INSERT statement in this program so only invoices that have a custom field populated will get synced to these tables. The custom field name to check is "Online Order Number". Requirements: - Modify functionality of existing program to only INSERT records to MySQL table when invoice record contains a value in custom field "Online Order Number" The ideal freelancer for this project should have: - Proven exp...

Before you respond on Freelancer.com, please take a minute to read this document in full. There is no rush. Also view our "Client profile" before you bid. We are a reputed employer with excellent previous ratings. The chosen freelancer will receive positive feedback score and prompt payment. ----------------- About the subject ----------------------- This is a 4-hour project to create a 30-second to 1-minute video (time can be slightly more or less, it is up to your judgment when making the video) The deadline is sacred, we cannot extend the 4 hour timeline. ---------------- About the video ------------------- Video script: (See attached file - video ) Platform brief (see attached Powerpoint presentation) --------- Other details ------------------------- N...

I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.

I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clea...

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.

...interested in having car, background, and other animations added. These should be creative and interactive to enhance the player experience. - Incorporate sound effects: Sound is an important aspect of any game and I'd like to include sound effects that enhance the overall experience. - Perform necessary bug fixes and improve the game's performance, rendering, scaling, and responsiveness: Ensuring the game runs smoothly on ANY browser (desktop or mobile) and without any issues is crucial. - Enhance the website's completeness and social media integration: The game should be fully integrated into the website and connected well with social media. - Improve the architecture to allow for future features: The game should be in a state that it can be easily expande...

...document in full. There is no rush. Also view our "Client profile" before you bid. We are a reputed employer with excellent previous ratings. The chosen freelancer will receive positive feedback score and prompt payment. ----------------- About the subject ----------------------- This is a 4-hour project to create a 30-second to 1-minute video (time can be slightly more or less, it is up to your judgment when making the video) The deadline is sacred, we cannot extend the 4 hour timeline. ---------------- About the video ------------------- Video script: (See attached file - video ) --------- Other details ------------------------- No voiceover is required. Generic background music is required, something light and peppy. Please bid only if you have p...

Idea is to be able to manage my current users in my dev cluster, most of them have cloudadmin permissions, idea is to have a whitelist of users, I will be providing you access to my API Keys and repo for this, also the whitelist based on the users email, I am using azure devops to do CI-CD Tasks, idea is to create a yaml file pipeline able tu run this process everyday at midnight.

I have an html form php file on my server. I would like a passcode (no username) added to the form that captures the u...captures the user connected to the passcode when the form is submitted. I would like the data sent to Google Sheets when a user submits the form. The Google sheet is complex. I would like the form data sent to 1 of 13 sheets. It should search for the sheet name, date, and user (from the html form) to find the correct sheet and row to insert the data from 5 fields. Can you help with this? We have an form in the laravel, these are three main tasks : 1) Secure the form with 6 code passcode. 2) Update the URL of the form. 3) Save the form data in google sheet. There are various tabs in the sheet, so we need to save t...

I am in need of an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It should make it easy to identify trends and cha...

...document in full. There is no rush. Also view our "Client profile" before you bid. We are a reputed employer with excellent previous ratings. The chosen freelancer will receive positive feedback score and prompt payment. ----------------- About the subject ----------------------- This is a 4-hour project to create a 30-second to 1-minute video (time can be slightly more or less, it is up to your judgment when making the video) The deadline is sacred, we cannot extend the 4 hour timeline. ---------------- About the video ------------------- Video script: (See attached file - video ) --------- Other details ------------------------- No voiceover is required. Generic background music is required, something light and peppy. Please bid only if you have p...

I'm looking for a Laravel expert to integrate Google Sheets into my system. Specifically, I want to connect it with a form on my site for seamless data ...looking for a Laravel expert to integrate Google Sheets into my system. Specifically, I want to connect it with a form on my site for seamless data handling. I have an html form php file on my server (built in laravel). I would like a passcode (no username) added to the form that captures the user connected to the passcode when the form is submitted. I would like the data sent to Google Sheets when a user submits the form. The Google sheet is complex. I would like the form data sent to 1 of 13 sheets. It should search for the sheet name, date, and user (from the html form) to find the correct sheet and r...

...(Basic Income Statement, Balance Sheet, change of Equity, and cash flow) as of 2024 March 31st (Year End 31-03-2024) 2. Maintain the company account and record transaction recorded (e.g: Journal Enters) 3. Recording and reconciliation of banking, AP, and AR transactions 4. prepare the accounting schedule (The “schedules”); A. Account Receivable, B. Account Payable, C. Payroll (Included MPF) D. Loan, E. Accrued expense. F. Amount due from/to G. Bank transaction. H. Fixed asset (with depreciation) 5. Prepare monthly financial statement (with the schedules Above) "Additional Scope" (I want you to do) 6. Using the accounting system "Odoo" for better recording process A. The Ideal scenario is keeping all the records at the Odoo. 7. Advise and enhance be...

I'm looking for a professional to create a monthly income statement in Excel spreadsheet format. Key Requirements: - The task is to generate an income statement. - The data must be accurate and well-organized. - I would like to have the report in Excel spreadsheet. - The report should be delivered on a monthly basis. Ideal Skills: - Proficiency in financial reporting and analysis. - Advanced Excel skills. - Attention to detail. - Experience in creating income statements. - Timely delivery.

...knowledge with google maps, and screenshot capabilities. Who can help me conduct in-depth market research. The task involves identifying and documenting all Amazon lockers situated near rural locations on Google Maps. The deliverable should be an Excel spreadsheet with the following information for each locker: I have provided a sheet with more detailed instructions attached, with list of cities required included. - Name - Address - Picture - Need link to image or image attached. - Operating hours This research is crucial to exploring potential market opportunities. It's essential that the information is detailed and accurate to assist me in making informed decisions. Will need to have provide a and excel or google sheet document with t...

I need a skilled VBA developer who can help with an important task -- Macro Programming. The main purpose of this programming will be to improve the output of data in a more coherent and meaningful way. Here's what the project involves: - Macro Programming: I am specifically looking for someone who can build macros in our system to ease the process and make it more efficient. - Data Output Formatting: The second important part of the task is to navigate data output formatting. Even though I haven't specified the kind of formatting, this is a crucial aspect of the job. Skills and experience necessary for this project include: - Proficiency in VBA development and Macro programming - Experience in managing and manipulating data - Skil...

business profit loss reporting excel(Jan, Feb & March)

As the owner of an upcoming web application, I am in need of a professional UI designer who can develop an illustrative interface for my platform. Key responsibilities will include: - Designing a distinctive, illustrative UI that is both engaging and user-friendly - Implementing design principles which align with the functionality of the application - Ensuring that the design appeals to the platform's target market Ideal candidates should have: - Proven experience in designing interfaces for web applications - Demonstrated proficiency in creating illustrative UI designs - Solid understanding of user-centered design principles Description: Under this project 1) You have to create home page - header with menu navs (parallax effect) to show the s...

I'm in immediate need of a Solidworks expert to assist with multiple tasks related to creating and manipulating sheet metal panel drawings. The work will primarily involve: - Creating 3D models from 2D drawings - Making modifications to these models - Generating flat patterns needed for manufacturing - Setting up configurations and global variances for sizes, materials, and thicknesses Moreover, the final goal is to establish a DriveWorks automation project. I'm looking for someone to ensure it encompasses: - A customizable user interface for parameter input - The ability to automatically generate reports or documentation I need this project to be completed as soon as possible. Ideal candidates should have a strong background in Solidworks, with extens...

-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression an...

I need an experienced data entry person to perform research on Twitter(X) for crypto/stock twitter influencers/posters with over 1,0...who make predictions on crypto/stocks. @CryptoCapo_ is one example of a desired crypto influencer account. I also want you to find stock and crypto prediction Substack accounts, there is no subscriber minimum. It is your job to find other similar accounts and make a spreadsheet with two sheets, one for twitter and one for substack. the twitter sheet will include the twitter handle and the link to their profile for each account. The substack sheet will include the link to the main substack page, the number of subscribers, and whether the substack is free or paid. if the substack is paid, please have different columns for the different tiers ...

I'm seeking an experienced data extraction specialist to scrape both HTML and text files for specific data. Particulars to look for wi...to scrape both HTML and text files for specific data. Particulars to look for will involve the text content within these files that follows a mixed format structure so would require vast knowledge and understanding of both table format data and paragraph-style data. Key Skills and Experience Required: - Strong abilities in web scraping - Adept with HTML, text parsing - Knowledge of data formats and how to transform data - Proficient in CSV file generation. We need a comprehensive extraction that maintains the integrity and accuracy of the data. As these files do come in multiple formats, versatility and attention to d...

...each item. • Delivery You will be given a Google Sheet template and bank statements to work on. You will work autonomously with minimal supervision. • Workplace You will be working online remotely. • Experience Please show us your detailed related work experience. • IP The intellectual property, including the source code, belongs to Sors Markets Ltd. • Future work I hope that one day you can be good enough to handle some of the simple payments and research on, for example, flight and train tickets. If you can handle the preliminary work, more admin work can be shifted to you, and the number of hours on the task will increase. If you have any questions, please send us a message. Key skills: - Proficient in Microsoft Excel / Google ...

...each item. • Delivery You will be given a Google Sheet template and bank statements to work on. You will work autonomously with minimal supervision. • Workplace You will be working online remotely. • Experience Please show us your detailed related work experience. • IP The intellectual property, including the source code, belongs to Sors Markets Ltd. • Future work I hope that one day you can be good enough to handle some of the simple payments and research on, for example, flight and train tickets. If you can handle the preliminary work, more admin work can be shifted to you, and the number of hours on the task will increase. If you have any questions, please send us a message. Key skills: - Proficient in Microsoft Excel / Google ...

As a t...- We would want the content creator to assist in creating the content. Then we would want generic fields or a pivot table to input data that then flows to the brochure/template. So that each client receives a personalised brochure. It is a tax summary page, with tax saving tips, performance graphs, overall tax positions, etc. - The main thing is having fields we can populate with our financial data that will then pull into the brochure, into graphs or tables, etc. Ideal Skills: - Proficiency in Canva or similar software - Experience designing professional, minimalist templates - Understanding of the tax accounting sector would be a plus. By accurately meeting these requirements, the template created will contribute substantially in th...

I'm looking for a talented graphic designer to create a sleek and modern 3-page brochure targeting homeowners. This brochure will be used to inform potential clients about our custom home building design process. Key elements for the brochure include: - A visually appealing, modern and sleek design that resonates with the target audience - A detailed explanation of our custom home building process in a clear and engaging manner Ideally, you are someone who: - Has a strong portfolio showcasing modern and sleek design aesthetic - Has experience in designing brochures or marketing materials for the real estate or home building industry - Can come up with creative solutions and engaging visuals to communicate complex concepts in a simple manner This project...

I'm in need of a skilled WP Job Manager/Smyles Plugin expert to make some changes and additions to both the back-end and front-end of my website. The primary focus of this project is to modify the back-end using the Smyles Plugin. Key requirements: - Expertise in WP Job Manager/Smyles Plugin: You should have proven experience with these plugins and be able to implement the necessary changes competently. - Back-end Development: You will be tasked with adding new search criteria and fields to the back-end using the Smyles Plugin. - Attention to Detail: It's important that the changes you make are seamless and do not disrupt the existing functionality of the site. Your main responsibilities will include: - Implementing new search criteria: Specifically, I need...

...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 good understanding of how general contrac...

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.

The WhatsApp bot contains two services: one for subscribers and one for the general public. For the general public: 1. When a sende...input is incorrect, the bot asks the sender to resend the correct code, send an image containing all the codes, or return to the main menu. 3. If the code is entered correctly, the bot displays general information in text form taken from a Google Sheet. Along with this information, a menu is displayed: • PDF file extracted from Google Drive or a folder • Image • Information in text form taken from a Google Sheet • Input another code • Return to the main menu For subscribers: 1. Information from PDF files or images is sourced from a different folder. Alternatively, information in text form is more co...

I'm looking for a talented individual who can help me develop an LLM text model which behaves like a virtual girlfriend. This text model must be engaging in intelligent dialogues with emotions and feelings. Here are the primary requirements for this project: - Create an AI-driven text model: I need a text model that is capable of engaging in intelligent dialogues. This means understanding context, providing relevant and meaningful responses, and exhibiting emotional intelligence. - Incorporate emotional responses: The text model should be capable of expressing emotions and feelings in a realistic manner. This is crucial for creating a believable and engaging virtual girlfriend. - The model can be trained from scratch or, if you have knowledge of current mo...