Excel VBA Jobs

We need to set up a progress plan and resource plan. Easy to use. This is quite similar to MS project or Smartsheet, and many other tools. We also need to be able to easily see where the resources are, shown as both a timeline / gantt, and in calendar view. Want to integrate with outlook calender. This means that we must be able to choose between the project list and the resource list in terms of display, and here we can choose between seeing it as a timeline and a calendar. The filter function must also be functional. Where you easy can choose to only see project, search for project/text etc.. Need it done asap. See attached screenshots, that i think explain it all..

Ich möchte ein EXCEL Projekt starten, und suche einen selbständigen EXCEL - Experte mit Ideeen Wir sind in der Livestream Branche zuhause, und für eine Übersicht zu bekommen möchte ich mir eine EXCL Liste anlegen. - Kalender Agenda - Auftrag Übersicht - Projekt (Eventerfassung) - Sowie Daten von den Livestream erfassen hat hier jemand eine geile Idee? jemand eine geile Idee für eine Umsetzung

Crear una app para mantener un control de una carwash, desde ingreso del vehículo hasta la impresión del ticker. que todo sea en línea ya sea por appsheet o en un sitio web php. Integre los siguientes modulos: Dashboard Módulo de ventas Módulo de clientes Módulo de inventario Modulo de historial de ventas Módulo de configuración de paquetes, precios de servicios Módulo de citas en línea Integración de API para contactar via whatsapp, cuando el carro esté listo el sistema envíe un mensaje de whatsapp Integración de SMS con MSG91 Impresión de ticket de entrada Módulo de facturación

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!

Preciso alguém que faça uma planilha financeira comigo e um power bi

E-commerce Product Optimization Overview: Our website's navigation is hindered by an overwhelming number of products and outdated categories, making it difficult for customers to find and compare items. We are seeking a project-based contractor to streamline and reorganize our product categorization, improving usability and searchability for a better customer experience. Pain Points: Functional Misalignment: Products are not categorized by their primary function, leading to customer confusion and difficulty in exploring, finding, and comparing products. Redundant Child Categories: The current structure includes repetitive or overlapping child categories under the same parent category, cluttering navigation. Cross-Category Duplication: Products often appear in multiple child catego...

I am looking for a way to automatically export and sort timesheet data from Microsoft Teams/Shifts. The timesheet needs to be exported weekly based on our pay period (Friday - Thursday). A new Excel document should be created for each supervisor or team leader, and each staff member should have their own sheet within their teams relevant Excel document. All data in the supervisor documents should be easily readable. If automatic exporting is not possible, the minimum requirement is for someone to manually export the timesheet and copy it into a location where it can be automatically processed, with no additional input required from the staff member exporting the timesheets. The data that needs to be extracted from the timesheet export includes: Date Clock-in Clock-out Break Start B...

PS : BIDS WITH NO EXAMPLE OF THEIR WORK WILL BE REJECTED I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly. === Project Requirements 1. Single Excel File (.xlsm) • All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook. 2. Multi-User Access & Password Protection • Ideally, have basic password protection or user-level access within Excel: • For example, an initial login form that requests username/password. &b...

I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly. === Project Requirements 1. Single Excel File (.xlsm) • All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook. 2. Multi-User Access & Password Protection • Ideally, have basic password protection or user-level access within Excel: • For example, an initial login form that requests username/password. • Different roles (e.g., admin vs. read-only) would be gr...

I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly. === Project Requirements 1. Single Excel File (.xlsm) • All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook. 2. Multi-User Access & Password Protection • Ideally, have basic password protection or user-level access within Excel: • For example, an initial login form that requests username/password. • Different roles (e.g., admin vs. read-only) would be gr...

I'm looking for an expert in Excel who can help me manage various aspects of my business using this powerful tool. Key Responsibilities: - Inventory Management: Track and manage stock levels, shipments, and purchases. - Financial Calculations: Assist with budgeting, forecasting, and expense tracking. - Data Analysis: Examine sales data, transportation costs, administrative expenditures, and stock valuations to derive actionable insights. Ideal Skills and Experience: - Proficiency in Excel with a strong understanding of custom formulas. - Experience with creating automated reports and dashboard visuals. - Background in accounting and customer relationship management (CRM) is a plus. - Ability to create user-friendly dashboards for easy navigation and understanding. This project is ...

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'm looking for a skilled VBA programmer to enhance my existing code. Around 75% of the code is already written to read data from CSV/Excel. The enhancements should facilitate the generation of summary reports, creation of various types of graphs and additional data processing functionalities. Key Responsibilities: - Modify existing VBA code to create summary reports. - Develop functionality to generate Bar charts, Line graphs, and Pie charts. - Implement additional data processing capabilities including data filtering, sorting, and aggregation. Ideal Skills: - Proficiency in VBA - Experience with Excel and CSV data processing - Strong understanding of data visualization techniques - Ability to create comprehensive summary reports Please note, the final output should include furth...

I'm looking for a professional who can help me build a database by scraping sales data from a password protected website. I attached an example. I need the dashboard to self populate with the data that is held in the "Clearview" and "TimInsights" tabs. The data in both of these tabs need to be screen scraped from it's respective websites. Once the data is created, i want it to be able to create automated powerpoint presentation with respective data. Key Requirements: - Proficient in screen scraping techniques - Experience with building and managing databases - Ability to handle data from password protected sites I have the necessary login credentials for the website. The data needs to be scraped on a weekly basis. Please reach out if you have the required s...

Yêu cầu bao gồm: - 1 file excel tổng hợp hết thông tin đầu vào của học sinh (ID, tên, năm sinh, lớp học, lưu ý ...) - Từ file tổng hợp có thể phân loại học sinh ra các file nhỏ cho từng môn và từng lớp. Các file này dùng để nhập điểm nên sẽ cần công thức tính toán. Mỗi môn sẽ có nhiều bài thuộc nhiều đầu điểm khác nhau, cần tính ra trung bình của từng đầu điểm rồi nhân với hệ số để ra được điểm tổng trung bình. - Các file nhỏ cần liên kết được với file tổng hợp để nếu chỉnh sửa thông tin của học sinh từ file tổng hợp thì ở các file còn lại cũng được update. - Từ các file nhỏ cần ...

The concept of my software is as follows: I provide an input in this format: :70255400-zone-custom-sessid-OV8O1koo-sessTime-15:184fERnR From this line, the IP address () is automatically extracted and checked against the following websites: : To determine the proxy type. If the proxy type is identified as Residential or Cellular, the process continues. : To check the fraud score of the IP address. If the fraud score is below 10, the original proxy line is included in the output. The software delivers only the valid proxy lines that meet these criteria as the final output.