Forum Discussion
dynamic arrays
ShimonGeiman Not sure I get your point, but have attached a slightly revised file where the lists for the dropdowns are now transposed and on to the same row as the item description for each of the categories chosen. Added an extra product to demonstrate what I was thinking of. For the next product, just copy the table and the formulae in N to where ever you want to have your next product.
If this is not what you had in mind, please show an example of how your sheet with 60-70 products really looks like.
ShimonGeiman Not sure I get your point, but have attached a slightly revised file where the lists for the dropdowns are now transposed and on to the same row as the item description for each of the categories chosen. Added an extra product to demonstrate what I was thinking of. For the next product, just copy the table and the formulae in N to where ever you want to have your next product.
If this is not what you had in mind, please show an example of how your sheet with 60-70 products really looks like.
Thank you so much - it works!!!!!
Its a saver
Shimon
ShimonGeiman Glad it worked out!