Hello again,
I have an excel file with 3 sheets, in each sheet under Column A I have a 5 to 7 digit number. I would like to set up a macro to copy data from sheet 3, A1 then search all of column A in both sheet 1 and sheet 2. If the number is found I would like some way of marking it, I assume highlighting it would be easiest. I would like this to continue for Sheet 3, A2 with a loop of some sort. That's the basics of it
I've tried recording a macro but getting the paste value to land in the "Selection.Find(What:=" is proving to be beyond my skill set and I am sure there is an easier way to go about this.
Thanks in advance to you all, this forum has saved me countless hours in the past.
Bookmarks