Question 1:

I have this VBA command that copy (from a database) and paste some numbers into (what I would like to be) an table. Right now I paste these numbers in row 4, column 2, 3, 4 and 5 (that is B4:E4). My problem is: I need a command that makes Excel look in the database, copy data if not blank, and then paste them into the table in row 5, 6 and so on - until there is no more data to copy from the database? In other words, I would like to replicate the command I have, but place the data in the next available row - and do this until there are no more data in the database.

Question 2:

Then, I need a command that copy the range name from the database (for example: Excelforum Inc.), which could be found in row 1, and paste it into column 1 (e.g. "A") in the table? Of course, I want this names to be pasted at the correct row, that means the row that the numbers from question 1 are pasted into.

Kind regards

xtian