| Thread | Last Post | Replies |
|
| Automatically Updating Filter in Multiple Sheets | 11 Jan 2005 23:32 GMT | 1 |
I have data in multiple sheets. Each row of data in each sheet is identified with a text identifier. I can use auto-filter to select the prefered text identifier in each sheet so that it shows only that data required. This is slow and tedious.
|
| Excess columns | 11 Jan 2005 23:00 GMT | 4 |
I have set up my worksheet, but have a tremendous number of columns left unused. I have tried to delete them, but they don't go away. How can I get rid of them?
|
| y axis label problem | 11 Jan 2005 22:29 GMT | 2 |
I have a Sony VAIO VGN-A200 laptop. My Excel charts' y axis label is truncated at high resolution but is not at low resolution. A Microsoft Knowledge Base article for another application suggests this can happen when the ratio of horizontal size to vertical size
|
| Outlines | 11 Jan 2005 22:05 GMT | 3 |
Is it possible to create an outline without subtotals that is 4 levels deep? e.g. given a spreadsheet with 4 columns, Country, State, City, Zip - can I create an outline that at the highest level will show countries only, then expand to states, etc.? I have no data to sub-total.
|
| border color problems | 11 Jan 2005 20:41 GMT | 6 |
Excel 2002 (10.6501.6626) SP3 My Border Color is set to Automatic. When I use the Borders Toolbar button to make some borders on a cell(s), the color is always light Grey. When I highlight these
|
| Quickly moving down one row on pasted data from another worksheet. | 11 Jan 2005 20:26 GMT | 4 |
Ok, this should be fairly simple but I'm a excel novice. I have two worksheets. One contains all data with each row representing a different store. I then have another worksheet that is a form. I need to fill out a form for each store. The information maps the same
|
| creating text files | 11 Jan 2005 18:14 GMT | 2 |
I am looking for away to creat a test file from an excel worksheet. I tried "Text Write Program-1c" but it dosn't seem to give me the results I am looking for, the fields don't always drop into place. If anyone can help I would appreciate it.
|
| error with code | 11 Jan 2005 17:44 GMT | 4 |
I have the following code: Range("A2").Select ActiveWorkbook.Sheets("Main").Activate Range("A2").Select
|
| file not opening | 11 Jan 2005 16:56 GMT | 1 |
Hi to all, I have a diskette with two files in it. The first file opens as usual but the second one I cannot open. I get a message that the program is not responding. Is there a way
|
| Checkboxes and highlighting | 11 Jan 2005 16:53 GMT | 6 |
I need a good tutorial on using checkboxes (I guess a tutorial on VBA is probably needed). I just need a whole series of checkboxes but know nothing about forms or VB. Then, based on the result, I would like to highlight a range of cells using
|
| Step down a Sheet for Copy | 11 Jan 2005 16:26 GMT | 1 |
I have a workbook with a sheet that has contact info in A1 B1 C1 etc which my macro copies to another sheet in same workbook and then saves the sheet to a new workbook and closes. I know need to go back to the contact worksheet and move down to A2 B2 C2 etc and redo the copy ,
|
| Count items in cel | 11 Jan 2005 16:15 GMT | 7 |
Okay, here's my problem: In my excel-list I have 3 codes: "l","s" and "ls". l is the equivalent of 1,50 euro s the equivalent of 1 euro
|
| Adding a total row to a chart data table | 11 Jan 2005 16:14 GMT | 2 |
I have the following data in a chart Week 1 2 3 4 5 6 7 8 Data1 1 5 7 6 1 6 7 6 Data2 3 4 5 7 9 4 6 6
|
| Calculate time difference | 11 Jan 2005 16:04 GMT | 2 |
I'm new to excel so I hope that you can help me. I want to make an excel file that calculates my working hours. If I for example writes 08:00 in one cell and 17:00 in another cell I want the result to be 00:00 (since my working day is 1 hour and I have 1 hour lunch -> 17:00-08:00-08 ...
|
| Calculating on alphabetic cell content | 11 Jan 2005 15:13 GMT | 5 |
A selection of 4 different letters in a column representing different values to be used in a formula shall be run through. The calculated result of each cell in the column shall be placed in the cell next to the read one that holds the letter.
|