How do I get data automatically entered into a cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Formatting a cell based on other cells' data 1
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Overwriting a cell with a formula without deleting the formula 1
Automatic Data Update by Date Range 1
Can trendline equations be automatically entered into cells? 1
formula to show time that data was entered on spreadsheet 1
Excel Entering Identical Data in a Designated New Cell 4

Back
Top