Re: $$Excel-Macros$$ Help Please - Data sub validation

2013-05-21 Thread Abhishek Jain
Good job!!! On Tue, May 21, 2013 at 3:42 PM, Chaya wrote: > Thanks a lot priti. > > > Regards, > Chaya > > The excel learner :-) > > > On Tue, May 21, 2013 at 3:39 PM, priti verma wrote: > >> HI chaya, >> I hope this is what you're asking ... >> >> >> On Tue, May 21, 2013 at 2:59 PM, Chaya wro

Re: $$Excel-Macros$$ Help Please - Data sub validation

2013-05-21 Thread Chaya
Thanks a lot priti. Regards, Chaya The excel learner :-) On Tue, May 21, 2013 at 3:39 PM, priti verma wrote: > HI chaya, > I hope this is what you're asking ... > > > On Tue, May 21, 2013 at 2:59 PM, Chaya wrote: > >> Dear Priti, >> >>As always you did the great logical solution. Infact

Re: $$Excel-Macros$$ Help Please - Data sub validation

2013-05-21 Thread priti verma
HI chaya, I hope this is what you're asking ... On Tue, May 21, 2013 at 2:59 PM, Chaya wrote: > Dear Priti, > >As always you did the great logical solution. Infact i really don't > understand the formula used for data validation in Level2 (very huge long), > but i have got some more ideas o

Re: $$Excel-Macros$$ Help Please - Data sub validation

2013-05-21 Thread Chaya
Dear Priti, As always you did the great logical solution. Infact i really don't understand the formula used for data validation in Level2 (very huge long), but i have got some more ideas on this. Thanks a lot. Now i have small help modification in the attached sheet. Exapmle : If F2 changes

Re: $$Excel-Macros$$ Help Please - Data sub validation

2013-05-21 Thread priti verma
HI Chaya, PFA see if it helps, On Tue, May 21, 2013 at 9:42 AM, Chaya wrote: > Dear Experts, > > Please help in doing data sub validation. Please see the attached > sample. > > What ever I select in the Category No column, the same corresponding item > should be drop down in H Column. > >

$$Excel-Macros$$ Help Please - Data sub validation

2013-05-20 Thread Chaya
Dear Experts, Please help in doing data sub validation. Please see the attached sample. What ever I select in the Category No column, the same corresponding item should be drop down in H Column. Ex: if I select M then all the items of M should be drop down in the H column. What ever I sele

Fwd: $$Excel-Macros$$ Help Please

2012-12-16 Thread Pravin Gunjal
*Dear Sanjay* *Also use a meaningful subject's to your mails...* *Regards* *Pravin. * -- Forwarded message -- From: अनिल नारायण गवली Date: Mon, Dec 17, 2012 at 10:43 AM Subject: Re: $$Excel-Macros$$ Help Please To: excel-macros@googlegroups.com Dear Sanjay, U cannot give

Re: $$Excel-Macros$$ Help Please

2012-12-16 Thread अनिल नारायण गवली
Dear Sanjay, U cannot give same name to two sheets. And while inserting the default name will be "Sheet and the number ". II'm guessing that u want the name while inserting a blank sheet . a name which is defined by U and not the excel program. If i'm guessing right then logic is *Sub AddWorkshe

Re: $$Excel-Macros$$ Help Please

2012-12-16 Thread David Grugeon
Each sheet in a workbook has to have a different name from any other sheet in the same workbook. Subject to that constraint you can change the name of the inserted sheet after you have created it. Can you give more detail of what you are doing. Ie how you are inserting the sheet, what name you want

Re: $$Excel-Macros$$ Help Please

2012-03-31 Thread Bé Trần Văn
2012/3/31 NOORAIN ANSARI > Very useful link Ashish, Thanks to sharing with group > > > On Fri, Mar 30, 2012 at 9:37 PM, ashish koul wrote: > >> http://www.rondebruin.nl/ribbon.htm#Examples >> >> >> >> >> On Fri, Mar 30, 2012 at 9:33 PM, Divaker Pandey wrote: >> >>> >>> >>> On Fri, Mar 30, 2012 at

Re: $$Excel-Macros$$ Help Please

2012-03-30 Thread NOORAIN ANSARI
Very useful link Ashish, Thanks to sharing with group On Fri, Mar 30, 2012 at 9:37 PM, ashish koul wrote: > http://www.rondebruin.nl/ribbon.htm#Examples > > > > > On Fri, Mar 30, 2012 at 9:33 PM, Divaker Pandey wrote: > >> >> >> On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey wrote: >> >>> Plea

Re: $$Excel-Macros$$ Help Please

2012-03-30 Thread ashish koul
http://www.rondebruin.nl/ribbon.htm#Examples On Fri, Mar 30, 2012 at 9:33 PM, Divaker Pandey wrote: > > > On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey wrote: > >> Please help, >> >> >> On Thu, Mar 29, 2012 at 4:31 PM, Divaker Pandey wrote: >> >>> thanks for reply noorain >>> >>> But I wan

Re: $$Excel-Macros$$ help Please

2011-05-04 Thread Kabir....:-)
Dear Mahesh, May i know how this is possible. I want to learn it. Thanks in advance. Regards, Saroj. On Tue, May 3, 2011 at 10:58 PM, Mahesh parab wrote: > Hi > check attach, whether its as per u r requirement > > On Tue, May 3, 2011 at 8:29 PM, m7md.gmail wrote: > >> all, >> please i need

