Command Button Code to copy data
I have a spreadsheet where I would like to click a button
and it extracts certain information into a different sheet.
e.g. on Sheet 1 I would like to click a command button
that copies information from cells A1, C1, D1 & E1 and
places this in Sheet 2 cells E5, E7, E8 and E9
Can anyone help with the code to achieve this?
|