Hello all:
I am trying to enter a alpha numerical (eg. Rd1234567) into the top line of a table with 4 columns and 35 rows. I want to make the entry mentioned above appear in 1 column but in all 35 rows with the last digit increased by 1.
Example:
RD1412920
RD1412921
RD1412922
RD1412923
RD1412924
RD1412925
RD1412926
RD1412927
RD1412928
RD1412929
RD1412930
RD1412931
RD1412932
RD1412933
Any suggestions in how to do this with a macro???
Thanks
Tom