View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Larry Moores Larry Moores is offline
external usenet poster
 
Posts: 1
Default Double Click Copy

I have a question whether a certain funcionality can be
incorporated into a spreadsheet. I have an estimate
worksheet into which I want to copy and paste a data line
from a seperate worksheet which I call the production
database. What I would like to be able to do is have both
sheets open at once, go to the database line I want to
have copied into the estimate sheet, then just doubleclick
somehwhere on that line and have it copy to the active
cell line on the estimate sheet. I can do it with a macro
button, but would really just like to be able to double
click on the line itself . Thank you.

Larry