title: macro to use active cell and copy multiple cells to another sheet in different cells
body: <p>I am trying to copy info from one sheet into another using a macro. I'd like to be able to select a cell in Sheet A (eg A10), and using that as a reference copy cells in the same row, eg c10, d10 and g10, and paste that info into static cells in Sheet B, eg $A$6, $A$7, and $A$8.
  Have looked through the message boards but haven't found anything that uses the active cell, and multiple cells.
  Thanks in advance!
  Adrian</p>