title: Copy data to user selected cell in another workbook?
body: <p>I am fairly new to VBA
  I figured out how to copy a cell value from one workbook to another assuming the location of the destination cell is known.</p>
  
  <p>What i need is for the user to select a single cell in a worksheet and when a command button attached to a macro is clicked data from a fixed location is copied to that cell.</p>
  
  <p>I would really appreciate any suggestions...</p>
  
  <p>I need to open a new workbook and copy cell / named range then come back to original workbook and paste in the location that was selected by the user. In case of range the selected cell is taken as starting cell.</p>