Re: $$Excel-Macros$$ Chart show & Hide-Request help for solution

Hi Deba Rajan, Thank very much for more time spend on my solution. Very Helpful and thanks again providing this helpful knowledge Regards Amar On Fri, Dec 14, 2012 at 12:16 PM, Deba Ranjan wrote: > Ok, i have not used any coding there just simple formula as well the combo > box. Please find

Re: $$Excel-Macros$$ formula without macro

Hello Swapnil Thanks for your Help. Rgds Rajesh On Thursday, December 13, 2012 4:04:34 PM UTC+5:30, Swapnil Palande wrote: > > Hi Rajesh, > > You can use "Indirect" function > > =VLOOKUP(A2,INDIRECT("'[bcm.xls]" & L2 & "'!$A:$B"),2,0) > > Pls find attach solution. > > Regards, > > Swapni

Re: $$Excel-Macros$$ Chart show & Hide-Request help for solution

I talk about second attachment (VBA Chart show & hide.xls) On Fri, Dec 14, 2012 at 12:01 PM, Deba Ranjan wrote: > i have send you two attachment, which you are taking about ? > > > > Thanks & Regards, > *Deba ranjan* > > > > > > > On Fri, Dec 14, 2012 at 11:56 AM, amar takale wrote: > >> De

$$Excel-Macros$$ Pie Charts

Respected Guru's, I have a curious question i.e why cannot pie chart represent two sets of values.For Example if I Take a table with Employee Name ,Salaries ,PF. I can get Pie Chart for only for only two sets of values only like Name & Salaries,Name & PF etc.Why do not we get a pie chart for mor

Re: $$Excel-Macros$$ Chart show & Hide-Request help for solution

i have send you two attachment, which you are taking about ? Thanks & Regards, *Deba ranjan* On Fri, Dec 14, 2012 at 11:56 AM, amar takale wrote: > Dear Deba > Again Thanks for help,if i want more than 3 chart show how to modify code. > > On Fri, Dec 14, 2012 at 11:44 AM, Deba Ranjan

Re: $$Excel-Macros$$ Chart show & Hide-Request help for solution

Dear Deba Again Thanks for help,if i want more than 3 chart show how to modify code. On Fri, Dec 14, 2012 at 11:44 AM, Deba Ranjan wrote: > Amar, > > > U can see this attachment also. PFA. might it will help you. > > > > Thanks & Regards, > *Deba ranjan* > > > > > > > On Fri, Dec 14,

Re: $$Excel-Macros$$ Chart show & Hide-Request help for solution

Thanks Amar !! Thanks & Regards, *Deba ranjan* On Fri, Dec 14, 2012 at 11:52 AM, amar takale wrote: > Dear Deba Rajan, > > First Congratulation for winner of Calendar quiz.Dear Deba which you send > file it is fantastic,Mind blowing,I like it very much.It is also > very usefu

Re: $$Excel-Macros$$ Chart show & Hide-Request help for solution

Dear Deba Rajan, First Congratulation for winner of Calendar quiz.Dear Deba which you send file it is fantastic,Mind blowing,I like it very much.It is also very useful our Excel user Group members. Regards Amar On Fri, Dec 14, 2012 at 11:24 AM, Deba Ranjan wrote: > Attachment missed..

Re: $$Excel-Macros$$ Chart show & Hide-Request help for solution

Attachment missed... Hi Amar, PFA the chart sheet, might it will help you out. -deba Thanks & Regards, *Deba ranjan* On Fri, Dec 14, 2012 at 11:23 AM, Deba Ranjan wrote: > Hi Amar, > > PFA the chart sheet, might it will help you out. > > > -deba > > > > > > Thanks & Rega

Re: $$Excel-Macros$$ Chart show & Hide-Request help for solution

Hi Amar, PFA the chart sheet, might it will help you out. -deba Thanks & Regards, *Deba ranjan* On Fri, Dec 14, 2012 at 11:05 AM, amar takale wrote: > Dear All Experts, > Can you help me above two file,last week you help me which is very > Helpful &knowledgeable for me.I lo

Re: $$Excel-Macros$$ Excel Query-(Appreciate the help)

Dear Pravin, Solution is Perfect as like me.How to do it, any logic for code (true & false) I will also try for 4th chart.And one more Chart is movable from here to there Can I fixed this one place. Thanks again Amar On Fri, Dec 14, 2012 at 10:38 AM, Pravin Gunjal wrote: > *Hi Amar,* > * > *

