Copy from one sheet to another using combo boxes

Hello, i have a Range "A1:B6" on Sheet 2, 3, 4 and 5.

I would like to have two combo boxes and a button on Sheet 1 that would allow me to copy from one Sheet to another

So i would need two combo box :

-One for the Sheet from witch the range is copied,

-Another for the Sheet witch the range is pasted,

Both combo boxs with Sheet 2, 3 , 4 & 5 as options.

And finally a button, once both location are selected, to make the transfer

I'd prefer 3 comboboxes.

?

snb said:

I'd prefer 3 comboboxes.

Click to expand...

What