Excel macro import data export datamunkák

We have a requirement to work with Excel Power Pivot, Power Query Editor and prepare a Report. Very normal report and can be completed within couple of hours by an expert. I can pay maximum of INR1500/2000 for this first project but I will ensure, all my future work will be assigned to you. Looking for someone whom I can bank on for future. Thank you!

...business, and will require importing text data from photographs into a PostgreSQL database. The developer will then need to integrate this functionality with our existing PHP-based website. Below will be the work flow for project Step 1: Implement a button on a PHP-based website labeled 'Import Bills'. When clicked, it triggers the import process. Step 2: Upon clicking the 'Import Bills' button, provide a browse option allowing the user to select the bill image from their disk. Step 3: Utilize an OCR (Optical Character Recognition) plugin to extract data from the selected image. This extracted data is then compared with existing data in the PostgreSQL database. A popup will display the mapped data an...

I am in need of an Excel specialist who can handle a large dataset of over 51,000 records. The data centers around employee contributions to political candidates. Specifically, I require detailed analysis on: - Contribution patterns - Candidate preferences - Employee demographics As an Excel expert, you should be proficient in working with pivot tables and be able to identify trends within large sets of data. Your experience managing, analyzing, and interpreting datasets should be well demonstrated. In addition, there is a particular interest in providing a thorough analysis of contributions based on political parties. This will help to understand better the political leanings within the dataset. To apply, please highlight your relevant experience. I look fo...

I urgently need proficient help with excel. The tasks to handle include but not limited to; - Data entry. - Data analysis using relevant tools. - Leverage advanced excel formulas and functions to streamline data processing. The data to handle resides within 1-5 sheets and contains both numeric and categorical data. Ideal skills for the job include; - Advanced proficiency in Excel. - Deep knowledge of data analysis methodologies. - Quick data entry skills. - Understanding of Excel functions and formulas. Experience in processing both numeric and categorical data on Excel is crucial.

I'm seeking a detail-oriented freelancer with strong skills in text data entry, Excel, and who is comfortable working with less than 500 pages of data. Key Requirements: - Proficiency in text data entry - Strong familiarity with Excel - Able to handle less than 500 pages of data The ideal freelancer should efficiently turn raw data into an organized Excel spreadsheet. Accuracy is vital in this job, as any mistake could lead to incorrect data analysis. Please provide evidence of your past experience in text data entry and working with Excel.

...Type, Unity, Variety, Hierarchy (see Lecture 2) 2 point deduction For each instance of not following the functions of design: identification, instruction, promotion. (see Lecture 1) 2 point deduction For each element in the “include” sections that is missing 5 point deduction Assignment not turned in as a PDF Assignment turned in late (5 points for each extra day) Export Settings File>Export>Adobe PDF (Print)>SAVE>EXPORT IMPORTANT!!!! the files below show an example of what it can look like...

As a professional involved in the field of data analytics, I'm in need of an expert to develop advanced lab exercise materials for Excel, with a particular focus on Excel Macros, Array formulae, forecasting, countif, if statements, and all LOOKUPs. All exercises should come from dataset or data files KEY REQUIREMENTS: - The labs should cover 10 advanced topics, including but not limited to Excel Macros. - For each topic, I need 5 well-thought-out lab exercises created with step-by-step answers. - The exercises must be suitably challenging for advanced-level Excel users. - Each exercise should come with a step-by-step questions and answers guide to aid understanding. IDEAL SKILLS: - Extensive knowledge of Excel, especially in Macros an...

I'm in need of an expertly designed Excel spreadsheet that will serve as a dynamic sales reporting template. This tool will play a significant role in tracking and analyzing data related to various aspects of sales. The successful candidate in this role will incorporate tracking capabilities for variables such as: - Product sales - Revenue by customer - Customer % of revenue Furthermore, the spreadsheet should provide robust reporting on seasonality, current month vs prior year, and fiscal year to date (FYTD) vs the prior year. This comparative analysis is crucial in understanding trends and informing strategic decision making. Ideal Skills and Experience: - Proficiency in Excel - Experience in creating dynamic reporting tools - Understanding of sales data...

This project entails creating a Power BI report that is linked to Excel spreadsheets for trend analysis purposes. The main user of this report will be the sales team. I'm seeking a professional with: - Expertise in Power BI and trend analysis - Proficiency in handling and linking Excel spreadsheets to Power BI - Familiarity with sales data and crafting useful reports for sales teams. Your primary objective will be to create a functional, insightful Power BI report, providing our sales team with meaningful trend analysis based on our historical data stored in Excel spreadsheets.

