Re: $$Excel-Macros$$ Want conditional lookup

Dear Laxman, PFA. On Wed, Jul 24, 2013 at 11:13 AM, LAKSHMAN PRASAD wrote: > Dear Expert, > Want conditional lookup from sheet 1 those data which is active in column > A , plz the attached file > ** > Thanks, > Regards > LAKSHMAN > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? A

$$Excel-Macros$$ Want conditional lookup

Dear Expert, Want conditional lookup from sheet 1 those data which is active in column A , plz the attached file   Thanks, Regards LAKSHMAN -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://ww

Re: $$Excel-Macros$$ Re: NEED FORMUALE TO PLACE DIFFERENT TYPE OF BOTTLES IN ROWS (NO DIFFERENT BOTTLES ON SAME ROW)

Great! This is it! Thanks Deepak,you are a genius Regards Vijay Yadav On Mon, Jul 22, 2013 at 2:53 PM, Deepak Barnwal wrote: > Dear Vijay > > PFA > > regards > > Deepak > > > On Mon, Jul 22, 2013 at 2:08 PM, vijay yadav > wrote: > >> Dear Excel experts, >> >> Kindly help >> >> >> Regards >

Re: $$Excel-Macros$$ spit varios sheets of one excel file to related other excel file

Dear Priti, I want to copy sheet in specific sheets & not make new sheets. This macro is creating new sheets. Thanks & Regards, sagar On Mon, Jul 22, 2013 at 6:41 PM, priti verma wrote: > Try this code > Change Strpath as per your Path > > Sub creatnewWkb() > Dim wkb As Workbook > Dim strpa

Re: $$Excel-Macros$$ doubt with regard to change event of the combo

Dear Abhishek thank u for replying. if for example i selected gp 1900 then the value of paycode is 06 and payband code as B1 On Mon, Jul 22, 2013 at 12:58 PM, Abhishek Jain wrote: > What is your criteria? > > Suppose I select one value in gp combo, what values should be selected in > the other

Re: $$Excel-Macros$$ doubt with regard to change event of the combo

Hi,   Simply put your code in change event of GB combobox. From: Abhishek Jain To: excel-macros@googlegroups.com Sent: Monday, July 22, 2013 12:58 PM Subject: Re: $$Excel-Macros$$ doubt with regard to change event of the combo What is your criteria? Suppos

Re: $$Excel-Macros$$ Excel Gurus :- Please Help me out for the formula for amount distribution

You're welcome, glad to know it solve the problem Have a good days Pada 24/07/2013 1:34, Vishwanath menulis: Dear Mr.DP.. Awesome... I admire it. You have reduced my whole day effort to few minutes.. My heart filled thanks to you. Best regards Vishwanath On 23 July 2013 23:55, De Premor

Re: $$Excel-Macros$$ Excel Gurus :- Please Help me out for the formula for amount distribution

