Visual Basic Jobs

I need a master Excel spreadsheet designed and populated with data from financial documents I will provide. This will include a master page produced from all the data on the separate tabs. - Data Types: The project primarily involves working with financial data, specifically tracking revenue and expenses. - Update Frequency: The data will need to be updated monthly. Ideal skills for this job include advanced Excel proficiency, experience with financial data, and the ability to create clear and comprehensive master spreadsheets. Please provide examples of similar projects you've completed in the past. Each sheet will total and feed into the master page. I would like reports ideally that can be run on total expenses or revenue in a time period as well as ratios to be provided as da...

I need an MS Access database to manage and track transfers between my bank accounts. Currently, this data is being tracked in Excel, and I'm looking for a more efficient and organized way to handle this. Key Features: - The database should capture essential data fields for each transaction. These fields include: - Account number - Amount - Date - description - some sums formulas The ideal freelancer for this project should have extensive experience with MS Access, and a proven track record of creating databases for financial transactions. They should also have excellent skills in data organization and management. Importing Data: - Currently, I am entering the data from Excel into the database manually and copy paste from bank website. The freelancer should be able to prov...

I need assistance with my Excel Master Workbook. The project involves transferring generic data from the Master sheet into specific tables in another sheet within the same workbook. Details: - The data is dynamic and will change daily based on updates in the main sheet. - The method for matching the data to the specific tables in the other sheet varies. Ideal Skills: - Proficiency in Excel - Experience with data manipulation and transfer - Ability to work with dynamic data - Attention to detail

I need assistance in fixing and enhancing my Excel reports that are generated daily, weekly, monthly, and yearly. 1. Please fix the Stock Performance tab with Top 20 & Bottom 20. Its never worked when 2 or more companies have the same % gain/loss. 2. Commodities & Chart_All_Commodities, I changed the commodity on a few of them including Antimony, Germanium, Gallium, Platinum & Niobium. This seems to work on the Commodities tab, but I have to manually update the Chart_All_Commodites Tab, please fix this. 3. Please add 5 new Blank Commodities & Project Location Areas so it allows me to add specific ones in that field and it automically updates to the Chart_All_Commodities & Chart_All_Project Location Area too 4. Can you add a filter by Market Cap for the whole shee...

I'm looking for an Excel expert to create a comprehensive Mess Management Excel sheet. Requirements: - Tracking of student Mess fees - Fee calculation and tracking functionalities Ideal Skills and Experience: - Proficiency in Excel - Experience in creating expense tracking systems - Ability to incorporate complex fee calculations Please include examples of similar projects you've completed in your bid.

I'm looking for a proficient Excel expert with strong macro programming skills to create a comprehensive Excel sheet for processing data from my securities trading reports and FX market data. This is for the purpose of tax filing. I just update the FX page and the trade data and it produces the pnl sheet for me. I’ve attached the sheet with the required output. I need a macro to automate this sheet for me. Key Requirements: - The Excel sheet must be able to process various elements from my trading reports, including trade dates and times, transaction amounts, and securities identification. - The sheet will also need to incorporate data from FX market feeds. Ideal Skills: - Advanced Excel skills - Strong experience with macros - Familiarity with securities trading...

I'm seeking an experienced Excel specialist to create a software-based Gantt chart for me. This chart should incorporate task dependencies, progress tracking, and resource allocation capabilities. Key Requirements: - Proficiency in Excel with a strong understanding of its advanced features. - Experience in creating interactive, software-based Gantt charts within Excel. - Ability to incorporate task dependencies, progress tracking, and resource allocation into the Gantt chart. Ideal Skills: - Advanced Excel skills - Project management software experience - Strong attention to detail - Excellent communication skills

I need help with capturing data from a website. The data is displayed in a table format below a chart for a particular facility. I want to capture monthly data for all time periods for all facilities on the website. Key Details: - The data is easily selectable and copyable. - I want the final data saved to an Excel spreadsheet. - If possible, I would like the use of a VBA macro for ease of use. Ideal skills for this project include: - Proficiency in Excel, particularly with creating and using macros. - Experience with data extraction from websites. - Attention to detail to ensure all data is accurately captured. Budget is $50

