Excel 2003 Mileage Template Shortcut Query

[Sam D]

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!

 

[Mary Sauer]

news://msnews.microsoft.com/microsoft.public.excel

 

[Sam D]

I'm sorry, I don't understand your reply. Pasting the reply address brings
an unrelated tpoic up...

 

[Mary Sauer]

The URL will setup your newsreader with the Microsoft newsgroup. Otherwise look
for an Excel newsgroup in the community web site.