TEAR SHEET: Press the button "Separation sheet and name".
ELIMINATION OF SHEET: Press the button "Delete sheet detached".
2014-05-07 14:12 GMT+07:00 Shrinivas Shevde :
> Very very thanks
>
>
> On Wed, May 7, 2014 at 11:27 AM, Vaibhav Joshi wrote:
>
>> Hi
>>
>> Yes you can paste data in mast
Hi,
If you want in columns, say a1,b1,c1 etc use the following fomula(which I
learned from this site) and drag it (UPTO Z).
=MID(ADDRESS(1,COLUMN()),2,1)
-r.karunanithi.
On Friday, May 9, 2014 1:20 PM, Amit Desai (MERU)
wrote:
Dear Abhishek,
This worked perfectly fine. Thanks a lot.
Hi,
Keep the cursor in A1 and run the following code. Here I put the autofill 'C'
column and you will get the required result.
File also enclosed.
Sub autofill()
Do While ActiveCell <> ""
ActiveCell.Offset(0, 2).FormulaR1C1 = ActiveCell.Offset(0, 0)
ActiveCell.Offset(1, 0).Select
