Hello!

We have a project that requires inputting names into a schedule. Right now, the users are typing the names in. I have pre-loaded the names into hidden rows above the columns so that the user only has to input enough unique letters to identify the name. However, it is still time-consuming.

Control-dragging the upper corner of each cell works from the names column works, but it is difficult to always grab the upper corner, and it copies the conditional formatting, too. It also requires another mouse click to select the starting cell.

We would like a simpler way to copy values from one cell to another. One idea would be to launch a macro, click on a cell, and clicking on a second cell automatically copies values to the second cell. This could continue until the macro is stopped. And the technique must NOT copy formatting to the destination cell.

Any ideas appreciated!