| Thread | Last Post | Replies |
|
| Freeze column and row | 03 Feb 2006 17:44 GMT | 3 |
Can someone please tell me how to freeze a column and a row at the sam time? Thank --
|
| HOW TO VIEW SPECIFIC COLUMNS for A CALL LIST? | 03 Feb 2006 17:08 GMT | 5 |
I want to create a telephone call list from my customer list. I only want to view the records with the data in these columns only; CODE (A7), ACCOUNT (B7), BUYER (C7), ADDRESS (D7), CITY (E7), ST (F7), ZIP (G7), TEL (H8), FAX (J8), NOTES (M8). For instance, I do not need the ...
|
| Need help with one line of macro | 03 Feb 2006 16:50 GMT | 1 |
I need to write a macro that finds the first blank cell in Column A, and activates that cell. I don't know how to write it. What I have so far is an English language phrase that says what the If statement should do, below. Can someone tell me how to write this so it works in ...
|
| Can one sort, filter or search for data that is marked with a particular colour? | 03 Feb 2006 16:48 GMT | 1 |
Is it possible to sort, filter or search for data that is marked with a particular colour as opposed to the criterion being text based? Please advise. Many thanks
|
| Find stock/funds/accts spreadsheet | 03 Feb 2006 16:44 GMT | 1 |
'Looking for a template or ready-made spreadsheet to list accounts such as: stocks, funds, bonking, credit, insurance, etc with acct no, tele, broker, etc.
|
| Basic filter-like function/question. | 03 Feb 2006 16:34 GMT | 1 |
As the easiest way to explain what I'm looking to do, I'll just give a example: Name | Pay Salary Albert | 50,000
|
| PivotCaches | 03 Feb 2006 16:30 GMT | 1 |
JScript, Excel2003 var Excel = new ActiveXObject('Excel.Application'); Excel.Visible = true; var Worbook = Excel.Workbooks.Add();
|
| Data cells ignored by formula | 03 Feb 2006 15:30 GMT | 1 |
I am using the following formula =COUNTIF(M3:M13,">0") but it is ignoring cells M7 to M9. I have the same formula and data type in the columns on both sides and they are working fine. What is wrong?
|
| Macro To Insert Empty Rows?? | 03 Feb 2006 15:17 GMT | 1 |
anyone a dab hand at Excel? I need a had creating a macro. What i hav is a column with numbers, for example 12222 12222
|
| Years of Service Question? | 03 Feb 2006 15:05 GMT | 3 |
In a form, I have a Years of service note. It works as it should except for the first year of work, which would really be "0" years for the first year.
>D48 > 02/06/06 >D48 is the Anniversary date MM/dd/yy |
| How to write a data in Excel file dynamically from C / VC++ | 03 Feb 2006 14:04 GMT | 1 |
Very Urgent... I Need to write a structure of data which is in "C" to excell file. So, using C/VC++ how i can create a Excel file and how i can write a data into the respective cell at run time.
|
| Allow only one special character i a cell | 03 Feb 2006 13:35 GMT | 3 |
Hi... Is there a way to allow only one special character i a cell? I use the validation on the Data-menu to allow only one character in a cell, but in this cell the only character allowed is a capital "X"
|
| calculation sales of particular month among months of sale | 03 Feb 2006 12:47 GMT | 2 |
> I m facing problem with my worksheets which i have to calculate total sales
> in particular month. |
| I'm looking my mentor | 03 Feb 2006 12:44 GMT | 1 |
pls can u find me ,my mentor i saved it but it could be disappeared
|
| Weighted Average | 03 Feb 2006 11:42 GMT | 3 |
I am new to the weighing of numbers using excel. I really need help. I am able to do this manually, but I it takes too long. Yes I still use the calculator instead of excel. I am new at this. Please help. I need to figure out the Quaterly total of the Average
|