I'm seeking a freelancer to design an Excel reporting template to track our membership enrollments. The template will primarily handle registration data, specifically focusing on membership sign-ups. Key Features: - Automated Calculations: The template should perform relevant computations automatically. - Visual Charts and Graphs: The template must convert data into easy-to-understand visual representations. - Data Filtering and Sorting: The template needs to facilitate easy sorting and filtering of data. Ideal Skills: - Proficiency in Excel, particularly in creating complex templates. - Experience with data visualization - Strong understanding of membership enrollment processes. With this project, I hope to simplify our reporting process and enhance our data interpretation capabil...

Dashboard Creation We are seeking a highly skilled and experienced Excel Expert to create professional and visually appealing KPI Dashboards in Excel. The ideal candidate should have extensive knowledge of advanced Excel functionalities and a strong ability to translate data into actionable insights. Proficiency in Google Sheets is a plus. Key Responsibilities: Design and develop customized KPI Dashboards in Microsoft Excel based on business requirements. Collaborate with stakeholders to identify key performance indicators and define dashboard objectives. Use advanced Excel formulas, functions, and tools (e.g., VLOOKUP, INDEX-MATCH, SUMIFS, Pivot Tables, etc.) to process, analyze, and visualize data effectively. Create dynamic and interactive dashboards with features like slicers, dropdow...

I need a skilled developer to create an Access form based ticket tracker. Key Requirements: - The primary purpose of this ticket tracker is to monitor customer support tickets. - The tracker should be accessible to everyone in the company, not just the support team. - While specific fields in the ticket form have not been predetermined, the developer should propose incorporating essential fields like customer information, issue description, and priority level. Ideal Skills: - Proficiency in Microsoft Access and form development. - Experience in creating ticket tracking systems. - Ability to design user-friendly interfaces for company-wide accessibility.

I am an eBay seller seeking assistance to enhance my Boost Space automation with Google Sheets. The primary goal is to streamline my shipping purchasing and automate my accounting updates while ensuring my data is properly formatted. Key Responsibilities: - Integrate Boost Space with Integromat and Google Sheets - Connect various shipping platforms, primarily eBay and possibly Pirate Ship - Update my spreadsheets with order numbers and formatting dates to a U.S. style date format Ideal Skills: - Proficient in Boost Space and eBay shipping processes - Extensive experience with Integromat and Google Sheets - Strong understanding of eBay and Pirate Ship integration - Excellent attention to detail for data formatting and accuracy Your expertise will help me significantly reduce manual work...

I am in need of an experienced VB6 developer who can update my source code and add new features to my application. Key Requirements: - Update existing VB6 application source code - Implement user authentication - Integrate data export functionality - Enhance existing reporting tools The primary goal of this project is to add new features to the application. Please note that I am not looking to fix any bugs or improve performance at this time. Your main focus will be on the successful implementation of the new features. Ideal Skills and Experience: - Extensive experience with VB6 - Proven track record of updating source code - Prior experience implementing user authentication - Capability to integrate data export functionality - Experience enhancing reporting tools in a VB6 application...

I need a program or spreadsheet that will make my data submissions during home inspections more efficient. Key Features: - Drop-down boxes: For standardized responses. - Fill-in text boxes: For additional comments. - Photo attachment functionality: To attach site pictures to relevant report sections. Data Storage: - The tool should support both Google Drive and local device storage for easy access and backup. - Ideally, it should be a user-friendly interface that's easy to navigate during inspections. Ideal Skills: - Proficient in creating interactive software or spreadsheets. - Understanding of intuitive interface design. - Ability to implement photo attachment capability within the tool. The platform for this tool can be flexible, but it should prioritize ease of use. Most data...

Hello. It's supposed to generate teams based on data from multiple sheets, but it doesn't work like I need. When I run the script it gives me an error and I can't solve it, can you help me?

I'm in need of a Microsoft Access developer to create an Attendance and Salary Management System for security guards. The core functions of the system include: - Attendance tracking - Dashboard - Employees profiling - Manual Attendance - Basic Pay, Overtime Amount, Deductions - Auto employee IDs - Salary calculation - Reporting (Daily Salary Voucher, Montly Salary Report) Ideal skills and experience for the job include: - Proficiency in Microsoft Access - Experience in developing attendance and salary management systems - Good understanding of tracking and reporting systems - Ability to create user-friendly interfaces for manual data entry.

I'm looking for an Excel spreadsheet that can help me track my daily sales, inventory, exports, imports, and expenses. Key Requirements: - Daily input fields for sales, inventory, export, import, and expenses - Monthly summary calculations for total sales, expenses, inventory balance, profit and loss, and exports/imports across multiple outlets - Detailed tracking capabilities for each product and product categories The ideal freelancer for this project would be well-versed in Excel, particularly in creating spreadsheets with complex formulas and functions. You should also have experience in designing user-friendly interfaces within Excel to make data entry straightforward and intuitive. Since the number of outlets is uncertain, the spreadsheet should be flexible and easy to expand...

