Help please if possible. I have 3 columns of data on a worksheet that
need to be updated when clicking on a selection in a list box.
The first 2 columns have common data regardless of the selection. I
have created a macro for this by following key strokes for select, copy
and paste, and it works fine.
The third column however requires data specific to the selection made
in the list box. This data is in columns on another worksheet, one
column for each possible selection option, and each column having a
reference number (1 to 20) across the top. These reference numbers
correspond to the options displayed in the list box.
How do I code the next part of the macro so that when clicking the
selection in the list box the corresponding reference number is
identified on the worksheet containing the data, the data range
selected in that column, and copied to the data range in the third
column? Regards - John


--
tvac
------------------------------------------------------------------------
tvac's Profile: http://www.excelforum.com/member.php...o&userid=29347
View this thread: http://www.excelforum.com/showthread...hreadid=490566