Re: $$Excel-Macros$$ Help for understanding VBA

2010-02-27 Thread Vijay Aggarwal
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 Differen

Re: $$Excel-Macros$$ Dependent drop down lists

2010-02-27 Thread Christopher Luka
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 t

$$Excel-Macros$$ Subtraction on variable size array

2010-02-27 Thread DeveloperMichael
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

Re: $$Excel-Macros$$ CHANGE IN DATE FORMAT IN EXCEL

2010-02-27 Thread rf1234 rf1234
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

Re: $$Excel-Macros$$ VBA Help

2010-02-27 Thread rf1234 rf1234
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

Re: $$Excel-Macros$$ Re: pdf converter software code needed (able2extract)

2010-02-27 Thread Nandkumar kakvipure
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: > h

Re: $$Excel-Macros$$ Dependent drop down lists

2010-02-27 Thread Abhishek Jain
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: exc

Re: $$Excel-Macros$$ VBA Help

2010-02-27 Thread Dilip Pandey
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 dil

Re: $$Excel-Macros$$ Dependent drop down lists

2010-02-27 Thread Abhishek Jain
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

Re: $$Excel-Macros$$ CENTRAL EXCISE REGISTERS

2010-02-27 Thread HARI NAIR
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:

RE: $$Excel-Macros$$ Dependent drop down lists

2010-02-27 Thread Dave Bonallack
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

Re: $$Excel-Macros$$ Dependent drop down lists

2010-02-27 Thread Christopher Luka
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 Dif