Dear Mr. Dibben,
Thank you for responding. I've tried working with what you suggested but
have not been successful. I am not very experienced with this stuff. I've
enclosed below what my Macro is now and unfortunately it does exactly what I
was complaining about originally; not skipping a line. As I said I tried your
suggestion but I just keep getting various error messages and I really don't
know what I am doing. If you would be kind enough, and have the time to do
so, maybe you could add your suggestion to my recorded macro below so it will
work as I was hoping it would. Thank you.
Sincerely, Paul Pollack

LineSkip Macro
' Macro recorded 12/20/2004 by Paul Pollack
'

'
Range("F12:J12").Select
Selection.Copy
Range("F52:J52").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Range("L51:R52").Select
Application.CutCopyMode = False
Selection.FillDown
Range("K12").Select
Selection.Copy
Range("K52").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False

End Sub

"Gord Dibben" wrote:

Paul

Sub Copyit()
Range("A5:H5").Copy Destination:= _
ActiveSheet.Cells(Rows.Count, 1).End(xlUp) _
.Offset(1, 0)
End Sub


Gord Dibben Excel MVP

On Mon, 20 Dec 2004 10:01:02 -0800, "PaulPoll"
wrote:

I want to make a macro that will automatically skip a line. Each day I fill
in a cell with a number which changes seven or so various formula cells
residing on one line. I then copy and paste those values to their place below
the last day's entry. Each day it's the same procedure but the values change.
I cannot get a macro to find the place it should "paste" the value to
properly. It always copies over and replaces the cells from the previous day
because it is not moving down a line. Eg. Every day I make an entry to A1
which in turn changes the values in A5 thru H5. I then copy cells A5 thru H5
and paste those "values" to A6 thru H6. The next day, after entering data in
A1 that changes the values in A5 thru H5, I again want to record those new
values but I now want them pasted in the line below the previous day's entry;
I now want them pasted in A7 thru H7, each day moving to the next line below.
Can anyone tell me what I need to add to a macro to make it automatically
move to the next line? Thank you.