I have a table with 4 rows. When I am in a cell on column B I would like a shortcut way to have the last cell entered in column c to be copied over to the new cell in column B. I have attached the spreadsheet. I know it is fairly simple to just go to the last cell in column C and copy the value and then enter into the new cell in column B. However, I am entering a lot of data and want to cut down on the number of steps it takes me. I can't have it be an automatic thing every time either because sometimes the value isn't the same. I just want to be able to get to the new cell in column B and press something like "ctl l" and have it copy the last cell entered in column C. I want to save this to my Personal Macro workbook so that I can use it in different workbooks.

Can anyone help me with this?

Thank you!