Excel MT 144 p2 Formula: Avoid Data Validations 1 Rule Limit

Hi,

I've been working on a macro to replace English text in a worbook with French. Everything works fine, expect it crashes when covert some of the Data Validation messages. If I remove the problem validations in runs fine. I've used the same macro on another workbook and it works fine. I am concerned that the French text is too long for Validation error or input messages. Does anyone know if there is a character limit and what it would be?

Thanks.

Hi there

Is there some way to force MS Excel 2003 to allow 4 rules to be entered under conditional formatting????

I wouldn't have thought so, but I thought it wouldn't hurt to ask!

I am creating a file which will be used on both 2007 and 2003 versions. Failing the above, I was thinking of setting up the conditional formatting with the 4 rules I want in the 2007 version, to see what happens when it is opened in 2003. Would it just drop the last rule?

Thanks
Sunil

Dear Fellows,

I do not know excel programming and hence posting my requirement here to seek your help.

I need a VBA script for Excel which when a button is pressed will scan through the entire data in the sheet and perform various validations on the data and list the erroneous rows in a new sheet.

The validations a
(a) Check whether the length of data in column C is less than 21 or not and in column D is less than 15 or not? If not then list the row and column number along with the error message "Data length greater than 21" in the error sheet.
(b) Check whether the data in column E is one of the following ("y", "Y", "n", "N", "Yes","YES","No","NO").
(c) If the date in the column A is between 01-DEC-2009 to 31-DEC-2009.

Requesting your help in providing the VBA script. Appreciate if you can add useful comments in the code as well.

*Script should ignore the header.

I have spread sheet with one thousand rows, I need to calcuate total value of different type of funds not cleared. "Y" = funds cleared the bank eg if cells in column E are blank - look to column C to see what type funds (A,D,C) add up the correspondent value from column D. The total value of "C" = 160 in column D. I need a formula that automatic total the values?

My email address is santoshrana@tiscali.co.uk if you want a copy of this spread.

cheer

column C D E F G H I J K L M N date tpye of london bank cleared tpye of Midland bank cleared tpye of Asia bank cleared c/l cash book c/l bank funds funds funds funds funds funds bank balance 12/06/2009 A 3.52 Y A 3.52 Y A 3.52 Y 10.56 10.56 12/06/2009 D 10 y A 30 C 10 50.00 20.56 12/06/2009 C 100 D 30 y A 20 Y 150.00 70.56 12/06/2009 A 40 A 400 E 30 470.00 70.56 12/06/2009 C 60 E 50 A 100 Y 210.00 170.56 170.56 london bank Midland bank Asia bank A formula need in this section D C A C

In a Worbook if you have an item in cell A1 and have all the items in the "A"
column available as a drop-down box on another sheet can you create a rule to
say anytime the contents from cell A1 on sheet one is selected in another
sheet then the contents from cell B2 on sheet 1 will automaticlly be placed
in the cell to the right of it?

Example Example
Sheet 1 Sheet 2

Cell A1=Cat B2=Dog Cell A1 from Drop down is Monkey B2 would = lion
Cell A2=Mouse B2= Bird
Cell A3 = Monkey B2= Lion

All contents from Sheet 1 in column A would be available as a drop-down box
in the other sheets. If anywhere in other sheets A1 is chosen then whatever
is in the immediate cell to the right of it in sheet 1 would follow it in the
new sheet?

Sorry if I am not making sense. Any help is greatly appreciated!

Hi,

I can't upload my s/sheet due to work security protocols but I'm desperate to get this problem I have sorted so thought I'd try my luck at explaining the problem I'm trying to solve.

In column A I have a list of account numbers, some of which are duplicates. In column B I have a word or blanks.

For example; in cells A2:A4 I have the same account number 127689. Cells B2:B3 are blank but cell B4 I has the word Internet. In cells A5:A7 I have same account number 10064425. Cell B5 is blank, B6 has the word Mobile, B7 is blank.

I need a formula in column C that will populate all the correspondinding blank cells in column B with the word where the account number in column A is the same.

So the formula in cells C2:C4 would populate these cells with the word Internet because cells A2:A4 have the same account number. Cells C5:C7 would be populated with the word Mobile because A5:A7 has the same account numbers.

Any help greatly appreciated.

Hi,

I can't upload my s/sheet due to work security protocols but I'm desperate to get this problem I have sorted so thought I'd try my luck at explaining the problem I'm trying to solve.

In column A I have a list of account numbers, some of which are duplicates. In column B I have a word or blanks.

For example; in cells A2:A4 I have the same account number 127689. Cells B2:B3 are blank but cell B4 I has the word Internet. In cells A5:A7 I have same account number 10064425. Cell B5 is blank, B6 has the word Mobile, B7 is blank.

I need a formula in column C that will populate all the correspondinding blank cells in column B with the word where the account number in column A is the same.

So the formula in cells C2:C4 would populate these cells with the word Internet because cells A2:A4 have the same account number. Cells C5:C7 would be populated with the word Mobile because A5:A7 has the same account numbers.

Any help greatly appreciated.

I am New to the Forum and I am more an MSAccess programmer who is now delving into Excel.

On a worksheet I want 4 cells to have validation, when a selection in the first cell is made this limits the choice in the second, when the second is selected then the third is limited by 1 and 2 and the forth will be limited by 1,2, and 3.

In the attached example data , if I choose a Region, I have a choice of Countries.
When I choose a Country I am limited to valid Cities and when I have chosen a City then a list of applicable Agents will be available.

I have used NamedRanges for a two dimensional lookup but for four and my list will be far bigger than the sample, I do not fancy maintaining numerous NamedRanges.

Is there a way of doing what I want to do.

I attached a spreadsheet for this question:

I am inputting 5 variables in columns A through E:
Family (Y/N)
Adult (1/0)
Child (1/0)
Date of Birth
Gender

I am attempting to generate:
Age Males in families sorted into age brackets
Age Females in families sorted into age brackets
Age Males single sorted into age brackets
Age Females single sorted into age brackets

I did this rather simplistically generating 4 columns (F through I) and then using COUNTIF (although I know there is a better way than the lame way I used COUNTIF but that is not the point right now).

However, my question is, can I generate the data described above (located in D13:I22 on my spreadsheet) without going through the messy, cumbersome step of creating extra columns?