using excel

[james howells]

I want to transfer data from one page to another
and make a ledger type list on page 2

HOW DO I MAKE EXCELL PASTE TO THE NEXT EMPTY LINE USING A
MACRO

EXTRA INFORMATION
I WANT TO PASTE AN STANDARD TEMPLATE E-MAIL INTO PAGE ONE
COPY OVER CERTAIN NUMERICAL ENTERIES TO PAGE TWO
( THIS I CAN DO USING A MACRO)
I THEN CLEAR THE E MAIL AND POST ANOTHER ONE IN EXACTLY
THE SAME PLACE

NOW I WISH TO PAST THE SECOND LOT OF INFORMATION TO THE
NEXT LINE DOWN ON PAGE TWO
SO AS TO MAKE A LEDGER

THE PASTE ANOTHER E MAIL CONTAINING DIFFERENT VALUES BUT
IN THE SAME TEMPLATE POSITIONS INTO

 

[Harald Staff]

Hi

See if this will help:

Sub test()
Dim L As Long
L = Sheets(2).Cells(Rows.Count, 1).End(xlUp).Row + 1
MsgBox "First empty row in Sheet 2 A is " & L
End Sub

HTH. Best wishes Harald