Excel change pivot datasource vbaงาน

I'm looking for a skilled data visualization expert to create a comprehensive dashboard in Excel based on the following criteria: - Data Visualization: The dashboard should primarily feature line graphs and pie charts to represent the sales data of various organizations. The design should be clean, intuitive and should effectively communicate the insights from the data. - Data Organization: The data should be organized by category, making it easy for the user to understand the performance of different organizations segmented by different categories. I expect the freelancer to have experience in data visualization, specifically in Excel, and should be able to design a dashboard that is not only visually appealing but also highly functional. Please include samples of yo...

Tengo macros vba para excel que quiero transformar a python (la macro crea copias de un archivo base a otros siguiendo una lista con nombres especificos), y este poder ejecutarlo en un servidor online, tambien requieor un offuscador que inhabilite el acceso al proyecto vba de los libros excel. xslm generados por el codigo. 01 primeramente el resultado final sera que el codigo python actue de la misma manera que la macro (per con archivos alojados en gdrive) 02 offuscador y proteccion a los archivos excel generados 03 - Implementar la ejecucion del codigo python de manera online

I'm looking to enhance my Microsoft Excel skills, focusing on data analysis, pivot tables, and macros, to efficiently manage project construction data and create insightful reports. Key Responsibilities: - Advanced Data Analysis: Interpret project construction data effectively. - Pivot Tables Mastery: Create complex reports with dynamic pivot tables. - Macro Proficiency: Automate repetitive data analysis and report generation tasks, boosting efficiency. Ideal Skills: - Proven expertise in Excel, particularly in data analysis, pivot tables, and macros. - Experience with project construction data, financial data or similar. - Strong analytical and problem-solving abilities. - Excellent attention to detail to ensure high-quality, accurate repo...

...have a stack of physical documents that need to be input into an Excel spreadsheet. Your task will be to transfer this information accurately and efficiently. Key Requirements: - Proficiency in Excel: You will need to have a good working knowledge of this software, and be able to use it to create a well-organized database from the information provided. - Attention to Detail: While I don't expect perfection, I do need the data input to be mostly error-free. Accuracy is key. - Physical Document Handling: As I will be sending you hard copies of the documents, you will need to be able to handle and return them safely. This project is great for those with a good amount of data entry experience, and who are confident in their Excel skills. The ability to work with...

...efficient results promptly. Description: We require a straightforward script to display planetary hours based on location and date input. Key Functions: The script will closely resemble the functionality of this sample site, with additional features: - Integration of Islamic (Hijri Date) display alongside the conventional calendar. - Option for users to select their location, with the flexibility to change it as needed. - Enhanced visualization by displaying the names of planetary rulers alongside logos. - Addition of the current day (Monday, Sunday, etc.) with its corresponding planetary ruler and Islamic name. - Division of each day into two sections: Day and Night, with each section divided into 12 rows. -Incorporation of detailed data for each hour, including the ruler, Is...

I have an Excel sheet with some data that needs a basic clean-up. I'm looking for someone who can help me with this task. Key Responsibilities: - Remove duplicates from the data - Ensure the data is clean and free from any inconsistencies This task is fairly straightforward and doesn't require any advanced data cleaning techniques. It's more about ensuring the data is accurate and removing any unnecessary repetitions. Ideal Skills: - Proficiency in Excel and data entry - Attention to detail - Ability to follow instructions and deliver work accurately and on time This project is ideal for someone who is starting out or looking for a quick task to complete. If you're good with Excel and data management, this would be a good fit for you.

I need an expert in Excel VBA to help automate complex, repetitive tasks within my large sets of Excel data. Key Responsibilities: - Developing a VBA script to automate repetitive tasks in Microsoft Excel - Implementing PivotTables, Macros, and other advanced functions - Ensuring the automation is efficient, reliable, and error-free Ideal skills for this project include: - Advanced knowledge of Microsoft Excel - Extensive experience in VBA scripting, particularly with automation of complex tasks - Proficiency in creating and working with PivotTables - Strong understanding of Macro creation and modification Please bid on this project if you have the necessary experience, skillset, and can ensure the automation meets the required standards...

My existing PowerPoint presentation has animations and transitions that need to be cleaned up, especially in the early slides. It feels clunky and requires more clicks than it should. I'm looking for a skilled professional who can help me create a dynamic and engaging style throughout the entire deck. Please do NOT change the animation styles (like appear, crush, etc) but rather clean up the empty clicks and make it all flow so much better. Key requirements: - Clean up existing entrance animations, exit animations, and slide transitions. - Apply a consistent and engaging dynamic style across all slides. - Ensure that the cleaned up animations and transitions are professional and subtle. I need the entire presentation to flow seamlessly with engaging transitions and anima...

