Hi,
I'm new and dunno if this is the right place to post this, or if what I want is possible... but here goes.

Basically I wanna simulate a lottery. 1-49, selecting 6 numbers. I'd like it if the numbers selected would be in numerical order (i.e. if the 6 numbers went from A1:F1, A1 would be the smallest, F1 would be the largest) and some way to search for an entire combination. Some way to get a new load of numbers (like a button) would be good too. A bonus number would be an extra cool feature but isn't 100% necessary.

Thanks if anyone can help with this.