Flux rss
Search : in
By : Relevance Date Username
Statut : Not resolved

Excel: alphanumeric if then statements

  imainternforhcs, on Wednesday 28 May 2008 à 19:56:08
Hello,
I am setting up a database template for people who are not Excel trained and I am attempting to make the input easy for the users as well as myself when I begin analyzing the data. I am trying to an if-then statement or create a macro (I know nothing about macros) that will allow me to have the users select their county for a list validation and the county number appear the cell to the right of the county name.
like this

County County Number
Kioskea 67856

Any advice would be helpful.
Configuration: Windows XP
Firefox 2.0.0.14
Reply to imainternforhcs  Report this message to moderators

Résultats pour Excel: alphanumeric if then statements

Excel macro help please Hi guys, I have a excel document with several If statements. Everything I have figured out so far. But now I am sitting with a problem. The 1 sheet is about 10 - 15 pages long with info that has to be filled in (it's a compliance audit that the... en.kioskea.net/forum/affich-22135-excel-macro-help-please
Firmnual Help If cell is blank go to next ce Hello, EXCEL FORMULA If cell is not blank automatically look go to next cell (across) and if the cell has text in it the show the text ? I have 35 colums some have info (dates) and some do not I am trying to show the last intry in the colum at the... en.kioskea.net/forum/affich-26805-firmnual-help-if-cell-is-blank-go-to-next-ce
Batch loop to start excel.exe Hello, I am facing problem with one of my applicaiton exe file gets stop anytime and frequently. was trying to create batch file that will search for applicaiton exe file in process (exe file in tasklist eg. excel.exe), if find it will go in loop to... en.kioskea.net/forum/affich-30772-batch-loop-to-start-excel-exe

Résultats pour Excel: alphanumeric if then statements

Reference books for Java and C++Reference books for Java and C++ Online Links for beginners in C++ If you are a newbie to Java or C++, there are excellent online references to help you either to discover or progress in this programming sphere. Java is a useful... en.kioskea.net/faq/sujet-477-reference-books-for-java-and-c
What to do if a file cannot be deletedWhat to do if a file cannot be deleted How to get rid of the file? Solution 1: Ensure that the file/folder is not in use Solution 2: Run your system on Safe Mode Solution 3: Download or update your Antivirus program Solution 4: Use... en.kioskea.net/faq/sujet-292-what-to-do-if-a-file-cannot-be-deleted
Excel tips : How to insert date In an Excel cellExcel tips : How to insert date In an Excel cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press “CTRL”+ “;” in the chosen cell. To insert current... en.kioskea.net/faq/sujet-313-excel-tips-how-to-insert-date-in-an-excel-cell

Résultats pour Excel: alphanumeric if then statements

EXCEL HELP!Hello, i have two tabs other hidden I need to put in the â??other tabâ?? a column to show if any of the labels(column D) which are text names in there are in the hidden grp labels tab. I tried a if statement but I got, u couldnâ??t work it... en.kioskea.net/forum/affich-31800-excel-help
Conditional formatting with 4 IF statementsHello, I am trying to create a VBA code that will affect all cells from J2 to BZ1000. Column I shows the revised milestone date COlumn G shows the % complete COlumn F shows the RAG status Column J to BZ show a calendar (one week per column). I have 4... en.kioskea.net/forum/affich-25997-conditional-formatting-with-4-if-statements
Excel vba if first char of cell is 1 thenHello, I have a question about "if then" in excel vba I've been looking all over the web for an answer or example and now matter what code I try I cannot get the right syntax. I have a column named "code" which contains item codes and I want to... en.kioskea.net/forum/affich-19939-excel-vba-if-first-char-of-cell-is-1-then

Résultats pour Excel: alphanumeric if then statements

Download Excel ViewerWith Excel Viewer, you can open, view, and print Excel workbooks, even if you don't have Excel installed. You can also copy data from Excel Viewer to another program. en.kioskea.net/telecharger/telecharger-52-excel-viewer
Download ConnectCode Free Excel TrainingService Excel is an inevitable when they use Windows as Word is him. However her use is not of the most intuitive for the laymen. ConnectCode Free Excel Training is a program of study for introduction with Excel. It understands ten different... en.kioskea.net/telecharger/telecharger-568-connectcode-free-excel-training

Résultats pour Excel: alphanumeric if then statements

Spreadsheets - Data Entry A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics: a type, which means the intrinsic type of the data. There are generally three types of values: numeric values, for example 3.1415927, 58%,... en.kioskea.net/tableur/tabsaisie.php3
Spreadsheets - The Excel Interface Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel document is called a file... en.kioskea.net/tableur/tabinterface.php3