Hello all. This is my first post so please be gentle. I have posted in the new section as I should imagine these are basic queries.

In essence I have with helped created a food costing sheet, I work in the catering industry. My aim is to make it as simple as possible to use (for other people). but the nature of my business dictates that we cannot give everyone a copy of Access but in general every one has Excel on their computer.

The sheet is based on Vlookup with a seperate page containing the products, with cost/weight next to each item.

On another sheet the user has a pop up box for each line of the ingredients lists which taps via data validation that product page. Once they have chosen something the vLookup pops the weight and cost in the ingredients line.

The trouble for me is I am now up to and beyond 300 items in the products page. The pop up list in data validation has got unweildy and has a number of REF! errors, and blank lines that do not relate to anything. My concern is data valiadation lists were not necesserily designed for 300+ entries?

So is there another way to do this?

One other issue is in VBA, I have a button on that ingredients page that when clicked renames the worksheet tab to the content of a specific cell (i.e. the dish name) however if the user enters the name of a tab already with that name it bumps out to debug. I am hoping there is a better way, i.e. if they give it a duplicate name a warning will pop up. If someone could just point me in the right direction that would be great.

Many thanks