This is an excel spreadsheet, with pivot tables and macros, for up to 5 hikers.
All the gear info, including quantity, for all hikers is entered on the master list.
Then pivot tables automatically create a separate list for each hiker.
Download at :
This is my first try at this, I hope it works.