Drop Down List

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel Misc
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Need your help Excel Worksheet/Form I have created a form on worksheet 1....I want to enter the data on worksheet 2 to automatically populate on the form in worksheet 1... but keep a running tally of the data in worksheet 2 which is the raw material..... example: in worksheet 2 column a1, would be the customer first name, column a2 would the customer phone number, column a3 would be the customer address, column a4 would be the customer city, state, zip..... as i enter the raw data from worksheet 2 to automatically populate into worksheet 1 (which I did - just fine) but now my problem is keeping the data in the ROWS column example: row 1 - customer name, customer phone, customer address, customer city state zip (across the top rows) to display in a spreadsheet format.... so that I can see that I have completed this form for this customer... thank you... Please let me know if you can assist me... I know that the form (worksheet 1) will change as the data from (worksheet 2) is enter, and that is fine.... i just want the data stay in the worksheet 2 as the spreadsheet.... so in the future, I can go to row 115 and see the data entered... I know someone knows how this is completed.. Tag: Drop Down List Tag: 802974
  - 2
    - Merging three cells into one I have four cells I want to merge into one cell. I have used the "=A1 & " " & B1 & " " & C1 & " " & D1 to combine them into one cell - but what do I use to tell it to not put a space if there is no middle initial or no suffix? Thanks A1 A2 A3 A4 John D. Ameen Kenneth E. Amos Jr. Brett Anderson Gregory T. Anderson Tag: Drop Down List Tag: 802966
  - 3
    - Replace NA with Null - Access 2003 I have a spreadsheet I am trying to import into Access 2003 and I keep coming across type mismatches. I have noticed that the previous user would place NA into a field if the information was not needed rather than just leaving it blank. When this comes to a field that is supposed to be a number, could this be causing my mismatch? If so, how can I replace those "NA"s with a Null value? Is there a way to do it accross the board all at one time? (Even if this is not the primary cause I would like to know how to do this anyway.) Thank you again for your help, I am deeply appreciative. Tag: Drop Down List Tag: 802965
  - 4
    - Excel Properties Tab on Doc Save Hi All, I have my properties tab popping up on every new document i save. It's prompting me for either a documnet Title. Does anyoe know of how to set a default for this area? Thanks to anyone who can give me some insight into this frustrating occurrance!!! Tag: Drop Down List Tag: 802964
  - 5
    - Click and drag How do I make a cell so it can repeatedly be clicked on and dragged over and over? FOr example I want a row of cells on the right that have 10 different "values or answers" and I want the user to be able to click on one of those and drag it into a cell in an adjacent spreadsheet. They may need to drag one answer several different times so I need those answers able to be dragged and still be there to be draged again. Hope this makes sense. Tag: Drop Down List Tag: 802963
  - 6
    - Table Formatting in Excel 2007 When I format a range of cells as a Table in Excel 2007 and then convert the table back to a range, the style formatting seems to get locked into the range. If I convert the range back to a Table, I can then not change the table style from the original one selected in the first table format. Any ideas? Lynn Trapp Application Developer/Trainer Tag: Drop Down List Tag: 802960
  - 7
    - Opening Excel 2003 in Outlook 2007 I just recieved a spreadsheet created with Excel 2003. I got it in Outlook 2007. I can open the sheet fine, but when I try to print it does not give me the option to print the entire workbook. Does anyone know anything about that? -- Being Wet on the Net Can be an Electrifrying XPerience. Tag: Drop Down List Tag: 802959
  - 8
    - TRYING TO COMBINE FORMULAS INTO AN "OR" FORMULA Iâ??m trying to create a formula that combines and evaluates two sub-formulas and returns a different result depending on which of the two evaluates to true. Here is a description of the two conditions and the formulas that work correctly for each condition: 1. If B1 is â??ETâ?? or â??ITâ??, â??YESâ?? is returned in A1 (otherwise â??NOâ??) =IF(OR(B1="ET",B1="IT"), "YES","NO") 2. If B1 is blank, then â??-â?? (that is just a dash) is returned in A1. =IF((ISBLANK(B1)),"-") What I cannot figure out is how to combine the two into one larger formula. The combination needs to be some kind of OR formula since one or the other of the two needs to calculate. Thanks for your assistance. -- William Tag: Drop Down List Tag: 802955
  - 9
    - Excel Spreadsheet I have created a form on worksheet 1....I want to enter the data on worksheet 2 to automatically populate on the form in worksheet 1... but keep a running tally of the data in worksheet 2 which is the raw material..... example: in worksheet 2 column a1, would be the customer first name, column a2 would the customer phone number, column a3 would be the customer address, column a4 would be the customer city, state, zip..... as i enter the raw data from worksheet 2 to automatically populate into worksheet 1 (which I did - just fine) but now my problem is keeping the data in the ROWS column example: row 1 - customer name, customer phone, customer address, customer city state zip (across the top rows) to display in a spreadsheet format.... so that I can see that I have completed this form for this customer... thank you... Please let me know if you can assist me... I know that the form (worksheet 1) will change as the data from (worksheet 2) is enter, and that is fine.... i just want the data stay in the worksheet 2 as the spreadsheet.... so in the future, I can go to row 115 and see the data entered... I know someone knows how this is completed.. Tag: Drop Down List Tag: 802953
  - 10
    - Conditional formatting won't update until cell is selected: Excel This applies to Excel 2007. I have a column full of values that have conditional formatting that says, if the value in this cell matches the value in cell $C$1, turn yellow. If I type a value in C1 that matches cell A6, for example, it won't turn yellow until I select cell A6, or edit data elsewhere in row 6. Tag: Drop Down List Tag: 802937
  - 11
    - conditional format using "OR"? I have a set of data, there are a few possible entries: S V A P E [NUMBER] T [NUMBER] A [NUMBER] I would like to have the S, V, and P cells all be one colour and the rest be another colour. How would I define the conditional formatting to make this work? thanks Tag: Drop Down List Tag: 802934
  - 12
    - is there a formula for working out vat without repeating *17.5% I know the formula for working out vat i.e =*17.5% is there a repeat formula for cells to work out vat automatically , a am using excel. Tag: Drop Down List Tag: 802932
  - 13
    - Excel comments unable to be edited I have an excel document created in XP Office Pro 2003 where I am unable to edit comments that have been entered into cells by other users. The document is not protected and the cells are not locked. I can use the work-around of doing the show/hide comment so it displays the entire comment all of the time, but my user does not want that. If I right-click and chose "Edit" Excel just doesn't respond. If I enter garbage information into a clean cell, then add a comment and then right-click the cell and hit Edit it will work correctly. I've tried saving the document as another name onto a personal drive and it continues to act odd like this. Any suggestions? Thanks in advance. Tag: Drop Down List Tag: 802931
  - 14
    - Excel converts string in CSV file as number A file named test.csv has one line in it: 16E035 This is an accounting code used at our university. If I open that file, Excel shows 1.6*10^36 in cell A1. If I specify that the value is a string: "16E035" Excel still converts it to 1.6*10^36. How should this value be entered in the file so Excel leaves it as a character string? Thanks for your help. Tag: Drop Down List Tag: 802922
  - 15
    - Word to Excel What's the easiest way to turn a Word "labels" file into an Excel file Tag: Drop Down List Tag: 802921
  - 16
    - save excel file in tiff format in 2007 How can I save as in tiff format using a 2007 excel file Tag: Drop Down List Tag: 802920
  - 17
    - Wildcard Character in IF formulas Is it possible to use wildcard characters in an IF formula? I tried =IF(OR(H8="E*",H8="R*")=TRUE,AA12,0) but this did not work. Any help would be appreciated Thanks! Tag: Drop Down List Tag: 802917
  - 18
    - $ use for what Tag: Drop Down List Tag: 802911
  - 19
    - Copy worksheet and rename sheet How can I copy a worksheet and rename at the same time? Tag: Drop Down List Tag: 802900
  - 20
    - Search for data and return multiple fields I have a massive spreadsheet of around 8,000 rows and tons of data. Is there a way I can set up a separate worksheet as a front sheet where I can type in the name of a company in a cell on the front sheet and it will search for the name of the company in the data sheet and pull it up along with all the other details of that company? My main issue is that I'd want to use "*" in the search field and that there may be multiple contacts for one company. Is there a way to start typing the text to search for and have the cell autofill from the list of company names? Using the filter option on the main data sheet would be best to find everything quickly, but this is for our salespeople so it needs to be as user friendly as possible and easy for them to print off. Tag: Drop Down List Tag: 802896
  - 21
    - excel sheet. what does the error "cannot shift cells off sheet" means? how can i rectify this? Tag: Drop Down List Tag: 802887
  - 22
    - Sheet renaming and use as data I have a file with about 80 worksheets. How can I create a list in another sheet that reflects all the sheet names Tag: Drop Down List Tag: 802879
  - 23
    - Save file as a .dwg or .dxf file Is there a way of saving a spreadsheet or a selected range as a .dwg or .dxf file? I am trying to copy a range from excel 2000 and insert it into a cad package. Ideally i would like this to be automatic therefore VBA code would be good. Tag: Drop Down List Tag: 802878
  - 24
    - Remove characters If I a have a anme like O'Brien or De La Hoya or Van-Basten, how do I remove the charcters from the names. I want my answer to be OBRIEN, DELAHOYA AND VANBASTER Tag: Drop Down List Tag: 802866
  - 25
    - auto caps lock hi, how to set outo caps loc (beside turn on caps lock button) at sepcifiy cell. if any latter enter into cell , he will change to caps lock . rgds ramzi Tag: Drop Down List Tag: 802862