I'm seeking a VBA macro expert who can help optimize my code for faster execution. The macro is currently used for generating reports from data stored in Excel sheets. The main goal is to reduce the runtime of the macro to improve efficiency. Ideal Skills and Experience: - Proficiency in VBA programming - Experience with Excel-based data manipulation - Skills in code optimization and performance improvement - Ability to enhance code readability for future use Freelancers who can deliver a fast, efficient solution will be prioritized.

I'm seeking assistance with specific small tasks in Excel that may require the use of VBA coding and formulas. Key Requirements: - Creating macros to streamline processes - Using the macros for data validation and cleanup Ideal Skills: - Proficient in Excel with extensive knowledge of VBA - Experience in creating macros - Capable of performing data validation and cleanup tasks

I'm seeking a developer who can build an ASP.NET Framework project to seamlessly connect with Power BI. Key Requirements: 1) Integrate Power BI with ASP.NET Framework application. 2) Implement a login system where each user (one person, one computer) can access the application using a unique username and password. 3) Ensure that each user is only able to view their own information on Power BI, which includes Pid, Job_Name, Email, and Location. I will provide the SQL Server query necessary for the project, and you have the option to create a stored procedure if you wish. Ideal Skills: - Proficient in ASP.NET Framework - Strong experience with Power BI integration - SQL Server expertise - Familiarity with creating user authentication systems Please note, the authentication method ...

I need assistance with my Excel VBA and Python integration. I can open a Colab Notebook from VBA, but I'm having trouble getting the code to execute automatically upon opening the Notebook. VBA-code: Sub StartColabScript() Dim colabLink As String colabLink = "" colabLink End Sub I cant get this code to run my Python-script. I also tried: # Add code to Colab Notebook !python /path/to/ !python (I dont know if the Notebook is called the right way. The name of my workbook is: Ny241028Hent33Tickers3Blokke5y I guess its .py How do I refer to this workbook from VBA, and how do I get to autoexecute, when called? Key Requirements: - I will provide the Python code, I also have working VBA-code. - The script should run immediately upon opening the Colab Notebook. - ...

I'm seeking a proficient Excel specialist to consolidate multiple spreadsheets into a comprehensive master template. The current spreadsheets contain real estate tracking data and your task will involve: - Merging data on property values, insurance replacement costs, and financial statement information. - Implementing key formulas to facilitate future analysis. This includes: - Sum totals for each category - Average values across properties - Percentage changes over time The ideal freelancer for this project should have advanced Excel skills, particularly with formula implementation and spreadsheet consolidation. Experience with real estate data would be a significant advantage. Please ensure that the master template retains all necessary formulas for ongoing use.

I need an Excel sheet for tracking vacation plans in my department. The sheet should be divided into three categories: resident, specialist, and consultant, each having its own separate sheet. The tracking should be done on a weekly basis for 2025 Key Features: - Under each category, there should be a count of the total remaining persons available. - I need to track for each person: their name and the dates of their vacation. - The sheets should use specific colors for each category: Red for residents, Green for specialists, and Blue for consultants. Ideal Skills: - Advanced Excel skills and experience in creating complex spreadsheets. - Knowledge of color coding and formatting in Excel. - Excellent attention to detail to ensure accurate tracking.

I've developed a construction management workbook in Excel that requires some enhancements. The enhancements include improved data analysis tools, a user-friendly interface design, advanced reporting features, and syncing with QuickBooks. I also want to integrate a construction schedule into the workbook. Specifically, the types of data analysis tools I want to improve are custom formulas, pivot tables, and data visualization techniques such as charts and graphs. Ideal Skills and Experience: - Expertise in Excel, specifically in creating and modifying workbooks - Experience with construction management tools or software - Proficiency in designing user-friendly interfaces - Knowledge of QuickBooks for potential syncing - Ability to create advanced reporting features - Skills in dat...

I've developed a construction management workbook in Excel that requires some enhancements. The enhancements include improved data analysis tools, a user-friendly interface design, advanced reporting features, and syncing with QuickBooks. I also want to integrate a construction schedule into the workbook. Specifically, the types of data analysis tools I want to improve are custom formulas, pivot tables, and data visualization techniques such as charts and graphs. Ideal Skills and Experience: - Expertise in Excel, specifically in creating and modifying workbooks - Experience with construction management tools or software - Proficiency in designing user-friendly interfaces - Knowledge of QuickBooks for potential syncing - Ability to create advanced reporting features - Skills in dat...

