Hi there... having an excel issue, was curious if somoene here might help with the solution (if one exists)

I've recently learned how to do pull down menues. I have the following problem now.

I have a sheet that has the following 5 numbers in a row. Lets say "1 2 3 4 5". I create 5 pull down menus based on these rows of data. So, in the first box, I select 3. in the second box, I still have 5 options. What I would like to do is have a pull down menu for the second box updated to contain only "1 2 4 5". Does anyone know how to do this in excel? I've done some searching, but so far have not been successful in my quest.

On another question... is there a method to auto-sort with a pull down menu? Lets say I select 3. Next I select 2. Then 3 is auto-switched with 2. That possible?

thanks!

MrH

Another quick question... Is there a method for hiding a tab? Or perhaps making it viewable only by certain users?

I'm also wondering how difficult it is to defeat the "lock sheet" function.. is there an easy work around?

MrH

These are the links I have for excel....some may have nothing to do with what you are looking for but at least you have a reference.

http://lacher.com/toc.htm
http://www.excel-repair.com
http://www.digdb.com/
http://aitt.acadiau.ca/tutorials/Excel97/
http://www.office-addins.com/-excel-addins/advanced-excel-find-replace.html
http://www.k2e.com/ade/
http://www.ablebits.com/excel-find-replace-manager-addins/index.php
http://www.mvps.org/dmcritchie/excel/excel.htm
http://www.ozgrid.com/
http://www.engr.psu.edu/www/trg/TIPS/Tip-excl.htm
http://www.internet4classrooms.com/excel_advanced.htm
http://training.freeskills.com/courselibrary/category/52
http://www.siliconbeachtraining.co.uk/excel_training/advanced_excel_training_uk.htm

Going to look at some of the resource, but if you have a quick answer to this one, you could save me a few hours searching :)

I have a series of numbers in Excel. I need to have positive numbers with a + sign in front and negative numbers with a - sign in front. Its pretty easy, but my formulas are getting way too long to continue my method. Reaching max formula length.

Here is what I'm doing

=IF(H1 - H2 > 0, "+","") & H1 - H2

The effect of this is it forces a + in front of the evaluation. Thats fine, but I have to basically copy and calculate my formula twice. Once to get the sign and once to display. So, is there a workaround? I've looked in excel, and there is a SIGN(X) function, but it only give a binary telling if its negative. Any other quick fixes I'm not aware of yet?

For the negative i have the format set for numbers that are negative the negative sign automatically is in from of them. Simple formula 2-3= -1. As for forcing a plus sign I don't know. I have never had to do that.

I looked under the formating but I could not find anything that forces the plus sign. You may be able to right something in visual basic that ads plus sign's to any possitive numbers and add that to the formating tool. Not sure how well that would work but i know of a couple people that have used visual basic to do things similiar.

For the negative i have the format set for numbers that are negative the negative sign automatically is in from of them. Simple formula 2-3= -1. As for forcing a plus sign I don't know. I have never had to do that.

I looked under the formating but I could not find anything that forces the plus sign. You may be able to right something in visual basic that ads plus sign's to any possitive numbers and add that to the formating tool. Not sure how well that would work but i know of a couple people that have used visual basic to do things similiar.

Thanks. I had come to a similar conclusion. I've not worked with VB before, so I was hoping for something similiar, like a MAKESIGN function or something similar :) I guess its not going to be so easy. I've learned enough languages that VB should not be too hard to pick up.

What I am working on is not a rush thing, its just been a hobby for almost a year now. Been education with Excel too. I'll see about posting it here when its near a finished state. I know there is a little bit of a D&D crowd on MT, and there might be here too!

Yeah i am a d&d fan. I am interested in what you find that works. The negative should just go there because it is negative. I know the number format can have a negative like this (1), but you can have it formated as -1. I had a feeling you were using excel for a d & d reason.

I've finished up the sheets. the programming portion is finished at least. For the D&D crowd, I thought I'd try and post it... its not complete. The correct version is the Caladros Sheet. The Readme is a bit out of date too, but it might help if you want to use it to create some of your own characters.

Can anyone host the file for me? I can email directly if you send me a PM privately.

I'd like to see the file but give me a little time to settle in. I might fit somewhere in my forum if you don't mind putting it there.