Macro for auto-filling down a column

[bcexcel]

Hello!

I am often needing to type in a specific set of characters down a column, all starting with the same string before -- as shown in the attached picture. The first part of the cell is never the same but it always needs to fill down BLK1 through MSD1.

I want to make a macro that could make it so I just need to type string-BLK1 in the first cell and then highlight it and then down 5 cells for it to auto populate the way I want. Is this possible? I don't need someone to design the code, I would just like pointers on how to get this going.

 

[6StringJazzer]

I would use the Worksheet_Change event to detect when you add a value ending in "-BLK1" to that column. Then it is very simple to extract the prefix, and then add the next four values in the next four rows. You wouldn't highlight or drag, the macro would run automatically as soon as you type in the first value. It should also check to ensure that there are four blank rows afterwards to have room to fill it in.

Hopefully those are the pointers you're looking for but it would take me about 5 minutes to write the code if you need more help.