$$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 Message was sent from Indian Oil   Messaging Gateway, Refineries HQ, New 
Delhi, India. The information contained in this electronic message and any 
attachments to this message are intended for the exclusive use of the 
addressee(s) and may contain proprietary, confidential or privileged 
information. If you are not the intended recipient, you should not disseminate, 
distribute or copy this e-mail. Please notify the sender immediately and 
destroy all copies of this message and any attachments. 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-07-14 Thread MITTAL AJAY 
Thanks anish.
-Original Message-
From: Anish Shrivastava
Sent:  14/07/2011, 10:18  PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Want to copy two rows in all sheets except few


Hi Ajay,

Attached please find the updated sheet with rows copied in each sheet.

Below is the code I used.. (It might look amature, as I am new to VBA) :)

Sub copy_rows()
Dim sht As Integer

  For sht = 5 To Worksheets.Count
   Sheets(4).Select
 Rows(5:6).Copy
  Sheets(sht).Select
   Rows(5).Select
ActiveSheet.Paste
  Next sht

End Sub

Let me know if it works fine.

Thanks,
Anish

On Thu, Jul 14, 2011 at 9:23 PM, Rakesh Joshi 
rakesh.ri...@gmail.commailto: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 
amit...@iocl.co.inmailto:amit...@iocl.co.in wrote:
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.inhttp://iocl.co.in/

This Message was sent from Indian Oil Messaging Gateway, Refineries HQ, New 
Delhi, India. The information contained in this electronic message and any 
attachments to this message are intended for the exclusive use of the 
addressee(s) and may contain proprietary, confidential or privileged 
information. If you are not the intended recipient, you should not disseminate, 
distribute or copy this e-mail. Please notify the sender immediately and 
destroy all copies of this message and any attachments.

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/
4. Learn VBA Macros at 
http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/

To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel



--
Rakesh Joshi


--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/
4. Learn VBA Macros at 
http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/

To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

This Message was sent from Indian Oil   Messaging Gateway, Refineries HQ, New 
Delhi, India. The information contained in this electronic message and any 
attachments to this message are intended for the exclusive use of the 
addressee(s) and may contain proprietary, confidential or privileged 
information. If you are not the intended recipient, you should not disseminate, 
distribute or copy this e-mail. Please notify the sender immediately and 
destroy all copies of this message and any attachments. 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http

$$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@googlegroups.com] On 
Behalf Of ashish koul
Sent: Tuesday, July 05, 2011 1:33 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy data without opening file

i suggest you hide the workbook from which you are copying the data if you dont 
want to show it to the user


http://akoul.blogspot.com/search/label/Hide%20and%20Unhide%20a%20workbook%20in%20vba



On Tue, Jul 5, 2011 at 12:53 PM, Rajan_Verma 
rajanverma1...@gmail.commailto:rajanverma1...@gmail.com wrote:
No, We cant Copy the data from Closed Workbook.. but we can get the Data by 
Using Full Reference of cell .. Like

='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1


