auto fill with one column and multiple unique rows.

You can use a bit of Excel magic to do this.

First, highlight the cells that you want this to apply to (A6:A35 in your example);
Then press the F5 key (GoTo), then click on Special;
Click against Blanks in the pop-up then click OK;
Begin to enter a formula by typing = and then click on the cell above (i.e. A6);
Then do CTRL-Enter and the data will be filled.

You might want to use Copy | Paste Special | Values | OK then <Esc> to fix those values.

Hope this helps.

Pete

That works perfectly. Is there a way to set up a macro or function to do it automatically? I plan on distributing the workbook so that other people can copy and paste data. i'm trying to make it as user friendly as possible.

Just record a macro while you go through those actions - that was one of the first macros that I was introduced to many years ago.

Hope this helps.

Pete

you have been great help

If you want a code

Please Login or Register  to view this content.