Hi, nathansev,
according to what I read from the OPīs request I would not see any reason for an additional sheet but just the sheet where the data is changed.
@Hood:
right-click on the worksheet tab, choose View Code and paste the procedure into the Code Window:
This code will add the change for Column B in Column D (which could be omitted if not needed/unwanted). Please remember that there may only be one event called Worksheet_Change behind the worksheet, if you already are using an event of this name we would have to match the codes into one procedure.
Ciao,
Holger
Bookmarks