MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
cross post at mrexcel.com/board/threads/chan…umn-b-of-sheet-2.1213743/
I have sheet 2 like below. I need a code please that when I type or paste a number into a cell on Sheet 1 column AE, it needs to change to what is next to it on sheet 2 column B.
So if I type or paste 'Test' into say AE2 on sheet 1 it will change to 'Test1' automatically. Or if I type or paste 'Hello' in AE5 it automatically changes to 'Goodbye'. Data on sheet 2 may be thousands of rows.