Simple Macro to Copy From One Cell to Another

[slovacek]

This is probably really simple. I used the macro recorder copy the contents from E28 to B29. I want it to copy from column E to column B one row lower. The result of my macor only copies from E28 to B29 (again and again). How do I get it to do something like (go up one row and right three columns, copy the contents, move back down one row and left three, and paste).

 

[pboltonchina]

Why use a macro? Put this in cell B29 and copy down

=E28

 

[slovacek]

I've used that method before but the contents in Exx aren't always what I want to populate in Bxx+1. I'm working with a mileage log. B has Starting Mileage for a trip (like "Go to the bank") and E has the Arrival Mileage. So, in most cases, if the driver recorded things correctly, the Starting Mileage for the next trip (like "Return home from the bank") should be the same number as the number from the Arrival Mileage from the previous trip. However, there are times when the mileage doesn't get recorded or the paper the recording was written on gets misplaced. If I use the previous number, it can be misleading. So I want to have the macro so that, if, the mileage from E28 is what I'm looking for, I can just ctrl+macro letter and copy from E28 to B29.

 

[pboltonchina]

The macro would still only copy the same value as the formula I gave you