 # tompols 26

Contributor
Registration date
July 28, 2004
Contributions
24
Gender
Male
Birthdate
May 15, 1980
Location
grenoble, FRANCE
Signature
On entend par une belle solution, la solution simple et facile d'un problème difficile et compliqué

## Copy row if a range of column matches a value [Solved]

Could you please help me with the following macro. The following macro basically copies the entire row if the column B contains the value "1". But in my case, I would like to copy the entire row if a range of column (for ex: B via Z) contains the value "1". It would even be better, if the user could input a number/string and then if th... Read more

## new in CCM [Solved]

Hello, I'm a new member in CCM . @+

## formula or else ??? [Solved]

Hello, I have a range of cells B5:AC5 containing each a letter from a name, ex: DAVID THOMAS SMITH So B5=D, C5=A, D5=V, E5=I, F5=D..and so on up to the end of the name. In cell B22 I need it to check the range B5:AC5 if it has one "A" or more and if it does, write "A" in cell B22, if no "A" then leave B22 blank. In cell B23 I need it ... Read more

## Need to sum Coumn F only when B & C identical [Solved]

Hello, I am trying to set up a formula that will allow me to get the average of values in F, but only for the rows where both Coumn B & C are identical. I have Column A set to be a conditional "start of like data" and use an "x" in the first row of identical samples. So, I know I can do an =if(a5="x", ...,"") to leave the value blank... Read more

## return data from one spreadsheet to another

Hello, I have a workbook with 3 spreadsheets. Spreadsheet 1 is for data entry. The spreadsheet has 3 columns, Description, Income, Expenses. On spread sheet 2, I need to bring in ONLY the income and description from Spreadsheet 1. In spreadsheet 1, income and expenses can be on any row. So row 1 and 2 may have income, row 3-... Read more

## VB script for error text box

Hello, Can some one please help before my head explodes. I need a script to look at a range and if the cell contains a "0" then flash up a warning box. I can get it to work for one cell with the syntax below but cannot get it to work for a range of cells. I am a complete novice. Thanks Read more

## countif with and function

Hello, I am trying to count cells in a column if they are greater than 60 and less than 29. How can this be done with a countif and function? Thanks! Julie

## excell calculations

Hello, I am a programmer and not use to restrictions when calculating formulas. I would like to know if there is a way to calculate a number and place the result back in the same cell. EX (A1+B1=A1) the formula would be in A1.