VBA code to calculate cell contents based on another cell value?

Hi all,

I have a worksheet containing data where row 1 is the column headings, and subsequent rows contain data about individuals with one row per person.

One of the columns contains the title "age", and I need to pick up this column and insert two columns after it, titled "age_low" and "age_high" which will simply contain a Y or N in each, depending on whether the person's age falls into the low bracket or the high bracket.

The code below is what I've got so far. I can find the "age" cell no problem and insert columns, but I'm a bit stuck at the tricker bit of saying "if value in the cell in the column titled "age" is between x and y, then the value of this cell is 'Y', else the value of this cell is 'N'".

Please Login or Register  to view this content.

Any pointers on where to go from here would be much appreciated!

You could simply use the min and max worksheet functions in your code. Try adding this code in at the beginning (note that this assumes the ages are in column C:

Please Login or Register  to view this content.

Then simply add in code as you are evaluating each row that says

Please Login or Register  to view this content.

Many thanks for the replies. I've been tied up with other stuff lately but will experiment with the suggested code when I get the chance.