Hi!

I'm looking at your file. What are you trying to do?

It looks like you want to extract data from column A and B if column V is
not blank. Is that correct?

Biff

"sonar" wrote in
message ...

Hi

I have still tried to make heads or tail out of this, and still cant
get it right.

I have attatched a file, what is it that I need to modify here? I have
tried changing the ranges, but it seems as if it is 9 rows out. any
idea anyone?

Regards
Sonar


+-------------------------------------------------------------------+
|Filename: test.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3755 |
+-------------------------------------------------------------------+

--
sonar
------------------------------------------------------------------------
sonar's Profile:
http://www.excelforum.com/member.php...fo&userid=8424
View this thread: http://www.excelforum.com/showthread...hreadid=399751