Database.xls (I am not sure, because I do not have the database here
right now - it might be the opposite direction -- "A1": Name, "B1" to
"E1": Numbers):

"A1": Exelforum (name)
"A2": 200
"A3": 123
"A4": 34
"A5":1

"B1": name02
"B2": 100
and so on...

Therefore I want to copy these numbers until there is no data in the
column...

"A1" equals cell A1...


--
xtian
------------------------------------------------------------------------
xtian's Profile: http://www.excelforum.com/member.php...o&userid=34816
View this thread: http://www.excelforum.com/showthread...hreadid=545739