Re: $$Excel-Macros$$ $$How to FillDown using offset-macro required

2013-04-24 Thread Amit Basra
hi R.Karunanith, You can simply use the concatenate function to do the concatenation i have tried doing it seems to work fine for me, hope this solution works for you, i just tried helping, it it does'nt work please forgive me. Thanks & Regards Amit Basra On Wed, Apr 24, 2013 at 10:42 PM, karu

$$Excel-Macros$$ $$How to FillDown using offset-macro required

2013-04-24 Thread karunanithi ramaswamy
Sirs,    I want to fill down Sim card numbers around 5 lacs each contain 19 digits and the sims have numbers from one value to another, in sequence for 5 to 10,000. I split this to 3 or 4 columns and then idea to concatenate.  The numbers in sequence is highlighted in yellow.Using a macro i can m