I work with the State, and we have to report mileage using an Excel 2003
template - provided, of course, by 'The State' . The format is starting
destination - end point - purpose - mileage (end of row). Next row is last
end point - new destination - purpose - mileage (end) etc.
Here's what I am searching for. Is there an easy keyboard (or other)
shortcut to fill in 'last destination' on the new row? The closest I can
find is control + ' but this just fills in the what is in the cell above. I
need a trick to fill in the information from the cell in the above row to the
right. Is there a shortcut or formula I can write to perform this so I can
be lazy and don't have to cut and paste?
Thanks for your help!