Posts by KjBox

    Try the attached. Click the button on Sheet1


    This is an alternative method which will be faster especially with a large data set.


    Code assigned to the button:

    Try this

    Maybe

    In that case change the code to this, note the Monthly Rent will not update because of the "METRO", change that to "Metro" and update is done.


    Try the attached.


    Code assigned to the button

    Like this?

    This will now do nothing if Column B is empty for the target row.

    Try this, paste the code to the Worksheet Object Module for the sheet concerned