Excel Macros Jobs

I need an Excel dashboard for project management, specifically to track metrics related to production orders. This dashboard should be macro-based and capable of providing insightful visualizations and summaries. Key Requirements: - The dashboard should monitor production order metrics, including duplicates and their aging. - You should have a deep understanding of Excel and its macro capabilities. - Experience in designing and implementing management dashboards is crucial. - Ability to translate complex data into user-friendly visualizations is essential.

I'm looking for an experienced Excel VBA developer to create a custom Customer Relationship Management (CRM) add-in for Excel. The add in should provide licence validation similar to XL padlock - https://www.xlspadlock.com. Also when validating the license each time the product is used, it should save the current copy to a cloud based location that can accessed by the user from our website. Each validation should also provide any feature updates from the latest template in a cloud location. Key Features of the CRM Add-in: - Comprehensive Customer Data Management: The add-in should allow for efficient management of customer information, including but not limited to contact details, purchase history, and customer interactions. - Robust Sales Tracking: The add-in should include feature...

I'm looking for a programmer who can create a Windows-based standalone application that generates and appends dummy credit card numbers to a CSV file. Requirements: - The credit card numbers should be in the format of 16 digits with space after every 4th digit (1111 1111 1111 1111) - The program should be compatible with Excel - The application should be able to create and append these numbers to a CSV file - The program cannot allow long numeric fields to convert to scientific notation (ie: 3.21825E+7) - column name would by CCNO and appended as the last column (column names could vary) Ideal skills and experience for the job include: - Proficiency in programming for Windows - Experience creating standalone applications - Familiarity with CSV file manipulation - Understanding of Ex...

I'm in need of a proficient freelancer to develop a sophisticated Excel-based accounting system for my business. This system should not only track sales, purchases, payments, and receipts but also offer full automation and complex tracking capabilities. Key Requirements: - Advanced Level Complexity: The system should be capable of complex tracking and be fully automated. - Basic Integration: I need the system to connect with simple accounting software. - Custom Templates: The system must include templates for invoices and financial statements. Ideal Skills: - Expert in Excel with advanced formula and macro skills. - Previous experience in designing comprehensive accounting systems. - Ability to create custom templates and forms within Excel.

I'm looking for an Excel expert who can help me streamline my Excel tasks using Macros. The focus will be on automating: - Data entry and validation - Generating reports The data will be coming from and processed within Excel itself. Ideal skills for this project include: - Deep understanding of Excel and its macro capabilities - Previous experience with Excel automation - Strong attention to detail for data validation tasks - Ability to create efficient, effective solutions to automate report generation Please provide examples of previous Excel macro projects you have worked on.

Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.

I am looking for an expert to help me automate my lead tracking and follow-ups. Currently, I am primarily working with contact information stored in Excel. Key Requirements: - Experience with lead data management - Proficiency in Excel - Skills in automation tools and scripts The ideal freelancer for this project should be able to streamline my lead management process, making it more efficient and less time-consuming. Prior experience with CRM software is a plus, though not a necessity. Your understanding of tracking systems and automation will be crucial for the success of this project.

I'm looking for a professional with expertise in construction BOQ (Bill of Quantities) to help me match rates. The project primarily focuses on estimating costs, and the ideal candidate should be skilled in analysing and aligning these with a benchmark of below 5% of the estimated cost. Critical Requirements: - Expertise in construction BOQ - Proficient in cost estimation - Able to analyze and align rates Skills and Experience: - Previous experience in construction rate matching - Strong analytical skills - Familiarity with market rate databases