Fwd: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner.

*Dear Sir,* * * *It would be better, if you send those calenders to see.* *Thank you,* * * *Regards* *Pravin Gunjal* -- Forwarded message -- From: Paul Schreiner Date: Fri, Dec 14, 2012 at 12:41 AM Subject: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winn

$$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner.

Hi, It would be a lot better if we could see the calenders submitted. If required I can provide web space to host these files too. Warm regards, Anand Kumar On Sunday, 18 November 2012 21:53:29 UTC+5:30, Ayush Jain wrote: > > Dear members, > > Let's get set for the new year 2013 > > Here is inv

$$Excel-Macros$$ Re: Fw: Data validation to stop copy from above or any where!!

Hi Sandeep, Can you please share ur workbook so that i can understand your problem. Regards Prince On Thursday, December 13, 2012 10:13:29 PM UTC+5:30, sandeep chhajer wrote: > > Dear excel guru is there any way to make data validation effective in case > the source data is copied from other so

Re: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner. *

Congrats Winners :) Regards Prince On Friday, December 14, 2012 1:19:42 AM UTC+5:30, hilary lomotey wrote: > > Congratulations to the winners > Sent from my BlackBerry® smartphone from Airtel Ghana > -- > *From: * Paul Schreiner > > *Sender: * excel-...@googlegroups.c

Re: $$Excel-Macros$$ Macro Modification Needed To Include Start/Stop Time

My Pleasure.. You have given me new title. On Fri, Dec 14, 2012 at 12:57 AM, Bill Q wrote: > Just what the doctor ordered. Thank you very much Dr. Anoop. > > Much appreciated. > > > > On Thursday, December 13, 2012 1:59:22 AM UTC-5, Enrique Martin wrote: > >> Hi Bill, >> >> I have modif

Re: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner. *

Congratulations to the winners Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Paul Schreiner Sender: excel-macros@googlegroups.com Date: Thu, 13 Dec 2012 11:11:20 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Dynamic calendar q

Re: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner. *

Can we see all the calenders of participants? Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Paul Schreiner Sender: excel-macros@googlegroups.com Date: Thu, 13 Dec 2012 11:11:20 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Dyn

Re: $$Excel-Macros$$ Macro Modification Needed To Include Start/Stop Time

Just what the doctor ordered. Thank you very much Dr. Anoop. Much appreciated. On Thursday, December 13, 2012 1:59:22 AM UTC-5, Enrique Martin wrote: > Hi Bill, > > I have modified the code which will work within stipulated time as > described above. > I have also provided two command butt

$$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner.

Results of the recent Calendar Challenge are IN ! The competition was furious, and the judging, difficult. The goal was to create a calendar in excel using Functions ONLY (no user defined macros). The calendar should be displayed on a single sheet, and update dynamically for any given year. And

Re: $$Excel-Macros$$ FORMAT DATES IN USERFORM * *

SPOT ON PAUL. 120% ACCURATE .. VERY GRATEFUL On Thu, Dec 13, 2012 at 4:31 PM, Paul Schreiner wrote: > UserForm1.TextBox1.Value = Format(Now(), "dd-mmm-") -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titl

Re: $$Excel-Macros$$ Formula to Calculate Networkdays

Hi Manjunath, solved your query, please find the attachment. -- *Regards,* * * *Excel Beginner* * * On Thu, Dec 13, 2012 at 8:45 PM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > Hi experts, > > > > I want to calculate no of workdays and excludes holid

Re: $$Excel-Macros$$ HIGH LOW QUERY

Thanks Sent on my BlackBerry® from Vodafone -Original Message- From: Prince Sender: excel-macros@googlegroups.com Date: Thu, 13 Dec 2012 08:38:12 To: Reply-To: excel-macros@googlegroups.com Cc: Prince Kumar Subject: Re: $$Excel-Macros$$ HIGH LOW QUERY Hi Dhaval' PFA Regards Prince

Re: $$Excel-Macros$$ Formula to Calculate Networkdays

how did you (or did you) specify the holidays in the NetWorkdays function? Microsoft has no way of knowing what days YOU consider "holidays". Every country has their own "national" holidays. Employers may choose which of these holidays to "observe". So, Networkdays and NetWorkDays.intl have the a

$$Excel-Macros$$ Fw: Data validation to stop copy from above or any where!!

