Re: $$Excel-Macros$$ Urgent Formula Required Help me
U can Use Mid Function for the same =Mid(Cell Reference, Starting Num, No of Chars) For eg Ur Orignal Code is 8900765 U want 765 then fromula is =mid(cell Ref, 5,3) Hope this will get result as u want. On Apr 1, 6:55 pm, "Puttu *" wrote: > Can you please please help any one > > > > > > On Fri, Apr 1, 2011 at 5:40 PM, Puttu * wrote: > > sorry again, please hep me in the formula > > > On Fri, Apr 1, 2011 at 5:12 PM, Puttu * wrote: > > >> awaiting for your replay please. > > >> On Fri, Apr 1, 2011 at 4:49 PM, Puttu * wrote: > > >>> Experts please help me on this it's bit urgent sorry to bother. > > >>> On Fri, Apr 1, 2011 at 4:10 PM, Puttu * wrote: > > Hi Experts, > > I have list of items which have not full codes. I need them to convert > full code. Could you please help me. > > Item code column has either 3, 2, 4 & 5 digits no. but by default they > should be either 6 or 7 or 8 digits code. What best formul I need to use > to > get that output. Item Full Code output column has the correct answers > which I manually entered. I want the same way answer using the formulas > > Item Full Code output > > Give the formula for output > > Item Code > > 200990 > > 990 > > 200991 > > 991 > > 300011 > > 11 > > 300014 > > 14 > > 300104 > > 104 > > 520901 > > 20901 > > 520902 > > 20902 > > 500450 > > 450 > > 500451 > > 451 > > 203529 > > 3529 > > 203538 > > 3538 > > 8515959 > > 15959 > > 8516271 > > 16271 > > 8203892 > > 3892 > > 8203893 > > 3893 > > 1620224 > > 224 > > 1620225 > > 225 > > -- > Putta > > -- > > ------ > 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 athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://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 > > >>> -- > >>> Putta > > >> -- > >> Putta > > > -- > > Putta > > -- > Putta- Hide quoted text - > > - Show quoted text - -- -- 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$$ Urgent Formula Required Help me
> >Item Full Code output > > Give the formula for output > > Item Code > > 200990 > =Text(item_Code,"000") > > 990 > > 200991 > > 991 > >300011 > > 11 > > 300014 > > 14 > > 300104 > > 104 > >520901 > > 20901 > > 520902 > > 20902 > > 500450 > > 450 > > 500451 > > 451 > >203529 > > 3529 > > 203538 > > 3538 > >8515959 > > 15959 > > 8516271 > > 16271 > >8203892 > > 3892 > > 8203893 > > 3893 > >1620224 > > 224 > > 1620225 > > 225 > > > -- > Putta > > -- > > -- > 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 > -- Regards Rajan verma +91 9158998701 -- -- 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$$ Urgent Formula Required Help me
Can you please please help any one On Fri, Apr 1, 2011 at 5:40 PM, Puttu * wrote: > sorry again, please hep me in the formula > > > On Fri, Apr 1, 2011 at 5:12 PM, Puttu * wrote: > >> awaiting for your replay please. >> >> >> On Fri, Apr 1, 2011 at 4:49 PM, Puttu * wrote: >> >>> Experts please help me on this it's bit urgent sorry to bother. >>> >>> >>> On Fri, Apr 1, 2011 at 4:10 PM, Puttu * wrote: >>> Hi Experts, I have list of items which have not full codes. I need them to convert full code. Could you please help me. Item code column has either 3, 2, 4 & 5 digits no. but by default they should be either 6 or 7 or 8 digits code. What best formul I need to use to get that output. Item Full Code output column has the correct answers which I manually entered. I want the same way answer using the formulas Item Full Code output Give the formula for output Item Code 200990 990 200991 991 300011 11 300014 14 300104 104 520901 20901 520902 20902 500450 450 500451 451 203529 3529 203538 3538 8515959 15959 8516271 16271 8203892 3892 8203893 3893 1620224 224 1620225 225 -- Putta -- -- 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 >>> >>> >>> >>> -- >>> Putta >>> >> >> >> >> -- >> Putta >> > > > > -- > Putta > -- Putta -- -- 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$$ Urgent Formula Required Help me
why r u using 200 for 990 or 300 for 11 any reason On Fri, Apr 1, 2011 at 4:49 PM, Puttu * wrote: > Experts please help me on this it's bit urgent sorry to bother. > > > On Fri, Apr 1, 2011 at 4:10 PM, Puttu * wrote: > >> Hi Experts, >> >> I have list of items which have not full codes. I need them to convert >> full code. Could you please help me. >> >> Item code column has either 3, 2, 4 & 5 digits no. but by default they >> should be either 6 or 7 or 8 digits code. What best formul I need to use to >> get that output. Item Full Code output column has the correct answers >> which I manually entered. I want the same way answer using the formulas >> >> >> Item Full Code output >> >> Give the formula for output >> >> Item Code >> >> 200990 >> >> 990 >> >> 200991 >> >> 991 >> >>300011 >> >> 11 >> >> 300014 >> >> 14 >> >> 300104 >> >> 104 >> >>520901 >> >> 20901 >> >> 520902 >> >> 20902 >> >> 500450 >> >> 450 >> >> 500451 >> >> 451 >> >>203529 >> >> 3529 >> >> 203538 >> >> 3538 >> >>8515959 >> >> 15959 >> >> 8516271 >> >> 16271 >> >>8203892 >> >> 3892 >> >> 8203893 >> >> 3893 >> >>1620224 >> >> 224 >> >> 1620225 >> >> 225 >> >> >> -- >> Putta >> >> -- >> >> -- >> 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 >> > > > > -- > Putta > > -- > > -- > 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 > -- -- 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$$ Urgent Formula Required Help me
Hi Puttu, explain it in excel sheet and also mention all the possibilities. Regards Umesh On Fri, Apr 1, 2011 at 5:12 PM, Puttu * wrote: > awaiting for your replay please. > > > On Fri, Apr 1, 2011 at 4:49 PM, Puttu * wrote: > >> Experts please help me on this it's bit urgent sorry to bother. >> >> >> On Fri, Apr 1, 2011 at 4:10 PM, Puttu * wrote: >> >>> Hi Experts, >>> >>> I have list of items which have not full codes. I need them to convert >>> full code. Could you please help me. >>> >>> Item code column has either 3, 2, 4 & 5 digits no. but by default they >>> should be either 6 or 7 or 8 digits code. What best formul I need to use to >>> get that output. Item Full Code output column has the correct answers >>> which I manually entered. I want the same way answer using the formulas >>> >>> >>> Item Full Code output >>> >>> Give the formula for output >>> >>> Item Code >>> >>> 200990 >>> >>> 990 >>> >>> 200991 >>> >>> 991 >>> >>>300011 >>> >>> 11 >>> >>> 300014 >>> >>> 14 >>> >>> 300104 >>> >>> 104 >>> >>>520901 >>> >>> 20901 >>> >>> 520902 >>> >>> 20902 >>> >>> 500450 >>> >>> 450 >>> >>> 500451 >>> >>> 451 >>> >>>203529 >>> >>> 3529 >>> >>> 203538 >>> >>> 3538 >>> >>>8515959 >>> >>> 15959 >>> >>> 8516271 >>> >>> 16271 >>> >>>8203892 >>> >>> 3892 >>> >>> 8203893 >>> >>> 3893 >>> >>>1620224 >>> >>> 224 >>> >>> 1620225 >>> >>> 225 >>> >>> >>> -- >>> Putta >>> >>> -- >>> >>> -- >>> 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 >>> >> >> >> >> -- >> Putta >> > > > > -- > Putta > > -- > > -- > 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 > -- -- 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$$ Urgent Formula Required Help me
attach the sample file so we can help you. -- -- 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$$ Urgent Formula Required Help me
sorry again, please hep me in the formula On Fri, Apr 1, 2011 at 5:12 PM, Puttu * wrote: > awaiting for your replay please. > > > On Fri, Apr 1, 2011 at 4:49 PM, Puttu * wrote: > >> Experts please help me on this it's bit urgent sorry to bother. >> >> >> On Fri, Apr 1, 2011 at 4:10 PM, Puttu * wrote: >> >>> Hi Experts, >>> >>> I have list of items which have not full codes. I need them to convert >>> full code. Could you please help me. >>> >>> Item code column has either 3, 2, 4 & 5 digits no. but by default they >>> should be either 6 or 7 or 8 digits code. What best formul I need to use to >>> get that output. Item Full Code output column has the correct answers >>> which I manually entered. I want the same way answer using the formulas >>> >>> >>> Item Full Code output >>> >>> Give the formula for output >>> >>> Item Code >>> >>> 200990 >>> >>> 990 >>> >>> 200991 >>> >>> 991 >>> >>>300011 >>> >>> 11 >>> >>> 300014 >>> >>> 14 >>> >>> 300104 >>> >>> 104 >>> >>>520901 >>> >>> 20901 >>> >>> 520902 >>> >>> 20902 >>> >>> 500450 >>> >>> 450 >>> >>> 500451 >>> >>> 451 >>> >>>203529 >>> >>> 3529 >>> >>> 203538 >>> >>> 3538 >>> >>>8515959 >>> >>> 15959 >>> >>> 8516271 >>> >>> 16271 >>> >>>8203892 >>> >>> 3892 >>> >>> 8203893 >>> >>> 3893 >>> >>>1620224 >>> >>> 224 >>> >>> 1620225 >>> >>> 225 >>> >>> >>> -- >>> Putta >>> >>> -- >>> >>> -- >>> 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 >>> >> >> >> >> -- >> Putta >> > > > > -- > Putta > -- Putta -- -- 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$$ Urgent Formula Required Help me
awaiting for your replay please. On Fri, Apr 1, 2011 at 4:49 PM, Puttu * wrote: > Experts please help me on this it's bit urgent sorry to bother. > > > On Fri, Apr 1, 2011 at 4:10 PM, Puttu * wrote: > >> Hi Experts, >> >> I have list of items which have not full codes. I need them to convert >> full code. Could you please help me. >> >> Item code column has either 3, 2, 4 & 5 digits no. but by default they >> should be either 6 or 7 or 8 digits code. What best formul I need to use to >> get that output. Item Full Code output column has the correct answers >> which I manually entered. I want the same way answer using the formulas >> >> >> Item Full Code output >> >> Give the formula for output >> >> Item Code >> >> 200990 >> >> 990 >> >> 200991 >> >> 991 >> >>300011 >> >> 11 >> >> 300014 >> >> 14 >> >> 300104 >> >> 104 >> >>520901 >> >> 20901 >> >> 520902 >> >> 20902 >> >> 500450 >> >> 450 >> >> 500451 >> >> 451 >> >>203529 >> >> 3529 >> >> 203538 >> >> 3538 >> >>8515959 >> >> 15959 >> >> 8516271 >> >> 16271 >> >>8203892 >> >> 3892 >> >> 8203893 >> >> 3893 >> >>1620224 >> >> 224 >> >> 1620225 >> >> 225 >> >> >> -- >> Putta >> >> -- >> >> -- >> 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 >> > > > > -- > Putta > -- Putta -- -- 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$$ Urgent Formula Required Help me
Experts please help me on this it's bit urgent sorry to bother. On Fri, Apr 1, 2011 at 4:10 PM, Puttu * wrote: > Hi Experts, > > I have list of items which have not full codes. I need them to convert full > code. Could you please help me. > > Item code column has either 3, 2, 4 & 5 digits no. but by default they > should be either 6 or 7 or 8 digits code. What best formul I need to use to > get that output. Item Full Code output column has the correct answers > which I manually entered. I want the same way answer using the formulas > > > Item Full Code output > > Give the formula for output > > Item Code > > 200990 > > 990 > > 200991 > > 991 > >300011 > > 11 > > 300014 > > 14 > > 300104 > > 104 > >520901 > > 20901 > > 520902 > > 20902 > > 500450 > > 450 > > 500451 > > 451 > >203529 > > 3529 > > 203538 > > 3538 > >8515959 > > 15959 > > 8516271 > > 16271 > >8203892 > > 3892 > > 8203893 > > 3893 > >1620224 > > 224 > > 1620225 > > 225 > > > -- > Putta > > -- > > -- > 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 > -- Putta -- -- 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
$$Excel-Macros$$ Urgent Formula Required Help me
Hi Experts, I have list of items which have not full codes. I need them to convert full code. Could you please help me. Item code column has either 3, 2, 4 & 5 digits no. but by default they should be either 6 or 7 or 8 digits code. What best formul I need to use to get that output. Item Full Code output column has the correct answers which I manually entered. I want the same way answer using the formulas Item Full Code output Give the formula for output Item Code 200990 990 200991 991 300011 11 300014 14 300104 104 520901 20901 520902 20902 500450 450 500451 451 203529 3529 203538 3538 8515959 15959 8516271 16271 8203892 3892 8203893 3893 1620224 224 1620225 225 -- Putta -- -- 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