Is it possible to find multiple data?

[stewwie]

We have a small lotterysyndicate in work which is all logged onto an
excel spreadsheet. Is it possible to search all numbers and all
occurances at once, rather than individually?

Ie - we have 15 lines of 6 numbers each - can i search for all 6
numbers drawn, across all 15 lines in one go?

Im sure this must be possible - just dont know how.

Thanks

 

[VBA Noob]

Hi,

Try the attached shpuld work


http://cjoint.com/?ifnqlRzV4c

VBA Noo

 

[stewwie]

Thats the type of thing - just tested it with our lines and works well -
only problem is, I cant save it

 

[VBA Noob]

Click on link again.

This time click save instead of open

VBA Noo

 

[stewwie]

I got it working now!!!

Thank you!

 

[stewwie]

I was doing copy and paste - but it wasnt copying the formulas
properly.... It did with paste special though

Thanks again