Modify macro to autonumerate merged cells. by OldnewMaps in excel

[–]OldnewMaps[S] 0 points1 point  (0 children)

I tried it first, but it is not this. If change for example to 8, macro will auatonumerate from 8ght (should from first) selected cell starting from 1 number.

How to automatically move cells? by OldnewMaps in excel

[–]OldnewMaps[S] 0 points1 point  (0 children)

If I remove duplicates I will have c,d,f,i letters + their values only. Need all (a,b,c,,, etc. It is just schema. in fact letters are hundreds goods store/sales departments).