Locked - reason Title >>> help required

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.

Originally Posted by mudraker

SRussell

Please read forum rules - see links below

Your thread title is invalid

yeah thanks for that mudraker. sorry for breaking the rules.
If I knew which type of fourmula function I needed I would put that in the title, but as I don't I can fully explain in the short title space what my problem is.

By the way, tried to change the title name, but to no avail.

Hi
try this it may help, It's a bit raw but works. there are probably easier ways but it's a start.

I hope it's what you ment if not please alaborate further


change the values in "table for" in Bookings and check booking number sheets.


regards



fletch

Originally Posted by fletch396

Hi
try this it may help, It's a bit raw but works. there are probably easier ways but it's a start.

I hope it's what you ment if not please alaborate further


change the values in "table for" in Bookings and check booking number sheets.


regards



fletch

Hi Fletch,

thanks for your sample, this is almost what I'm looking for.
I have attached a sample copy of the booking sheets we use (all inofrmation has been added on the 1st Day tab)

Basically what I need to do is the opposite of your example.. The bookings would be entered onto the relevant day page for either day or evening and then I want to extract all the booking that are 10 or more to compile a summary sheet.

So what I would need to do is check every cell for numbers >=10 and then take that number and the information on the cell directly to the right.

As you will see from the example we block off the tables that we would use for the party, but those cells are not important for this exercise, only the first number (table size) and the cell to the right (booking information)

It would also be usefull if we could take the time from the cells at the top, although this is not important as all I need the summary sheet for is to auto check if anyone has entered a large party (i.e 10 or over) into the sheets which means I will then need to follow up the booking. At the moment I need to go through each day manually to see if any changes.

Hi, sorry been busy...I will look at it and see what I can do and get back to you asap


regards



Dave

Hi,
try this.....you may need to jiggle it a bit and protect the sheets afterwards...I have put a summary sheet at the begining...Give it a try...



Regards



Dave