i have 2 columns - W and F
i need some type of macro that if a cell in W is greater than ""
cell in F, then F's value will automatically appear in W.

example:

w2 is 40
f2 is 30

therefore w2 should become 40

the W column is already filled and i'm filling in F cell by cell fro
outside info.

also, the cells are compared to their "rows" only meaning w2 = f2 an
so on, not w2 = f5, etc...

the macro doesn't have to loop as i type in column f... meaning i'll b
very happy w/ a macro that i can just run once when i feel like it an
it'll just take care of the 2 columns for me. but either will do...

thanks

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com