Ok, I have a worksheet(worksheet ABC) that I copy data into from an external source (website), in order to get a Vlookup to work I'm using a Trim macro. It works fine if I manually run it, but I'd like to activate it by entering a date in a seperate worksheet (worksheet Exam date). I've tried a couple of suggestions from other posts, but so far nothing...... I don't have much experience with VB, macros, etc.......so any help would be greatly appreciated.