| Thread | Last Post | Replies |
|
| Mix up names | 25 Feb 2008 22:34 GMT | 5 |
What is the formula and how to: To change the names from alphabetical order to being shuffled. Excel 2003 Thank You
|
| Hidden Rows | 25 Feb 2008 22:23 GMT | 1 |
OK .. this has me stumped. I can't find rows 1 and 2 on my spreadsheet. They aren't hidden (format/row/unhide), and there is no data filter on my spreadsheet so I can't go to "show all". When I "go to" cell B1, my cursur probably goes there but I still can't see it.
|
| Starting Auto_Close macro based on an IF statement | 25 Feb 2008 22:22 GMT | 4 |
I'm over my head -- I run an auto_close macro to retrieve and save data collected during a user session. The macro takes all rows with data, copies them to a folder, then clears the collection sheet for next session.
|
| How to select certain cells in a column ? | 25 Feb 2008 22:08 GMT | 3 |
Excel 2007... In Column A are the 1,200 ID numbers that I want, in sequence. They're not all consecutive numbers. No numbers are repeated.
|
| Date calculation cell became #NAME?. | 25 Feb 2008 21:36 GMT | 1 |
I have hundreds of row with column ship date, complete date, etc... For the column of complete date, I have this formula which calculate 15 days from the ship date field excluding holiday. =(WORKDAY($B162,-15,Holiday!$A$2:$A$24))
|
| Insert filename via a browse to cell | 25 Feb 2008 21:23 GMT | 2 |
I would like to click in column A. Let's say cell A3 and browse to a file on the network and then click on the file and have the filename automatically inserted in the cell. Maybe even the path - but it just has to be the name. Then if I move to cell A4, would like the same ...
|
| PASTE SPECIAL | 25 Feb 2008 21:01 GMT | 1 |
I have this code to submit a time stamp whenever a button is pushed but I want it to paste Special so the time stays static and does not update with each push of the button. Sub TimeStamp()
|
| Counting more than one criteria | 25 Feb 2008 20:53 GMT | 4 |
I need a count of how many times three columns (Year, Gender and Date) have the same values. For example Year 4, Male and In or Year 8 Male and In. Name Year Gender 25/02/2008
|
| edit insert dialogue box | 25 Feb 2008 20:42 GMT | 1 |
In 2000, Excell, I had more option when it came to inserting or deleting. I had 2003 Excel installed and now when I try to insert a cell, it will only ask me to shift entire row or entire column. It doesn't allow me to shift cells down or shift to the right.
|
| Sorting a range loses formatted borders | 25 Feb 2008 19:58 GMT | 3 |
Recently started new job where the standard is Excel 2003 SP2. I have a worksheet which is automatically populated and formatted from VBA, based on data extracted from a directory-full of spreadsheets. All works ok, except when I sort the resulting worksheet the borders don't move ...
|
| Comparing to a range and printing value | 25 Feb 2008 19:57 GMT | 4 |
I have a column of data like this (just a sample): 16.81 17.25 16.51
|
| Match and Sum | 25 Feb 2008 19:57 GMT | 1 |
I am trying to get a sum total upon matching conditions (Example) B6 = CL Type E6 = Number of Letters in cell B6 there will be one of 4 selections (ENC Letters, ENC BR Letters, V
|
| Need of a Database for some "basic" info | 25 Feb 2008 19:56 GMT | 1 |
A friend was asked to create a Database that would allow a person to pull up the info (while on the phone) that contains basic info (like client's names, addresses, spouses, birthdays, etc.). This can be done in an Address Book or Contacts List. However, the person may also ...
|
| Formula to write Calendar dates excluding weekends - urgent pleas | 25 Feb 2008 19:56 GMT | 2 |
I need to create a time tracking sheet for 3 employees working on certain tasks. I need to track their time they worked on these tasks for each day. The employee should go in each day and write how many hours they worked each day on those tasks..
|
| Where is speech and Handwriting tool in office 2007 | 25 Feb 2008 19:55 GMT | 1 |
How i can get in word/excel 2007
|