Hi, I'm trying to create a macro that will search various files for a reference number and once found to highlight/copy and paste it somewhere else.
I know how to get one file open searched and closed but not sure how to write a macro that will then more onto subsequent file. All files are in...