Hi, I have sheet called static data with some lists on. I
have a data sheet with a lot of data on it, against which
I am writing a value from the static data sheet, im doing
this by autofiltering the main data, then using a macro
im popping up a window with a list box in it with all the
items from the static data sheet, when I double click an
item from the list box its puts the value in the active
cell on the data sheet, I then have to manually copy the
value down the filtered list, is there anyway instead of
just pasting the list box value back to the active cell I
can paste it to all the cells for the current column that
are showing in the autofiltered list ?