I have this macro (as per below) that I use to 'locate' a "Ref Number" within another sheet. I would like the macro to be able to search multiple sheets;
If it finds the result in 1st sheet it stops (as it does now).
If it doesn't find in 1st sheet, it goes to 2nd sheet and continues, if it doesn't find in 2nd sheet it goes to 3rd sheet and continues.
Sub FindCanBo() ' ' Select FindCanbo Macro ' Dim x As String x = ActiveCell.Value 'set the value of the activecell, unique ref number cell selected to x With Sheets("CanBo") 'with the worksheet CanBo .Select 'select the worksheet .Range("A1:AB5000").Find(what:=x, after:=.Range("A1")).Activate 'find the cell whose value is equal to x and activate it End With End Sub
I don't know how to do the code myself, any assistance much appreciated.