I'm seeking assistance with comprehensive data analysis in Excel, as well as generating reports and creating formulas. The job also involves sending multiple email attachments via Gmail. Ideal skills and experience for the job: - Expert level proficiency in Excel, particularly in data analysis, formula creation, and report generation. - Experience in managing and sending multiple email attachments through Gmail. - Strong attention to detail and ability to work efficiently.

I'm looking for a Google Sheet that helps me track my bills and expenses bi-weekly. The sheet should have the following features: - Auto-calculation of totals: The sheet should automatically calculate the total expenses, making it easier for me to keep track of my finances. - Expense categorization: I want my expenses to be categorized (e.g., groceries, bills, entertainment, etc.). This will help me identify where my money is going. - Automatic import from bank statements: I want the sheet to be able to automatically import data from my bank statements. This will save me the hassle of manual input. - Advanced interactive dashboards: I need the data visualizations to be presented in advanced interactive dashboards. This will help me understand my spending patterns at a glance. Ideal ...

I've got a 2002 MS Access application that needs to be upgraded to the current MS Access version. The app is primarily used for data entry and management, and the upgraded version will need to support multiple users with different permissions. Key Requirements: - Upgrade from 2002 MS Access to the latest version - Retain all original functionalities without enhancements - Support for multiple users with different permissions Ideal Skills: - Extensive experience with MS Access - Strong understanding of data management applications - Ability to replicate complex permission structures in new software - Knowledge of MS Access security features for user permissions

I'm looking for a professional to create an Excel workbook that tracks inventory, allocated inventory and available to sell. I would like one page to be a dashboard with highlights and the other tab to be the details. Key Metrics: - Current stock levels for multiple products - Low Stock reorder alert - Inventory valuation - Allocated and available to sell Ideal Skills: - Advanced Excel skills - Experience in creating dashboards - Understanding of project tracking and inventory management This dashboard will assist me in managing my project's resources efficiently. Please only apply if you have the required skills and experience.

I'm in need of a professional who specializes in Excel VBA and Outlook email automation. I have made some experimental progress but I am currently stuck and would appreciate assistance in troubleshooting my existing code and learning basic coding concepts. The specific tasks required include: - Automating email generation from specified Excel worksheet cells on a schedule based on corresponding dates in other cells. - Incorporating specific types of content into the body of these emails, including text and hyperlinks. - Assisting me in understanding and learning basic coding concepts. Ideally, you would have extensive experience with Excel VBA and Outlook, and be able to explain concepts in a clear and understandable manner. Your role will not only be to help me progress with this p...

I'm experiencing an issue with a combobox in my MS Access database. It's directly bound to TableA and supposed to select entries from Column A. When an entry is found, it should concatenate Column A and Column B and insert the result into Column C in TableB. However, my VBA code keeps throwing an 'Entry Not Found' error, even though I have confirmed all entries are in TableA and all formats are correct. Key Tasks: - Troubleshoot the combobox issue - Optimize the AfterUpdate VBA code I need a freelancer with strong skills in MS Access and VBA, who can help fix this issue and ensure the combobox can correctly select entries from TableA. Please note, I am not using any filter criteria on the combobox data.

Excel VBA Macro Debugging - Compiler Error Fix I'm encountering a compiler error while running a macro in Excel VBA. The macro is primarily designed for data manipulation and includes various functions. I need assistance to diagnose and fix this issue so the code can run without errors. Ideal Candidate: • Extensive experience with Excel VBA and macros. • Strong troubleshooting skills to resolve compiler errors. • Proficiency in data manipulation using macros. • Ability to maintain existing code functionality while fixing errors. Important Instructions (Read Carefully): 1. To Be Considered: You must resolve the error and provide the complete, functional code. I will test the code, and payment will only be made if it works as expected. 2. No Automated Responses:...

I've developed a construction management workbook in Excel that requires some enhancements. The enhancements include improved data analysis tools, a user-friendly interface design, advanced reporting features, and syncing with QuickBooks. I also want to integrate a construction schedule into the workbook. Specifically, the types of data analysis tools I want to improve are custom formulas, pivot tables, and data visualization techniques such as charts and graphs. Ideal Skills and Experience: - Expertise in Excel, specifically in creating and modifying workbooks - Experience with construction management tools or software - Proficiency in designing user-friendly interfaces - Knowledge of QuickBooks for potential syncing - Ability to create advanced reporting features - Skills in dat...

