Help on VB

[Closed]
Report
-
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,
I am trying to copy only those rows from sheet 1 to 2 where column 1 in sheet 1 > column 2 in sheet1. It is quite simple but I have not done any vb. PLease help
Thanks
Saum

1 reply

Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
Suppose you are comparing Column A & B in Sheet1 and then want values in Sheet2 ....

Write this formula in Sheet2 Cell A1 and drag it down only values of column! of sheet1 will appear which are > Column B ......


Sheet2!A1 =IF(Sheet1!A1>Sheet1!B1,Sheet1!A1,"")