Run Macro Upon Entering Data into Cell/s

[Matt]

Using a made up example: Spreadsheet starts off with two titles
A1: Item
B1: Category

Rest of spreadsheet is empty

Scenario 1 (1 entry): Upon entering "Apple" into cell A2 a macro will
run that will populate B2 with equation
=IF(A2="Apple","Fruit","other")

Scenario 2 (multiple entries): Upon simultaneously pasting Apple into
A2, Toast into A3 and Apple into A4 a macro will run that will
populate the equation =IF(A2="Apple","Fruit","other") into and
=IF(A3="Apple","Fruit","other"), and =IF(A4="Apple","Fruit","other")
etc etc

Thanks

 

[Don Guillett]

Using a made up example: Spreadsheet starts off with two titles
A1: Item
B1: Category

Rest of spreadsheet is empty

Scenario 1 (1 entry): Upon entering "Apple" into cell A2 a macro will
run that will populate B2 with equation
=IF(A2="Apple","Fruit","other")

Scenario 2 (multiple entries): Upon simultaneously pasting Apple into
A2, Toast into A3 and Apple into A4 a macro will run that will
populate the equation =IF(A2="Apple","Fruit","other") into and
=IF(A3="Apple","Fruit","other"), and =IF(A4="Apple","Fruit","other")
etc etc

Thanks

Is this a "homework" assignment?

 

[Matt]

Is this a "homework" assignment?

No - I wish I was still doing homework. Out of interest would it
matter anyway?

 

[Don Guillett]

No - I wish I was still doing homework. Out of interest would it
matter anyway?

As a matter of principle I don't do homework since you don't learn if I do it for you. So, I will help if I can understand your logic. Send a file to dguillett1 @gmail.com with a complete explanation and EXAMPLES.