Excel parts search screen
Budget: $30 – $250 USD
I need a skilled Excel expert to create a comprehensive spreadsheet and optimize its formulas and functions. The project needs to be completed within a month.
Key Tasks:
- **Spreadsheet Creation**: The successful freelancer will be responsible for creating a detailed spreadsheet that will serve as a part search tool.
- **Formula and Function Optimization**: I need assistance in optimizing the formulas and functions within the spreadsheet. This is to ensure the tool is efficient, accurate and user-friendly.
I would like to have a new parts search screen made up similar to the one attached ( Storeroom Parts Locator. ) but using the attached excel sheet (inventory Report)
Nice UI on front page would be great!
should be able to search for description and or part number.
results should be easily view able and printable
search results should show : Item Code (Column H -Inventory Report), Item Description (Column F -Inventory Report), and locator Name ( Column Z - inventory report) , Onhand qty (column O-inventory report)
Would also like to have a similar "import custom catalog" function where we can upload a new "inventory report" as needed and entire search document will be updated.
documents:
Example : Storeroom Parts Locator V6
New report to incorporate : Inventory Report
* if possible please unlock Storeroom Parts Locator v6 excel
Any questions please feel free to reach out to me
Ideal Freelancer:
- Proficient in Microsoft Excel with a strong background in data structuring and management.
- Experienced in creating complex spreadsheets for specific purposes.
- Skilled in optimizing formulas and functions for advanced data analysis.
- Efficient and committed to deliver high-quality work within the given timeline.
Key Tasks:
- **Spreadsheet Creation**: The successful freelancer will be responsible for creating a detailed spreadsheet that will serve as a part search tool.
- **Formula and Function Optimization**: I need assistance in optimizing the formulas and functions within the spreadsheet. This is to ensure the tool is efficient, accurate and user-friendly.
I would like to have a new parts search screen made up similar to the one attached ( Storeroom Parts Locator. ) but using the attached excel sheet (inventory Report)
Nice UI on front page would be great!
should be able to search for description and or part number.
results should be easily view able and printable
search results should show : Item Code (Column H -Inventory Report), Item Description (Column F -Inventory Report), and locator Name ( Column Z - inventory report) , Onhand qty (column O-inventory report)
Would also like to have a similar "import custom catalog" function where we can upload a new "inventory report" as needed and entire search document will be updated.
documents:
Example : Storeroom Parts Locator V6
New report to incorporate : Inventory Report
* if possible please unlock Storeroom Parts Locator v6 excel
Any questions please feel free to reach out to me
Ideal Freelancer:
- Proficient in Microsoft Excel with a strong background in data structuring and management.
- Experienced in creating complex spreadsheets for specific purposes.
- Skilled in optimizing formulas and functions for advanced data analysis.
- Efficient and committed to deliver high-quality work within the given timeline.