View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sho sho is offline
external usenet poster
 
Posts: 2
Default 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?