I'm seeking a professional who can help me streamline our HR processes using Microsoft Forms and Excel. The main aim is to utilize Microsoft Forms for case raising, where employees can report various issues. Key Responsibilities: - Set up Microsoft Forms for case raising - Utilize Excel to track each client, employees, auto send email notification with a unique ID - Implement direct data import from Microsoft Forms to Excel and a dashboard -Excel dashboard for clients and employees Ideal Skills: - send email via outlook to each client absence data weekly -Excel invoice system - Save files auto from email to drive or excel - Proficiency in Microsoft Forms and Excel - Experience with HR processes - Ability to create and manage a unique ID system in Excel - Skills in setting up aut...

I'm looking for an Excel wizard to craft a reconciliation tool for two payment datasets - our Genie Ledger and Payment Gateway Data. Key Tasks: - Identify critical data fields for reconciliation, focusing on Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details. - Develop a user-friendly tool that compares both datasets and displays all calculations on a dedicated front cover sheet. - Spot any discrepancies and highlight them in red on the front cover sheet. Ideal Candidate Should Have: - Extensive experience with Microsoft Excel, particularly with macros and VLOOKUP. - Strong analytical skills and attention to detail. - Ability to present data clearly and in a list format. I need a straightforward solution with clear explanations of how discrepancies ...

I'm seeking assistance to develop a comprehensive KPI spreadsheet for my sales team, compatible with Microsoft Excel. The KPIs to be incorporated include: - Sales volume - Conversion rate - Inputs needed for each team member to achieve their quota The spreadsheet will need to facilitate weekly updates of the KPI data. Ideal skills for this project include advanced Excel proficiency, experience in sales analytics, and understanding of KPI design. I have attached some pictures of some examples I am looking for. I would like a blend of the examples and make it custom to my team.

