| Thread | Last Post | Replies |
|
| Sorting in Excel | 08 Oct 2006 21:19 GMT | 1 |
Quick question, hopefully my last one for this project. If I have a sheet within a book, that pulls one line of data from other sheets in the same book, is it possible to sort these lines within that one sheet? Would I need a macro for such a task?
|
| populating a cell with parameters | 08 Oct 2006 20:00 GMT | 4 |
I need to populate cells with another cell ex. if a2 thru a6 = 872 I need b2 thru b6 = text message Any suggestions on how to do it???
|
| Define A Range Named Percent | 08 Oct 2006 18:44 GMT | 3 |
I am working on an Excel practice text and I have been asked to "Define a range named percent to all the percent values in column E". Column E looks like the following: SAT Average
|
| Index & Match Problem | 08 Oct 2006 18:42 GMT | 4 |
Using Excel XP I have a worksheet that has 30 days in B3:AE3,(Sep 1, Sep 2, etc...) each shows the average wind direction for that certain day. I want to find the wind direction that was used the most during that period.
|
| In excel 2003, the negative numbers not appearing with brackets | 08 Oct 2006 15:57 GMT | 2 |
In my PC's excel 2003, the negative numbers are not appearing with brackets, where as its appearing in other PCs. I think something has been disturbed, how to fix?
|
| Automatic Highlighting as you move down the spreadsheet | 08 Oct 2006 14:52 GMT | 4 |
I have a spread sheet with 100 names down the lefthand side in column one. I enter details all the way along the rows and I would like the name to change to bold when I am in any cell in the relevant row. (i.e. If
|
| unable to add info onto disk | 08 Oct 2006 13:52 GMT | 3 |
I saved several worksheets on the disk with Excel and am now unable to work with them on my labtop. Message read-only appears. How do I undo read-only?
|
| Error message using Data/Forms | 08 Oct 2006 13:02 GMT | 3 |
When I try to use Data/Forms to add records to an existing table, I get an error message, "Cannot extend list or database." This worksheet is not protected, and I can easily add records without using the Form feature. This particular table has 1100 records, and this workbook is ...
|
| Paste data to next available empty row | 08 Oct 2006 12:32 GMT | 2 |
In a spreadsheet used to total golf scores and calculate Stableford points, the data entry people enter the 18 hole scores for each player. The total score and points are calculated and the data entry person passes those two items to the scoreboard on paper. The data entry person ...
|
| round problem | 08 Oct 2006 12:23 GMT | 2 |
When I do the following: A1 = ? 1743.14 A2 = ? 9940.34 A3 = ? 10855.77
|
| Copy/Paste Rows | 08 Oct 2006 12:19 GMT | 5 |
When copy/pasting rows i notice some machines copy existing formulae & some don't Assume this is some sort of Excel settings Any Clues?
|
| Publishing excel 2003 to web problem | 08 Oct 2006 11:53 GMT | 1 |
I have a spreadsheet with embedded drop-down menus. When publishing to the web I loose the drop-down buttons. Anyone know how to fix this? Thanks.
|
| FS: need help with Excel formulas | 08 Oct 2006 02:05 GMT | 7 |
I am desperately searching for help with how to do two things in Excel with using formulas. I'm sure to some of the Excel experts in this forum, they may be quite simple, but I'm killing myself searching on the net and in Excel Help for the answers and can't figure it out. So
|
| Another frustrating Excel problem | 08 Oct 2006 00:32 GMT | 1 |
I'm having an incredibly annoying problem with Excel again. I'm trying to do some basic lookup spreadsheets, for hockey statistics purposes. I have a multi-tab book, and my goal is to have a couple of tabs to dump raw data in from a database on the net, and then the main
|
| Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | 07 Oct 2006 20:00 GMT | 4 |
This is my first time posting in any Usernet group. We have an issue at work where multiple worksheets would disappear in a shared Excel file randomly. We are running Excel 2000 with about 10 users accessing and update these four shared spreadsheets. Every few days or so, I
|