I require a College License Plate Recognition System developed with Python. The key components required are: - Use of the YOLOv8 model for plate detection. The detection should be real-time using webcam. - An incorporated Optical Character Recognition (OCR) library for the recognition part. - It should match the characters of license plate from an excel sheet that already contain the data of college cars in an excel sheet. - A model that produces at least 95% accuracy. - An easily navigable user interface. The system does not need to process an enormous amount of data daily, as it will be dealing with less than 500 entries. Thus, the solution should be designed with this volume in mind. Ideal applicants are experienced in Python programming, YOLOv8 model applications, and ...

Looking for a skilled data entry specialist who can efficiently transfer plain text data into a structured spreadsheet. The type of data to be entered is purely textual, excluding any numeric or mixed data. The target platform for data entry is a user-friendly spreadsheet. However, the source of data is not specified, ...spreadsheet. The type of data to be entered is purely textual, excluding any numeric or mixed data. The target platform for data entry is a user-friendly spreadsheet. However, the source of data is not specified, implying a need for a flexible and independent professional who can adapt to various sources. Ideal Skills and Experience: - Proven experience in data entry - Excellent knowledge of MS Excel - Fast typing speed - Attention to detail - Ability to work ind...

For my paper on the topic: "Interest rate increases and their impact on the real estate investment market: A critical analysis of value and performance indicators" I need a presentation in the form of a regression created with Excel in which dependent and independent variables are modeled according to this topic. Proper presentation and clean work is very important here, so that the model can be interpreted and analyzed well. You have to provide me with the necessary data sets and use them for the regression, I only will tell you which variables to use, so research for the data is included. I will define the variables in more detail and describe what exactly I want to show with the regression. It will be about the behavior of interest rate development, transaction volume...

I'm seeking a skilled professional to work on the PCB design for a BLDC Stepper Motor. I want to create the smallest board (ideally 15mm x 30mm or less). The motor requires 12v, I'm hoping for the PCB to contain everything, and there could be a third button for speed or an FWD/rev switch and a pressure button for variable speed. I've been looking at the Attiny85 and L...skilled professional to work on the PCB design for a BLDC Stepper Motor. I want to create the smallest board (ideally 15mm x 30mm or less). The motor requires 12v, I'm hoping for the PCB to contain everything, and there could be a third button for speed or an FWD/rev switch and a pressure button for variable speed. I've been looking at the Attiny85 and L293D to drive the motor, but I'm happy to...

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

I'm in search of a skilled freelancer who can develop a dynamic Power BI dashboard using my Excel sales data. The ideal candidate must: - Demonstrate expertise in developing interactive Power BI dashboards utilizing Excel data - Understand how to represent sales data clearly and coherently for easy analysis - Be familiar with creating data drill-down and pivot table functionalities in Power BI to interact with data for in-depth analysis Essentially, this dashboard should enable interactive exploration and detailed scrutiny of sales data, allowing us to gain meaningful insights to drive our business decisions. A proven track record in Power BI developments with a strong understanding of sales data is a must.

I'm looking for an expert in Excel AI automation to streamline my data entry and analysis processes. This role will be focused on handling intermediate level data analysis tasks, such as trend analysis and forecasting. Ideal Skills and Experience: - Demonstrated experience with Excel AI automation - Proven ability to handle intermediate data analysis tasks - Strong problem-solving and analytical skills - Excellent communication and time management skills

I require a skilled accountant with a deep understanding of financial statement analysis. The project is urgent, and I need a professional who can work quickly and efficiently. please read the questions, and look into the excel sheet to solve the tables. Let me know if are welling to work on this project. and i want this work by few hours under.

...freelancer to establish and maintain an email database for my monthly marketing campaigns. My small business, based in London, UK, caters to estate agents, necessitating the creation of a comprehensive lead database for email marketing purposes. Key Responsibilities: Set up and manage an Excel spreadsheet for the email database Regularly update the email database with new leads and modifications on a monthly basis Ensure the accuracy and integrity of data entries in the database Ideal Candidate: Proficiency in Excel and Microsoft Office suite Previous experience in email database management Meticulous attention to detail to uphold the accuracy of the database Proactive and capable of working independently to conduct monthly database maintenance This project has the pote...

I require a skilled accountant with a deep understanding of financial statement analysis. The project is urgent, and I need a professional who can work quickly and efficiently. please read the questions, and look into the excel sheet to solve the tables. Let me know if are welling to work on this project. and i want this work by today.

Hola, Busco una persona experta en selenium que pueda automatizar la entrada de datos en la pagina de alta de los cursos de udemy. Para este trabajo buscamos a una persona que ya conozca el proceso de dar de alta en los cursos de udemy. El proceso deberá leer una excel donde la 1º columna contiene el nombre de los diferentes puntos que contiene un curso. La segunda columna contiene la dirección donde se encuentra el video, al dar de alta un punto para un video hace falta el nombre del punto y el video. Al escribirme por favor indica el precio del presupuesto. Un saludo.

I have 1 unfinished Access/VBA project. I need assistance to finish the project. The project require the developement of Access forms, VBA code and Generation of reports. My estimation is 3 working days. Max budget : 100$ Thanks for you bid

I have a list of contacts in an excel file, and I need someone to find their email addresses. - The main task will be to locate and verify the email addresses of these contacts. It is crucial that the emails provided are accurate. - The purpose of this exercise is for personalized outreach to these individuals and not for mass email marketing or research purposes. The ideal freelancer for this job is someone with excellent research skills, an ability to meticulously verify information, and experience in email marketing or personalized outreach. A high level of proficiency with Excel is also required. Files: There are lots of entries that need to be completed. you will need to add the email address of

This is a one of project; I'm looking for an Excel expert to develop a workbook enabling data analysis of multiple bank and credit card statements. This workbook must have the ability to run multiple functions/reports - Implementation of SUM and COUNT functions. - Utilization of VLOOKUP or HLOOKUP. - Creation of Pivot Tables and informative Charts. The ideal candidate would be someone with prior experience in financial analysis or data engineering, who can ensure that the workbook provides the insights needed. Ability to ensure accuracy and relevancy within the formulas and functions is essential. Attached is a sample data file. This is a pdf to excel conversion. Prior to submission, the conversion data will be sanity checked and verified. If an alternative...

I need an experienced JavaScript developer to fix 2 issues on existing game. #1) Change Mouse Pointer to Gun Cross Hair #2) Center the Explosion Image On the Object $10 Job

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

I have an Excel sheet with some data that needs a basic clean-up. I'm looking for someone who can help me with this task. Key Responsibilities: - Remove duplicates from the data - Ensure the data is clean and free from any inconsistencies This task is fairly straightforward and doesn't require any advanced data cleaning techniques. It's more about ensuring the data is accurate and removing any unnecessary repetitions. Ideal Skills: - Proficiency in Excel and data entry - Attention to detail - Ability to follow instructions and deliver work accurately and on time This project is ideal for someone who is starting out or looking for a quick task to complete. If you're good with Excel and data management, this would be a good fit for you.

I need an Excel expert to create an advanced sheet for employee management. This sheet would primarily serve two types of employees, sales and telecallers, and perform multiple significant tasks. Key Features: - The sheet should calculate sales data and commissions. - It must track daily leads assigned to the sales team. - It needs to generate reports on business shared between telecaller and sales teams. Design Requirements: - The design should be simple and minimalistic. - It must have color-coded cells for easy interpretation and usage. As the Excel version was not specified, the sheet should ideally be compatible with multiple versions to ensure smooth operation. Ideal Skillset: - Advanced knowledge of Excel. - Experience in creating sophisticated Excel...

I'm looking for a developer to create an airdrop script specifically for Solana SPL. The main aim of this script is to distribute tokens to a specific, pre-selected group of Solana SPL addresses/wallet. The script/app able to read the list of addresses/wallet from txt or Excel . The distribution needs to be fully automated, without requiring any manual intervention. The amount of tokens need to be specific or random from 100 to 1000 etc. Also be able to adjust the Sol sending fees. Key requirements: - The script should be designed to distribute tokens to only a specific, pre-selected group of Solona SPL users, not all users. - It should be fully automated, meaning the distribution process should not involve manual intervention. Ideal skills and experience: - Proficiency in de...

