Anomandaris
04-01-2009, 09:31 AM
Hi there,
I'm trying to figure out a macro that will change the value in Column D(Price) based on value in Column B. I can do it without macro but it takes more time and not as effective.
If Column B is 'B' then Price remains positive, if 'S' then it should change to negative. And they should be in descending order for each code (eg GC;J09).....so for GC;J09 all prices should be in descending order, then SC;J09 and so on...
It seems simple, but i'm stuck lol.
any ideas?
thanks a bunch
I'm trying to figure out a macro that will change the value in Column D(Price) based on value in Column B. I can do it without macro but it takes more time and not as effective.
If Column B is 'B' then Price remains positive, if 'S' then it should change to negative. And they should be in descending order for each code (eg GC;J09).....so for GC;J09 all prices should be in descending order, then SC;J09 and so on...
It seems simple, but i'm stuck lol.
any ideas?
thanks a bunch