Run Macro Upon Entering Data into Cell/s

  • Thread starter Thread starter Matt
  • Start date Start date
M

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
 
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
Click to expand...

Is this a "homework" assignment?
 
No - I wish I was still doing homework. Out of interest would it
matter anyway?
Click to expand...

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