Vbscript create excel pivot table työt
...values in the paragraph below to be automatically looked up from the values within Table above. Each quarter the Table above will change in terms of the values in the two right columns, and the number of rows will also change. I would like the paragraph to again automatically lookup the referenced values from the new Table. Expertise in Word automation and document editing is essential for this project. Familiarity with VBA scripts for Word or similar is also very beneficial. The chosen applicant should demonstrate an understanding of Word functions, automation techniques, and table editing. In a nutshell, I want a system where I don't have to manually change numeric values within the text every time the Table data updates. Sounds like you? I...
I need an excel system for One Drive that will enable me to effectively monitor my business' trash expenses. The following features should be included: - Data entry for each individual bill spent on trash. I'll manually enter the amount spent on each bill. - Calculation of total trash expenses over a given period. - Monthly reporting of trash expenses, to aid financial planning and cost analysis. Having experience in Excel, formulas, complex calculations and reporting will be handy for this project. If you're familiar with One Drive, that's even better. Perfect for someone who is detail-oriented, precise, and efficient.
I am looking for a proficient software developer who can create a Point of Sale (POS) system that responds to the unique needs of a restaurant setting. The ideal software should encompass the following functionalities: - Order Management: An efficient system to handle payment processing and menu customization. Being a cash-only restaurant, the system should be set up to facilitate hassle-free cash transactions. - Inventory Management: A built-in feature that will handle the monitoring and tracking of stock efficiently and let us know when to replenish items. - Table Management: A seamless feature that enables table reservation, tracking, and management improving our front-of-house operations. As the ideal candidate, you should have prior experience in POS softwar...
I'm on the search for a versatile artist who can help launch my clothing brand, specializing in graphic tees. The designs will primarily pivot around well-loved athletes and artists - an electrifying mix of sports and arts, encapsulated onto a tee. While I'm open to your individual style of artwork, there are few essentials I would need in your application: - Detailed Project Proposal: Show me your vision - How would you craft the meeting point of sports and arts onto apparel? How can you take iconic figures and transform them into wearable statements? Dedicated to an adult demographic, our designs need to appeal to the matured tastes of this group. Skills & Experience: - Proven experience in designing for clothing, particularly tees. - An understanding of cultures...
- Remove the threshold value to prevent small transactions from causing significant negative balances. - Check if the user has enough money for a transaction before processing it. - Implement a separate modul...transactions from causing significant negative balances. - Check if the user has enough money for a transaction before processing it. - Implement a separate module to manage balances, checking if the user has sufficient funds for transactions and providing balance history. - Develop a robust calculation system (tokenization) to verify the user's balance before debiting. - Structure the write-off table with fields such as user ID, date, write-off type, debit link, flag for actual record, virtual balance value, real balance value, balance history, and date for virtual bala...
... Arabic language, and Islamic studies. Required qualifications: Extensive track record in digital marketing, specifically in the educational academy space, including but not limited to social media marketing, search engine optimization, email marketing, and Google ads. Ability to effectively reach my target audiences in the United States, Canada, United Kingdom, and Australia. Flexibility to pivot and adapt between different marketing strategies and platforms. When applying for this role, including your relevant prior experience is essential. Your proven digital marketing expertise, especially in educational academies focused on Quran teaching, Arabic language, and Islamic materials, will significantly influence my decision. Let's take my business to the next level. I loo...
I am in need of a skilled freelancer to carry out web scraping in a professional and timely manner. The ideal candidate will have significant experience in the field of data mining and extraction. Your task will be to scrape text content, images, and product information from specified websites. ...candidate will have significant experience in the field of data mining and extraction. Your task will be to scrape text content, images, and product information from specified websites. Please ensure you highlight your experience in your application. Upon completion, I'll need the scraped data to be organized and delivered in an Excel Spreadsheet format for ease of analysis. Key Skills: - Web scraping - Data mining - Data extraction - Proficiency in Excel, for the clea...
Join our team as a Telemarketer and earn commission-based pay for your hard work! We do not require any upfront payment from our employees - all compensation is provided after the completion of tasks. If you are motivated, results-driven, and ready to excel in a dynamic sales environment, we want to hear from you. Contact us today to learn more about this exciting opportunity!
Request from Mikel: "I need a small develo...from external XML files. In a file, I'd define some XML source URL. Different ones, but with same structure. 2 types: 1) One or more URLs. It needs to show current listener and listener pick amount from 2 XML tag. If I set more than one URL, it should sum the amount of all of them (sum the numeric tags and show the total). 2) One of more URLs (different ones) from defined XML source. It's a table with 3 columns. It should show formatted. If there is more than one URL, it should concatenate and show the data of all of them together. They can be upto 50.000 or 60.000 lines. We won't use any database, the variables will be in a local file. If you need to download the XML files to process them, you can download it temp...
I am looking for a Power BI developer to help me make a new visual and table where elements are mapped together. Must work over teamviewer or anydesk. I cannot give out passwords for SQL
More details: What is the purpose of the Excel sheet data typing project? Data entry What type of data will be entered into the Excel sheet? Both numerical and textual data What is the source of this data? Manual entry
Create and redesign a logo for the following business, no point reproducing what we already have. Thermal Investigation and Testing Solutions (TITS) Current logo to be redesigned is attached. Incorporate colours of a thermal image from a building inspection. Logo to fit a ratio of 1:1 round to use as avatar, fb and social etc. please no ai… Even tho we are a thermal image business, thermal is the image the camera captures. We specialise in water leak and membrane failure not Hot and Cold as in the aircon industry. is a thermal image, blended and mask in original logo. Titsau is what we do.
More details: What is the purpose of the 3DMax videos? Promote a product or service What kind of products or services are you looking to promote in the videos? Tech products What specific elements or attributes of the tech product do you want highlighted in the 3DMax videos? Design aesthetics
I'm looking for a professional experienced in Power Automate Desktop to autom...looking for a professional experienced in Power Automate Desktop to automate a task I regularly deal with. The task involves extracting specific 'pricing details' from multiple webpages, and subsequently transferring this data into an Excel file. Skills and Experience: - Proficiency in Power Automate Desktop - Expertise in web data extraction and management - Knowledge of Excel data handling Please note that the automation must be able to cover multiple pricing details - whether they are listed singularly or in package form, and accurately convey them into the Excel file. Prior experience with this type of automation is a plus. The successful candidate will have the capaci...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I need a professional to extract emails, phone numbers, and usernames from Instagram users' followers. These data are crucial to launching my marketing campaign. After the completion of extraction, I want the data to be delivered in an excel spreadsheet. Skills in Instagram API and data mining will come handy and are thus ideal for this job. An experience in extracting big data sets from social platforms will also be advantageous.
Looking for a profes...deposits). The balance is stored in a table and this table stores all the history of deposits and withdrawals of this balance with links to specific debits (transactions). We also need a good system of calculations (tokenization) - that would find out before the moment of debiting - whether the user has enough money or not. Structure of the write-off table: user id date (time stamp) write-off type (bonus deposit accrual / bonus deposit write-off / real money accrual / real money withdrawal) debit link (in transactons collection) Flag - that this is an actual record Value of virtual balance Value of real balance Balance history (i.e. directly write real deposit + virtual deposit = balance) Record the date when the virtual balance should be b...
APP event specs Project Title: End-toEnd Event lifecycle management and automated Application Deployment: Mobile, Tablet, Laptop The application will help simplify all the steps for building an event, the application has the following functionality Description: I need a UI/UX (User Interface/User Experience) design expert to help me create an ultra-smooth web or mobile interface for event creation. The goal is to minimize friction for organizers and provide a highly efficient process. The application build in appsheet an integrated with appscrit and google gemini, will provide intuitive user interface that first allow the user to provide the inputs on the event, including the objective, industry, and narrative, In the next screen the user will be proposed with a short list of...
I need an expert with a strong background in Python to extract specific data from a PDF file. You'll need to accurately shift this data to a structured CSV or Excel spreadsheet. Key Responsibilities: - Browse a folder containing PDF files - Extract text-based information from the source files - Extract each line item and append it to the existing list if not add to the list - Focus on retrieving numeric data and dates specifically - Ensure the dates are formatted as 'DD/MM/YYYY' - Generate a log of processed files and errors if any Skills & Experience: - Python programming - Data extraction, wrangling, and analysis - Previous work with PDF data extraction strongly preferred - Attention to detail is vital, to ensure accurate data extraction - Understanding of d...
As per discussion, the project is intended to create 2D site plan for showing lot distribution, entry/exit roads and other details as per chat discussion.
I urgently need an expert in Excel VBA who is highly skilled to create a tool capable of storing passwords securely. This task is critical and needs immediate attention. Key Requirements: - Development of an Excel VBA sheet with password storage functionality - Emphasis on security measures: While I skipped the question related to specific security measures, the chosen freelancer should be competent in advising and implementing the most appropriate ones such as data encryption, file password protection or two-step verification to ensure the highest level of safety. Ideal Skills: - Proficiency in Excel VBA - Expertise in data security principles - Knowledge about password storage and encryption - Capability to work under tight deadlines Given the urgency of t...
...display inspiring, customer-centric quotes around our workshops. Here’s what I need from you: - **Design Engaging Posters:** Create eye-catching posters that embody our mission. Each poster should combine motivational quotes with the vibrant Tata Motors logo and colors. The goal is to inspire our technicians every day to adopt more customer-centric behaviors. - **Experience in Corporate Branding:** You should have a strong background in corporate branding, especially in designing materials that resonate with company values and culture. Experience with automotive industry branding is a plus but not mandatory. - **Creativity and Insight:** Bring your creativity to the table! We need posters that not only communicate the message but also do so in a way that catches...
I'm in dire need of a proficient professional with strong skills in Microsoft Excel, particularly with linking and integrating data across spreadsheets. The focus is on nutritional data, specifically numerical data. Key Project Requirements: - Experience in managing numerical data in Excel - Ability to flawlessly link different Excel sheets for seamless data retrieval - Hands-on ability to import nutritional data from a database to an Excel sheet - Strong attention to detail to ensure accuracy and consistency of imported numbers Your efforts will greatly simplify my day-to-day management of nutritional data. An understanding of nutritional data or related fields will be a strong advantage, though is not entirely necessary. Speed and accuracy are of utmos...
I'm searching for an exceptional video editor, proficient in special effects to uplift my faceless YouTube channel. PLEASE SHARE LINK TO YOUR PREVIOUS VIDEOS. Key Responsibilities: - Delivering high-quality edits for videos ranging between 5-15 minutes. - Integrating advanced special effects, including green screen and other visual effects to...other visual effects to increase viewer engagement. - Fostering a casual and relatable video style that resonates with my audience. Ideal Candidate: - Has a creative flair for video editing - Holds expertise in advanced special effects - Can adapt their editing style to match a casual and relatable vibe Bring your creativity, technical expertise, and passion for producing engaging content to the table, and let’s make brillian...
...File types: To include: pdf, ms word, Excel, CSV, text, XML, JSON User acceptance: To be able to query openAI about the file and get responses that relate exclusively to the reference file. Code: Native JavaScript. Can use external libraries. Should run on any server without installing plugins. Specifications: - The file constitutes mixed data, encompassing both numerical and textual information. - The system should seamlessly interact with the entirety of the file. - The primary task involves integrating the API to fetch data from the stored file, read and analyse it as required, and send appropriate responses. Ideal Skills & Experience: - Robust knowledge about APIs, specifically in relation to Excel integration. - Experience in handling Excel files wit...
I am in need of a unique yet straightforward website, primarily dedicated to sharing an event calendar and notes from various day trips. I would like it to be easy to update. Right now I have excel tables. Want easy to share and update (no public update). Can share what I have now. Want the ability to add a few links to other sites, to add a small number of pages or a subsite in case I start a small side gig - for example an airport shuttle service Key Features Required: Event Calendar: - The ability for me to add events, complete with crucial details like date and time. - Display of these events should be flexible, allowing both a monthly and weekly view. Day Trip Sharing: - Each day trip note needs to be in an individual blog post format. - I would also like an interactiv...
I am in urgent need of a dedicated virtual assistant fluent in data entry for text and numbers into Microsoft Excel. The task at hand will involve: - Populating an Excel database with text and numerical information. - Using five different fields for each entry. An ideal candidate should possess: - Proficiency with Microsoft Excel and an understanding of its usage for data management. - An acute attention to details to ensure data accuracy. - Proficient typing speed for quick data entry. - Data management and administration experience are beneficial. I will provide the sources from where the data is and can be accessed for input into an Excel workbook I have built. See attached workbook. The tabs are broken out by states here in the USA. Please note ...
...expert guidance and daily minimum 3 hours mentorship for at least 2 weeks to optimize and integrate our in-house applications built on Django. Our applications range from AI chatbots for consultants to excel mapping. Django has already been installed, a main APP has been created, each application is intended to run as an API. Here's where you come in: - Optimize Application Performance: Help us enhance the speed and efficiency of our apps. - Integrate with External APIs: Guide us on how to effectively link our applications with external APIs. - AI Application Development: We want to create AI apps in a more efficient manner. Your insights will be valuable. I expect freelancers applying to this project to have: - Experience: relevant experience in Django and AI a...
...data interpretation and manipulation. I have 5 columns, vendor name, product, from qty, To Qty, unit price. The vendor is giving a price for quantities between the from and To Qty. Example of data table: acme vendor, widget, 1, 25, $10.00 So the price for any quantity between 1 and 25 will cost $10.00 Ace vendor, widget 4,6,$11.00 Big corp, widget, 7,25,$15.00 Dog Inc, part-A ,2,10,$25.00 Cat Corp Part-123, 2-5 I need to be able to search the data let’s say for any pricing that is for a qty 6. So in the table it should result in Acme, Ace, and Dog pricing. I assume there needs to be. Table of sequential Numbers from 1 through 3000. So there can be a filter for the user to enter there quantity that they want to use for the search. That’s a gues...
Looking for old Forex Excel files need IT, UK Leads if you have some lists give me the info how many have you got? info must have name, last name, email, phone number bulk needed around 1m per geo if you have it send me small image to see the fields, cost amount
...Conduct a thorough comparison between ITA GAAP and Romanian GAAP to identify key differences affecting financial reporting. Excel Spreadsheet Design: Develop a structured Excel workbook that includes: Separate sheets for the original financial statements of both companies. A detailed analysis of the differences between ITA GAAP and Romanian GAAP. A consolidated financial statement sheet with extensive account details according to Italian accounting principles. Financial Statement Reconciliation: Adjust the Romanian company's financial statements to align with Italian accounting standards. Highlight differences and reconcile them in a dedicated column within the Excel workbook. Consolidated Financial Reporting: Aggregate the adjusted financial data into a fin...
I recently created my company ServinTime. We offer an innovative solutions for restaurants : a button displayed on the tables to call the waiters. I need a simple yet effective logo for my company. The background of the logo is black, and the colors of the logo are purple and white. The purple shoudl be kind of a metal purple (see attached example "télé"), but you can suggest different variations of the purple if you want. The logo should be composed of a simple logo and the letters ServinTime. The logo should be 2D, no 3D
As someone in need of a React Native developer, my project requires the application to be developed for both iOS and Android platforms. I am currently in the pre-design stage therefore, design specifications or wireframes for the ap...development and is comfortable working with minimal initial guidance. The ideal freelancer should thrive in an environment that requires flexible thinking and adaptability. As the project evolves, clear concepts and guidance will be provided. Experience in both iOS and Android platforms is a must. Knowledge to create user-friendly, intuitive layouts and designs would be a huge plus. Looking forward to collaborating with a creative and innovative mind who can bring ideas to the table. Please bid if you're comfortable with uncertainty and tak...
I require a highly skilled Power BI professional to automate reports based on customer data currently stored in Excel spreadsheets. Tasks: - Familiarize themselves with the data structure in our Excel spreadsheets. - Use Power BI to automate the reporting of this data. Ideal Skills: - Advanced understanding of Power BI and its functionality, specifically in regards to report automation. - Experience with data analysis, particularly of customer data. - Expertise in Excel, able to work with complex spreadsheets. Your ability to work 'real time' using screen-share technology is essential. This will help ensure a seamless integration of your work into our existing system. Freelancers who have successfully conducted similar projects in the past will be highly r...
I'm in need of a proficient data entry specialist, particularly knowledgeable in Excel. The data to be entered is not just simplistic entries, it involves working with links between spreadsheets and complex formulas. Here's what I require: - Fascinating skills in Excel data entry - Proficiency in creating links between spreadsheets - Ability to handle complex formulas within Excel - Competence in creating both pivot tables and graphs based on entered data This project requires an individual with advanced knowledge in Excel, and strong precision to detail. The ideal freelancer should have excellent organizational skills and previous experience working with similar projects.
I'm seeking seasoned professionals who excel in website development, mobile app creation, and graphic design to bring my multi-faceted e-commerce concept to life. The scope includes: - Crafting an e-commerce website - Developing a corresponding mobile app - Deploying enticing graphic designs I aim to establish a platform for selling products/services, highlighting the necessity of expertise in similar business-oriented projects. Ideal Skills include: - Proficiency in e-commerce website development - Expertise in mobile app development, iOS and Android - Exceptional creative graphic design capability - Excellent understanding of UI/UX principles Proven experience in similar projects will significantly increase the chances of collaboration. Looking forward to innovative, ...
I am looking for a highly experienced Program Management Consultant to take the lead in designing, implementing, and maintaining operational processes for a large company. Key focus will be on rolling out and managing new processes, with a goal of increasing productivity and enhancing project delivery. What I'm looking for: - Proven experience in implementing new processes - Stro...Strong portfolio showcasing successful process improvements - Ability to optimize operations for enhanced productivity Successful freelancers should include examples of relevant past work in their applications. The ideal candidate can demonstrate past success in streamlining operations and effectively managing new process rollouts. Your proposal should clearly show your ability to take on and excel...
I'm in need of a skilled freelancer who is an expert in Excel 365 and specifically skilled in VBA automating tasks. The main function of this role includes: - Automating tasks in Excel 365 - Utilizing VBA to generate regular reports - Should work in Windows and Macbook both The ideal candidate for this project has strong experience in using Excel 365, with specific knowledge in automating tasks through VBA. I am especially interested in those who have a proven track record of generating regular reports using VBA. Please include examples of similar work in your proposal.
...company's B2B program as Excel and XML within a certain period of time. The B2B program installed on my computer was installed on my desktop with keys and passwords via remote connection. The information I want from this program; I want a program that can quickly capture the stock code of the product, product description, original number of the product, price of the product, image URL of the product, and stock quantities of the product in which warehouses within a certain period of time. After making this program, it should automatically upload this data to my own website, which I purchased with a ready-made theme, as soon as possible. I need someone who can integrate and do this. The ready-made themed site I purchased uploads data in bulk with an XML address and Excel...
I need assistance in extracting specific elements from 250 Excel spreadsheet addresses - specifically, the city, state, and ZIP codes. The purpose of this extraction is ultimately to import this data into a specialized software. Ideal Skills: - Strong grasp of Excel - Experience in data extraction and manipulation - Familiarity with data importation process for software applications Deliverables: - Clean and well-organized list of city, state, and ZIP code data extracted from 250 addresses - Recommendations on best practices for importing this data into software.
...I am currently a student in a business school and I am preparing for a makeup session regarding Excel VBA. Unfortunately, during my preparation, I encountered difficulties using ChatGPT for the exam, which was not successful. Additionally, I faced a delicate situation when it turned out that I had used a portion of a friend's work to help me, which was noticed by the professor since my friend's name was on the Excel file. I am simply seeking an expert specializing in automating tasks in Excel using VBA. The main focus of this project revolves around automating data entry processes. Here, efficiency and accuracy are paramount. The main responsibilities include: - Automating data entry in Excel using VBA - Enhancing the speed and accuracy of data i...
I am in need of a freelancer who is an expert in Excel to assist me with data analysis. The ideal candidate should have advanced skills in Excel and should be proficient in general data analysis techniques. The specific tasks that I require help with include data analysis, formula creation, and formatting and design. The freelancer should also be experienced in working with a variety of data sets. If you have the required skills and experience, please apply for this project.
As someone who has a sizeable collection of videos to edit, I'm looking for freelancers who bring a wealth of experience to the table. Successful freelancers should provide details about their prior experiences, giving me a clear picture of their work style and skill set. The project will vastly revolve around clip sequencing and special effects, indicating a need for proficiency in these specific areas. All in all, I am hoping to find a capable and imaginative professional who can elevate my footages to the next level. Skills and experience required: - Extensive experience with video editing - Proficiency in clip sequencing and special effects - Excellent time management and commitment to deadlines - Previous relevant work experience.
I'm looking for an Excel expert to create a spreadsheet for me. Here are the key features I want: - Automatic calculations: I need the spreadsheet to automatically calculate sums and percentages. Prior experience in creating automatic calculations in Excel is important. - Graphs: I would like the spreadsheet to include bar graphs. This will visually display the data in digital format, so freelancers with skills in creating and managing graphs in Excel would be ideal. The final deliverable should be a user-friendly Excel spreadsheet that meets the above requirements. As such, attention to detail, proficiency in Excel, and a knack for visually representing data are all necessary skills for this job. I want to make an Excel that allo...
...Scraping text content and images from a test website. - Ensuring the data is accurate and comprehensive. - Organizing scrapped data in an Excel spreadsheet or a csv file. Keen attention to detail is critical. Applicants with prior experience in web scraping, data extraction, and data management, who are comfortable with Excel functions, will be ideal for this project. Please bid on an hourly basis for your time and explain who you will charge by the hour. I'm assuming that you will need to set up the scraping tool, which might take some time, then do the scraping itself from about 2,500 website pages, and then make sure the data is correct in the excel spreadsheet (or csv). Please share what tool you will use and if there is any additional cost to us for usin...
I'm seeking an experienced developer to create a comprehensive dropdown system linked to multiple table views. Expertise in creating dynamic data UI is crucial. Key Project Details: - The primary function of the dropdown is to display various options. - The table views will contain a mixture of numerical and textual data based on the dropdown selection. - The displayed data in the table views is to be directly linked to the options selected in the dropdown, and should update accordingly. Candidates with a thorough understanding of data integration with UI elements will have an advantage. Knowledge of data filtering and sorting methods, as well as an ability to opt for effective, responsive design is also desirable.
...which will also provide updates. It will connect with youtube so that videos can be added to show progress and talk about ideas for new vodkas and Gins. Latest youtube videos should show on the front page automatically. There should also be a library of videos. It will provide a calendar where customers can book workshop times to join workshops to create spirits using a small pot still. Similar to the way that people can book a restaurant table. I want customer participation so that people can place orders for the first bottles that are produced. There will be no production until a liquor licence is obtained. But pre-purchases can be made at a discount based upon a desciption of the process and the receipe. -Blog section: Regular updates and articles will be poste...
I require a proficient assistant with expertise in data entry, Excel, Word and Adobe Photoshop. The tasks involve: - Data Entry: Handling data entry tasks, few in number (fewer than 50 entries), which includes handling mixed data i.e. numeric as well as textual data. - Excel and Word: Manipulating and analyzing said worked data using Excel functions and creating detailed reports or documentation using MS Word. - Photoshop: Require basic graphic editing skills in Adobe Photoshop. Ideal skills for the job would be attention to detail, good command over Microsoft Excel and Word functionalities, and fundamental Photoshop skills. Past experience in data entry and graphic design would be highly appreciated.
I need someone to convert 20 PDF files into Excel spreadsheet format. Secondly, once converted to Excel format, I need a slightly new design (colour scheme) to the existing design found in the PDF files. If you could create several sample designs of how to represent the data in the PDF files in a different way (style?) in Excel? See attached 1 x sample PDF file to convert
