I am filling out excel spreadsheets with the same data, and instead of copy
and pasting I know there is a way you can set up excel so that you can just
press a key (say r) and it will automatically fill the cell with information,
and also you can have it a certain colour etc. I don't thinks it's a macro
as I've had this set up for me before and all you have to do is press a
single key. Help!