Re: $$Excel-Macros$$ help Please

2011-05-03 Thread Mahesh parab
Hi check attach, whether its as per u r requirement On Tue, May 3, 2011 at 8:29 PM, m7md.gmail wrote: > all, > please i need help to solve my problem > > if there cell i give it red color in another cell record the date whose i > colored 1st cell - if there any function make this > > > ** > * >

$$Excel-Macros$$ help Please

2011-05-03 Thread m7md.gmail
all, please i need help to solve my problem if there cell i give it red color in another cell record the date whose i colored 1st cell - if there any function make this ** * -- * Regards, Mohamed Mahmoud -- -

Re: $$Excel-Macros$$ Help, please, with debugging a function

2011-02-22 Thread DaveO
Dave, I use a version of this code to examine the "white space" in a file to see if it is empty- if empty, I delete that range, and reduce file size. So if the code locates a cell that is populated either with a number or formula, it moves the cell pointer to that cell so I can determine if that ce

RE: $$Excel-Macros$$ Help, please, with debugging a function

2011-02-18 Thread Dave Bonallack
Hi, The logic appears to be a bit weird: If Not IsEmpty(rCell) Or HasDependents(rCell) = True Then Range(rCell.Address).Select Exit Sub End If If the first cell in the selected range is not empty, or has dependents, then that cell is selected, and the sub exits. What do you actually want the ma

$$Excel-Macros$$ Help, please, with debugging a function

2011-02-18 Thread DaveO
I wrote some code to search a range of cells to locate non-blank cells and cells with dependents. (A clever contributor on these forums, Jim Cone, was pivotal- thank you, Jim!) I had this code running correctly at one point, but lost the file that contained the working code. I've tried to recreate

Re: $$Excel-Macros$$ help please urgently

2010-01-01 Thread kvc praveen kumar
Hi Ashish, I have not gone thru ur issue completely. But i thought this could help you. Did you try inserting this statement ON ERROR RESUME NEXT in the sub procedure defintion like this: *Sub Macro7() On Error Resume Next* I guess this would be sufficient. Regards, Praveen On Tue, Dec 29, 200

$$Excel-Macros$$ help please urgently

2009-12-31 Thread ashish koul
hi please check the attached query its urgent thanks a lot regards Ashish -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel

Re: FW: FW: $$Excel-Macros$$ Help Please

2009-09-05 Thread Dilip Pandey
> Prashant > > > > > > *From:* Dilip Pandey [mailto:dilipan...@gmail.com] > *Sent:* Friday, September 04, 2009 8:08 AM > *To:* prashant > *Cc:* excel-macros@googlegroups.com > *Subject:* Re: FW: FW: $$Excel-Macros$$ Help Please > > > > Hi Prashant, > >

RE: FW: FW: $$Excel-Macros$$ Help Please

2009-09-05 Thread prashant
09 8:08 AM To: prashant Cc: excel-macros@googlegroups.com Subject: Re: FW: FW: $$Excel-Macros$$ Help Please Hi Prashant, Attached workbook has the solution to your query. Sorry for the delay, yersterday I was occupied with some urgent priority work(s). Thanks. -- DILIP KUMAR PANDEY

RE: FW: $$Excel-Macros$$ Help Please

2009-09-02 Thread prashant
M To: prashant Cc: excel-macros@googlegroups.com Subject: Re: FW: $$Excel-Macros$$ Help Please Hi Prashant, You can use copy - paste special - transpose option and this will be taken care off in seconds. If your amount is going to change, then you can use formulation. let me know if you need

Re: FW: $$Excel-Macros$$ Help Please

2009-09-02 Thread Dilip Pandey
; > > Prashant > > > > *From:* Dilip Pandey [mailto:dilipan...@gmail.com] > *Sent:* Wednesday, September 02, 2009 5:38 PM > *To:* prashant > *Cc:* excel-macros@googlegroups.com > *Subject:* Re: FW: $$Excel-Macros$$ Help Please > > > > Hi Prashant, > > > >

Re: FW: $$Excel-Macros$$ Help Please

2009-09-02 Thread Dilip Pandey
mac...@googlegroups.com] *On Behalf Of *prashant > *Sent:* Tuesday, September 01, 2009 1:15 PM > *To:* excel-macros@googlegroups.com > *Cc:* dilipan...@gmail.com > *Subject:* $$Excel-Macros$$ Help Please > > > > Dear All, > > > > Ple

$$Excel-Macros$$ Help Please

2009-09-01 Thread prashant
Dear All, Please help as per attachment Thx in advance Regards, Prashant --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Vide

$$Excel-Macros$$ Help please

2009-08-18 Thread Sam K
Hello All I have small query regarding the use slope formula, attached is sheet for reference how the formula used. All I need to know is this correct process to use function or not secondly I need to know exact definition for auditions to let them understand what I try to represents them Tha

$$Excel-Macros$$ Help please

2009-08-16 Thread prashant pawle
Dear All Excel Gurus, Kindly help on the problem in the attached sheet. I need formula for ranking , punches as per day/time Regards, Prashant --~--~-~--~~~---~--~~ -- Some important