| Thread | Last Post | Replies |
|
| use pull down menu to select a picture | 03 May 2005 12:39 GMT | 1 |
I use the Combo Box pull down menu buttons a lot. I click on the Box, select an item from the list and the relevant data pops up as expected. How can I make a picture pop up when I select an item from the Combo Box List?
|
| formula... PLEASE HELP | 03 May 2005 05:07 GMT | 2 |
I have what I think is a formula...on Sheet 1 I have a total $ amount for items sold. I typed in L3+M2 (the L column is profit and M is the total..NOW..on Sheet 2 I have the same thing for different items,
|
| How do you sort words in Excel by the number of letters in a word | 02 May 2005 23:42 GMT | 2 |
I have a list of 5,000 words that I need sort by the number of letters in the word for my students is this possible to do? The words range from 1 letter to 9 letters in a word.
|
| How do I calculate the age of a person? | 02 May 2005 22:39 GMT | 3 |
If I have the date of birth, how do I calulate the age of a person? Thanks Doug
|
| Clear Comboboxes & Textboxes | 02 May 2005 22:29 GMT | 3 |
I have a userform containing various VBA controls such as comboboxes, listboxes and check boxes. I want to provide the option for a user to clear the form. I have tried the below code but get an error message stating 'Compile error - Sub or Function not defined'
|
| Copying to Clipboard query. | 02 May 2005 21:42 GMT | 4 |
I need to copy a column of 40,000 numbers to the clipboard, using Excel as a database, carry out 12-15 sorts dropping the clipboard contents into vacant columns as I go. After I try a sort, the paste option no longer offers.
|
| Print Area. | 02 May 2005 21:39 GMT | 2 |
I set "Print Area" and print, whereupon I choose "Clear Print Area" and I suddenly am the recipient of sundry lines of dashes throughout the sheet.
|
| Sequential Numbering. | 02 May 2005 21:35 GMT | 3 |
I have a column of numbers in assorted sequential but non contiguous blocks from 4 to 30. I seek a formula to renumber them 1 and onwards, until a lower number is found, whereupon they would begin again at 1.
|
| How can I set different print areas in the same Excel sheet? | 02 May 2005 20:16 GMT | 2 |
I know very little about Excel since until recently all of my work was in Microsoft Word. However, people now email Excel documents to me to print and I get more confused with each one. Is it possible to set three different-sized print areas in one sheet, each
|
| Linking to External Data that has been moved | 02 May 2005 19:24 GMT | 7 |
Any help would be appreciated I have this workbook that reads info in from data files (not exce workbooks) which is then in turn used in another workbook t calculate values. The problem is that these files were moved t
|
| HOW DO i SYNCHRONIZE MULTIPLE WORKSHEETS IN EXCEL? | 02 May 2005 19:19 GMT | 7 |
I have 7 worksheets in a workbook. all the worksheets have a lastname, firstname, employee ID in the A,B,C columns of every worksheet. I need to synchronize the worksheets so that when I click on an employee
|
| Date Fields | 02 May 2005 18:06 GMT | 2 |
I have a spreadsheet that has 4 columns. H=Month, ex 4 J=Day , ex 1 K=Year, ex 5
|
| Data Validation w/custom + w/list | 02 May 2005 16:35 GMT | 4 |
Two cells, using data validation | custom... COUNTA($A1:$B1)<2 This works fine to prevent data in both cells. But I also want to use a drop down list for the data selection in A1 and B1, How can I do both?
|
| Excel falsely asks me to save! | 02 May 2005 15:56 GMT | 4 |
Everytime I open a certain Excel doc, even if no changes are made, it asks me if I want to save when I close it! Even if I open it and instantly decide to close it! Why does it do this and how do I get it to stop?
|
| 3 max values | 02 May 2005 13:27 GMT | 2 |
need advice how to get 3 biggest values of each row from table of 10 columns into new table.
|