sorry its hard to explain what i am at
i have the correct data ie names matching addresses etc
but my main sheet is all over the and i wanted to have active members
at the top
i added an active/inactive column and sorted using this new column
but then the details/addreses etc got mixed up

this vlookup might be the way

i can do changes manually to sort it out but i'd rather leave it in the
present format if possible

thanks for your time


--
micks
------------------------------------------------------------------------
micks's Profile: http://www.excelforum.com/member.php...o&userid=26021
View this thread: http://www.excelforum.com/showthread...hreadid=393747