excel macro and "shift+end+down"

Hello, I am new to VBA but our company converted from Lotus to Excel and am making the leap. I need to write a macro where I copy a date to the right of a record in a report having several hundred records. The problem is the records are sometimes one, two, or three lines. In Lotus this was no problem, I simply went to my open column where i wanted to copy the dates, and went used a period to anchor, then right arrow key, end, then down arrow key. I can't figure this out in Excel, and it won't work even using absolute records. It just offsets the number of rows recorded on the first record. Can anyone help me?