| Thread | Last Post | Replies |
|
| Select specific text in cell | 17 Feb 2008 01:09 GMT | 30 |
Is there a simple way to extract text in a cell that occurs between specific characters, or to the right of a special character? The text strings are various lengths and content. Excel 2003, Windows XP SP2
|
| modify a standard color like in 2003 | 17 Feb 2008 00:12 GMT | 5 |
In Excel 2003, you could modify an existing standard color, by clicking tools, options, color, and then mofifying one of the basic colors to a unique one. Is this possible in Excel 2007? It is a very useful tool when you want to change everything in a workbook that is red to say ...
|
| Formula to return the reference of a range of cells | 16 Feb 2008 23:28 GMT | 4 |
I need to build a formula that finds a text reference in a vertical list, e.g finds "Feb" in a list of months. Having found the text, I need the formula to return in text format the cell references of a range of a cells located in the same row as the found text and
|
| How to get a list from one worksheet to another. | 16 Feb 2008 21:51 GMT | 1 |
Good Afternoon and Thank you! I am currently working on a spreadsheet with 2 different worksheets. One worksheet "Deposit Calculations" I have a list of branches that I would like to carry over to the 2nd worksheet "What If Scenario" but be able to select
|
| Excel Charts | 16 Feb 2008 20:17 GMT | 2 |
I am using XP Professional with Excel 2000. I would like to show a comparison of 4 companies and their 2008 sales data vs. their 2007 data (for the same date ranges one year to the next). I'd like to show this on the same chart using cluster columns for the 2008 totals, and ...
|
| Duplicating of Message Boxes | 16 Feb 2008 19:34 GMT | 5 |
The below shows the 2 MB's Twice -- OK the first time, but I ned to eliminate them from ccurring the 2nd time (text only shows - no values) Thanks, Private Sub ComboBox1_Change()
|
| excel sheet is starting from top right | 16 Feb 2008 18:41 GMT | 5 |
i dont know what's wrons office, now excel is starting from the top right - i mean cell A1 is showing at top right corner and all succeeding columns, i.e., B C D etc are to the left it should be the other way around i.e. cell A1 should be at top left!
|
| Need help | 16 Feb 2008 17:49 GMT | 1 |
Hello every body I need help about Scientific and Fractions in Cell==>Format Menu==> Excel program. I mean what are these commands for.
|
| Excel "can't find" double-clicked files | 16 Feb 2008 17:44 GMT | 2 |
I have a client who, when they double-click on an Excel file the program starts to open, and then pops up a dialog that states it can't find the specifed file. This also happens when trying to open the file after being downloaded from an email attachment. I can browse to the
|
| Filter Data | 16 Feb 2008 17:40 GMT | 2 |
I am trying to set up a spreadsheet for my personal expenses. What I am tryng to do is have one sheet were I enter all of my expenses. I then want to have a tab for each month. What I am trying to do is have the tabs for each month pull the data from were I enter all of my ...
|
| Excel Lookup | 16 Feb 2008 17:36 GMT | 3 |
I want to display the result of where a row and column intersect from a table of values. Can anyone assist?
|
| TextBox linked to a ComboBox? | 16 Feb 2008 14:50 GMT | 3 |
Is there a way to link a textbox to a combobox list? I have a combobox1 on my userform that I want to be able to select a item on that list and which in turn puts an associated item in textbox1. To give you an example:
|
| macro to print sheets from wrkbk only if data has been typed in | 16 Feb 2008 14:19 GMT | 3 |
I have a workbook that has 24 tabs on it. It is used to evaluate people. An evaluator will evaluate up to 24 people. But not the max all the time. If thhey only do say 10, then I only want to print 10 from that workbook. The I might open 16 workbooks on an evaluation day and need ...
|
| Indirect referencing of external spreadsheets | 16 Feb 2008 13:59 GMT | 4 |
I have implemented the "pull" function to indirectly reference data in external spreadsheets that are closed. This is very slow (almost .5 seconds per cell). I have about 500 cells to update so it takes awhile whenever I do a manual update.
|
| How do i write logical_test for more than 100 values (IF) | 16 Feb 2008 12:50 GMT | 2 |
I would like to use (IF) for more than 100 values "I want to type the employee number and the logical test to be employee name
|