Search results

Hi Hafiz, I've uploaded a file in the below link. Is that what you were looking for? http://rapidshare.com/files/3299115436/Copy%20of%20Book3.xls Thanks, Sammy

dingdang, Check on the below link for an uploaded file. http://rapidshare.com/files/68853277/dingdang.xlsx Thanks, Sammy

Sorry, been out for a couple of days and saw your post only today. I've uploaded a sample in the link below. As i said before, it's all messy as i haven't done any clean up :) http://rapidshare.com/files/3366986634/Test.xlsx Thanks, Sammy

Finally figured it out. Had to do a lot of indirect lobbing from here to there and from there to here and so on. My worksheet is like the aftermath of a war now :)

I guess I'll just have to go with data validation instead of list boxes. Thanks to you both bobhc & SirJB7 for looking into this! Regards, Sammy

Well bobhc, the problem is I have lots of users accessing this dashboard with different restriction levels across different locations. Of course I can use the data validation option, but isn't there any other options in using the list boxes?

Hello Champs, I have 3 list boxes (to select Country, State, District) linked to each other. Under “country list box”, I have a list of country names and when one gets selected it shows corresponding states under “state list box”. State list box also has a list of states which upon selecting...

Perfect! Thanks a ton, Hui. Much appreciated.

Hello Champs! I have a dashboard that shows month to date and week to date information and there is not enough space to show all the values! Hence a slight problem for me. What I am looking for is to have a comment display the remaining information when a user hovers/selects the respective...

Yes, the list box is connected to a cell and gives a numerical value, and the cells in col A contain a vlookup formula Well, I used the below formula on top of my actual formula and it works fine when I change the locations, even though I ended up with a messy and LENGTHY formula :( Parts of...

I'm using a Form Menu List Box wherein I have a list of the locations. I did try using the file under different computers but with the same results.

Hi Luke, Yes, I am using 2007 and already tried the steps mentioned. It works fine, but not for long! Basically I have a dashboard which displays data for different locations in percentages and numbers for different parameters, I am using a list box to change locations to view that...

Hello! I have a question that I couldn't find by searching through other posts and have been stuck on this problem for hours. I have a row in a worksheet in which the value in cell A12 (and A13, A14, A15 till A61) contains either "P", "D" or "". Based on the value under column "A" i would...

Thank you, GCExcel. Worked like wonders... fabulous... Now I have some time left for me to read more of Chandoo's and learn more :) VERY VERY MUCH APPRECIATED...

Thank you, GCExcel. Worked like wonders... fabulous... Now I have some time left for me to read more of Chandoo's and learn more :)

This might sound silly/crazy/plain laziness :). I have 30-40 .csv files that I open using Excel, each containing some numbers in row 'A'. Is there any way that we can take a count of the number of rows in each file and have it updated in a separate workbook? What I am doing right now is...