Fill in a term above certain cells by means of a macro
Dear Experts:
I would like to run a macro that performs the following action:
Loop thru all the cells in Column A.
Whenever the macro hits a 1 (i.e. a cell filled with the value 1 in Column A) it should enter 'beginning' just above the cell where the value 1 is found.
Help is much appreciated. I have attached a sample file for your convenience.
Thank you very much for your professional support.
Regards, Andreas