View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jgpac00000 jgpac00000 is offline
external usenet poster
 
Posts: 1
Default how to copy a value from another cell by using a one key entry

I have a really simple worksheet, one part of which is a list of all the
tenants with the amount of their rents in a separate column. When I receive
the checks, I enter these in another column, dated to the day of the deposit.
My question is, I would like to expedite the entries by using a one key
entry when the amount entered in the rent column and the amount of the check
are the same. Anyone have an idea?

Marlene