If anyone has advice on best practice for setting up the following I’d really appreciate some tips…
I’m creating a list of materials that has many columns detailing each materials qualities and uses. Each material will have multiple suppliers and I’m trying to find the best way of not overloading the user with information until they need it.
I could add multiple columns in a single sheet for each supplier but wondered if there is a neater way of organising this? Is having a separate sheet that lists material name and then the various suppliers each in a separate column a better way? And link through to this?
Many thanks for any suggestions you can give.