For Excel sheet data typing, you'd be looking for someone proficient in data entry and manipulation, preferably with experience in Excel. Here are the ideal skills and experience: Proficiency in Microsoft Excel Accurate and fast typing skills Attention to detail to ensure accurate data entry Familiarity with common data manipulation tasks in Excel such as formatting, sorting, and filtering Ability to handle large amounts of data efficiently Knowledge of basic formulas and functions in Excel for data analysis and manipulation Experience in working with different types of data formats and structures Strong organizational skills to manage and organize data effectively Ability to troubleshoot and r...

Need to upgrade my existing excel macro, very simple project

For this project, I need an individual experienced in data entry to transfer 159 sets of data from an Excel file into an invoice system. I won't specify the exact data to be transferred, but expect that it could be a mix of customer information, product details or payment details. When applying, don't feel the need to highlight past work, experience or provide detailed project proposals unless you feel it is relevant. Expected Organization of Data: - The data must be arranged by date once in the invoice system. Ideal Skills: - Proficiency in Excel and Invoice systems - Strong attention to details - Efficiency and accuracy in data entry.

Unify TXT files into Excel. (This data is good) This is a data merge project. Merge data from 3 txt files into excel. This is NOT a simply copy paste. The data needs merged. The data from 2 of the files will become columns of data in the 'master file' (see below) Download 2 files from here: Download 1 file from here: Note: This is public data it is completely permisable to use it. The files listed are: Deeds - don't use this file Owner: 1,817,424 lines. Step #1 for this file: Delete all rows that the aka pct_own is 0.000. This data will become columns of data in the master file ie: Owner 1 ln_num

For this project, I need an individual experienced in data entry to transfer 159 sets of data from an Excel file into an invoice system. I won't specify the exact data to be transferred, but expect that it could be a mix of customer information, product details or payment details. When applying, don't feel the need to highlight past work, experience or provide detailed project proposals unless you feel it is relevant. Expected Organization of Data: - The data must be arranged by date once in the invoice system. Ideal Skills: - Proficiency in Excel and Invoice systems - Strong attention to details - Efficiency and accuracy in data entry.

...need an Excel VBA utility that is able to perform calculations, specifically advanced financial modeling for cost using VBA & Macros. I require complex projections for various scenarios to be calculated through this utility. This tool should enable me to: - Efficiently perform cost calculation for a project and financial based on inputs - Efficiently calculate the cashflows automatically based on the inputs. - Generate advanced financial projections incorporating different scenarios. Ideally, the freelancer taking this project on would have a robust background in both financial analysis and Excel VBA programming. Proficiency in financial modeling (Including Project cost calculation) and a solid understanding of finance principles is necessary. Experience with develo...

We're in need of a proficient programmer proficient with Blazor C#. Our project currently has few runtime error that needs a fix. Specifics about when and where this error occurs will be provided after we've started. There are only two pages that needs your fixing. 1. location page Show Message that data has been edited, saved or delete. When user clicks on specific item data to be loaded in textbox Search is not working Export data to excel with formatting 2. Login page Issue with adding new user (password not getting captured) Add roles and claims (department) When user click on user form the table it should Edit user details including email address Only admin user to have right to Add/edit this page. Other user can only view the details. S...

...automation. Help in cross app integration. Bring in data from apps outside Zoho and integrate it inside Zoho. Help in generating api from Zoho for consumption in external apps. Required Skills: Expertise in ZOHO CRM Familiarity with ZOHO Survey, Zoho Campaigns, and 3rd Party APIs Ability to customize ZOHO CRM according to specific requirements Check our current blueprints & optimize the flow. In Deals blueprint, an approval process to be implemented.. 2) Create dashboard to understand daily calls, emails sent, leads added, tasks created, and leads moved between statuses for each salesperson, Activities done on any day etc. These dashboards should help us in understanding sales performance of any given day. 3) Import candidates data from our Oorwin softwa...

I urgently require an adept designer with proficiency in graphic design, logo creation, and branding. Mastery in Adobe Illustrator will be beneficial to the successful completion of the project. Responsibilities: * Examine and enhance the visual design of the existing PowerPoint presentation. * Improve content organizat...Responsibilities: * Examine and enhance the visual design of the existing PowerPoint presentation. * Improve content organization. * Incorporate engaging animation effects. * Execute graphic design tasks including logo design and branding. Candidates with keen attention to detail, a commitment to meeting tight deadlines, and a background in corporate or formal PowerPoint presentation design will excel in this role. Immediate ability to start on the project is a ...

I need assistance with data collection from online databases, primarily working with customer data. This role involves gathering and organizing necessary information into a structured and usable format, and will require: - Proficiency in browsing different online databases with a keen eye for detail - Expertise in organizing large sets of customer data - Verification skills to ensure data accuracy - Excellent understanding of data privacy standards Experience in similar projects will be highly appreciated. Knowledge of CRM systems will be a bonus, but is not mandatory. A successful partnership on this project could lead to long-term collaboration.

This job requires programming experience to create and design an app based on the attached PowerPoint where I have detailed each page of the app. The data needed for the app will be supplied in an Excel file. The bid is to create the app for both iPhone and Android. App programming and graphic design experience is mandatory for this project and will require more than a basic knowledge of app creation. The rough project should be completed in 1-2 months. Please review the PowerPoint as it has very detailed information and don't hesitate to ask any questions.

macro based excel project with auto copy data and paste in chrome through selinium

Kérjük, regisztráljon vagy jelentkezzen be a részletek megtekintéséhez!

I'm in dire need of a skilled graphic designer familiar with various desktop publishing software, like Adobe InDesign, Adobe Illustrator, or CorelDRAW. I'm currently grappling with an issue where the fonts in my .pdf file don't display as they should, and the layout is inconsistent. Unfortunately, I'm unsure of the exact software being used to create the files, which, I admit, adds an extra layer of complexity to the task. I also skipped the question about specific fonts used, so flexibility and proficiency in a range of common fonts may come in handy.

Hello, We are looking for a freelancer or company to repair and import a SQL Server corrupted file (about 25 Gb) corresponding to a MS Dynamics 2008 database. The file is generating the error "File size property incorrect" while trying to import (see attached file). Please let us know if you have some experience with similar recovery. Due to the size of the file we will need you to work remotely on our system directly.

Your report/dashboard should answer the following questions posed by the sales director of the client: 1. What is the total number of orders catered by the firm? There should be a date filter in the dashboard. 2. What is the revenue earned by the firm? 3. What is the total discounted value (base price - check out price) * number of orders? 4. What is the overall discount %? 5. What are the top 5 selling categories? 6. Does the operational area of the store influence number of orders? 7. Are emails & product features on the homepage an effective mode of promotion? 8. What will be the next 5 weeks forecasted weekly quantity sold for each center, city, and meal category (you may use a simple trend-based forecasting method)? You need to submit your PBIX file work as a zip.

I need a thorough data collection process to collect Ceramic & Porcelain Tiles Importers within Vietnam. This project requires: - Collection of contact information and company details. - The data needs to be organized in an Excel spreadsheet. - Include data for all importers, regardless of volume or frequency of importing. Ideal skills and experience for the job: - Strong data scraping and crawling capabilities. - Proven experience with swift and accurate data entry. - Proficiency in Excel.

I need to get Detailed drawing of a Bedroom , Kitchen and Bathroom. I have already created everything in SketchUp I just need the the detailed drawings of it as I had some issues with my Lap and not able to use the softwares. You should know how to create section planes and export it to autocad and mention the details and measurements. I have attached a sample of a detailed drawing. l will also attach the SketckUP Files of the bedroom , kitchen and bathroom. This Is an Urgent Work.

I'm in need of a Python programmer skilled in web scraping to help me extract text content from mostly text-based PDF files. Requir...programmer skilled in web scraping to help me extract text content from mostly text-based PDF files. Requirements: - Extensive experience in Python and specifically Python libraries for web scraping. - Should deliver the extracted text content in an Excel file. Ideal Skills: - Experience in PDF scraping, especially text-based. - Strong Python programming skills. - Excel file formatting. This will involve working with mostly text-based PDFs and programming a Python script to scrape the text content, and subsequently placing that data into an Excel file. Experience with similar projects will be highly advantageous. The ...

Is a task require basic Excel skills with four tasks in total need it in 5-6 hours

I require a qualified specialist to generate sales leads for my green fertiliser project targeted at farmers, agricultural businesses, and gardeners in the UK. Your tasks will include: - Enhancing visibility through SEO optimisation - Website codi...farmers, agricultural businesses, and gardeners in the UK. Your tasks will include: - Enhancing visibility through SEO optimisation - Website coding in PHP - Creating engaging and informative web content and blogs - Using LinkedIn Sales Navigator for lead generation Your understanding of the farming world will be a great asset for this project. Delivery of the sales leads should be through an Excel spreadsheet, Emails, and my CRM platform. Past experience in a similar role, particularly within the agricultural industry, will be highly...

I need a skilled WooCommerce specialist to install a product option plugin that will add dropdown menus on my site. I'll need you to import data from a CSV file of product include option to the site.

