| Thread | Last Post | Replies |
|
| List box help | 26 Jan 2006 17:57 GMT | 2 |
How do I select an option in a list box and have it send me to another list box. Such as. in list box (1) I have numbers 1 - 10. If I select, say, number 5 I'll need it to go to the other list box where I will again have choices to send me to another list box. Actually just a way ...
|
| Canot 'Size' Excel | 26 Jan 2006 17:45 GMT | 5 |
Help! For some obscure (to me) reason I cannot re-size Excel. I can 'Size' individual Windows within Excel but not Excel itself. 'Size' is greyed out in the top left menu button. Every other program seems OK. I have tried
|
| Holding some cells and sliding others | 26 Jan 2006 17:38 GMT | 2 |
I seem to recall in an early day spreadsheet or data base having the capability to stabilize all cells left of a point and the cells right of that point could be made to slide left one data field at a time allowing you to continually view the first x number of fields while ...
|
| Tabbing from cell to cell | 26 Jan 2006 17:23 GMT | 1 |
When I press the tab key in a brand new worksheet the cursor moves from A1 to L1 then to W1...anyone? Thanks! Connie
|
| filtering colums | 26 Jan 2006 16:51 GMT | 2 |
Can anyone tell me how I filter a column, so it shows the entries that are not present in a second column? say: column1: column2: 1 2
|
| Expiration date based on 5 years and Birth month,day ... | 26 Jan 2006 16:42 GMT | 4 |
>B5 Birthdate ( MM/dd/yy format ) >D5 Issue Date ( MM/dd/yy format ) >F5 Expiration Date ( MM/dd/yy format ) A particular licence is issued for a time period of 5 years, expiring on the
|
| Can't see row numbers or left scroll arrow in Excel spreadsheet | 26 Jan 2006 16:06 GMT | 1 |
One of my excel spreadsheets won't display the row numbers (half of column "A" also can't be seen); left scroll arrow is not on screen. Other spreadsheets are OK. What to do? Thanks
|
| Stopping autoformat when replacing cells. | 26 Jan 2006 15:02 GMT | 3 |
I'm trying to replace text cells that read 1-1, 1-2, 1-3, etc. to be 2-1, 2-2, 2-3, etc. I've been going to Find and finding "1-" and replacing with "2-", which changes the 1-1, for example to 38749. What am I doing wrong?
|
| how to copy value from a combobox | 26 Jan 2006 14:18 GMT | 1 |
I would like to know the way to copy a selected value (either text or number) from a combobox to a worksheet. I wish to have the copied value for vlookup purpose regards
|
| Writing a macro that will exit a spreadsheet | 26 Jan 2006 13:41 GMT | 2 |
I am designing a spreadsheet and have various macros running, print, save etc, allocated to buttons on the sheet. However I would like to have a macro that also exits the spreadsheet when I run it, unfortunately when I try and record the macro I exit ok but the macro doesn't ...
|
| Tool for auto loading/refreshing/updating/etc... | 26 Jan 2006 13:21 GMT | 1 |
Can anyone recommend a tool that can load workbooks on a schedule, perform tasks, etc, etc.... Thank you. Richard
|
| how to copy a selected value from a combobox | 26 Jan 2006 12:20 GMT | 1 |
Hi I have a combobox which holds different names of my products. It is my great interest to know how to get the value or name selected and copy it to another worksheet or cell location. I am thinking of using this to
|
| how to make Under invoice formula | 26 Jan 2006 11:40 GMT | 1 |
Please help me how to make formula if as following case? Thank you very much in advance to expert helpers. I want divide a total amount of many diffrent product, in according to there actual value of product of each product. as following example.
|
| Autofilter for more than one condition!! | 26 Jan 2006 08:55 GMT | 4 |
Is it possible to have an autofilter on the header bar that can filter for more than condition e.g I have 600 rows of data, In Col A there are various groups names ; Alpha, Beta, Charlie,Delta etc.
|
| What If?? | 26 Jan 2006 06:58 GMT | 9 |
In a monthly report I have a requirement to track a certain type of day ( AE10 ) that is dependant upon two other day group conditions ( L10:P10, and AB10 ). The answer cell ( AE10 ) should indicate either a 0 or 1.
>L10:P10 ( ie. =SUM 3.8 hrs ) |