- Next
  - 1
    - Identifying quarter to which a date belongs? how to identify the quarter to which the following date belongs '31/3/2007' in excel? please let me know what function i should apply on the cell to get the quarter. like in the above case answer comes out to be - 1. Thanks, Harsh Tag: Drop Down List Tag: 802861
  - 2
    - Display text at random Hi all... Can anyone please post a detailed way of how I can display text lines at random in a specific cell when I press a macro button. The text is pre-typed in the module I would assume. Also how can I set all this up to work together? It would a great help if anyone can assist. Thanks Tag: Drop Down List Tag: 802860
  - 3
    - Precedents Hi All, I am using sumif worksheet function in sheet I would like to give an example here... Apples 100 Apples 100 Mangos 150 Apples 10 I am using this formula in cell B5: =Sumif(A1:A4,A5,B1:B4) I just want that when I press Ctrl + [ in my sumif holding formula it select only those cell that meets my given criteria specification, rather select the range A1:B5. is there any way to this Tag: Drop Down List Tag: 802857
  - 4
    - Prevent filldown Can I use an event macro to prevent the user from using the fill handle on unprotected cells? The issue is data validation. Column B has a list validation. (For example: Tom1,Dick1,Harry1) If the user chooses "Tom1" from the drop-down list in cell B1, then uses the fill handle to fill down, B2 will read "Tom2", B3 will read "Tom3" etc, which is not prevented by data validation. Excel 2000. Thanks in advance Dave, Tag: Drop Down List Tag: 802854
  - 5
    - Conditional Format a cell in time increments I have a macro running a timestamp for cell "d" when I make a change to cell "c". How can I make it also change the cell colors of cell "d" after intervals of 8, 16 & 24 hours (yellow, orange, red)? Tag: Drop Down List Tag: 802849
  - 6
    - Find within an embedded document object Hi! I'm working with a large workbook (40+ worksheets, many of which of embedded Word document objects in them). When I do a search and/or replace on a word in the normal Excel workbook, the word is not located/identified within the document objects. Is there a way to set Excel so that it will include the embedded pieces in the search? Tag: Drop Down List Tag: 802845
  - 7
    - Array to Populate ListBox Problem I have a dynamic array that has two columns, i.e. myarray(7,0) Reading up on dynamic arrays, it seems like only the last column can be expanded. I'd like to populate a listbox using the array, hence something like: entry.listbox = myarray Only when this is done, it's the first column that's entered in the listbox, but I want the second column to be the one to populate the listbox. I could break it up into two arrays rather than one (and actually have), but am still curious to see if this is possible. Thanks. -np Tag: Drop Down List Tag: 802832
  - 8
    - Indirect and sumif functions with multiple workbooks I have one workbook that basically needs to use a sumif function with the sum range being an indirect reference to a named range. This works when the named range is in the same workbook as the sumif formula, but I am having trouble getting the sumif function to work using an indirect reference to a named range in a different workbook. I tried the following formula to no avail to reference the named range, assuming 'store alignment g1' and 'store alignment g2' refer to the other file's name and tab respecitvely: =SUMIF('[Total Country Data File (District & Store P&L).xls]IS Data'!$B$5:$B$40243,F3=SUMIF('[Total Country Data File (District & Store P&L).xls]IS Data'!$B$5:$B$40243,F3,(INDIRECT(("'["&'Store Alignment'!G1&".xls]"&'Store Alignment'!G2&"'!"Indirect(h1))))) Indirect H1 is on the sheet where my sumif formula is, and it is referring to a named cell range on the other open workbook (total country data file). Can you nest indirect formulas like this? Is there another way to sum a named range in another workbook? Tag: Drop Down List Tag: 802826
  - 9
    - Formula needed for adding every nth column on another sheet Hi I have tried everything I can think of but with no luck - can somebody please help. On sheet 2 I have all the data in columns from rows 1-20. On sheet 1 I want the total of the sums of every 3rd column. ie. Sheet 1: A1 = sum Sheet 2: A1:A20 Sheet 1: B1 = sum Sheet 2: D1:D20 Sheet 1: C1 = sum Sheet 2: G1:G20 and so on... Instead of manually entering all the formulas on Sheet 1 for the sum totals of every 3rd column, is there a formula I can enter in A1 on Sheet 1 and copy across the row? Thanks for any help!! Tag: Drop Down List Tag: 802819
  - 10
    - Saving email addresses from excel document I have an excel document with a great number of email addresses which I want to have put into my address book. I don't want to have to type them over. Is there a way to select and send them to the address book? Tag: Drop Down List Tag: 802814
  - 11
    - Create error message if number entered is greater than previous ce I want to create some sort of error message or warning if the user enters a number that is higher than the cell before it. How can this be done? Thanks! -Joe Lewis Tag: Drop Down List Tag: 802811
  - 12
    - Adding a range with three variables I have a spreadsheet that has site, job title and FTE. I want to add the FTE by site and job title. I use for two variables the sumif function but can not get it to work with three. For example, Site Job Title FTE Beaverton NP 1.0 Beaverton RN 0.8 Hillsboro NP 0.8 Hillsboro RN 1.0 etc. This list is longer that this but I need to add the total of FTE for a person who is a NP and works in Beaverton. Can someone help. Thanks. I have Excel 2003. -- Thank you. Tag: Drop Down List Tag: 802805
  - 13
    - Can't sum a series of numbers I copied two sets of numbers based on two different queries from the same source into a spreadhseet. The first set of numbers I copied into the spreadsheet will sum up fine. The second set of numbers will not sum. I tried reformatting the cells as number with 2 decimal places and then when I highlight the cells the bottom right tally shows a count not a sum as I'd expect. There are no $ signs, no commas, etc. and I have already tried reformatting the cells in various different number formats (number with 2 decimals, currency, etc.) and that doesn't help. If I manually type over the figure in the cell it will then be included in the sum total (without changing any formatting). This is a very large spreadsheet and it is not practical to retype everything. Is there a way to reformat the cells which I've not tried that might work? Any other suggestions to get them to total up? Thanks in advance for any help you can render. Tag: Drop Down List Tag: 802803
  - 14
    - Labels on data points in chart Is there a way to associate labels with data points in a series, and then have the data points appear on a chart? I don't want to directly apply the labels to the chart, but instead, I'd like to be able to maintain the data over a period of time, and add data points to the series. Each point would have a data label that would remain associated with the point, and would appear any time the graph is updated. Thanks. Tag: Drop Down List Tag: 802801
  - 15
    - auto group row and/or rows I would like to group the cells that are filled in column A automatically. If A2 is filled I would like it to be grouped. I also need to group cells A10-A15 together is they are filled. In this example I would have 2 different groupings of rows; A2 and A10-A15. Tag: Drop Down List Tag: 802798
  - 16
    - filling a single cell before the sum of the previous rows. In other spreadsheet programs, you would create a spreadsheet with the following information, row by row 21 10 15 15 1 then you would request a sum of the rows and wth some formatting it would look like this: 21 10 15 15 1 -- 62 where the - is, you would use \- and press enter to fill the single cell. Can this be done in any and or all versions of excel and how is this done. Tag: Drop Down List Tag: 802793
  - 17
    - Rounding by .05 I have a formula where the cell multiplies the answer of 100/60. I put the formula in as =A2*100/60 The answer comes out as 53.33333. I want the answer to round up to 53.35, when I add the roundup in front of the A2 to rounds up to 54.00, Can someone tell me how I can make it round to the nearest .05? Tag: Drop Down List Tag: 802791
  - 18
    - Selecting a range of cells in a macro Can anyone help me with this please. I have written an Excel (XP) macro that has to start by selecting a range based on the active cell and the 10 cells to its right. How do I put this into VBA code please? Thanks, V Tag: Drop Down List Tag: 802789
  - 19
    - how i can refer to cell in long formula go to another file ='C:\Documents and Settings\VENUS\Desktop\[1.xlsx]1'!$A$1 this is a formula in the specific cell but i have more than 150 files.xlsx and i have to merge it in one sheet can any one give me a way to make this idea possiable a b c d e 1 1xlsx 2.xlsx 3.xlsx 4.xlsx 5.xlsx 2 ='C:\Documents and Settings\VENUS\Desktop\[A1]1'!$A$1 3 ='C:\Documents and Settings\VENUS\Desktop\[B21]1'!$A$1 4 ='C:\Documents and Settings\VENUS\Desktop\[B3]1'!$A$1 that mean i will refer the name of the file in the furmula to the cell A1 B1 C1 etc. i have tried many ways but it doesn't run so kindly and expert tell me the way to do that with the file name and the sheet that i give (1) for it names also in the same way Tag: Drop Down List Tag: 802788
  - 20
    - MATCH() or VLOOKUP() across mutliple 65K sheets possible? 2003 Imported a large file into 3 Excel w/s. The w/s are identical in format. Is there a way to perform a VLOOKUP() or MATCH() across three 65K sheets? ANY other ideas? TIA EagleOne Tag: Drop Down List Tag: 802785
  - 21
    - remove spaces in front of text I need to remove the 4 and the 9 spaces after so my cell F55 will only read Educate patient/care giver regarding behavior modification program purpose, goals, and use in home/community environment instead of 4 Educate patient/care giver regarding behavior modification program purpose, goals, and use in home/community environment. Any suggestions Tag: Drop Down List Tag: 802783
  - 22
    - Pivot Table Help Needed!!!! Hi, I have a pivot table that shows data as below. I donot have any columns in pivot table. Row Data Total January --- Total no. of requests --> 10 ( I have created using count ) Total no. of rejects --> 2 ( I have created using count ) % of Rejects --> 20% ( I am not able to get this 20% ) for some reason Febru --- Total no. of requests ---> 5 Total no. of rejects ---> 4 % of Rejects ---> 80% ( Not able to get this ) Total Requests ---> 15 Total Rejects ---> 6 Total % of Rejects ---> 40% ( Not able to get this ) Below is what I am getting. Row Data Total January --- Total no. of requests --> 10 ( I have created using count ) Total no. of rejects --> 33.34% ( I have created using count ) % of Rejects --> 20% Febru --- Total no. of requests ---> 5 Total no. of rejects ---> 4 % of Rejects ---> 66.67% Total Requests ---> 15 Total Rejects ---> 6 Total % of Rejects ---> 100% It is getting the % of total. Could you please help me get the desired result. Also, I need to set the graph color out of this pivot table if let's say the % of rejects are more than 35% show the bar in red, if it is more than 25% and less than 35% show in yellow and if it is less than 25% show them in green. Could someone please help me resolve this. Thanks a lot in advance for your help. Tag: Drop Down List Tag: 802778
  - 23
    - Convertion of Star Office documents to Microsoft Office I was recently forced to upgrade to a new computer, with Vista installed. Much of my previous hardware and software won't run under Vista. This includes Star Office 7. I have a number of documents and spreadsheets, that I need to view. Is there a free convertion utility, that will let me read them in MS Office Home & Student 2007 (or anywhere else for that matter). Tag: Drop Down List Tag: 802775
  - 24
    - Adding values generated by "IF" Statement I have a spreadhseet that contains an "IF" statement as follows: =IF(D5>0,"Â£150.00","0"). This statement works fine. I want to add up the total at the bottom of the column containing the formula, but the =SUM function doesn't appear to recognise the Â£150.00 as a value - I cannot get it to "see" the amount. I know this probably has a very simple solution but I've been working 12-14 hour days for 3 weeks without a break and cannot work out the solution myself. Any help would be more appreciated than a bottle of gin tonight. Thanks Tag: Drop Down List Tag: 802769
  - 25
    - Tidal Times I'm a yachtsman and need to mark tidal times on tidal atlases. For the non-sailor, a tidal atlas shows on each page a geographical area with a representation of tidal speed and direction for each hour up to 6 hrs before or after high water at a standard port. Doing this manually is tedious. I want to create an Excel 2000 spreadsheet that will automatically show hourly up to 6 hrs before and 6 hrs after the time of high water for each day that I type in. For example, if I type in a high water time of 23 Mar 08 2345 (perhaps in 2 adjacent colums), I would like automatically for the spreadsheet to display to the left 23 Mar 08 2245, 23 Mar 2145 and so on up to 6 hrs before high water. At the same time I would like it to display to the right 24 Mar 08 0045 (note date change), 24 Mar 0145 etc up to 6 hrs after high water time. I've tried to work this out but am stumped. Can anyone suggest a way? Tag: Drop Down List Tag: 802768

The font on my created drop down list is tiny. How do I increase it?

RE: Drop Down List by StumpedAgain

StumpedAgain
Fri Jul 25 10:29:04 CDT 2008

Unfortunately, you can't. Here's something from Debra Dalgleish's site
that's an alternative (zooming).

http://www.contextures.com/xlDataVal08.html#Font

--
-SA

"KenCanuck" wrote:

> The font on my created drop down list is tiny. How do I increase it?

Top