Adding a function to select from a validation list within a macro.

[Detroitslim]

Hi all,

I have a macro that copies values from one sheet (1) and pastes them into another sheet(2). However in sheet 2 there are 3 validation lists that I need the macro to select from based on other values in sheet 1. Recording the macro to copy and paste values and then loop it down the range was easy, but I'm not sure how to get the macro to take the values from sheet 1 then select from the lists. I assume its some sort of select/choose/if then function that can be added to the macro because the items on the validation lists are either yes/no or one which has four options. Any help on how to do this without too much programming would be very helpful.

Thanks everyone