|
adding minutes and seconds correctly
Hi, I have a spreadsheet which holds data as minutes and seconds i.e. 13:57 =
13 minutes and 57 seconds. When I try to add up the column, Excel thinks 13
represents hours and 57 is minutes and adds up accordingly. I've tried using
custom to make the field MM:SS without any success. What am I doing wrong or
does someone know how to resolve this? Many thanks in advance for your help.
Chee...
|
9 |
13.09.2006 08:29:02 |
|
|
Object Library
I have written a macro in Excel 2002/XP which uses different MS Object
Libraries (Excel, Office & PowerPoint) and it works fine.
When I save the file in Excel 2003 the references get changed automatically
to version 11 and the file works but when I open the file in Excel 2002
again the Object Library for PowerPoint stays on version 11 all others
swiches back to version 10. This produces e...
|
3 |
13.09.2006 06:19:47 |
|
|
SUMIF question
Hi,
I have a workbook with column A formatted as dates, and column B containing
numbers. I would like to know how to get excel to tell me how much the sum
of the numbers would be for a given time frame. So, for instance, if I
wanted to know the sum of the numbers in column B that have year 2006 in
column A, etc. There must be a way to do this, but I'm stumped.
Also, can the criteria in the...
|
5 |
13.09.2006 04:00:04 |
|
|
Delete records in a worksheet
I'm working on a simple program that lets the user enter, edit and
print the data. I developed the program using Microsoft Excel 2003 with
VBE.
The problem is that, under Edit button I want to enable the user to
edit the existing data and save as well as to save as another name.
But, how to let the user delete the data in the worksheet?
Example :
When the user clicked on Delete button...
|
3 |
13.09.2006 03:31:11 |
|
|
Undoing a change that has been saved
I Have a database with close to 3,000 addresses on it. I put it in zip code
oreder then saved it and closed it when I reopened it and realized I had only
arranged the ZIP code and not the addresses that go with them. Is there a way
to go back and find an old one. Or to undo a change of the nature?
Please help!
Thanks...
|
3 |
12.09.2006 22:24:11 |
|
|
Months
Hi,
Is there a way (formula or whatever) to have the 12 months instead of typing
them.
I used Jan in cell B2 and Feb in cell C2, selected both cells and then used
the mouse to copy them to the range D2:M2.
Some of the months were Ok but not all of them?
Can any one help?
Khalil Handal
...
|
4 |
12.09.2006 21:25:48 |
|
|
Excel 2003 formula bar question
Greetings,
I just upgraded from 2000 to 2003. In Excel 2000, when you were
typing in a formula, a small window would open up automatically under
the formula bar and say something like "value is ..." and give an
on-the-fly evalaution of the expression. I found this quite useful,
both as an error checking device and also because it allowed me to use
the formula bar itself as a quick calcula...
|
5 |
12.09.2006 20:07:09 |
|
|
Cursor moves after enter, when it should not
Using Excel 2003/SP2, I have the check box in tools/options/edit cleared for
"move cursor after enter". Normally this is fine, but I made a sheet with a
few protected cells and now it moves to the next unprotected cell, in
whatever direction is greyed out. I don't often protect cells, so I don't
remember if older versions worked correctly.
I'm doing a sort of manual optimization and I w...
|
3 |
12.09.2006 19:04:22 |
|
|
How to take a list of cells and sort them into a new list
Let's say I have a list of 20 student numbers, unsorted, in cells A3:A22.
How, if possible, can I set up my worksheet so that it will automatically
take the values in that range of cells, sort them, and display them in cells
C3:C22 in sorted order?
Thanks for any help....
|
7 |
12.09.2006 18:48:27 |
|
|
Months
Hi,
Is there a way (formula or whatever) to have the 12 months instead of typing
them.
I used Jan in cell B2 and Feb in cell C2, selected both cells and then used
the mouse to copy them to the range D2:M2.
Some of the months were Ok but not all of them?
Can any one help?
Khalil Handal
...
|
2 |
12.09.2006 18:48:02 |
|
|
Items Not Found in Lookup Tables
I'm setting up Lookup Tables for the first time, and have gotten myself
into some trouble along the way. If an item is not found in my Lookup
Table, it seems to pick up the closest item alphabetically. How do I
prevent this from happening? Is there anything I could put in my
Lookup Table that would be a catch all for items not found, and would
act as an alert to me that the table needs ...
|
5 |
12.09.2006 18:30:05 |
|
|
Microsoft Office 2003
When I try to open an Excel file, nothing responds and I end up having to doa
ctrl. alt. delete and get a message 'you chose to close a non responsive
programme'.
It cannot find excel.exe and when I try to re-install or repair Office it
stops have way throught and says it closed due to an error encountered.
Any ideas...
|
3 |
12.09.2006 18:29:05 |
|
|
Help Debug Complex Formula (SUMPRODUCT? SUMIF?)
Folks,
I'm really struggling with this one.
I've got 354 rows of data (rows 3:352). In column G there may be a date. In
column M there is a number (1-12) which represents a monthly period, and in
column O there is a dollar amount which represents a montly invoice total.
I need to construct a formula which calculates the sum of O for a specific
period M where there is a date entered ...
|
4 |
12.09.2006 18:16:19 |
|
|
Opening Excel files in Works
Is it possible to open Excel files in microsoft Works?...
|
2 |
12.09.2006 16:06:18 |
|
|
operaciones con comentarios de celdas
Hola a todos ::
estoy trabajando con unas con multitud de comentarios, y quisiera saber de
que forma puedo "jugar" con ellos mediante macros
las dos operaciones que necesito hacer ahora son
- cambiar el tamaño del texto dentro del comentario (muchos estan escritos a
tamaño 8 y casi no se leen
- copiar el texto del comentario a otra hoja para tener en esta todos los
comentarios. La ide...
|
2 |
12.09.2006 15:33:45 |
|
|
Using Hebrew Dates
Hi, I need to use Hebrew dates. How do I switch from Gregorian to Hebrew? I am using Office 2003 under XP with Hebrew support. Can anyone help me? Thanks.
Moshe
...
|
1 |
12.09.2006 14:53:24 |
|
|
Consolidate and Lookup
Hi all,
I receive 8 reports monthly, 1 for each area, with the all the activity
for that period. I would like to consolidate the data into one total
sheet. I have a master sheet with all the specialties where I would
like to have all the totals show. The activity will be different each
month so the the number of rows may change. The number of columns is
constant.
Below is what I have at...
|
2 |
12.09.2006 14:52:01 |
|
|
Changing a Number in a Column Using Arrays?
I am trying to change a number in the left column to the number in the
adjacent column. My setup looks like this.
Number to Change Change to this Number
182001 182000
182002 182000
193002 193000
Code New Code (from the Change to this Number column)
181000 ...
|
4 |
12.09.2006 09:28:36 |
|
|
using `if` a value is between
I am using zz as my variable
what I want to do is
if zz is between 7 and 10 then print out a range within a sheet
is the print range line correct ????????
any assistance appreciated
If ZZ = >1 or < =7 Then ' check value of zz
Range("A2:G36").PrintOut.SelectedSheets ' Print selected range
If ZZ > 8 or < 14Then
Range("A2:G36").PrintOut.SelectedSheets
...
|
8 |
12.09.2006 08:41:42 |
|
|
Mathematical operation on a value retrieved from a different sheet
I'm working with 2 Excel sheets, PLY TABLE and LIBRARY TABLE.
PLY TABLE will allow the user to insert the corresponding data and the
LIBRARY TABLE will display the summary of the data entered in PLY
TABLE.
The problem is that, how could I possibly do a mathematical operation
to the value in PLY TABLE to be displayed in the LIBRARY TABLE?
Example: I want to add the value in PLY TABLE, cel...
|
5 |
12.09.2006 06:14:11 |
|
|
Using function in worksheet
Hi All,
Bank A/C no. Holder Cash In Cash Out Net Total
----------------- --------- ----------- ------------ ------------
1234 Father 1200 450 750
1234 Mother 800 125 675
1234 Son a 15000 885 14115
...
|
4 |
11.09.2006 23:47:31 |
|
|
Web Query
Hello all
I am new to Web Queries and my vb isn't much good either.
I need to go to a specific page enter a string from a list into the
search box on that web page and download the results into excel. I then
need to go to the next string on the list and so on.
I have managed to create a query that will download the first 10
results.
What I would dearly love to do is get the next results and...
|
6 |
11.09.2006 22:02:25 |
|
|
Validation issue
I have set up my cells on one sheet with validation to a list. The list is
on a different sheet. I accomplished this be selecting the 20 possible cells
to contain data in the list and Insert|Name called MyList. Now on the other
sheet, for the cell validation the source is: =MyList
The issue is not all 20 cells will hold content at all times (depends on how
many activities the user needs...
|
2 |
11.09.2006 19:59:10 |
|
|
Toolbars look different depending on how Excel starts
Hi,
I have noticed that the toolbars look different depending on how Excel
starts. If I click on a spreadsheet file to launch Excel the toolbars
look flat and have a dotted outline around them. If I start Excel from
the start menu the toolbars have more of a 3D look to them. Also the
"About Microsoft Excel" looks different. The information in it is the
same either way. I only have the one co...
|
4 |
11.09.2006 19:04:52 |
|
|
Formatting when combining text & value in a cell
The value of my cell is
="Product Margin is "&Z5
Z5 is 63.6% (in Z5) but 0.63653676693 in my combined cell. How do I
format the percent when combining text & value? Thank you for your
time.
...
|
3 |
11.09.2006 16:03:59 |