| Thread | Last Post | Replies |
|
| sorting or is this consolidating | 08 Nov 2006 12:38 GMT | 3 |
I have an excel file that looks like this: ID# account status 10 1 open 20 1 open
|
| deleteing documents | 08 Nov 2006 09:31 GMT | 1 |
I cannot delete any documents in the recent document list that are not in use any longer, my list of recent documents just keeps getting longer; I have changed the pin to green to unpin the document but nothing happens......how do you delete the names (the files are no longer ...
|
| Protecting Sheets | 08 Nov 2006 08:51 GMT | 1 |
I have a workbook which has about 120 worksheets. Is there any way to set the Worksheet Protection on all sheets at one time? I want all sheets set to allow only the selection of unlocked cells.
|
| Counting values in a range | 08 Nov 2006 06:34 GMT | 3 |
Hi to all, Range C5:C32 contains letters either "C" or "M" Range D5:D32 contains letters either "M" or "F" I want to count the number of combinations of the letters which are as
|
| Select column range in VB? | 08 Nov 2006 03:18 GMT | 2 |
Hi - I am using MS XL 2002 and I have created a macro that inputs data to a specific cell. I want the macro to input this data in a range of cells; the data should be input into all the same row cells in column A, providing there is data in the same rows in Column B.
|
| Hide sheet tabs? | 08 Nov 2006 01:16 GMT | 12 |
Is there any way to hide sheet tabs? Thanks.
|
| Cells won't accept specific text | 08 Nov 2006 00:53 GMT | 3 |
When I attempt to type the three letters myu into a cell and press enter, the u gets dropped leaving only the letters my. It does not happen with ayu, byu, nyu, etc, only with this combination of letters. If I change the cell formatting to text only, the same result occurs.
|
| time sheet help | 08 Nov 2006 00:41 GMT | 3 |
I need to analyze the hours worked by employees on certain days off to determine how many hours, during what would be their normal shift time, that they actually worked. Here's how I have the columns: A= Time started, B= time finished, C= the total hours worked, D= normal shift
|
| Formating of cell size- | 08 Nov 2006 00:14 GMT | 1 |
Hi- It should be simple but I can t figure it out. Cells are locked to size from top to bottom of document .Yes I can adjust the heights and widths but how do I format some cells in the bottom of a document that I dont want to be the same size as ones a little higher in the ...
|
| Two lists, find *similar* cells (not duplicates) and mark/highlight, etc. | 07 Nov 2006 23:55 GMT | 3 |
So I have 2 lists with client names. Since different salespeople entered each data cell, the client names are spelled differently in many of the entries. For example, some list client Bill Smith as: "B Smith" "B. Smith" "Bill S." "Bill Smith"...you get the idea.
|
| Migrating Macros to new log-on | 07 Nov 2006 21:38 GMT | 1 |
We've just been migrated to new servers, and with them came a new log-in. I had a whole bunch of macros under my old log-in, and if I go back to it, they're still there. How can I move them to the new log-in? If I just have to re-key everything I can do that, but I hope ...
|
| Excel configuration | 07 Nov 2006 20:56 GMT | 3 |
I have Office 2003 on two systems, one of them brand new. Is there a way to move my Excel configuration from the old to the new system? Thanks, CMA
|
| Sum column based upon corresponding values | 07 Nov 2006 20:27 GMT | 2 |
I know this is probably simple but I can't get anything to work. I have a formula that I took from another document to use in a new project. The formula looks at the values of a specific range in another workbook and then counts the values of a corresponding column.
|
| Pivot question | 07 Nov 2006 20:27 GMT | 1 |
I have to create a pivot table as follows The raw data are structured like that Id Col1 Col2 Col3 1 A D F
|
| Excel 2000 VBA problem | 07 Nov 2006 19:41 GMT | 3 |
Can someone please advise me how I would write a VBA routine to scroll through each row of a spreadsheet and delete the row if one particular column value <>"" . I should mention that there is a formula in this column - IF (H1= "","",networkdays etc etc. I am trying to keep all
|