EXCEL Manufacturing Product scheduler/run time tracker We are developing a means to schedule components in an integrated excel spreadsheet that includes various production steps: (Functions) Laser, shear, punch, bend, paint, assembly, weld, assembly 2, shipping. To be save on a network-share point so all can access same document. The idea is to have a laptop at each station (listed above) 1a,1st step: Manual enter/copy paste-from engineering Initial step-Enter data (component part number(description)) into the first sequence, list all items from the project that needs to be produced. once entered, you can filter material gauges, material types in order to consolidate production run on the LASER. When running the selected items (check box) we track time to produce on laser (start / sto...

I need help organizing confidential client data in an Excel spreadsheet. The data is currently in one column and needs to be split into appropriate columns for First Name, Last Name, Phone number, Email, Birthdate, Mortgage start date, mortgage term, and Client Birthday. - Required Skills: Intermediate level Excel proficiency, with experience in using formulas to manipulate data in Excel. - Platform: The session will take place on Microsoft Teams, where I will share my screen. - Data Format: The data is currently organized in an Excel Spreadsheet. Due to the confidential nature of this data, I am unable to share it via email. The ideal freelancer for this job would be able to work swiftly and accurately, ensuring that the data is correctly organized.

I'm seeking a skilled Excel expert to create a reconciliation tool for comparing two payment datasets. The first dataset comes from our internal ledger (Genie Ledger), and the second from our payment provider (Payment Gateway Data). Key Tasks: - Identify important data fields for reconciliation, considering factors like Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details. - Develop a tool that compares the two datasets, showing all workings on a dedicated front cover sheet. - Identify any reconciliation discrepancies and highlight them on the front cover sheet. The ideal candidate should have: - Extensive experience in using Microsoft Excel, particularly with macros - Strong analytical skills - Attention to detail and ability to present data clearly in...

I need an expert in Excel automation and API integration to help me in calculating GHG emissions, specifically Carbon dioxide (CO2). The primary data source for the calculations will be an API, so experience with API integration is crucial. The project involves: - Automating the process in Excel for GHG emissions calculation - Using API for manual data entry - Focusing on Carbon dioxide (CO2) emissions The final output of the project should be in the form of a dashboard visualization. Therefore, experience in creating dashboard visualizations is essential.

I'm seeking an Excel specialist to help me create a sophisticated dashboard and tracking tool for compliance data. Key Responsibilities: - Automating processes with macros to streamline compliance tracking - Assisting in the design and development of a user-friendly dashboard - Automated email system which track the due dates and triggers the email to the respective email addresses. Ideal Skills: - Proficiency in Excel with a strong focus on automation - Experienced in complex formula creation and data analysis - Prior experience in designing dashboards and tracking tools - Familiarity with compliance tracking is a plus Please provide examples of previous Excel projects you've completed, particularly those involving dashboard creation and automation.

I'm looking for an expert in data management and Excel/CSV manipulation. The project involves merging multiple CSV files with custom combination rules. Key Responsibilities: - Analyze and understand the structure of the provided CSV files. - Implement custom rules to merge specific data from those files. Ideal Skills: - Proficiency in handling and merging CSV files. - Excellent understanding of Excel and its data manipulation capabilities. - Ability to understand and apply custom rules for data combination. - Strong attention to detail. Experience with data science or data analysis is a plus.

I'm seeking an Excel specialist to design a financial dashboard for monitoring investments. The dashboard will primarily display financial data and needs to be tailored to track investment metrics. Ideal Skills: - Advanced Excel skills - Data visualization - Financial analysis - Dashboard creation Your proposals should reflect your experience with similar projects.

I need an Excel sheet designed to facilitate data entry, enhanced with picture drop-downs and regular option drop-downs. Key Features: - More than 10 drop-downs in total, strategically placed to aid data entry - Picture drop-downs, with images inserted directly into the Excel sheet - Regular option drop-downs for standard data input Ideal Skills and Experience: - Proficiency in Excel - Experience in designing user-friendly spreadsheets - Ability to creatively incorporate images into an Excel sheet

I'm looking for a professional who can create an inventory tracking spreadsheet for tracking assets. Features of the spreadsheet should include: - Automatic Calculations: The spreadsheet should automatically calculate totals, averages, and other necessary figures to minimize manual input and error. - Real-time Updates: I need a system that allows for real-time updates to keep track of asset changes immediately. The spreadsheet will be accessed by a larger group of over 10 people, so it should be user-friendly and easy to navigate. Ideally, the freelancer should have a strong background in data analysis, Excel, and inventory management systems. Experience in creating similar spreadsheets for large teams will be a plus.

I need an Excel macro that can automate the creation of product labels. The macro should be able to generate labels that include: - SKU number - SKU Description - UOM (Unit of Measure) - Up or Down Arrow The ideal freelancer for this project should have extensive experience in Excel and VBA (Visual Basic for Applications) for creating macros. Please provide examples of similar projects you have completed. The macro should recognize various size labels based on avery sheet label sizes. The Description, font size and number of characters should adjust based on size of label. I have existing file but would like to review as I speak to a developer to ensure needs are understood before sharing.

I'm looking for an Excel expert to set up a comprehensive database for tracking customer information, specifically contact details and addresses. Key Requirements: - Design an Excel database to track customer information effectively. - Incorporate automated data entry forms to streamline data input. - Develop customizable reporting templates for tailored data analysis and reporting. Ideal Skills & Experience: - Proficiency in Microsoft Excel, with extensive experience in database setup. - Prior experience in designing automated data entry forms and customizable reporting templates. - Knowledge in data analysis and reporting.

I need an experienced Excel professional to refine my financial report. The tasks will primarily involve: - Creating visually appealing and informative graphs and charts - Specifically, I need a pie chart to represent a portion of the data An ideal freelancer for this project should have: - Extensive experience with Excel, particularly in working with financial reports - A keen eye for detail, ensuring all visual representations are accurate and well presented - Skills in creating engaging and informative visuals that can enhance the readability and understanding of the report Please include examples of similar projects you've completed in your bid. Thank you!

Hi. It’s supposed to generate teams based on data from several sheets, but it’s not working as I need. Additionally, I would like to have a button to update the data for each game week. I’m attaching the code so you can review it and help me out if possible. Thanks in advance!

I have a comprehensive Excel file containing purchase and sale details that needs thorough analysis and a dashboard built in a corporate visual style. Key Requirements: - Dashboard: It should display stock quantity, total amount, and total quantity, broken down by brand, type, and color. - Stock Analysis: I need to see overall stock quantities by brand, type, and color, as well as date-wise tracking to see if a specific product is sold from a purchase date using FIFO method. - Purchase Details: Total quantity and amount of purchases should be calculated, alongside a slicer to view specific combinations of brand, type, and color. A macro to add new entries is also required. - Sale Insights: Total quantity and amount of sales, with a slicer for specific combinations, a macro for new entrie...