pulldown menu

[K-Ching]

Please Login or Register  to view this content.

one again i need help
pulldown menu is in sheet1 a5
and i want to bring sheet 2 A2:C6 into sheet1 A6:C19

it works perfectly if it's in the same sheet but i need to know how to bring it over from one sheet to anothe
thank you in advance.

[protonLeah]

Range("a6:c19").Value = Sheets("Sheet2").Range("a2:c6").Value