Excel VBA Jobs

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 ...

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 seeking assistance with using Smartsheet for data collection, specifically from a project intake form. Your tasks will include: - Setting up the Smartsheet to effectively collect data. - Ensuring the Smartsheet is able to capture all necessary project details, objectives, and stakeholder information from the intake form. Ideal skills and experience: - Proficiency in Smartsheet - Experience with project management and data collection - Excellent attention to detail

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...

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.

I need a skilled professional who can create an automation system for me to download and process my sales data. Requirements: - The sales data is currently accessed through a link that requires a login to download. - The automation should handle the login process with my username and password. - After downloading, the system should also process the data and create a csv file. - The output must be available to download from a link. Ideal Skills: - Proficiency in creating automation scripts or software. - Experience with handling and processing sales data is a plus. - Strong understanding of data privacy and security to handle login credentials responsibly. Please ensure your proposal includes relevant experience and a brief outline of how you plan to approach this project. Attached t...

I need a data entry specialist who can extract text data from PDF documents for me. The type of data will mainly consist of paragraphs and sentences. Skills and experience ideal for this job: - Proficiency in data entry - Excellent attention to detail - Experience in handling and processing PDF documents - Ability to accurately extract and transcribe text

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 ...