Think about it.

--
Don Guillett
SalesAid Software

"Theo Degr" wrote in message
...
Don,

Thank you for the code. Your code copies the values in Column "A" but what
would the code be to get the values from "a11:x11?"

Thanks again
Ted

"Don Guillett" wrote:

You should always post YOUR coding efforts for comments. Sounds like
homework but

Try this idea from anywhere in the workbook withOUT selections of any
kind.
Change to suit. Sheet5 is your sourcesheet. change to yours., etc.
Make VERY sure that your source range and copyto range are the SAME size.
a2:a6=lr+5

Sub copyvaluestodest()
With Sheets("yyy") 'destination sheet
lr = .Cells(Rows.Count, "f").End(xlUp).row + 1
..Range(.Cells(lr, "f"), .Cells(lr + 5, "f")).Value = _
Sheets("sheet5").Range("a2:a6").Value
End With
End Sub


--
Don Guillett
SalesAid Software

"Theo Degr" <Theo wrote in message
...
I have created some Macros using the already posted suggestions but I am
having trouble finding one that fits my current need. I am hoping that
someone out here can help me.

I am trying to copy a Range of Data "a11:x26" from one Work Sheet "Time
Sheet" to another Work Sheet "Time Record." I need the Macro to per
form a
couple of tasks. First it would need to perform the copy. The copy
would
need
to be the values only of the cells. Then the next time that I would
need
to
copy the data it would need to find the next empty row on the Work
Sheet
"Time record." Could someone please help me.

Thank you,
Ted