Copy data into next avaiable cell

C

Chisel

I have a workbook and on the 1st sheet I am inputting data. I then wan
to run a macro that takes the relevant data from this sheet and place
the 10 or so items onto a 2nd sheet from rows A7 to I17 (for example).

I then want to re-input new information on the 1st sheet and the
automatically copy it to the second sheet but in the next availabl
row. This could be A8, or if the 1st copy has more than one rows inf
it could be A10 or A13 and so on. This process may need to b
continued a number of times.

Does anyone know of a way that I can instruct Excel to find the nex
available cell and then copy to this?

Also the fact that sometimes I could be copying more than 1 rows wort
of data, is there a solution to this?

Thanks for your help
 
K

Katie

Chisel,

A possible solution is:

When you activate or select the 2nd sheet, and you have copied the data to
the clipboard already insert the following line of code:

Range("A7").End(xlDown).Offset(1,0).Select

This will select the cell in column A immediately below the last entry on
this sheet, provided that you haven't left any rows blank between A7 and the
end of your data on the 2nd sheet. You can then paste your data into the
ActiveCell or Selection.

Hope this helps
Katie
 
Top