| Thread | Last Post | Replies |
|
| Error In My Logic | 02 Dec 2006 00:19 GMT | 10 |
Looking for some more help with spreadsheet code. This spreadsheet that I'm working on is functioning correctly with the exception of cell "(0,7)". When the time value in cell "(0,5)" is displayed I want to print "1st Shift" or "2nd Shift" or "3rd Shift" in cell "(0.7)". ...
|
| Office 2007 newsgroup? | 01 Dec 2006 22:34 GMT | 4 |
Is there a newsgroup dedicated to the new version of Microsoft Office (Office 2007)?
|
| YAPTQ: Mixed data types in custom groups (Excel 2003) | 01 Dec 2006 21:14 GMT | 2 |
I'm trying to get the following accomplished in Excel 2003: I have a column in a table that keeps track of how late a form was turned in. It can have an integer (for the number of days it was late) or one of several text strings ("On time," "Cannot determine," "Outside
|
| Comparing Data in Two Excel Spreadsheets | 01 Dec 2006 21:05 GMT | 2 |
I'm using Excel 2002. I have two spreadsheets, each has a column containing account numbers. I would like to be able to identify any account numbers in spreadsheet #2 that are also present in spreadsheet #1. I do NOT want to merge the spreadsheets. Any good way of doing that?
|
| Problem Concatenating Strings In Excel 2000 | 01 Dec 2006 20:42 GMT | 2 |
I have Excel 2000 and am having trouble concatenating the contents of two cells. In cell E8 I have the letter D. In cell F8 I have the number 46833. In cell G8, I typed the following:
|
| How long is too long for a post in this forum? | 01 Dec 2006 19:10 GMT | 3 |
I tried to send the text of an error window that popped up in Excel, along with some specific questions. I learned that one is not allowed to insert a JPG, so I attached a couple. Then I got the too long message. I trimmed up the body of the message and removed one JPG ...
|
| Compare "like neighbourhoods"? Think outside the box? | 01 Dec 2006 18:54 GMT | 5 |
I have a really intersting request here and I'm wondering if there is an excel answer before I go for a VBA one. I have a list of 100+ locations and 12 data variables that define demographic information. Is there a way to sort the towns or query them so that I can find a town ...
|
| Compile error in hidden module | 01 Dec 2006 18:40 GMT | 2 |
The Visual Basic error window that popped up is "Compile error in hidden module: <module name> A protected module can't be displayed. This error has the following cause and solution:
|
| "Excel Services" does not appear in Publish menu | 01 Dec 2006 18:32 GMT | 5 |
I'm using Excel 2007, and the "Excel Services" button does not appear, as it is supposed to do, in the "Publish" menu of the Office button. And when I try to add it to the Quick launch toolbar, it does not appear neither. Does someone has an idea ?
|
| Combo box loosing it´s data. | 01 Dec 2006 17:01 GMT | 2 |
I have a combo Box that is linked to a dinamic range in another workbook. It works ok until I close the workbooks. When I open the workbooks again It looses it`s link.
|
| Increasing cell size (vertically) | 01 Dec 2006 16:39 GMT | 1 |
I have large chunks of text going to excel cells. I don't want to increase the cell width. So I opted for wrap text under cell formatting options. This is working fine when I manually stretche the cell size vertically.
|
| Pivot table help (blank) fields | 01 Dec 2006 16:17 GMT | 3 |
I have a huge problem...... I have a pivot table with report 3 from autoformat applied to it. The only problem is that there are (blank) fields at many places along with their subtotal (as per my list), many times there are figures in
|
| All CAPS | 01 Dec 2006 14:45 GMT | 25 |
How to do in excel ALL CAPS command like in WORD.To make small caps Big? I found some function upper but i cant do it in same cell?
|
| Help with formula, offset with conditional | 01 Dec 2006 12:55 GMT | 2 |
Hi, I need help with a formula, I want to do a left lookup, As I have duplicates in the column G, match the value in the cell I32 only if in the column B has the value that I have in the column J32.
|
| Adding tab via Macro | 01 Dec 2006 09:46 GMT | 1 |
I have to prepare a report each week in which after compilation of all the data I have to add one tab in each excel spreadsheet. I have 15 sheets and all the sheets have different numbers of tab. I am unable to conclude how to make macro to add a tab at the last of each
|