I have an xls sheet with street addresses in each row. Assuming that the house number is in colum A, I would like to be able to copy the rows of odd number homes to one sheet and those of even number homes to another sheet. I am using excel 2007 which supports iseven and is odd function. =IF(ISEVEN(A1), A1,"") and =IF(ISODD(A1), A1,"") will give me the odd and even house numbers but I don't know where to go from here.
Thanks
Thanks