Dear excel guru is there any way to make data validation effective in case the source data is copied from other source! (As I have observed that data validation would not work in case some data is copied from other source!!! Please help! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone

Re: $$Excel-Macros$$ Formula to Calculate Networkdays

use this one =NETWORKDAYS(DATEVALUE("12/24/2012"), DATEVALUE("12/28/2012"),A:A ) Let Range A:A contains list of holidays On Thu, Dec 13, 2012 at 8:47 PM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > > > Hi experts, > > > > I want to calculate no of workdays and excludes hol

Re: $$Excel-Macros$$ FORMAT DATES IN USERFORM *

Thanks! Keep in mind that: Excel doesn't have "dates". What it DOES is allows us to DISPLAY a number (the number of days since 1/1/1900) in multiple ways. SOME of which represents a date! That being said, your userform doesn't have a Date. It has a Text box. the contents of this text box is a TE

Re: $$Excel-Macros$$ Slow down time in Processing Information *

use both code and keep your current code between them On Thu, Dec 13, 2012 at 9:44 PM, Hilary Lomotey wrote: > thanks chief , but which of the codes shd i use, you provided two > > On Thu, Dec 13, 2012 at 3:58 PM, Divaker Pandey wrote: > >> [image: Boxbe] This m

Re: $$Excel-Macros$$ Slow down time in Processing Information *

Chief, its work beautifully, you are great thanks On Thu, Dec 13, 2012 at 4:14 PM, Hilary Lomotey wrote: > thanks chief , but which of the codes shd i use, you provided two > > On Thu, Dec 13, 2012 at 3:58 PM, Divaker Pandey wrote: > >> [image: Boxbe] This messa

Re: $$Excel-Macros$$ Slow down time in Processing Information *

thanks chief , but which of the codes shd i use, you provided two On Thu, Dec 13, 2012 at 3:58 PM, Divaker Pandey wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (divake...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Slow down time in Processing Information

hi you can write some code on command button click with application .screenupdating=false .calculation= xlcaluationmanual end with -Prsent code-- with application .screenupdating=true .calculation= xlcaluationautomatic end with On Thu, Dec 13, 2012 at 9:16 PM, Hilary Lomo

$$Excel-Macros$$ Slow down time in Processing Information

Hello When i click on a command button on my userform, it takes close to 50 secs before the information is processed to the worksheet. what could be accounting for this. is there a way to minimize the time?. thanks -- Join official Facebook page of this forum @ https://www.facebook.com/discusse

$$Excel-Macros$$ Formula to Calculate Networkdays

Hi experts, I want to calculate no of workdays and excludes holiday For examples 24/12/2012 to 28/12/2012 and exclude 25th & 26 th as holiday I tried using =Networkdays but I was able to no of working days Please help me to Exclude holiday. Thanks Manjunath P

$$Excel-Macros$$ Formula to Calculate Networkdays

Hi experts, I want to calculate no of workdays and excludes holiday For examples 24/12/2012 to 28/12/2012 and exclude 25th & 26 th as holiday I tried using =Networkdays but I was able to no of working days Please help me to Exclude holiday. Thanks Manjunath PL

Re: $$Excel-Macros$$ FORMAT DATES IN USERFORM *

try this code Sub dateformat() UserForm1.Show UserForm1.TextBox1.Value = VBA.Format(VBA.Date, "DD-MMM-") End Sub On Thu, Dec 13, 2012 at 8:17 PM, Hilary Lomotey wrote: > sorry my bad > > PFA > > On Thu, Dec 13, 2012 at 2:27 PM, Paul Schreiner wrote: > >> [image: Boxbe]

Re: $$Excel-Macros$$ FORMAT DATES IN USERFORM *

sorry my bad PFA On Thu, Dec 13, 2012 at 2:27 PM, Paul Schreiner wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (schreiner_p...@att.net) Add cleanup > rule

Re: $$Excel-Macros$$ FORMAT DATES IN USERFORM

Hilary, Your file is in .xlsx format. As such, it does not contain your userform or macros. Please attach a .xlsb (or .xlsm) file so that we can assist you.   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the pla

$$Excel-Macros$$ FORMAT DATES IN USERFORM

Hello In the attached file, i need assistance to be able to enter dates in the format dd-mmm-yy, and also to alert the user to enter dates in that format, i want the textbox1 to always pick the current date but date should be editable. thanks -- Join official Facebook page of this forum @ htt

Re: $$Excel-Macros$$ Formula to Calculate Weeks

That is correct. # (days) / 7 (days/week) = # (weeks)   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley

Re: $$Excel-Macros$$ HIGH LOW QUERY

Need Data Range upto 99000 in this sheet data Range upto only 2000 me try to change Data Range but its dosent work Pls do need full Thanks Dhaval Shah 98240 35253 On Wed, Dec 12, 2012 at 10:43 PM, Prince wrote: > Hi Dhaval , > > Pls find Attached. > Regards > Prince > > On Wednesday, Dece

$$Excel-Macros$$ Edit Link Code -support

Dear all, I need to know how convert below code , so that any file path get replaced by below code ActiveWorkbook.ChangeLink Name:= "c:\USER\app\Management Level Adj..xlsm" _ , NewName:="Management Level Adj..xlsm", Type:=xlExcelLinks Regards, Prashant -- Join official Facebook pa

Re: $$Excel-Macros$$ Formula to Find Range of Date of transactions *

Hi Guys i managed to solve this thanks On Wed, Dec 12, 2012 at 1:27 PM, Hilary Lomotey wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (resp...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Conditional functions based on multiple criteria

Hi Steve, Not able to understand what exactly you want. Can you explain it with any example or provide what answer you want in saperate column and highlight fields you use to get that answer. So it will be easy to find way to do it. Regards, Swapnil. On Thu, Dec 13, 2012 at 1:20 AM, Steve Bluba

Re: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with manual protect / unprotect

Hi Pravin, Share your workbook. Regards Prince On Thursday, December 13, 2012 3:13:50 PM UTC+5:30, Pravin Gunjal wrote: > > Dear Prince, > > By doing the changes suggested by you, the macro is not working properly. > Pl confirm. > > Regards > Pravin. > > -- Forwarded message -- >

Fwd: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with manual protect / unprotect

Dear Prince, By doing the changes suggested by you, the macro is not working properly. Pl confirm. Regards Pravin. -- Forwarded message -- From: Prince Date: Thu, Dec 13, 2012 at 2:44 PM Subject: Re: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with manual protect / unp

Re: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with manual protect / unprotect

Hi Pravin, You should palce this code on Worksheet_Activate() event and befor udating the sheet protact it.For updating the sheet unprotact it from menu bar. regards Prince On Thursday, December 13, 2012 2:29:57 PM UTC+5:30, Pravin Gunjal wrote: > > Hi Prince > Then please let me know , ho

Fwd: $$Excel-Macros$$ i want use pivot table in multi sheet of excel 2007

*This link may help you :* http://www.contextures.com/excelfiles.html#Pivot *Regards* *Pravin.* -- Forwarded message -- From: SHAIL GROUPS Date: Thu, Dec 13, 2012 at 12:10 PM Subject: $$Excel-Macros$$ i want use pivot table in multi sheet of excel 2007 To: excel-macros@googlegrou

Re: $$Excel-Macros$$ Re: BOND Macro

Thanks alot Prince. Much appreciated. Regards, Boreh On 13 December 2012 11:59, Prince wrote: > Hi Kip, > > Just copy this function and paste it in your workbook. The bold one last > line i have updated into this. > > Function PRICE364(settlement As Date, maturity As Date, rate As Double, > yl

Fwd: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with manual protect / unprotect

Hi Prince Then please let me know , how can I do the changes. Regards Pravin. -- Forwarded message -- From: Prince Date: Thu, Dec 13, 2012 at 2:09 PM Subject: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with manual protect / unprotect To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Re: BOND Macro

Hi Kip, Just copy this function and paste it in your workbook. The bold one last line i have updated into this. Function PRICE364(settlement As Date, maturity As Date, rate As Double, yld As Double, redemption, frequency) 'Initialize Variables Dim COUPNCD As Date Dim COUPPCD As Date coup = 0

$$Excel-Macros$$ Re: Macro enabled sheet to be worked with manual protect / unprotect

Hi Pravin, Whenever you move from one cell to other Worksheet_SelectionChange event is called thats why it is not allowing you to update the sheet. Regards Prince On Thursday, December 13, 2012 1:24:00 PM UTC+5:30, Pravin Gunjal wrote: > > *Dear Friends,* > > * * > > *I am using the followin

Re: $$Excel-Macros$$ Conditional Formatting

Dear Anoop, Thanks great,Exactly I want.I try this many time but not successful how to extract arrow (Neutral) where it is in excel in symbol I got but it is half arrow then I use it two half arrow with merge with concatenate which is use in attached sheet.But now you send me perfect arrow if it is