$$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

$$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

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

Dear Expert, 1. Is there any carrer in excel,This there good demand for excel knowledge in reputed company. 2. Is any scope in further growth as MIS. 3. Is there any course or institute related to MIS. 4. Because i am in MIS feild for prv 1.5 years the above question have asked

Re: $$Excel-Macros$$ One lookup and different corresponding values

Hi, I am not finding any link from where i can upload my sample file. Regards. Bhushan On Feb 2, 2:11 pm, Manish wrote: > Thanks for valuable post. > Is it possible to hide the complete row based on lookup value?? > For example in your solution, if i lookup value x than i want to hide

$$Excel-Macros$$ Unable to upload sample file

Hi Expert, PLease assist me how can attach sample excel file to the new post. There is no link avaliable which can upload my sample file for the clear understanding of my problem. Warm Regards, Bhushan Sabbani

$$Excel-Macros$$ One lookup and different corresponding values

)), 2) y =INDEX($A$1:$B$6,SMALL(IF($A$1:$A$6=A13,ROW($A$1:$A$6)),ROW(4:4)),2) there I have to change the row(4:4) to row(1:1) to get the corresponding value of the y lookup manual. Regards Bhushan Sabbani 98208 26012

Re: $$Excel-Macros$$ Please help

Dear All, We use $ sign in formula to relative or absolute reference of the range. And we use $ sign if we want to show the the amount in dollar rate. On Jan 30, 1:10 am, Paul Schreiner wrote: > I'm assuming you mean in a Cell formula. > > the $ is an "anchor". > > Let's say you have a column of

$$Excel-Macros$$ Re: Read a cell contend of file1 and then find same in file2.

Just hyperlink the file using ctrl+k Suppose your are working on the file 1 you want to switch and in file 2 then you can just insert the hyperlink the in a1 of file 2 and refer to the file 1. Just by click you can jump to file 1. On Feb 1, 11:47 am, Tom wrote: > I hope there is an expert who ca

$$Excel-Macros$$ Re: Help Required

Hi, For that you need to define a key in the dump sheet in Column A - Merging data from cells in column B & C and then use sumif formula in Analysis sheet, For your reference I have done and attached excel sheet. Hope this is what you required... On 7/20/09, Steven Dsouza wrote: > Hi, > >