Re: $$Excel-Macros$$ Help for understanding VBA
where is available file section... Please provide the link. regards, Vijay On Fri, Feb 26, 2010 at 11:27 AM, ankur wrote: > our file section has very good material on macros and vba .download > stuff from there > 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 Wed, Feb 17, 2010 at 3:44 PM, chethan Bhadravathi > wrote: > > Hi, > > > > Can anybody help me out in understanding VBA codes for creating macros > in > > excel,as i am very new to this and not able to grasp it easily. > > > > Is there any way to learn the codes easily.? > > > > Plz help me out in understanding the codes. > > > > > > Regards, > > Chethan > > > > -- > > > -- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > > http://twitter.com/exceldailytip > > 2. Join our Facebook Group @ > > http://www.facebook.com/group.php?gid=287779555678 > > 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 6,800 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 > > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 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 6,800 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 > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 6,800 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
Re: $$Excel-Macros$$ Dependent drop down lists
Dave & Abhishek,
Not so sure that's right. In Hanum's example, A points to C, A points to D,
and A points to E. It's a one-to-many relationship. Dave's example
contained a one-to-one relationship. Using Hanum's example, if I chose A in
the first dropdown, would the second dropdown be changed to C, D or E?
Chris
On Sat, Feb 27, 2010 at 7:29 AM, Abhishek Jain wrote:
> Excellent Dave!
>
> Simply superb.
>
>
>
>
> On Sat, Feb 27, 2010 at 6:25 PM, Dave Bonallack > wrote:
>
>> Hi,
>> Does the attached do what you need?
>> Regards - Dave.
>>
>> > Date: Fri, 26 Feb 2010 15:31:13 -0800
>> > Subject: Re: $$Excel-Macros$$ Dependent drop down lists
>> > From: harsha...@gmail.com
>> > To: excel-macros@googlegroups.com
>>
>> >
>> > Both the solutions are not what I am looking for...what I am looking
>> > for is my exampleI think it is very clear.
>> > Unlike these solutions, mine are always one-to-one relationship.
>> >
>> > On Feb 24, 12:29 am, santosh bahuguna
>> > wrote:
>> > > Create Multiple Range of you data
>> > >
>> > > Let suppose
>> > > we Have
>> > >
>> > > A C
>> > > A D
>> > > A E
>> > > B F
>> > > B G
>> > > B H
>> > >
>> > > Give the Name A1:A6 MAIN SOURCE
>> > >
>> > > GIVE Name the B1:B3 as A
>> > > GIVE Name the B4:B6 as B
>> > >
>> > > select the Column where you want to show main SOURCE
>> > >
>> > > and in sub menu Give Formula of =Indirect("Range of the data in bases
>> of you
>> > > want to display LIke A or B")
>> > >
>> > > Regards
>> > > Santosh Bahuguna
>> > >
>> > >
>> > >
>> > > On Tue, Feb 23, 2010 at 10:12 PM, Vinod N wrote:
>> > > > Hi Hanum,
>> > >
>> > > > Please find attached the Solution provided by one of the Gurus for a
>> > > > query similar to the one posted by you...
>> > >
>> > > > Use the attached.. in the meantime, Gurus will provide you with
>> exact
>> > > > solution
>> > > > if possible send us a sample file for exact query...
>> > >
>> > > > Vinod
>> > >
>> > > > On Tue, Feb 23, 2010 at 11:28 PM, Hanum
>> wrote:
>> > > > > I have a unique problem that I need your help. Here it is:
>> > >
>> > > > > There is a list of some numbers and names associated with each of
>> the
>> > > > > numbers. There are two drop down lists for a user to pick from -
>> one
>> > > > > drop down for the numbers and another for the names. When a user
>> > > > > selects a particular number from the number drop down, I want the
>> the
>> > > > > name drop down to show the correspsonding name. That's not all -
>> when
>> > > > > the user selects a particular name from the name drop down, the
>> number
>> > > > > drop down to show the correspsonding number.
>> > >
>> > > > > Here's an example: 01,.,15 are in drop down A, and
>> > > > > Arizona,,Virginia are in drop down B. When I select 05 from
>> drop
>> > > > > down A, the drop down B should update to New Mexico. Next, if I
>> go to
>> > > > > drop down B and change the current value 'New Mexico' to say
>> > > > > 'Virginia', drop down A should change to 15.
>> > >
>> > > > > 01 Arizona
>> > > > > 03 California
>> > > > > 05 New Mexico
>> > > > > 10 New York
>> > > > > 15 Virginia
>> > >
>> > > > > Please help.
>> > >
>> > > > > --
>> > >
>> > > >
>> ------
>> > > > > Some important links for excel users:
>> > > > > 1. Follow us on TWITTER for tips tricks and links :
>> > > >http://twitter.com/exceldailytip
>> > > > > 2. Join our Facebook Group @
>> > > >http://www.facebook.com/group.php?gid=287779555678
>> > > > > 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
>> > >
>> > > > > <><><><><><><><><><><><><><><><><><><><><><>
>> > > > > HELP US GROW !!
>> > >
>> > > > > We reach over 6,800 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
>> > >
>> > > > --
>> > > > Thanks and Regards
>> > >
>> > > > Vinod N
>> > >
>> > > > --
>> > >
>> > > >
>> ------
>> > > > Some important links for excel users:
>> > > > 1. Follow us on TWITTER for tips tricks and links :
>> > > >http://twitter.com/exceldailytip
>> > > > 2. Join our Facebook Group @
>> > > >http://www.facebook.com/group.php?gid=287779555678
>> > > > 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
>> > >
>> > > > <><><><><><><><><><><><><><><><><><><><><><>
>> >
$$Excel-Macros$$ Subtraction on variable size array
What is a common technique to perform subtraction on a variable size array? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 6,800 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
Re: $$Excel-Macros$$ CHANGE IN DATE FORMAT IN EXCEL
Hello Dear, It depends offcourse, if receiver has change his or her setting. If any issue abut the date field then resolve to freeze it, i.e if u r writing 22-jan-2010 u can use freeze ' 22-jan-2010 now receiver will get the correct date, and if he or she want to delimited ‘, then use data ->text to column->delimited by ' I hope this will help. :) Happy to help On Fri, Feb 26, 2010 at 10:48 PM, vikas gupta wrote: > Thanks a lot friends > > On 26/02/2010, Paul Schreiner wrote: > > > > > > The date display format is determined by the Personal Settings for the PC > > that opens the file > > (it is not stored in the file) > > that means, IF THE CELL IS A VALID DATE > > then you can have the PC you're using currently display the date as: > > DD/MM/, and then open the file on another PC and display it > > differently. > > > > However, You must be using the "default" date format you set up in your > > Excel settings, > > and the dates must be actual Excel dates, not text strings that look like > > dates. > > > > If you format he cells to a different date format (like using > right-click, > > format cells) > > then you are telling Excel to override he default and use a specific > format. > > > > So, when you open it in France, it will still override the defaults. > > > > Paul > > > > > > > > From: vikas gupta > > To: excel-macros@googlegroups.com > > Sent: Fri, February 26, 2010 7:40:10 AM > > Subject: $$Excel-Macros$$ CHANGE IN DATE FORMAT IN EXCEL > > > > DEAR ALL > > > > GREETINGS OF HOLI FESTIVAL > > > > I HAD SENT A EXCEL FILE THROUGH E MAIL FROM DELHI TO FRANCE > > IN EXCEL FILE A DATE IS WRITTEN IN DD/MM/ FORMAT > > BUT WHEN IT REACHED ITS DESTINATION IT SHOWS THE DATE FORMAT > > IN MM/DD/ FORMAT > > > > IS IT POSSIBLE IN EXCEL SHEET > > > > PLEASE PROVIDE ME SOLUTION URGENTLY > > > > THANKS IN ADVANCE > > > > REGARDS > > VIKAS GUPTA > > 09311334683 > > > > -- > > > -- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > > http://twitter.com/exceldailytip > > 2. Join our Facebook Group @ > > http://www.facebook.com/group.php?gid=287779555678 > > 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 6,800 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 > > > > -- > > > -- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > > http://twitter.com/exceldailytip > > 2. Join our Facebook Group @ > > http://www.facebook.com/group.php?gid=287779555678 > > 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 6,800 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 > > > > -- > Sent from my mobile device > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 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 6,800 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 > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Exc
Re: $$Excel-Macros$$ VBA Help
Hello Dear, You can bind the uses of VBA for specific industry.I am working with mainframe and we have to record the jcl log,We send all jcl log to the VBA Admin to arrange it date/time wise according to time. but my others friend are working in Other domain,told me that vba is also important for them also. vba generally used for automate the result,consolidate sheet and workbook. I hope it will help. :) happy to help. On Sat, Feb 27, 2010 at 9:59 PM, Dilip Pandey wrote: > Hi Chethan, > > Finance, Consulting - Analytics industries (KPO-BPO) uses VBA most, and I > would suggest you to update your resume in some top job portals and then > you'll automatic receive job opportunities. > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > > On 2/10/10, chethan Bhadravathi wrote: >> >> Hi Everybody, >> >> >> i want to know which industry use VBA for excel programming most.? >> >> >> So that i can apply for jobs who does VBA excel programming and also >> suggest me the links or websites to apply jobs for VBA excel programming. >> >> >> >> Thanks in advance. >> >> >> >> Regards, >> Chethan >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 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 >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,700 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 >> > > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > > 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 6,800 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 > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 6,800 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
Re: $$Excel-Macros$$ Re: pdf converter software code needed (able2extract)
Hi, Try Dis Link 100% Work http://rapidshare.com/files/205575931/Able2Extract_Professional_v6.0.0.0.rar Or <%20http://w18.easy-share.com/1702849420.html> ttp://w18.easy-share.com/1702849420.html<%20http://w18.easy-share.com/1702849420.html> On Sat, Feb 27, 2010 at 10:10 AM, ankur wrote: > hi friends > this is link for download the trail version > > and than use code given in earlier msg > > > http://www.investintech.com/prod_a2e_pro.htm > > 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 Fri, Feb 26, 2010 at 8:43 PM, Harpreet Singh Gujral > wrote: > > Hi Guys, > > > > Can somebody post the link for able2extract software. I guess the > > software would be helpful in converting pdf to different forms > > i.e. .xls or .doc etc. > > > > Thanks > > Harpreet > > > > > > On Feb 26, 2:11 pm, ankur wrote: > >> hi anil > >> this is not a excel file > >> its a software to convert files > >> > >> able2extract professional version > >> u can download that on from internet > >> 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 Fri, Feb 26, 2010 at 12:04 PM, anil panchal > wrote: > >> > Share With Exe File Please > >> > >> > Regards > >> > Anil Kumar > >> > >> > On Fri, Feb 26, 2010 at 12:02 PM, ankur > wrote: > >> > >> >> ya sure > >> >> this is the code > >> > >> >> 127418901528 > >> > >> >> 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 Fri, Feb 26, 2010 at 11:43 AM, Harshad K > >> >> wrote: > >> >> > can you share with me > >> > >> >> > regards > >> >> > harshad > >> > >> >> > On Fri, Feb 26, 2010 at 12:21 PM, ankur > wrote: > >> > >> >> >> i got the code > >> > >> >> >> thnks > >> >> >> 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, Feb 23, 2010 at 4:02 PM, ankur > wrote: > >> >> >> > hi experts, > >> >> >> > i had one pdf file converter > >> >> >> > pdf to different type of file like word, excel etc, i got that > >> >> >> > software from this group > >> > >> >> >> > software name is able2extract > >> >> >> > somebody had mail the code also > >> > >> >> >> > i lost that mail and code > >> >> >> > can anybody send me code again > >> > >> >> >> > it will be very helpful to me > >> > >> >> >> > Have A Nice Time & Enjoy Life > >> > >> >> >> > Regards: > >> >> >> > CMA Ankur Pandey > >> >> >> > (Someone Different) > >> > >> >> >> > I'm not the best but i'm not like the rest~~ > >> > >> >> >> -- > >> > >> >> >> > ------ > >> >> >> Some important links for excel users: > >> >> >> 1. Follow us on TWITTER for tips tricks and links : > >> >> >>http://twitter.com/exceldailytip > >> >> >> 2. Join our Facebook Group @ > >> >> >>http://www.facebook.com/group.php?gid=287779555678 > >> >> >> 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 > >> > >> >> >> <><><><><><><><><><><><><><><><><><><><><><> > >> >> >> HELP US GROW !! > >> > >> >> >> We reach over 6,800 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 > >> > >> >> > -- > >> > >> >> > > ------ > >> >> > Some important links for excel users: > >> >> > 1. Follow us on TWITTER for tips tricks and links : > >> >> >http://twitter.com/exceldailytip > >> >> > 2. Join our Facebook Group @ > >> >> >http://www.facebook.com/group.php?gid=287779555678 > >> >> > 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 > >> > >> >> > <><><><><><><><><><><><><><><><><><><><><><> > >> >> > HELP US GROW !! > >> > >> >> > We reach over 6,800 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 > >> > >> >> -- > >> > >> >> >
Re: $$Excel-Macros$$ Dependent drop down lists
Excellent Dave!
Simply superb.
On Sat, Feb 27, 2010 at 6:25 PM, Dave Bonallack
wrote:
> Hi,
> Does the attached do what you need?
> Regards - Dave.
>
> > Date: Fri, 26 Feb 2010 15:31:13 -0800
> > Subject: Re: $$Excel-Macros$$ Dependent drop down lists
> > From: harsha...@gmail.com
> > To: excel-macros@googlegroups.com
>
> >
> > Both the solutions are not what I am looking for...what I am looking
> > for is my exampleI think it is very clear.
> > Unlike these solutions, mine are always one-to-one relationship.
> >
> > On Feb 24, 12:29 am, santosh bahuguna
> > wrote:
> > > Create Multiple Range of you data
> > >
> > > Let suppose
> > > we Have
> > >
> > > A C
> > > A D
> > > A E
> > > B F
> > > B G
> > > B H
> > >
> > > Give the Name A1:A6 MAIN SOURCE
> > >
> > > GIVE Name the B1:B3 as A
> > > GIVE Name the B4:B6 as B
> > >
> > > select the Column where you want to show main SOURCE
> > >
> > > and in sub menu Give Formula of =Indirect("Range of the data in bases
> of you
> > > want to display LIke A or B")
> > >
> > > Regards
> > > Santosh Bahuguna
> > >
> > >
> > >
> > > On Tue, Feb 23, 2010 at 10:12 PM, Vinod N wrote:
> > > > Hi Hanum,
> > >
> > > > Please find attached the Solution provided by one of the Gurus for a
> > > > query similar to the one posted by you...
> > >
> > > > Use the attached.. in the meantime, Gurus will provide you with exact
> > > > solution
> > > > if possible send us a sample file for exact query...
> > >
> > > > Vinod
> > >
> > > > On Tue, Feb 23, 2010 at 11:28 PM, Hanum wrote:
> > > > > I have a unique problem that I need your help. Here it is:
> > >
> > > > > There is a list of some numbers and names associated with each of
> the
> > > > > numbers. There are two drop down lists for a user to pick from -
> one
> > > > > drop down for the numbers and another for the names. When a user
> > > > > selects a particular number from the number drop down, I want the
> the
> > > > > name drop down to show the correspsonding name. That's not all -
> when
> > > > > the user selects a particular name from the name drop down, the
> number
> > > > > drop down to show the correspsonding number.
> > >
> > > > > Here's an example: 01,.,15 are in drop down A, and
> > > > > Arizona,,Virginia are in drop down B. When I select 05 from
> drop
> > > > > down A, the drop down B should update to New Mexico. Next, if I go
> to
> > > > > drop down B and change the current value 'New Mexico' to say
> > > > > 'Virginia', drop down A should change to 15.
> > >
> > > > > 01 Arizona
> > > > > 03 California
> > > > > 05 New Mexico
> > > > > 10 New York
> > > > > 15 Virginia
> > >
> > > > > Please help.
> > >
> > > > > --
> > >
> > > >
> ------
> > > > > Some important links for excel users:
> > > > > 1. Follow us on TWITTER for tips tricks and links :
> > > >http://twitter.com/exceldailytip
> > > > > 2. Join our Facebook Group @
> > > >http://www.facebook.com/group.php?gid=287779555678
> > > > > 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
> > >
> > > > > <><><><><><><><><><><><><><><><><><><><><><>
> > > > > HELP US GROW !!
> > >
> > > > > We reach over 6,800 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
> > >
> > > > --
> > > > Thanks and Regards
> > >
> > > > Vinod N
> > >
> > > > --
> > >
> > > >
> ------
> > > > Some important links for excel users:
> > > > 1. Follow us on TWITTER for tips tricks and links :
> > > >http://twitter.com/exceldailytip
> > > > 2. Join our Facebook Group @
> > > >http://www.facebook.com/group.php?gid=287779555678
> > > > 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
> > >
> > > > <><><><><><><><><><><><><><><><><><><><><><>
> > > > HELP US GROW !!
> > >
> > > > We reach over 6,800 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- Hide quoted
> text -
> > >
> > > - Show quoted text -
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks
Re: $$Excel-Macros$$ VBA Help
Hi Chethan, Finance, Consulting - Analytics industries (KPO-BPO) uses VBA most, and I would suggest you to update your resume in some top job portals and then you'll automatic receive job opportunities. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 2/10/10, chethan Bhadravathi wrote: > > Hi Everybody, > > > i want to know which industry use VBA for excel programming most.? > > > So that i can apply for jobs who does VBA excel programming and also > suggest me the links or websites to apply jobs for VBA excel programming. > > > > Thanks in advance. > > > > Regards, > Chethan > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 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 > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 6,800 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
Re: $$Excel-Macros$$ Dependent drop down lists
What I understand from Hanum's query is:
He wants two drop down lists which are actually dependent on EACH OTHER.
Code no. should be changed on the basis of Names and,
Names should be changed on the basis of Code nos.
Now the problem is -
When we change the code no. it should show the city name (okay till this
far) but as soon as we change the city name, the code no. should get changed
according to new city name selected, and when code no. got changed, it
should show a new city name againand this goes on...
Hanum,
If you want the corresponding results in separate lists, I can do
thatbut both in same two lists is I am afraid beyond my knowledge.
Regards,
AJ
On Sat, Feb 27, 2010 at 3:00 PM, Christopher Luka <
christopher.l...@gmail.com> wrote:
> Check out the attached file. I think it will meet your requirements, and
> no VBA required.
>
>
> On Fri, Feb 26, 2010 at 11:25 PM, ankur wrote:
>
>> hi hanum
>> plz attach a sample file
>> so it will more easy for us to help u
>>
>> 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 Sat, Feb 27, 2010 at 5:01 AM, Hanum wrote:
>> > Both the solutions are not what I am looking for...what I am looking
>> > for is my exampleI think it is very clear.
>> > Unlike these solutions, mine are always one-to-one relationship.
>> >
>> > On Feb 24, 12:29 am, santosh bahuguna
>> > wrote:
>> >> Create Multiple Range of you data
>> >>
>> >> Let suppose
>> >> we Have
>> >>
>> >> A C
>> >> A D
>> >> A E
>> >> B F
>> >> B G
>> >> B H
>> >>
>> >> Give the Name A1:A6 MAIN SOURCE
>> >>
>> >> GIVE Name the B1:B3 as A
>> >> GIVE Name the B4:B6 as B
>> >>
>> >> select the Column where you want to show main SOURCE
>> >>
>> >> and in sub menu Give Formula of =Indirect("Range of the data in bases
>> of you
>> >> want to display LIke A or B")
>> >>
>> >> Regards
>> >> Santosh Bahuguna
>> >>
>> >>
>> >>
>> >> On Tue, Feb 23, 2010 at 10:12 PM, Vinod N wrote:
>> >> > Hi Hanum,
>> >>
>> >> > Please find attached the Solution provided by one of the Gurus for a
>> >> > query similar to the one posted by you...
>> >>
>> >> > Use the attached.. in the meantime, Gurus will provide you with exact
>> >> > solution
>> >> > if possible send us a sample file for exact query...
>> >>
>> >> > Vinod
>> >>
>> >> > On Tue, Feb 23, 2010 at 11:28 PM, Hanum wrote:
>> >> > > I have a unique problem that I need your help. Here it is:
>> >>
>> >> > > There is a list of some numbers and names associated with each of
>> the
>> >> > > numbers. There are two drop down lists for a user to pick from -
>> one
>> >> > > drop down for the numbers and another for the names. When a user
>> >> > > selects a particular number from the number drop down, I want the
>> the
>> >> > > name drop down to show the correspsonding name. That's not all -
>> when
>> >> > > the user selects a particular name from the name drop down, the
>> number
>> >> > > drop down to show the correspsonding number.
>> >>
>> >> > > Here's an example: 01,.,15 are in drop down A, and
>> >> > > Arizona,,Virginia are in drop down B. When I select 05 from
>> drop
>> >> > > down A, the drop down B should update to New Mexico. Next, if I go
>> to
>> >> > > drop down B and change the current value 'New Mexico' to say
>> >> > > 'Virginia', drop down A should change to 15.
>> >>
>> >> > > 01 Arizona
>> >> > > 03 California
>> >> > > 05 New Mexico
>> >> > > 10 New York
>> >> > > 15 Virginia
>> >>
>> >> > > Please help.
>> >>
>> >> > > --
>> >>
>> >> >
>> ------
>> >> > > Some important links for excel users:
>> >> > > 1. Follow us on TWITTER for tips tricks and links :
>> >> >http://twitter.com/exceldailytip
>> >> > > 2. Join our Facebook Group @
>> >> >http://www.facebook.com/group.php?gid=287779555678
>> >> > > 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
>> >>
>> >> > > <><><><><><><><><><><><><><><><><><><><><><>
>> >> > > HELP US GROW !!
>> >>
>> >> > > We reach over 6,800 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
>> >>
>> >> > --
>> >> > Thanks and Regards
>> >>
>> >> > Vinod N
>> >>
>> >> > --
>> >>
>> >> >
>> ------
>> >> > Some important links for excel users:
>> >> > 1. Follow us on TWITTER for tips tricks and links :
>> >> >http://twitter.com/exceldailytip
>> >> > 2. Join our Facebook Group @
>> >> >http://www.facebook.com/group.
Re: $$Excel-Macros$$ CENTRAL EXCISE REGISTERS
ANKURJI THANK YOU VERY MUCH On 2/27/10, ankur wrote: > > hi hari > check these files about excise > > > 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 Fri, Feb 26, 2010 at 6:38 PM, HARI NAIR > wrote: > > I am looking for Central Excise Registers, like RG-23A Part-!, II, RG-1 > > Registers in excel .If anybody have please post > > > > Thanks in advance > > > > -- > > > -- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > > http://twitter.com/exceldailytip > > 2. Join our Facebook Group @ > > http://www.facebook.com/group.php?gid=287779555678 > > 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 6,800 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 > > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 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 6,800 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 > > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 6,800 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
RE: $$Excel-Macros$$ Dependent drop down lists
Hi,
Does the attached do what you need?
Regards - Dave.
> Date: Fri, 26 Feb 2010 15:31:13 -0800
> Subject: Re: $$Excel-Macros$$ Dependent drop down lists
> From: harsha...@gmail.com
> To: excel-macros@googlegroups.com
>
> Both the solutions are not what I am looking for...what I am looking
> for is my exampleI think it is very clear.
> Unlike these solutions, mine are always one-to-one relationship.
>
> On Feb 24, 12:29 am, santosh bahuguna
> wrote:
> > Create Multiple Range of you data
> >
> > Let suppose
> > we Have
> >
> > A C
> > A D
> > A E
> > B F
> > B G
> > B H
> >
> > Give the Name A1:A6 MAIN SOURCE
> >
> > GIVE Name the B1:B3 as A
> > GIVE Name the B4:B6 as B
> >
> > select the Column where you want to show main SOURCE
> >
> > and in sub menu Give Formula of =Indirect("Range of the data in bases of you
> > want to display LIke A or B")
> >
> > Regards
> > Santosh Bahuguna
> >
> >
> >
> > On Tue, Feb 23, 2010 at 10:12 PM, Vinod N wrote:
> > > Hi Hanum,
> >
> > > Please find attached the Solution provided by one of the Gurus for a
> > > query similar to the one posted by you...
> >
> > > Use the attached.. in the meantime, Gurus will provide you with exact
> > > solution
> > > if possible send us a sample file for exact query...
> >
> > > Vinod
> >
> > > On Tue, Feb 23, 2010 at 11:28 PM, Hanum wrote:
> > > > I have a unique problem that I need your help. Here it is:
> >
> > > > There is a list of some numbers and names associated with each of the
> > > > numbers. There are two drop down lists for a user to pick from - one
> > > > drop down for the numbers and another for the names. When a user
> > > > selects a particular number from the number drop down, I want the the
> > > > name drop down to show the correspsonding name. That's not all - when
> > > > the user selects a particular name from the name drop down, the number
> > > > drop down to show the correspsonding number.
> >
> > > > Here's an example: 01,.,15 are in drop down A, and
> > > > Arizona,,Virginia are in drop down B. When I select 05 from drop
> > > > down A, the drop down B should update to New Mexico. Next, if I go to
> > > > drop down B and change the current value 'New Mexico' to say
> > > > 'Virginia', drop down A should change to 15.
> >
> > > > 01 Arizona
> > > > 03 California
> > > > 05 New Mexico
> > > > 10 New York
> > > > 15 Virginia
> >
> > > > Please help.
> >
> > > > --
> >
> > > ------
> > > > Some important links for excel users:
> > > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > > 2. Join our Facebook Group @
> > >http://www.facebook.com/group.php?gid=287779555678
> > > > 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
> >
> > > > <><><><><><><><><><><><><><><><><><><><><><>
> > > > HELP US GROW !!
> >
> > > > We reach over 6,800 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
> >
> > > --
> > > Thanks and Regards
> >
> > > Vinod N
> >
> > > --
> >
> > > ------
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > 2. Join our Facebook Group @
> > >http://www.facebook.com/group.php?gid=287779555678
> > > 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
> >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > HELP US GROW !!
> >
> > > We reach over 6,800 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- 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 Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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@go
Re: $$Excel-Macros$$ Dependent drop down lists
Check out the attached file. I think it will meet your requirements, and no
VBA required.
On Fri, Feb 26, 2010 at 11:25 PM, ankur wrote:
> hi hanum
> plz attach a sample file
> so it will more easy for us to help u
>
> 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 Sat, Feb 27, 2010 at 5:01 AM, Hanum wrote:
> > Both the solutions are not what I am looking for...what I am looking
> > for is my exampleI think it is very clear.
> > Unlike these solutions, mine are always one-to-one relationship.
> >
> > On Feb 24, 12:29 am, santosh bahuguna
> > wrote:
> >> Create Multiple Range of you data
> >>
> >> Let suppose
> >> we Have
> >>
> >> A C
> >> A D
> >> A E
> >> B F
> >> B G
> >> B H
> >>
> >> Give the Name A1:A6 MAIN SOURCE
> >>
> >> GIVE Name the B1:B3 as A
> >> GIVE Name the B4:B6 as B
> >>
> >> select the Column where you want to show main SOURCE
> >>
> >> and in sub menu Give Formula of =Indirect("Range of the data in bases of
> you
> >> want to display LIke A or B")
> >>
> >> Regards
> >> Santosh Bahuguna
> >>
> >>
> >>
> >> On Tue, Feb 23, 2010 at 10:12 PM, Vinod N wrote:
> >> > Hi Hanum,
> >>
> >> > Please find attached the Solution provided by one of the Gurus for a
> >> > query similar to the one posted by you...
> >>
> >> > Use the attached.. in the meantime, Gurus will provide you with exact
> >> > solution
> >> > if possible send us a sample file for exact query...
> >>
> >> > Vinod
> >>
> >> > On Tue, Feb 23, 2010 at 11:28 PM, Hanum wrote:
> >> > > I have a unique problem that I need your help. Here it is:
> >>
> >> > > There is a list of some numbers and names associated with each of
> the
> >> > > numbers. There are two drop down lists for a user to pick from -
> one
> >> > > drop down for the numbers and another for the names. When a user
> >> > > selects a particular number from the number drop down, I want the
> the
> >> > > name drop down to show the correspsonding name. That's not all -
> when
> >> > > the user selects a particular name from the name drop down, the
> number
> >> > > drop down to show the correspsonding number.
> >>
> >> > > Here's an example: 01,.,15 are in drop down A, and
> >> > > Arizona,,Virginia are in drop down B. When I select 05 from drop
> >> > > down A, the drop down B should update to New Mexico. Next, if I go
> to
> >> > > drop down B and change the current value 'New Mexico' to say
> >> > > 'Virginia', drop down A should change to 15.
> >>
> >> > > 01 Arizona
> >> > > 03 California
> >> > > 05 New Mexico
> >> > > 10 New York
> >> > > 15 Virginia
> >>
> >> > > Please help.
> >>
> >> > > --
> >>
> >> >
> ------
> >> > > Some important links for excel users:
> >> > > 1. Follow us on TWITTER for tips tricks and links :
> >> >http://twitter.com/exceldailytip
> >> > > 2. Join our Facebook Group @
> >> >http://www.facebook.com/group.php?gid=287779555678
> >> > > 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
> >>
> >> > > <><><><><><><><><><><><><><><><><><><><><><>
> >> > > HELP US GROW !!
> >>
> >> > > We reach over 6,800 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
> >>
> >> > --
> >> > Thanks and Regards
> >>
> >> > Vinod N
> >>
> >> > --
> >>
> >> >
> ------
> >> > Some important links for excel users:
> >> > 1. Follow us on TWITTER for tips tricks and links :
> >> >http://twitter.com/exceldailytip
> >> > 2. Join our Facebook Group @
> >> >http://www.facebook.com/group.php?gid=287779555678
> >> > 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
> >>
> >> > <><><><><><><><><><><><><><><><><><><><><><>
> >> > HELP US GROW !!
> >>
> >> > We reach over 6,800 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- 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/exce
