I’m trying to see if there is as way to have a master list of items and then several sub-sets of properties in different sheets. I’d like the same list of items to show up across all sheets and also be deleted in all sheets if it’s removed. We have a lot of different fields to update and it’s unwieldy keeping it in the same sheet with a million columns. I also need a way to export just certain sets of data for all items into excel to share with clients and thought separate sheets would be the best way to go, but I’m open to suggestions.
Item 1 weight, height, color, etc
Item 1 Quantity, manufacturer, etc.
Item 1 Production schedule