Search results

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

Hui, AS you know, Columns C is schedule and Column B is Forecast or actual if filled; I want to apply similar for Column B but its results does not returns: For example, for UT In April forecast values were 3 and actual are also 3. However, For May Forecast Values were 10 and Actual value...

Just to let you know range of B and C columns probably be $B$2:$B$6000 and $C$2:$C$6000.

Hello Hui, Thanks for your time to help me on my problem. As I said, I deleted some columns from the sheet for some reasons. In my Sample workbook there are three sheets, 1. Purchase - Column A contains order numbers, Column B contain date if date cell is not colored it means it is forecast...

Thank you so much, Hui. please see link below for the sample file. I have deleted some data but file still contains enough information what I request in my threat. However, columns name has been changed because of those deletion. http://www.2shared.com/document/vbt1vepf/Orders_-_Sample.html...

Hello Everyone, I am trying to develop a monthly report in Excel 2003 (solution has to work in 2003), I have a sheet named "Purchase" Columns M is with forecast date (format 01-Mar-12) but when cell background is filled with color (color can be different based of buyer choice) which means...