Recent content by shab

Thank you Narayan. Great Help. SHAB

Thanks for the explanation, Hui. For the item#4, actually for each category I have Quarters an Yearly I wanted to turn off monthly from Jan-Dec so that only quarterly and yearly data can be shown for each category. SHAB

OMG!Wow! Hui that is it!Now I know the new way to play with data in Chart! However, few questions to ask you to understand what you did better: 1. In "=IF($A5,OFFSET('All-in-One'!C$4,($A$2-1)*8+2,),NA())" What is "($A$2-1)*8+2" doing? 2. In...

Hello, I think I am lost, I can not figure out how to bring the data from "All-in-One" Sheet when selecting an option/radio and then have a check box for each item such as planned, planned-A etc. Please see attach and help me figure out that...

Thank you Hui for pointing out a clue to work. Let me see if I can do that.

Hello All, Here I am again with my Excel Learning Questions. So far this forum is helping me a lot to learn new Excel stuff and I must thank Hui and NARAYANK991. I tested the follower as per given instructions from http://chandoo.org/wp/2010/08/31/dynamic-chart-with-check-boxes/ and it...

I got that Narayan. Thank you again for your time and effort. SHAB

Thank you, Narayan. I am not sure what link to following to download the file. I can only view the file from the link above. Could you please let me know, where I can download that file. Also, I forgot to mention in my initial post that I am using Excel 2003. So solution needs to work in Excel 2003.

Hello All Please see following link for the sample file: http://www.2shared.com/file/5NZGVHPB/IFStatementProblem.html I am trying to develop a report (sheet name) based on "Order Total" sheet. User select year from drop down menu in F4 Cell from "Report". An adjacent cell value shall be...

Could you plese help m Hui to figure out why the above still does not give me Actual - meaning if there are 5 cells for May 201 and only 2 are filled with color. I want aboie to give me 2. It doesn' do that. I tried to play with he function I referred above but still no luck. your help will be...

Awesome!What I call "Greatooooooooooooo":) I will try that now.

Hui, Just wondering if you came across following CFColorIndex function that may resolve problem, I am having. When I try that I get #Value error. Any advice will be appreciated. http://www.xldynamic.com/source/xld.CFConditions.html .SHAB

I must Thanks, Hui too. He is very smart and prompt helping others. God Bless him.

Thanks again, Hui. I will see. The reason I was saying I may not be able to do that. Because, they have a macro built in with password protection. That macro is which connects to ERP ad get all requried data into workbook and does greyed out cell for Actual. Anyway, you help is very much...

Hui, I am getting #Name? Error when apply yours suggested formula for Column B. Actually,the file which I got is not under my control, at my work the same file is shared with several department. Therefore, I can not make any changes because Purchase sheet is filled by an internal ERP...