Dear Mr.DP.. Awesome... I admire it. You have reduced my whole day effort to few minutes.. My heart filled thanks to you. Best regards Vishwanath On 23 July 2013 23:55, De Premor wrote: > Ups Sorry, i dont make an error checking before > here is the rev code > > > =(EOMONTH(D$4,0)>$A5)*(D$4<

Re: $$Excel-Macros$$ Excel Gurus :- Please Help me out for the formula for amount distribution

Ups Sorry, i dont make an error checking before here is the rev code =(EOMONTH(D$4,0)>$A5)*(D$4<$B5)*IF(EOMONTH(D$4,0)>$B5,DAY($B5),DAY(EOMONTH(D$4,0))-IF(D$4<*=*$A5,DAY($A5),0))*($C5/($B5-$A5)) Rgds [dp] Pada 24/07/2013 1:15, Vishwanath menulis: Dear Mr.DP. Thanks a ton. Yes it computes on d

$$Excel-Macros$$ Re: Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet

Hi, The macro is doing exactly what I'm looking for, can you please add a condition to skip copy and past if the worksheetName = "RTA" Or worksheetName = "Pivot" Appreciate your help in advance. Thanks, Vijay On Monday, 22 July 2013 11:26:49 UTC-4, Vijay Gande wrote: > > Hi there, > > I'm

Re: $$Excel-Macros$$ Excel Gurus :- Please Help me out for the formula for amount distribution

Paste this in Cell G5, then copy left and down *=(EOMONTH(G$4,0)>$D5)*(G$4<$E5)*IF(EOMONTH(G$4,0)>$E5,DAY($E5),DAY(EOMONTH(G$4,0))-IF(G$4<$D5,DAY($D5),0))*($F5/($E5-$D5))** * Formula above will calculate on daily basis Rgds, [dp] Pada 23/07/2013 21:33, Vishwanath menulis: Dear Ashish, Thanks.

Re: $$Excel-Macros$$ Excel Gurus :- Please Help me out for the formula for amount distribution

Dear Ashish, Thanks. I was looking for similar solution. But data structure remains the same. But the amount should be distributed prorated for first month and last month.. For Example. In the first month... the amount should be proportion to number of days rather than equal distribution. in

$$Excel-Macros$$ Re: Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet

Awesome. I was Looking for it. Thanks guys. On Monday, July 22, 2013 8:56:49 PM UTC+5:30, Vijay Gande wrote: > Hi there, > > I'm amateur with excel macros and need help with the following task, > > I've an excel workbook with 16 sheets, all the sheets have same # of > columns but different # of

Re: $$Excel-Macros$$ Un protect the excel file

No problem, I wasn't trying to be "spiteful" or mean. I just wanted you to understand that what YOU may think of as a simple question may not be seen to others as quite so simple.   BTW:  I've been known to forget passwords too! I've got one application that's been running wonderfully for nearly 1

Re: $$Excel-Macros$$ Un protect the excel file

Thanks a lot. On Tue, Jul 23, 2013 at 5:22 PM, P.VIJAYKUMAR wrote: > Respected Prafull, > > There are password removing or breaking software.You Can use them.Here are > some links for their download.Password recovery software are also there. > http://www.straxx.com/ > http://asunsoft-excel-

Re: $$Excel-Macros$$ Un protect the excel file

Respected Prafull, There are password removing or breaking software.You Can use them.Here are some links for their download.Password recovery software are also there. http://www.straxx.com/ http://asunsoft-excel-password-remover.en.softonic.com/ http://www.password-find.com/excel_password.html?gc

Re: $$Excel-Macros$$ Un protect the excel file

Dear Paul Sir, Thanks for the information . I will search it by Google. Henceforth same will not happen again. Regards Prafull Jadhav. On Tue, Jul 23, 2013 at 5:13 PM, Paul Schreiner wrote: > See Forum Rules #3: > "Don't post questions regarding breaking or bypassing any security > measure." >

Re: $$Excel-Macros$$

thank you Paul. you cleared a concept, which was completely unknown to me. Regards, Waseem Saifi On Tue, Jul 23, 2013 at 5:07 PM, Waseem Saifi wrote: > Thank you so Much. > it is working absolutely fine. > awesome logic ! > > > > > On Tue, Jul 23, 2013 at 4:36 PM, Excel Learn wrote: > >> Dear

RE: $$Excel-Macros$$

Welcome friend :) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Waseem Saifi Sent: Tuesday, July 23, 2013 5:08 PM To: excel-macros Subject: Re: $$Excel-Macros$$ Thank you so Much. it is working absolutely fine. awesome logic ! On Tue, Jul 23

Re: $$Excel-Macros$$ Un protect the excel file

See Forum Rules #3: "Don't post questions regarding breaking or bypassing any security measure."   The problem is, there is no way for any of us to know if YOU actually own the file and are really the one that forgot the password.  Not that we're accusing you of lying, but how do we know?   Let's

$$Excel-Macros$$ Test mail

-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, F

Re: $$Excel-Macros$$

