Fill Down question

A

Andy B.

Hi Ron

That is supurb - thanks a lot. I tried it and it worked first time :
:)

Best Wishes

Andy
 
D

Debra Dalgleish

After you follow Ron's instructions, you should copy the column, and
paste special as Values. Then, if you sort the data, the rows will have
the correct label in that column.

There are instructions, and some sample code to automate the process,
shown here:

http://www.contextures.com/xlDataEntry02.html
 
R

Ron de Bruin

Thanks Debra for adding this information for the OP
Next time I copy/paste your link<g>
 
Top