| Thread | Last Post | Replies |
|
| Table contents to form | 15 Apr 2004 23:49 GMT | 1 |
I have 250 employees that I construct time sheets for and I have an employee data base. I need to take Name, SS#, phone # and team# and put on their individual time sheet forms. I would like to change only the employee data base and have it change their time sheet. Not the
|
| Search for Special Characters | 15 Apr 2004 23:46 GMT | 2 |
Is there any way to search for special characters in Excel, like a tab, for example? I haven't been able to find one.
 Signature Best Regards, Clark Murray
|
| Sheet msgbox | 15 Apr 2004 23:36 GMT | 2 |
I have a msgbox that I wish to appear when a sheet is active, I hav tried the code: Private Sub Workbook_SheetActivate But that doesnt seem to be working. Any ideas as to how to fix thi
|
| VBA - Pivot Table Refresh | 15 Apr 2004 23:23 GMT | 4 |
I am using Exel 97 and I am trying to put a macro together that refreshes a pivot table after new data is inputted. The data and the pivot table is in worksheet 1. The pivot table can change size depending on the number of cells with data in it. I have set up a button (or
|
| Best way to create reports summarizing data? | 15 Apr 2004 23:19 GMT | 1 |
I am trying to create a way of generating several reports from spreadsheet of data for a baseball team. Basically, I have spreadsheet which logs every appearance by each pitcher during season, including which inning each entered and what the score was a
|
| Strange Character | 15 Apr 2004 23:15 GMT | 6 |
I'm trying to write some code to delete a character in a text file. The character appears as a square "O", and when it is copied to MS Word, it turns out to be "^m" for a manual page break that I can find, edit and replace. So the question is, what is that character in Excel, and ...
|
| Copying cells or worksheet - Help! | 15 Apr 2004 23:10 GMT | 6 |
Newbie-ish question - I want to copy either a worksheet or the cells in the worksheet from version A of a workbook to version B of that workbook. The contents of the cells are formulae that refer to other sheets in the workbook. When I do the copy, the result is that Excel 2000 ...
|
| Highlighting Cells - | 15 Apr 2004 23:06 GMT | 4 |
Okay if I have information in a worksheet D:24-L:64, and I want to highlight that then I just hit Crtl + Shirt + * , but how do I highlight everything that is not highlighted. I know there is a way to do this, I have forgot how,
|
| shift key held down too long | 15 Apr 2004 21:48 GMT | 2 |
We have a problem with Excel on our laptops at work. Holding down the SHIFT key alone for more than 8 seconds puts th keyboard in a different mode. The keys no longer function as the should. The only way out is to close the file without saving an
|
| Invalid page fault | 15 Apr 2004 21:33 GMT | 1 |
Excel 97 works okay, except that when I try to get into Tools>Options I get a box which says: ------ EXCEL caused an invalid page fault in
|
| Table contents to form | 15 Apr 2004 19:48 GMT | 1 |
I have 250 employees that I construct time sheets for and I have an employee data base. I need to take Name, SS#, phone # and team# and put on their individual time sheet forms. I would like to change only the employee data base and have it change their time sheet. Not the
|
| Simple Format question | 15 Apr 2004 19:17 GMT | 2 |
What is the correct cell format to display the value "0.0412 %" , please? Regards ---
|
| Error bar Multiple plots! | 15 Apr 2004 18:17 GMT | 1 |
I have a simple problem. I can put error bars for one curve but if have multiple curves in a single figure then I am not able to includ error bars for the others. Infact I need to control the error bars of each curve individually.
|
| !!! Excel and Windows NT Integrated Security !!! | 15 Apr 2004 18:06 GMT | 1 |
Do you know how to read the userid logged on a PC using VBA. For example as using the instruction request.servervariables("AUTH_USER") in ASP. Thanks!
|
| Help! Can't unhide rows. | 15 Apr 2004 17:49 GMT | 8 |
I'm not able to unhide my hidden rows. I follow the directions and select the row above and the row below the hidden rows, then choose Format/rows/unhide. And nothing happens! This feels related to my earlier posting "autofilter does't work."
|