In book1 of Sheet1
I have from Combobox1 validation(ActiveX)
And the list has names,like Kath, James, Aaron etc.
whenever I select any names I want the macro to go and select book2, copy the range("A1:B10") for kath and come back to book1 and paste
in range E1.If James is selected copy...