Textile Inventory Tracking Excel Sheet
Budget: ₹100 – ₹400 INR
I need an easy-to-use Excel workbook that lets our team log and monitor the raw textiles we purchase. The only figure we want to capture right now is the type of fabric, and every entry should be organized by material—cotton, wool, silk, linen, etc.—so we can instantly filter or sort by those categories.
Here’s what I expect the finished file to do:
• Provide a clean data-entry tab with a dropdown list of materials.
• Store the records in a structured table so future metrics (quantity, price, reorder points) can be added without rebuilding formulas.
• Offer a summary view—this can be a simple pivot table or dashboard—that breaks down current items by material for quick reference.
• Be formatted clearly, with named ranges and no hidden dependencies, so any staff member can maintain it.
Please build the solution entirely in native Excel—no add-ins or external macros—so it remains compatible across multiple PCs running Office 365. Once delivered, I’ll test the categorization, add a few sample rows, and confirm that filters and summaries update automatically.
Here’s what I expect the finished file to do:
• Provide a clean data-entry tab with a dropdown list of materials.
• Store the records in a structured table so future metrics (quantity, price, reorder points) can be added without rebuilding formulas.
• Offer a summary view—this can be a simple pivot table or dashboard—that breaks down current items by material for quick reference.
• Be formatted clearly, with named ranges and no hidden dependencies, so any staff member can maintain it.
Please build the solution entirely in native Excel—no add-ins or external macros—so it remains compatible across multiple PCs running Office 365. Once delivered, I’ll test the categorization, add a few sample rows, and confirm that filters and summaries update automatically.