1 Overview: This project de-identifies personal information in the video that detects a person on an Edge Device connected to CCTV and protects personal information by changing the person's face or face + top and bottom. Here's what we need. 1.1 Edg...Device must be sent video from the CCTV Stream. 1.2 A person must be detected in the input video. 1.3 The following information must be extracted from the detected person and made into a metadata (JSON) file. - Facial Embedding Information - Extract information about a person's attributes (hair length, hair color, top color, bottom color, top shape, bottom shape, shoe shape, color, etc.) 1.4 Change to a new face, a new outfit. 1.5 Real-time converted images and generated metadata should be delivered to the storage ...

New freelancer welcome, I'm in need of a virtual assistant to help with my project , quick copy-paste job. My need video clip copy and pasts Excel sheet. I will give video link just need copy time clip. Ideal Candidate: - Proficiency in copy-pasting tasks - Ability to complete the task within a few hours - Experience in virtual assistance would be a plus. Looking forward to working with you! More discus with freelancer chat. Need strong freelance. Thanks

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 looking for an Excel expert to create a custom software for me. The software should primarily focus on automating spreadsheet tasks and presenting data in a visual manner. Key Requirements: - **Spreadsheet Automation**: I'm seeking a solution that can automate various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong unde...

Change the secret key and private key for payment gateway only. Payment gateway is integrated, no error to fix

exactly as per hue mty roof change

Ready to explode your sales with a versatile social media maven? As a top tier marketer, you'll weave your magic across Facebook, Instagram, LinkedIn and WhatsApp, focusing on: - Lead generation - Driving sales Experience with these platforms is vital. Our quest is to accentuate our brand and inspire actions that grow our business. Your expertise in social media marketing will pivot us into profitable realms. Come bring your multi-platform prowess and let's make sales soar.

I'm looking for a data entry operator who can assist me with cleaning, verifying and entering a small volume of data from handwritten documents. - The task involves verifying data for accuracy, identifying and correcting errors, and entering the information into an Excel or CSV file. - The data volume is small, around 1,000 records, making it an ideal project for someone who is detail-oriented and meticulous. Ideal candidates should have: - Experience in data entry and data cleansing tasks - Proficiency in using Excel or CSV files - High level of attention to detail - Ability to work with handwritten documents If you possess these skills and are interested in working on this engaging project, please submit your proposal.

I need a programmer with sufficient experience in Shopify platform and its programming languages to modify the code in the main-cart area. I want to change the 'continue shopping' button to an 'create account' button. When a customer completes the purchase process, they are presented with a button to continue shopping. I want to change that button to redirect the customer to the account creation page.

I would like to create a solution (can be EXCEL, etc.) for creating working schedule, your solution must have these features: 1. Allow multiple locations, with different schedules and number of workers; 2. Setup multiple workers, set dayoff, hours per week, min hours per day and max hours per day; Example: The worker can have 2 days off (w2 = Monday, w3 = Tuesday, …), should work 48 hours per week, and 5 until 8 hours per day (in sequence, 10:00 – 15:00). 3. Views per week, per month (and per location or per worker) – generate a week / month schedule per location and per worker. 4. A random button to regenerate all again 5. And a button to make equilibrium (YES or NO), with YES on this button, your solution will try to adjust the schedule to ensure the &ldquo...

