Search

Pete,

Everything is fine now.

Would i be right in thinking that if i add my new brewery into te Ref Data that i will then see it appear in the Data sheet and then i can add the beer fro that brewery into place?


I am raelly gonna push my luck now and ask if it's possible on the from Search sheet to add in 2 things,Total Brewery's and Total Beers and get them to add up automatically every time i input the data.


Thanks



Mike

The answer to your first question is no, so you have to add the brewery name to the Ref_data sheet for a new brewery, and both the brewery name and the name of the beer to the Data sheet for either a new brewery or beer.

Do you mean Total for those displayed (i.e. all the breweries which begin with A if that is what is selected in B8), or overall totals?

Pete

P.S. I'm going in the garden now, so I'll get back to you later on, after you have clarified the point about totals.

Hi Mike,

as I got rained off I carried on and have given you both the overall totals and the displayed totals for breweries and beers in the attached file. I've also made a few background corrections, so this is the file to use.

Pete