hey there,
looking for some help here, probibly an easy one for you guys.

basically what im trying to accomplish is:

on sheet 1 I have 6 cells of data - b10, b11, c1, c5, d2, e2

on sheet 2 I have 6 cells of data aswell - b1, b2, c1, c2, d1, e1


I have a button on sheet 1 that i am trying to program to replace the 6 cells of data in sheet 1 with the data in sheet 2 respectively when the button is pressed. (sht.1 b10 replaced with data from sht. 2 b1 etc.)

does anyone know how to program this or a reference i can use to accomplish this.

Great thanks in advance.