O
Oligo
let's say i have this set of input data.
Cell A1 (drop down menu consisting apple,orange,durian,pear etc)
cell A2 (drop down menu consisting apple,orange,durian,pear etc)
cell B1 (will lookup for A1 and display relevant fruit price)
cell B1 (will lookup for A2 and display relevant fruit price)
cell C1 (drop down menu of different quantity for A1, 1,2,3,4.....)
cell C2 (drop down menu of different quantity for A2, 1,2,3,4.....)
my output will be total cost base on the above input (ie. B1*C1+B2*C2)
my question is how can i tabulate the output data for different combinations
of A1 & A2( ie. apple and apple, apple and orange etc) ? The output data will
also change inaccrodance with the quantity C1&2 change. the above are just
lookalike case to my actual excel whereby more input drop down selection is
invovle to calculate the output.
is there any macro code that record or tabulate the output for the current
selection and keep the results while it continue to record the subsequent
A1&A2 combination?
Cell A1 (drop down menu consisting apple,orange,durian,pear etc)
cell A2 (drop down menu consisting apple,orange,durian,pear etc)
cell B1 (will lookup for A1 and display relevant fruit price)
cell B1 (will lookup for A2 and display relevant fruit price)
cell C1 (drop down menu of different quantity for A1, 1,2,3,4.....)
cell C2 (drop down menu of different quantity for A2, 1,2,3,4.....)
my output will be total cost base on the above input (ie. B1*C1+B2*C2)
my question is how can i tabulate the output data for different combinations
of A1 & A2( ie. apple and apple, apple and orange etc) ? The output data will
also change inaccrodance with the quantity C1&2 change. the above are just
lookalike case to my actual excel whereby more input drop down selection is
invovle to calculate the output.
is there any macro code that record or tabulate the output for the current
selection and keep the results while it continue to record the subsequent
A1&A2 combination?