Simple VBA macro - move cells, pull data from adjacent cell

[icg]

Hi, I have multiple columns of data - one of dates (column A), with data to the right (b-AA). How do I write the macro for "if, in a specific column, a number is greater than or less than a chosen value=>return the corresponding date (in a column to the left of the array)"

[p45cal]

You've cross-posted without poviding links
http://www.mrexcel.com/forum/excel-q...xcel-help.html
http://www.ozgrid.com/forum/showthread.php?t=195843
any where else?

see what you should do at all the sites you've cross posted this thread in, here: http://www.excelguru.ca/content.php?184
Ultmately it will be to your advantage.

You'd better upload a little sample file because:
1."a number is greater than or less than a chosen value"
You mean 'not equal to'? That's the only way something is greater than or less than another.

2. "in a column to the left of the array"
If that array includes column A, that's going to be difficult.

3. You probably need a formula, not a macro.