drop list

Hi all, apologies if this has already been answered elsewhere, there are a lot of threads to search. In sheet 2, I have 3 columns with 250 stock items. The 1st column has the stock code, the 2nd a description and the 3rd has the pack size. In sheet 1, I need to select a stock code from a drop...

Hi, I have a data base that I setup to be able to create multiple other sheets and pull the same information from sheet to sheet. The issue I am having is that the formula for the data validation drop list keeps updating back to the current sheet that the drop list is in instead of keeping the...

Hi, Can anyone help? I am trying to replicate a rather large worksheet in a new workbook. I need it to be identical in every way. I have copied the formulae by replacing "=" with "zz" then doing the reverse once pasted into the new book. This way the cells don't refernce the old workbook...

I actually have a couple questions here now. First, I have a user data base on one sheet with contact information that is all on one row and I am trying to copy select data from the data base onto an order form. I have a drop list box to select a name on the order form and I want the contact...

Hey I'm really hoping someone can help me out with this one. Basically what I'm trying to do is create a drop list depending on the option selected on another drop list. I think the main issue I'm having is that the option list is on another Sheet and excel keeps telling me I can't do a...