Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get data automatically entered into a cell?
How do I get data automatically entered into a cell when I enter data into an
adjoining cell? I'm doing a payroll project, and I basically want to enter a name in one cell and have that person's hourly wage data automatically entered in the next cell without having to type in the dollar amount every time. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get data automatically entered into a cell?
Hi:
Two possible methods: Use vlookup in the cell with an if as in if(a1="","",vlookup(a1,data,2,false)) or use the on change event for the worksheet check changes in the cell and then put the rate in the adjoining cell. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "rldjda" wrote: How do I get data automatically entered into a cell when I enter data into an adjoining cell? I'm doing a payroll project, and I basically want to enter a name in one cell and have that person's hourly wage data automatically entered in the next cell without having to type in the dollar amount every time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Update of Dropdown List Box data | Excel Worksheet Functions | |||
return a portion of data entered into a cell | Excel Discussion (Misc queries) | |||
In Excel-shade the cell automatically when data is entered | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |