| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to copy a value from another cell by using a one key entry
Perhaps use a macro to copy that cell with with the amount and insert
the date. jgpac00000 wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| restricting entry into a cell based on entry to a previous cell | New Users to Excel | |||
| Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
| copy value of cell from last entry in column | Excel Worksheet Functions | |||
| Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
| Auto-copy the last entry in a column to a new cell | Excel Worksheet Functions | |||
Linear Mode
