Creating a shortcut for Accounting

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

You could put this in K6:

=IF(CODE(UPPER($D6))-64=COLUMNS($A:K),$C6,"")

then copy across to Z6, and then copy down as required.

Hope this helps.

Pete

Thank you very much for both of these solutions. It would have been slightly easier if I had used the actual column names rather than examples. I would actually like to enter the letter required in Column C and then it to go in to to Columns K through to Z. I have attached a screenshot of the specific example that I am working with. I have just put the letter in to Column C for demonstration purposes....


Attachment 646432

Your attachment is looked upon as invalid, according to the forum software. Do not use the Paperclip icon for attachments, as it is broken on this forum. Instead, you can attach files like this:

It would help if you attached a sample Excel workbook, rather than a picture of one.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Hope this helps.

Pete

I think that has worked....

Many thanks Pete

By the way, the VBA option isn't available on Excel for Mac 2008 so I read...