I have a template sheet that many people on my team will use with their own data. This data will change everyweek, but sometimes there is a duplicate in the new data from weeks before.
I have 2 worksheets Not Retained and Worked Accounts. When an account in Not Retained is worked, it automatically gets copied to Worked Accounts. If as an example, next week comes and the new data includes an account previously worked, I would like that row on Not Retained to populate with the notes from column J in Worked Accounts (this will populate in column J in Not Retained as well. This will allow the user a quick glance of accounts already worked so he/she may work those without notes.
I have searched for how to do this, and usually I try my hand at figuring stuff out, but I cant seem to find anything that does the vlookup function aside from a message box display. I need it to fill the column J on Not Retained for each row that has notes from my Worked Accounts sheet also in column J.
Any help here would be great...even point me in the direction of some other resource and I can try to give it a go myself.
Thank you in advance!