button -replacing data in cells from sheet 1 with data from sheet 2

**miko.sims** · 01-09-2014, 03:32 PM

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.

**gsnidow** · 01-09-2014, 04:03 PM

Try putting this behind your button. Nothing fancy here

Please Login or Register  to view this content.

Or, you could create a link by copying sheet2!B10, say, then in sheet1!B1 paste special>paste link

Greg

**miko.sims** · 01-10-2014, 11:23 AM

ahh, looks great!

Thank you very much

**miko.sims** · 01-11-2014, 03:13 PM

Private Sub CommandButton1_Click()

Sheets("sheet1").Range("H10").Value = Sheets("Sheet2").Range("F8").Value

End Sub

etc..

with your help this code is what worked perfectly, excel 13

thank you