bademployee
Board Regular
- Joined
- Aug 19, 2010
- Messages
- 184
Hi all,
I have a VBA problem & no idea how to solve.
Sheet 1: Depending on what is selected in the drop-down I'm needing values to show in B4:B11 (Max number of ingredients is 63, but each product has no more than 7 ingredients) & also, values to show in C4:C11.
Note - B4:B11 are also validation lists so needs to be VBA.
[/URL][/IMG]
Sheet 2: Houses the data for the drop-down & composition for each product.
[/URL][/IMG]
Thanks for any help in advance.
Mark
I have a VBA problem & no idea how to solve.
Sheet 1: Depending on what is selected in the drop-down I'm needing values to show in B4:B11 (Max number of ingredients is 63, but each product has no more than 7 ingredients) & also, values to show in C4:C11.
Note - B4:B11 are also validation lists so needs to be VBA.

Sheet 2: Houses the data for the drop-down & composition for each product.

Thanks for any help in advance.
Mark