Seeking a function in Excel

  Dayglow 00:42 25 Oct 03
Locked

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!!

Dayglow

  gudda96 09:07 25 Oct 03

Dayglo

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 "Allexperts.com or something similar.

Good luck

  Forum Editor 09:10 25 Oct 03

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 03

Dayglo

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

click here

  VoG II 09:51 25 Oct 03

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:

FromSht.Range("A1:K1").Copy

Addy = "A" & xRow

ToSht.Activate

Range(Addy).Select

ToSht.Paste

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 03

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

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

What is Amazon Go and will it come to the UK? The store without checkouts or queues

1995-2015: How technology has changed the world in 20 years

Why ecommerce hasn't taken off on social media

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…