validation dependent

I have a worksheet, "Test Data Request" which has numerous data validations. I have had to enable this worksheet to allow "paste as link" to work as some business areas will be pasting in data from a source system extract rather than manually populating each field. As this will overwrite the...

First time post so bear with me please :eeek: I have an excel worksheet 'Initial Form' that has many validation dropdowns from other worksheet using the Indirect method and Named Ranges: =INDIRECT(VLOOKUP($B$58,ItemCause2Lookup,2,0)&"List") It works fine but for some reason, only sometimes...

I want cell A1 to only allow values below 100 IF cell A2 = True. If cell A2 = False, I want cell A1 to allow any value. I've seen things about dependent validation (involving the INDIRECT function), but this seems to apply specifically if you want to choose from a list. Thank you.

In most cases I can work my way around formula (VBA I have to ask) but I have a requirement that is causing me a problem. If a user selects "Individual CPC – Please complete on Summary" from cell D46 of sheet 1, then cell T31 of sheet 2 should accept a number only however if D46 on sheet one...

Hi, I need to validate the data in one column based on the data in the column to the left of it. Basically, I have a product code in column b and a product description in column c and I need to make sure that each code has the correct description. On a separate sheet I have a list of codes (col...

Hi guys, My first post! Wh00! Okay, I'm a little stuck around these VB Macro's. I've done some C# about a year ago (a bit rusty now) but I understand the concepts so hopefully any technical jargon and methods should be understood fine. I've been asked to put together a Quick (and dirty) little...

Help Required please: I have a tracker spread sheet whereby users are required to enter comments (text) when a specific RAG condition is met e.g. If condition RAG <> "G" then user must enter a comment and the comment cannot be " " or blank. Note: I have be able to apply a apply a...

I have a situation where I need to create a validation formula that limits length of entry to 30 characters or less, is all upper case and the end of the entry be the letters "ET" if the value of another cell is equal to "Y". I have already worked out the formula for the combination of length...