$$Excel-Macros$$ Excel minor Puzzle

Dear All, There is the minor puzzle and answer too. Regards, Bhushan Sabbani. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

$$Excel-Macros$$ Re: Date Formula

Dear Nikhil, Please the attached solution file might help you. Regards, Bhushan Sabbani. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

Re: $$Excel-Macros$$ MS Excel MCQ Quiz

please paste the ans. also. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups

Re: $$Excel-Macros$$ Call Center Dashboards

Check the below site. It contain the KPI dashboard which you where looking for. http://chandoo.org/wp/2008/08/20/create-kpi-dashboards-excel-1/ Warm Regards Bhushan -- -- Some important links for excel users: 1. Fo

$$Excel-Macros$$ Recover delete file.

Sub Killed() Application.DisplayAlerts=False ThisWorkbook.ChangeFileAccess xlReadOnly Kill ThisWorkbook.FullName ThisWorkbook.Close False End Sub Thanks in advance. Bhushan Sabbani. -- -- Some important links for excel users: 1. Fo

$$Excel-Macros$$ Re: help in vba coding and excel function

Pls help in the query. Thank in advance. Bhushan. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http:/

$$Excel-Macros$$ help in vba coding and excel function

Dear Excel Expert and Ashish, pls look into the above excel file If I am changing the % value in Q1,Q2,Q3, Jan & Feb & Mar then total changes in B16 but I want the total to be as in b3 for that I have to < or > the % value in d2 -- -

$$Excel-Macros$$ Need macro code help regaring the pop up .

n again and again to select the selected file. I do not want the such pop up it should delete the file directly without any confirm or pop up. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important link

Re: $$Excel-Macros$$ Conditional formating help

Dear Sonu, Pls attach the solution file. Pls let me know was it helpful or any problem. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

$$Excel-Macros$$ Re: Open Excel addin is unavailable

Dear Adhish, Thank u very much. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join

$$Excel-Macros$$ Re: Open Excel addin is unavailable

Dear Ashish, Thank u very much. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join

Re: $$Excel-Macros$$ Re: Open Excel addin is unavailable

=7UqvmUcAAABeK1bCvIVb6K29sqTYZWWthiVAWnx9NyJFXKNtI9V7lZpobs5UV66bp34JBeMmF1cbzHe87USdioT9uNiA7PHaeV4duv6pDMGhhhZdjQlNAw If you would provide any other link then it would be helpful. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel

$$Excel-Macros$$ Re: Open Excel addin is unavailable

pls await for the help. I need that addin. any help will be greatful. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Lin

$$Excel-Macros$$ Open Excel addin is unavailable

=7UqvmUcAAABeK1bCvIVb6K29sqTYZWWthiVAWnx9NyJFXKNtI9V7lZpobs5UV66bp34JBeMmF1cbzHe87USdioT9uNiA7PHaeV4duv6pDMGhhhZdjQlNAw If you would provide any other link then it would be helpful. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

$$Excel-Macros$$ Re: need help!

Dear Syed, Pls attach the solution file. Pls let me know was it helpful or any problem. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ Re: Need Small Help to pull values based on the criteira!

Dear Sharma, You are welcome. If you need any other help let us know. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

Re: $$Excel-Macros$$ Urgent Formula Required Help me

attach the sample file so we can help you. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.lin

$$Excel-Macros$$ Re: Pivot table - Pivot tabel row Range

Kind attach the sample file. Kindly check the data you have select is correct or not. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip

$$Excel-Macros$$ Re: Help in formula to find the top 10 values

Thank for the same -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871

$$Excel-Macros$$ Re: Help in formula to find the top 10 values

Thank for the same -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871

Re: $$Excel-Macros$$ Help in formula to find the top 10 values

Thank for the same -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871

$$Excel-Macros$$ Re: formula or macro to convert dates

Dear, pls attached the sample file so we can help you. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

$$Excel-Macros$$ Re: Fwd: Use The Same Vlookup To Find Two Different Values

Your are welcome. I am glad that my solution helped out. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

$$Excel-Macros$$ Re: Help : Formula Required

Dear Myur, =IF(AND(TEXT(B19,"hh:mm")>"07:00",TEXT(B19,"HH:mm")<"17:00"),"NO","YES") You can use the above formula. Dear Akash, Pls attach the sample file. So we c

$$Excel-Macros$$ Re: Rolling 4 Quarter Cummulative Revenue

Dear Akash, Pls attach the sample file. So we can help you better. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

Re: $$Excel-Macros$$ Is there any carrer in excel.

Dear Anand, Thanks for the valuable advice. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

Re: $$Excel-Macros$$ Re: How to prevent from duplication in one work book

Dear Arya, How I had apply the conditional formatting for the one column you can apply to all the column where you needed.. Pls attached the sample file so i can get the brief knowledge of your data. Pls let me know i did solve the problem or not,. Warm Regards Bhushan Sabbani +91 98208 26012

Re: $$Excel-Macros$$ Is there any carrer in excel.

Thanks. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group

$$Excel-Macros$$ Re: How to prevent from duplication in one work book

Dear Arya, Please find the below attached file. Pls let me know any problem in the file. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

$$Excel-Macros$$ Re: Count of color fills

your are welcome, Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN

$$Excel-Macros$$ Re: Count of color fills

Dear sayyad, Please find the below attached file. Pls let me know any problem in the file. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for

$$Excel-Macros$$ Re: SubTotal and Insert Req

Dear Dave, Use can use the feature of subtotal (ALt+D+B) it automatic insert the subtotal. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

$$Excel-Macros$$ Re: hello all, its very urgent;;;

Dear Vijay, Please visit the site http://chandoo.org there is great dashboard along with the tip and trick for preparing the same. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel

Re: $$Excel-Macros$$ Is there any carrer in excel.

Dear Sanjoy, Thank for the same. Warm Regards Bhushan Sabbani +91 98208 26012* * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

$$Excel-Macros$$ Re: Help in Excel

Dear, Please find the attached solved file for the same. Please let me know was that solution helpful. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on

$$Excel-Macros$$ Re: Please Help

Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @

$$Excel-Macros$$ Re: i need a help

Dear Vijay, Pls find the solution file. Warm Regards, Bhushan Sabbani -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

$$Excel-Macros$$ Re: Please Help

Hi Sudhir, Use the below formula for the running balance =SUBTOTAL(9,$E$24:E25)-SUBTOTAL(9,$F$24:F25) I am not clear where are you getting the pending amount. Please clear the same so i can help regarding the same. Warm Regards, Bhushan Sabbani +91 98208 26012

$$Excel-Macros$$ Re: Need coding help!

HI Sandra, Please attached the example file so i can help you. The concept of your is clear if you provide the example file so i can the help. Warm Regards, Bhushan Sabbani +91 98208 26012 -- -- Some important