From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com 
[mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On 
Behalf Of ankur
Sent: Tuesday, July 05, 2011 12:13 PM
To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy data without opening file

hi hanumant

you may find this to be useful

http://spreadsheetpage.com/index.php...a_closed_file/http://spreadsheetpage.com/index.php/tip/a_vba_function_to_get_a_value_from_a_closed_file/
[cid:image002.jpg@01CC3B1C.C8978CC0]http://www.excelforum.com/newreply.php?do=newreplyp=2079066

Have A Nice Time  Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~
On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde 
arsfan2...@yahoo.co.inmailto:arsfan2...@yahoo.co.in wrote:
Hi friends,

is there any way where we can copy data from closed workbook A and paste it
into workbook B which is open?

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/
4. Learn VBA Macros at 
http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/

To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/
4. Learn VBA Macros at 
http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/

To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/
4. Learn VBA Macros at 
http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/

To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel



--
Regards

Ashish Koul
akoul.blogspot.comhttp://akoul.blogspot.com/
http://akoul.posterous.com/
akoul.wordpress.comhttp://akoul.wordpress.com/
My Linkedin Profilehttp://in.linkedin.com/pub/ashish-koul/10/400/830


P Before printing, think about the environment.


--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to

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

2011-07-05 Thread MITTAL AJAY 
Thanks Dave. Excellent ..

With Warm Regards,

CA. Ajay Mittal
Finance Manager

[cid:image001.jpg@01CC3B22.459EBEA0]
Pipelines Division,
Noida - 201 301
Tel: 0120-2448312

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Dave Bonallack
Sent: Tuesday, July 05, 2011 2:38 PM
To: excel-macros@googlegroups.com
Subject: RE: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

Hi,
Here is another option. It is slightly shorter, and doesn't produce a #VALUE! 
error when the target cell does not contain the expected data.
=MID(A2,MIN(SEARCH({1,2,3,4,5,6,7,8,9,0},A21234567890)),11)
If your the 11 digit number always starts with a 1 or a 3, as it does in your 
sample, then the formula could be further reduced to:
=MID(A2,MIN(SEARCH({1,3},A213)),11)
Regards - Dave.

From: rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Subject: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING
Date: Tue, 5 Jul 2011 14:24:00 +0530
Use this In B2

=MID(SUBSTITUTE(TRIM(A2), ,*,2),FIND(*,SUBSTITUTE(TRIM(A2), 
,*,2),1)+1,11)



From: excel-macros@googlegroups.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 formula ?

With Warm Regards,

CA. Ajay Mittal
Finance Manager

[cid:image001.jpg@01CC3B22.459EBEA0]
Pipelines Division,
Noida - 201 301
Tel: 0120-2448312

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of ashish koul
Sent: Tuesday, July 05, 2011 1:33 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy data without opening file

i suggest you hide the workbook from which you are copying the data if you dont 
want to show it to the user


http://akoul.blogspot.com/search/label/Hide%20and%20Unhide%20a%20workbook%20in%20vba



On Tue, Jul 5, 2011 at 12:53 PM, Rajan_Verma 
rajanverma1...@gmail.commailto:rajanverma1...@gmail.com wrote:
No, We cant Copy the data from Closed Workbook.. but we can get the Data by 
Using Full Reference of cell .. Like

='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1


From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com 
[mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On 
Behalf Of ankur
Sent: Tuesday, July 05, 2011 12:13 PM
To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy data without opening file

hi hanumant

you may find this to be useful

http://spreadsheetpage.com/index.php...a_closed_file/http://spreadsheetpage.com/index.php/tip/a_vba_function_to_get_a_value_from_a_closed_file/
[cid:image002.jpg@01CC3B22.459EBEA0]http://www.excelforum.com/newreply.php?do=newreplyp=2079066

Have A Nice Time  Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~
On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde 
arsfan2...@yahoo.co.inmailto:arsfan2...@yahoo.co.in wrote:
Hi friends,

is there any way where we can copy data from closed workbook A and paste it
into workbook B which is open?

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/
4. Learn VBA Macros at 
http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/

To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/
4. Learn VBA Macros at 
http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/

To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2

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

2011-07-05 Thread MITTAL AJAY 
Thanks Rajan .

It is working fine.

With Warm Regards,

CA. Ajay Mittal
Finance Manager

[cid:image001.jpg@01CC3B23.4A34CC10]
Pipelines Division,
Noida - 201 301
Tel: 0120-2448312

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Rajan_Verma
Sent: Tuesday, July 05, 2011 2:24 PM
To: excel-macros@googlegroups.com
Subject: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

Use this In B2

=MID(SUBSTITUTE(TRIM(A2), ,*,2),FIND(*,SUBSTITUTE(TRIM(A2), 
,*,2),1)+1,11)



From: excel-macros@googlegroups.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 formula ?

With Warm Regards,

CA. Ajay Mittal
Finance Manager

[cid:image001.jpg@01CC3B23.4A34CC10]
Pipelines Division,
Noida - 201 301
Tel: 0120-2448312

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of ashish koul
Sent: Tuesday, July 05, 2011 1:33 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy data without opening file

i suggest you hide the workbook from which you are copying the data if you dont 
want to show it to the user


http://akoul.blogspot.com/search/label/Hide%20and%20Unhide%20a%20workbook%20in%20vba



On Tue, Jul 5, 2011 at 12:53 PM, Rajan_Verma 
rajanverma1...@gmail.commailto:rajanverma1...@gmail.com wrote:
No, We cant Copy the data from Closed Workbook.. but we can get the Data by 
Using Full Reference of cell .. Like

='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1


From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com 
[mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On 
Behalf Of ankur
Sent: Tuesday, July 05, 2011 12:13 PM
To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy data without opening file

hi hanumant

you may find this to be useful

http://spreadsheetpage.com/index.php...a_closed_file/http://spreadsheetpage.com/index.php/tip/a_vba_function_to_get_a_value_from_a_closed_file/
[cid:image002.jpg@01CC3B23.4A34CC10]http://www.excelforum.com/newreply.php?do=newreplyp=2079066

Have A Nice Time  Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~
On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde 
arsfan2...@yahoo.co.inmailto:arsfan2...@yahoo.co.in wrote:
Hi friends,

is there any way where we can copy data from closed workbook A and paste it
into workbook B which is open?

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/
4. Learn VBA Macros at 
http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/

To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/
4. Learn VBA Macros at 
http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/

To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/
4. Learn VBA Macros at 
http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/

To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel



--
Regards

Ashish Koul

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

2011-02-06 Thread MITTAL AJAY 

Thanks a lot to all ...

With Warm Regards,

CA. Ajay Mittal
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Anil Bhange
Sent: 04/02/2011 6:07 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ RE: EXCEL FILE

Hi Ajay,

Attached worksheet 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 04, 2011 3:18 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ FW: EXCEL FILE
Importance: High

Hi , can anybody help me in inserting a new sheet in this file  what was the 
issue.

With Warm Regards,

 Ajay Mittal
This Message was sent from Indian Oil Messaging Gateway, Refineries HQ, New 
Delhi, India. The information contained in this electronic message and any 
attachments to this message are intended for the exclusive use of the 
addressee(s) and may contain proprietary, confidential or privileged 
information. If you are not the intended recipient, you should not disseminate, 
distribute or copy this e-mail. Please notify the sender immediately and 
destroy all copies of this message and any attachments.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

This Message was sent from Indian Oil   Messaging Gateway, Refineries HQ, New 
Delhi, India. The information contained in this electronic message and any 
attachments to this message are intended for the exclusive use of the 
addressee(s) and may contain proprietary, confidential or privileged 
information. If you are not the intended recipient, you should not disseminate, 
distribute or copy this e-mail. Please notify the sender immediately and 
destroy all copies of this message and any attachments. 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
inline: image001.jpg

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 AND VBA MACROS
Subject: $$Excel-Macros$$ Re: How can Divide the Numbers by 1 lac in excel

Hi OPS

Simply write 1,0 in any cell, copy it, select the cell whom u want
to convert, right click -- select paste special, under paste option
select values, In operation section select divide, click on ok.

Regards
Rajender Soni | 7503225550

On Aug 20, 8:53 am, OPSHARMA opsharma...@gmail.com wrote:
 Dear Experts,

 I have many data in excel sheet and want to convert the same in Lakh.

 Kindly help me how can it be divided it through single formula.

 Regards

 OPS

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
This Message was sent from Indian Oil Messaging Gateway, New Delhi, India. The 
information contained in this electronic message and any attachments to this 
message are intended for the exclusive use of the addressee(s) and may contain 
proprietary, confidential or privileged information. If you are not the 
intended recipient, you should not disseminate, distribute or copy this e-mail. 
Please notify the sender immediately and destroy all copies of this message and 
any attachments. 


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe