Inventory Management XL VBA
Budget: ₹600 – ₹2,500 INR
As a business owner, I'm in need of someone skilled in xl design (VBA, Macros, Developer options, formulas must known, data visualization and possibly proficient in using business software like full knowledge with MS 365 and VBA codes. I want to create tracking sheets which cover diverse aspects of my Store operations. Each of these sheets serve distinct purposes:
- Invoice entry sheet
- Material Issues Entry Sheet
Finished Sheet Should Include :
- A Summary of all sheets, A Dashboard with graphic Transaction Log, GANTT Chart.
Beyond the design, I want the sheets to generate detailed summary reports such as: invoice summaries by supplier name Qty + Qty Value, consumption summaries by plant Wise or Machines wise Diesel purchase and consumption summaries by Machinery wise , an overall financial summary, and a customizable summary report.
I'm looking for a freelancer with strong attention to detail, a background in data management, business operations and a proficiency in visual data representation.
- Invoice entry sheet
- Material Issues Entry Sheet
Finished Sheet Should Include :
- A Summary of all sheets, A Dashboard with graphic Transaction Log, GANTT Chart.
Beyond the design, I want the sheets to generate detailed summary reports such as: invoice summaries by supplier name Qty + Qty Value, consumption summaries by plant Wise or Machines wise Diesel purchase and consumption summaries by Machinery wise , an overall financial summary, and a customizable summary report.
I'm looking for a freelancer with strong attention to detail, a background in data management, business operations and a proficiency in visual data representation.