I am looking for a developer to create a multilingual WhatsApp chatbot. The chatbot must be built on Twilio, and should be capable of answering user queries promptly and effectively in both Arabic and English. Skills and experience needed for this project: - Proficiency in chatbot development, specifically on the Twilio platform - Experience in designing chatbots that excel in query resolution - Strong command of both Arabic and English in a development context Please make sure to highlight any similar projects you've completed in your proposal, with specific details on chatbot functionality and multilingual support.

I'm looking for someone to make an application for me. Either windows or Android. I play a game called animal jam and in animal jam you can make paintings but you cannot import images into the game you can only draw it with the in game painting game. I would like for the program I have in mind to be able to draw an image that the user has selected in the painting game itself. In the painting game you can select the colours you want so I would like for the program to be able to colour the painting as well but not required.

Hello, We are looking for a freelancer or an agency to provide technical support for Microsoft Dynamics 2009 (custom developments, database updates, import/export of data via automated workflows, etc.) Please share or explain some examples of your developments with Microsoft Dynamics 2009.

I need an experienced Excel and VBA specialist to assist with a project that involves data cleaning and generating reports from a CSV file. This file contains dates and times against power usage for apartments and needs to be processed in Microsoft Excel. The job tasks include: - Fixing inconsistent data entries in the CSV file - Extracting time of usage for each apartment - Creating a repeatable VBA script for future use Ideal freelancers will have strong experience in: - Microsoft Excel for managing and manipulating CSV files - VBA for creating automated tasks related to data cleaning and report generation Your help will save me time and effort in terms of managing this CSV file and creating valuable reports in the future. Successful completi...

...can handle CSV files larger than 1MB. The data contained within the CSV files are a mix of text, numbers, and dates. The designed database needs to be optimized for handling large data sets efficiently. Key Requirements: 1. Capability to import CSV files holding data larger than 1MB. 2. Database should be tuned to store and manage text, numbers, and dates. 3. In case of duplicity in the CSV files, the system should be designed to retain existing data, rather than overwriting or creating new records. Ideal Skills: - Proficiency in database design, implementation, and management - Experience handling and managing big data - Strong understanding of handling CSV files - Ability to safeguard against duplicate entries while preserving existing ...

To create the UI required to make the different report types we have discussed, and export the data to excel. Potential to edit some information in report may be required. UI will also need to be updated to include different categories for deliverables, and allow for deletion and modification of deliverables if new categories are required. UI will need to allow for more solid creation of designations (user job title) for rates for over time and off days.

...plans for students. We currently have a wealth of data but no existing software. Therefore, bidirectional data import/export functionality is a must-have feature. As for data analysis, the software must be capable of analyzing and presenting: - Student Performance Data: We need a deep dive into how our students are performing. - Attendance Data: It is crucial to get insights on student participation to improve our courses. - Student Plans: Developing insights from student plans for better decision making is a prime requirement. Although our education platform does not have existing software, developers with prior experience in API integration, SSO integration, and student data analysis would be highly preferred. You will be wo...

I'm looking for an experienced Power BI professi...Implement Interactive Dashboards: With emphasis on user engagement, the dashboards should be interactive and user-friendly. - Data Visualization: The dashboard should visually represent the data from Excel spreadsheets in a clean, easy-to-understand format. - Interactive Charts & Drill-Down features: I want a dashboard where users can interact with charts and explore detailed views of our data. Ideal Skills: - Experience in Power BI - Proficient in data visualization - Deft with interactive chart development, and drill-down feature set up Your task is to guide me on how to create this, using an existing example as a guide. Your expertise in Power BI and data visualization would ...

i have excel framework that contains multiple user inputs the convert the outputs to a graphs and charts i need to convert the excel sheet to a website.

I am in need of an Excel expert who can successfully create rows in an Excel sheet with a dropdown list that allows multiple choices. These choices should be exclusively filled with text data. Key project tasks include: - The text data should be extracted from pre-existing Excel sheets that I will provide. - Any row that utilizes these dropdown lists must be color-coded differently, with the format contingent on differing data values. Ideal skills for this job would primarily include advanced knowledge of Excel or a similar spreadsheet software. Familiarity with text data extraction and color-based conditional formatting would also be of advantage. Previous experience managing similar tasks and a keen eye for detail would ...

I am in need of an experienced Microsoft Excel expert who can create a specialized personnel cost budget template. This template should include: - Automatic calculations. - Cost categories for Salaries and Wages, along with Benefits and Bonuses. Experience in financial modeling and budgeting would be ideal to ensure accurate automatic calculations are set up. You will be creating this from scratch, so creativity and attention to detail are also required. Please provide samples of similar Excel projects you've completed in the past. Adequate knowledge of personnel finance management is a plus.

I am in need of data entry and web scraping experts who can assist me with a project. The tasks that need to be completed include both data entry into a spreadsheet and web scraping for specific information. The final data should be delivered in Excel format. I have a specific deadline for the project and it needs to be completed within a week. Ideal skills and experience for this job include: - Proficiency in data entry and web scraping techniques - Experience with spreadsheet software such as Excel - Knowledge of web scraping tools and techniques - Attention to detail and accuracy in data entry - Ability to meet tight deadlines and work efficiently If you have the necessary skills and experience, please submit your proposal.

I'm in need of an Excel programmer who is proficient with VBA. The task involves creating a VBA scroll bar that changes values within a specific cell. The cell's contents should be adjusted in increments of 0.01 through the scrollbar's activities. - Proficiency in Excel and VBA is a must. - An understanding of user interface designs with Excel is ideal. - The candidate should be capable of testing and debugging functions within Excel. Your main goal is to create a VBA scroll bar that can accurately manipulate cell contents. Your work will be deemed successful when the scrolling alters the cell value as per the increment specified. Reach out if you have the necessary skills and can get this job done.

I need an adept Figma designer to construct and export frames as json files. Below are my specific project needs: - Frames: The focus will be on creating square posts outer frames for my Home page, About page and Contact page. - Dimensions: The necessary size for these frames is 12x12 inches. - Elements: These frames should contain both text and images. Experience in json file exports and proficiency in meeting specific design details are a must for this project. Familiarity with designing frames for web pages will be an advantage.

I am looking for an Excel expert who can assist with implementing logical formulas and calculating percentage-based results for different strategies. There are three key strategies that require your attention: Strategy A, Strategy B, and Strategy C. Your tasks would include the following: - Implementing logical operations to enhance data organization. - Entering information pertinent to each strategy. - Calculating and displaying the percentage of each strategy. Ideally, you should have extensive experience in Excel calculations and logical operations. Proficiency in data analysis and reporting is also a plus. I am in need of an individual who can accurately interpret and implement my strategy-focused approach in Excel. Your output will provide a foun...

Core Functionalities 2.1 User Authentication and Manage...tracked. Task Removal: Admin can remove tasks from the system at any time. 2.3 Tracking and Rewards Visit Tracker: A tracker will be placed on external websites to track user visits and send data to the CRM system. Earnings Management: Specific earnings will be assigned to users upon task completion. Withdrawal Requests: Users can request to withdraw their earned amount once it exceeds a predetermined minimum balance. 2.4 Financial Reporting and Admin Panel Earnings Reports: Admin can view total earnings, user-wise earnings, and date-wise earnings. Export to Excel: Admin can export financial reports to Excel. Admin Dashboard: Admin can use a central dashboard to manage all aspects of the CRM ad...

...need assistance with advanced Excel functions. My project focuses on two main areas: data analysis and usage of specific formulas. Tasks include: - Data Analysis: This entails financial analysis and data visualization. You'll be dealing primarily with fiscal data and you'll need to make the data meaningful and easier to understand. - Formulas and Functions: You'll be carrying out tasks that require an expert knowledge of VLOOKUP and IF functions. An ideal freelancer would be one who's proficient in Excel, specifically with experiences in handling VLOOKUP and IF functions, and someone who has a strong grip on financial analysis and data visualization. A keen eye for detail and ability to deliver accurate resu...

I'm in need of a data scraping expert to extract specific baseball statistics from a certain website. () - **The job will include:** Creating a file that can be executable on command. Could be excel or other that pulls the data required from website ( see file for details). I should be able to pull this data repeatedly over time with the fresh data of the day. - **Ideal skills and experience:** Candidates should have experience in web scraping, especially with sports data, proficiency in a programming language suitable for data scraping (such as Python) and a good understanding of baseball statistics. The website requires a login to get in. This task requires precision and an analytical mindset to ensure the accuracy and rele...

As a client deep within the Arts & Entertainment industry, I'm on the hunt for a seasoned professional. Whether it's a full-time, part-time, or freelance job you desi... or freelance job you desire, this could be your opportunity. Ideal Candidate: - Has significant experience or background in the Arts & Entertainment field. - Can demonstrate their expertise through their previous works and accomplishments. Application Requirements: - It is crucial to list your relevant experience. This shows me your readiness to take on the tasks at hand and your ability to excel in this field. Please note that skipping the type of job you're looking for won't affect the hiring process; what matters most is your capability to deliver, whether as a full-time employee,...