I have given Start time, Interval, End time in excel When i give start time(Ex:9:15), when that time reached E col data automatically copied in into G col, Next Interval is 10 Mins, When 9:25 reached E col data automatically copied in into H col, When 9:35 reached E col data automatically copied in into I col,When 9:45 reached E col data automatically copied in into J col, When 9:55 reached E col data automatically copied in into K col, When 10:05 reached E col data automatically copied in into L col, When 10:15 reached E col data automatically copied in into M col.(H col vale > G col, that cell is green, H col vale < G col, that cell is red, same process for all col) 9:15-9:25 is 1 10Mins during that time, how many time(count) E col value>G col value( Ascending not dece...

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

I'm in need of a professional who can accurately convert scanned PDFs into Excel. 3 different sheet for each supplier. The PDFs are inventory sheets that need to be organized by item number. These sheets will be used for inventory management, so it's crucial that the data is correctly transposed. Key Requirements: - Convert scanned PDFs to Excel - Organize data by item number - Implement conditional formatting to ensure data accuracy Ideal Skills: - Proficiency in data entry and conversion from PDF - Advanced Excel skills, especially in organization and conditional formatting - Experience with inventory management or similar data handling is a plus I look forward to receiving bids from professionals who can guarantee quick and accurate work.

In need of a skilled Microsoft Access VBA expert to establish various functionalities on an ongoing project. This will include, but not be limited to, creating data entry forms, generating reports, and maintaining the database. Ideal Skills: • Experience in MS Access and VBA is mandatory • Familiarity with creating user-friendly interfaces • Proficiency in designing and maintaining database structures • Expertise in automation of repetitive tasks and processes • Knowledge in data analysis using Access If you have any relevant past work or specific experience in the areas mentioned, feel free to include them in your application. In-depth project proposals are also welcome and will be beneficial in the selection process. The main purpose of the pro...

I'm in need of a frontend developer who is an expert in Sass and GSAP to help me troubleshoot and fix an issue with my menu bar animation. The specific issue is that the animation is not appearing at all after a background image add to the page. The change been made is z-index. Key requirements and details for the project: - The main focus is to get the menu bar animation working properly on desktop devices. - The error does not involve any specific device compatibility, but the animation should be visible on desktops. - Experience with Sass and GSAP is crucial for this project. In your bid, please outline: - Your experience with Sass and GSAP - Your approach to troubleshooting and fixing this type of error - Estimated timeline for completion. Looking forward to working...

...API. The ideal candidate will have experience in API integration and database management. Key Project Requirements: - Implement a bulk upload feature for FNSku to ASIN conversion - Utilize Amazon API to extract the ASIN number from the given FNSku - Develop an API database to store and retrieve the ASIN number and the FNSku Additional Functionalities: - Ensure the system allows bulk upload of Excel files - Incorporate the ability for users to download the conversion results - It's essential that results can be downloaded in a specific format, and in this case, directly to an API database. Ideal Skills and Experience: - Prior experience with Amazon API integration and product data extraction - Proficiency in bulk data processing and manipulation - Strong understanding of d...

...containing text data. Post scanning, these QR codes should display the text information incorporated while creating the codes. Furthermore, the software needs to house an Excel Workbook, which should be updated through manual uploads. The Workbook will be responsible for printing the necessary details derived from the CSV file. In addition, the software should also be engineered to retrieve cellular data upon scanning the QR code. Ideal Skills: - Proficiency in developing web-based software - Extensive knowledge in handling CSV files - Expertise in QR code generation and functionality - Experience in managing Excel Workbooks - Able to incorporate manual uploads - Experience with cellular data retrieval from QR scans. This entails a complex task, requiring ...

Responsibilities: Develop email marketing strategies that align with our business objectives and target audience. Set up and configure email campaigns within the Mailwizz platform, including creating templates, segments,...client-facing skills and ability to effectively communicate campaign strategies and results. Preferred Qualifications: Experience with email automation and drip campaigns. Knowledge of best practices for email design and coding. Familiarity with email deliverability issues and strategies for improving inbox placement. How to Apply: If you're passionate about email marketing and have the skills to excel in this role, we'd love to hear from you! Note: This is a freelance position with the potential for long-term collaboration based on performance and p...

Responsibilities: Manage the post-production workflow for my podcast, from raw audio files to final episodes ready for distribution. Edit podcast episodes for clarity, coherence, and overall quality, including removing mistakes, filler words, and background noise. Mix and master audio to achieve optimal sound quality and consistency across episodes. ...communication and collaboration skills, with the ability to work effectively in a remote team environment. Passion for podcasts and a deep understanding of the medium, including storytelling techniques and audience engagement strategies. Preferred Qualifications: Experience working with remote teams and using project management tools If you're passionate about podcasts and have the skills to excel in this role, we'd lo...

I'm in need of a versatile data scientist who can expertly navigate both Python and R. For this assignment, you should be proficient in various data analysis techniques including: - Predictive modeling - Data visualization - Statistical analysis The dataset I'll provide comes in Excel format. Your task will be to demonstrate these techniques in Python and R as accurately as possible. Please submit a bid if you're confident in your ability to efficiently illustrate professional-level data analysis in both languages. For now, I only need Part 1 and Part 3 to be done. Part 1 has multiple subparts and should be done in R language. While Part 3 should be done in Python

I'm looking to have an item's color changed from its current orange shade to a crimson hue. The item is made of fabric. The reflection in the pool also needs to be changed accordingly. I am looking for a skilled professional who has: - Experience with fabric dyeing and color change - The ability to understand color variations and matching - A keen attention to detail to ensure the end result is a consistent, deep crimson across the fabric - Knowledge of fabric types and how different materials absorb or react to color changes. Please share related experience or portfolio samples when applying.

I need a word document translated from English to Japanese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I need a word document translated from English to Turkish as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!