m******g 发帖数: 91 | 1 the easiest way is of course write a VBA macro for it. but if you
don't know, here is a workaround:
insert a new column, say A
start from the same row in colA where your data start, say A5, put 1 in A5,
and next row put = A5 +1, then autofill the remaining cells till it reaches
just one row before the 2nd picking point, say A104.
then copy and repaste the values ONLY of A5-A104.(paste special), and
then cp these values to the rest of the cells in colA till the end of your
data row.
now, select d |
|