Thank you so Much. it is working absolutely fine. awesome logic ! On Tue, Jul 23, 2013 at 4:36 PM, Excel Learn wrote: > Dear Waseem, > > ** ** > > ** ** > > Please see, if its fine. > > ** ** > > ** ** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegr

Re: $$Excel-Macros$$ urgent help

Hi nayak..pls share the file.. On Jul 23, 2013 12:02 PM, "devanand nayak" wrote: > hi > i have one sheet which consists of data on daily basis for whole year > e.g. datecustomer name tin no net 12.5% vat 12.5% net 5% > vat 5% oms tranpsort total > > i need this with tinwise t

Re: $$Excel-Macros$$

*Simply Bravo!*​ Mr. Paul. On Tue, Jul 23, 2013 at 2:29 PM, Paul Schreiner wrote: > "these type of cases"? > I'm not sure your situation falls into a "type" of case. > > In YOUR case, Excel is interpreting your string "> 7 days" > as: GREATER than " 7 days" > or: GREATER THAN [space]7[space]"d

Re: $$Excel-Macros$$

"these type of cases"? I'm not sure your situation falls into a "type" of case.   In YOUR case, Excel is interpreting your string "> 7 days" as:  GREATER than " 7 days" or:  GREATER THAN [space]7[space]"days"   In your samples, your cells contain "0-3 Days", "4-7 Days" or "> 7 Days". In each case,

RE: $$Excel-Macros$$

Dear Waseem, Please see, if its fine. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Waseem Saifi Sent: Tuesday, July 23, 2013 2:26 PM To: excel-macros Subject: $$Excel-Macros$$ Dear Experts, Please look into attached file. I want to f

Re: $$Excel-Macros$$

Dear Anil, thanx for help, But I am already getting right output using pivot table. My concern is what's problem with countif. what's the issue in countif. does countif not reliable in these type of cases ! Thanks, Waseem Saifi On Tue, Jul 23, 2013 at 3:52 PM, Anil B wrote: > Hi Waseem, > > Ju

Re: $$Excel-Macros$$

Hi Waseem, Just use this formula u will get the results. =+GETPIVOTDATA(" Category ",$G$1," Category ","> 7 Days") Thanks, Anil On Tue, Jul 23, 2013 at 2:26 PM, Waseem Saifi wrote: > Dear Experts, > > Please look into attached file. I want to find out percentage of each > category. Using Pivo

Re: $$Excel-Macros$$ Un protect the excel file

Dear Sir, There is no any software for the same . I cant send the file as it contain important information. Regards, Prafull On Tue, Jul 23, 2013 at 2:37 PM, Ankit Mehra wrote: > Hi Prafull, > > Please send the file. > > > On Tue, Jul 23, 2013 at 11:30 AM, Prafull Jadhav > wrote: > >> Dear E

Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet

From: ravinder negi To: "Veerabomma, Naresh" ; "'excel-macros@googlegroups.com'" Sent: Tuesday, July 23, 2013 2:59 PM Subject: Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet _

Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet

From: ravinder negi To: "Veerabomma, Naresh" ; "'excel-macros@googlegroups.com'" Sent: Tuesday, July 23, 2013 2:58 PM Subject: Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet Hi Naresh earlier yo

Re: $$Excel-Macros$$ Un protect the excel file

Hi Prafull, Please send the file. On Tue, Jul 23, 2013 at 11:30 AM, Prafull Jadhav wrote: > Dear Experts, > > I have given password excel file but I have forget the password ..Is > there any way to recovery password. > > Thanks in advance. > > Regards, > Prafull Jadhav. > > -- > Are you =EXP(E

$$Excel-Macros$$

Dear Experts, Please look into attached file. I want to find out percentage of each category. Using Pivot table it is correct. But using Countif it is incorrect. please help Regards, Waseem Saifi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) !

Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet

From: ravinder negi To: "excel-macros@googlegroups.com" Sent: Tuesday, July 23, 2013 12:44 PM Subject: Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet PFA From: