$$Excel-Macros$$ RE: Want to copy two rows in all sheets except few

2011-07-15 Thread MITTAL AJAY
Dear All, I want to copy & paste special rows 5& 6 of sheet “Heading” to all the sheets starting from “Balance Sheet” to “Note 31” Can someone suggest code for the same. शुभकामनाओं सहित, अजय मित्तल, वित्त प्रबन्धक पाइपलाइंस मुख्यालय टेलीफोन:0120-2448312 ई-मेल : amit...@iocl.co.in This Messag

RE: $$Excel-Macros$$ Want to copy two rows in all sheets except few

2011-07-14 Thread MITTAL AJAY
Sub Let me know if it works fine. Thanks, Anish On Thu, Jul 14, 2011 at 9:23 PM, Rakesh Joshi mailto:rakesh.ri...@gmail.com>> wrote: could you please let us knwo in which range or cell u want to paste this rows in note31 On Thu, Jul 14, 2011 at 7:25 PM, MITTAL AJAY mailto:amit...@io

RE: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

2011-07-05 Thread MITTAL AJAY
oups.com [mailto:excel-macros@googlegroups.com] On Behalf Of MITTAL AJAY Sent: Tuesday, July 05, 2011 2:07 PM To: 'excel-macros@googlegroups.com' Subject: $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING I WANT TO EXTRACT 11 DIGIT NUMBER IN CLOUMN B. Can anybody suggest a suitable fo

RE: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

2011-07-05 Thread MITTAL AJAY
groups.com [mailto:excel-macros@googlegroups.com] On Behalf Of MITTAL AJAY Sent: Tuesday, July 05, 2011 2:07 PM To: 'excel-macros@googlegroups.com' Subject: $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING I WANT TO EXTRACT 11 DIGIT NUMBER IN CLOUMN B. Can anybody suggest a suitable form

$$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

2011-07-05 Thread MITTAL AJAY
I WANT TO EXTRACT 11 DIGIT NUMBER IN CLOUMN B. Can anybody suggest a suitable formula ? With Warm Regards, CA. Ajay Mittal Finance Manager [cid:image001.jpg@01CC3B1C.C8978CC0] Pipelines Division, Noida - 201 301 Tel: 0120-2448312 From: excel-macros@googlegroups.com [mailto:excel-macros@google

$$Excel-Macros$$ RE: EXCEL FILE....

2011-02-06 Thread MITTAL AJAY
was protected by unprotecting the workbook you can insert the worksheet. There is no password for the file. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of MITTAL AJAY Sent: Friday, February

RE: $$Excel-Macros$$ Re: How can Divide the Numbers by 1 lac in excel

2010-08-20 Thread MITTAL AJAY
Great Solution ... With Warm Regards, CA. Ajay Mittal Finanace Manager Pipelines Division, Noida - 201 301 Tel: 0120-2448324 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Soni.Rajender Sent: 20/08/2010 11:53 AM To: MS EXCEL

$$Excel-Macros$$ Re: Opening of SAP in Excel

2009-03-15 Thread MITTAL, AJAY
Hi, We are using SAP as ERP in our office. We have developed some macros for preparation of reports in Excel. But every time, we have to LOG IN to SAP for preparation of Report abd Export Data in EXcel. If anybody know any program/Macro by which the data from the SAP can be extracted without log