Hi everybody,

I was wondering if there is a way to make your own commands on Excel. I'm assigning codes for the presence of different characteristics. I'm working on a project with 12 columns of codes, but I'd like to add commands for different lines. For example, let's say one line would be: 0; 0; 1; 1; 0; 1; 0; 0; 0; 0; 0; 1 (semicolons represent different cells/characteristics). If I knew the next line would have the same codes assigned, I would simply copy and paste from the line before. So, I would just Command+C and Command+V: 0; 0; 1; 1; 0; 1; 0; 0; 0; 0; 0.

However, if there are several lines that should be coded as: 1; 0; 1; 1; 0; 1; 0; 0; 0; 0; 1, and 0; 0; 1; 1; 0; 1; 0; 0; 0; 0; 0, I'd like a way to add a command to each so instead of manually typing in 0's and 1's, I could, for example, just press Command+0 (or any combination of keys) and then: 1; 0; 1; 1; 0; 1; 0; 0; 0; 0; 1, would be pasted, and then if I hit Command+9 and then: 0; 0; 1; 1; 0; 1; 0; 0; 0; 0; 0 would be pasted. Please let me know if I need to explain anything as I'm sure I didn't say it exactly right. Thank you for your help.