I have been using excel for years for doing my annual accounts. I'd like to know if it is possible to create a shortcut for something.
I have a date, description and amount. In the column next to the amount I would like to be able to type one letter and then it for copy the amount in the previous box to an itemisation box :
for example
Col A : Date
Col B Description
Col C : Amount
Col D : (ENTER A LETTER FROM K TO Z)
Col M : Automatically copies whatever amount is in Col C to the column you choose from K to Z
i.e.... Column M is Motor expenses so if an M is inputted in to D6 it automatically copies the contents of D6 in to K6
and then if Column P is Premises then anything in C7 is copied in to P7 if the letter P is placed in to D7...
This would save a lot of time by manually cutting and pasting it all in to the single cells...
Thank you in advance if anyone can help
Bookmarks