Copy values using VBA or Macros from one work sheet to another

[srivarun22]

Hi everybody,

I am new to Macros and VBA in excel and just know few basics.

Please anyone kindly help me with this query.

I have workbook in which there are 3 sheets named as Summary(sheet1), Detail(sheet2), Data(sheet3)

No my query is how to copy values from Data i.e Sheet 3 (B12, D12, E12, F12, L12, M12, N12, K12) and paste them respectively in Detail i.e Sheet 2 in cells BK3:BK10 as sheet 3 value B12 goes to sheet 2 cell BK3 and so on.

and I will update sheet 3 data monthly. So next time if I click the VBA or Marco button the same Data (sheet 3) cell values are to be copied to BL3:BL10

If I am unclear. I would be happy to clear it back. Kindly help.

Note: I am using Excel 2010.

Thank You