| Thread | Last Post | Replies |
|
| Conditional Formatting | 04 Mar 2008 07:27 GMT | 1 |
I have a rather large worksheet that will have hundreds of cells with conditional formatting. Most of them are the same (only the cells and value ranges change). Here is an example of a conditional format I need:
|
| Looking for Work Load/Production Report Logs spreadsheet... | 04 Mar 2008 07:10 GMT | 2 |
We are being asked to keep track of our daily work load. We need to record start and stop times as well as total time spent working on each job. It seems Excel would be perfect for this task because of it's Current Date and Time functions. Does anyone know whether this
|
| Excel 2000 Step By Step. What URL to use in Lesson 8? | 04 Mar 2008 05:07 GMT | 4 |
p 151 tells us to enter a url for importing data from web. But which URL? I'm connected to web and have installed cd to my pc. I found the correct errata in mspress for this book but it doesn't list the missing url as an error.
|
| Excel opens with Office Online 'get started ' window. How to stop? | 04 Mar 2008 03:32 GMT | 1 |
 Signature Ml
|
| How to copy a chart between workbooks? | 04 Mar 2008 00:50 GMT | 4 |
Another guy in my office has a nice chart which I want to use in my own weekly report. He has it posted on a shared network drive. How do I copy his chart into my workbook? I'm using Excel 2003. Thanks in advance,
|
| Appending collected x & y data from linkage analysis to another sheet | 04 Mar 2008 00:45 GMT | 1 |
I want to run a test where I look at a various-length linkages that each have two connecting pins. The linkage will have an angle monitoring device added to it that wirelessly sends data to a display box.
|
| auto date insert | 03 Mar 2008 23:48 GMT | 5 |
i'm using office spreadsheet which is similar formulas to excel i believe. I want it to automatically insert a date when you open it on a certain day, i.e., if i open my file on a friday, i want it to automatically enter the date and possibly cell data into the corresponding ...
|
| Moving Decimal Point | 03 Mar 2008 23:06 GMT | 2 |
I have a bunch of currency number data that was imported from a text file that has no decimal point. So, for example, 12.48 shows up in Excel as 1248. Of course changing the cell format in Excel now only adds a decimal point and zeros to the end of the number so it shows up as ...
|
| if statement | 03 Mar 2008 22:43 GMT | 1 |
Please help define an if statement that puts the value $100 in a cell when another calls value is greater than or equal to 20%.
|
| macros | 03 Mar 2008 22:22 GMT | 1 |
how to add macros to excel
|
| Importing specific content into an Excel 2002 worksheet | 03 Mar 2008 22:09 GMT | 1 |
I have some word documents that contain data I need throughout the document. As it stand, Ctrl+C and Ctrl+V are the easiest ways because the data is never in the same location on each document. Is there a way of capturing this data, and adding it to a selected field
|
| Bullet points | 03 Mar 2008 22:04 GMT | 2 |
I'm creating a document in excel and have stumbled on how to type in a cell as follows: 1.1 jdkjfkdla 1.2 djak;jfd
|
| Download Automation | 03 Mar 2008 21:18 GMT | 1 |
To download a bunch of EXE files I have to perform the following steps MANUALLY: * Go to a specific web site. * Submit an Invitation Code
|
| How to put the selected cell onscreen, but not upper left | 03 Mar 2008 21:09 GMT | 4 |
I want to put the currently selected cell onscreen but not at the top left. I want a cell in Col E selected, but I want the user to see cols A-E. I can manipulate XL to select A9, then scroll there, then select E9, but it seems there must be a better, more direct way. Right now I
|
| grouping data | 03 Mar 2008 21:09 GMT | 2 |
I have a list of tasks (column A) and in column B a priority from 1 to 4 for each task. what I'm trying to do is display each item in one of 4 quadrants according to it's priority (i.e priority 1 top left quadrant, priority 2 top right
|