I work in a restaurant that uses excell sheets to record booking information.

What I need to do is to set up a formula that looks for any booking size >=10, then copy that information to a seperate sheet.

Below is an example of an entry..

E............F..........G

10...........Booking name, tel number etc

..............12.........Booking name, tel number etc

In the case above there are two booking both >=10
The booking information is in the cell to the right.
I need to copy both the booking size (first cell) and the booking information.

Any ideas as to how I could do this as although I am fairly good at formulas within excell, this is way beyond me.

Thanks in advance for any help given.