Seeking a function in Excel

  Dayglow 00:42 25 Oct 2003

I am creating a table which is filled by data extracted from another table. After extraction, the data is totalled before transfer takes place. The data to be transferred is then on one row and extends across several columns.

I would like to know if there is a function within Excel XP which will scan down the rows of the receiving table, find the first empty row and copy the transferring data into it. This process would need to continue with the transfer of successive sets of data into the next available empty rows in the receiving table.

A workable solution would make me very happy!!


  gudda96 09:07 25 Oct 2003


I am not sure where it is, but there is a hep site for PC's and there are people who specialise on different areas like Excel/Word etc.

It might be " or something similar.

Good luck

  Forum Editor 09:10 25 Oct 2003

you'll attract the attention of VoG, who will no doubt provide you with the answer. I'm no Excel expert, so I won't even try.

  gudda96 09:13 25 Oct 2003


Found it!!you will definately get an answer at this site

click here

  VoG II 09:51 25 Oct 2003

This can be done but you need to use some Visual Basic for Applications (VBA) code to do it.

The first empty row in the receiving sheet can be obtained like:

xRow = Cells(Cells.Rows.Count, 1).End(xlUp).Row + 1

Your copy and paste would look something like:


Addy = "A" & xRow




But these are just fragments of the code required.

I need to know the names of the "from" and "to" sheets and the row number and column range on the "from" sheet. Then I can write a complete subroutine.

  Cesar 10:32 27 Oct 2003

This might Help click here scroll down and click on section one.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Moto G6 Play Review: First Look

iPad 9.7in (2018) review

Comment utiliser Live Photos ?