If specific cells contain specific values then reference cells from another sheet macro.

Hi,

New here and posting for the first time.

I please need some help creating a macro that runs automatically when two different cells contain specifc values.

I have cells A1 and A2 on (Sheet1) that each contain lists. For example, A1 list will contain Red, Green, Blue and A2 list will contain Fish, Eel, Frog. Any combination of these two cells, after selecting from the lists, will pertain to ranges of data on another sheet (Sheet2).

After selecting from the two lists in A1 and A2 I would like a macro to automatically copy the Data on (Sheet2) that pertains to the combination of A1 and A2 on (Sheet1), and paste it into a range on (Sheet 1).

I specifically need some help figuring out how to have a macro run automatically only after both of the cells A1 and A2 have had list items selected.

Can someone please help me out with this? It would be much appreciated.

If you need me to give more clarrification please let me know.

Thanks.

Hi Richard,

Thanks for the quick response.

Attached please find a workbook example that I hope will clear up the confusion.

After selecting the options from the lists in B1 and B2 on Sheet1 I want a function or macro to automatically populate the (A5:A9) range and (B5:B9) range on Sheet1 with the data found in the charts on Sheet2 that corresponds to the selections made from the lists on Sheet1.

Yes they were deliberately made different. Works great and thanks so much for the help. I might be back with more questions.