|
|
Help with copying formula by
John Calder
Hi
I run Excel 2K
I have typed the following formulas in three consecutive cells.
=SUM('DRO BY SHIFT'!Z10:Z12)+BP10
=SUM('DRO BY...
|
September 3rd, 2009 04:14 AM
by T. Valko
|
4 |
166 |
|
|
date calculation by
nishkrish
hi
i have a database where column b is date column c is customer name when i
input customer name in the system it should check if the same customer name...
( 1 2)
|
|
10 |
336 |
|
|
Running Balance by
jenhunley
i am trying to set up a running balance for payroll I have charge in column c
and i want to keep a running total in column d how do i get it to add up and...
|
|
2 |
159 |
|
|
Excel Help Needed by
RICHCHAP
Hi,
I have a number of excel documents. These are for individual stores of my
business to record their sales information. What I want is for all of these...
|
September 2nd, 2009 12:07 PM
by Eduardo
|
1 |
129 |
|
|
|
|
1 |
166 |
|
|
Excel clipboard in Microsoft Office 2007 by
Daffydd
Hi
I am bewildered though it doesn't take much to bewilder me when it comes to
computer applications.
When I worked in an office on the computer all day...
|
|
2 |
132 |
|
|
Excel variable for path by
Esgrimidor[_2_]
Excel variable for path
I would like propose a variable in an excel cell and launch a word
document from other excel cell
Y:\document\%variable%\proof.doc...
|
September 1st, 2009 01:16 PM
by JLatham
|
2 |
145 |
|
|
for/next loop by
Poor Richard[_2_]
I have a sheet in a workbook where I need to select the last row containing
data. Is there a for/next loop function where I can identify the last row,
then...
|
|
3 |
151 |
|
|
Subtract Time by
israel
Hi I have a column "A1" to "A300" with time data (06:19:21), how can I
subtract a half hour? The seconds should not be relevant in the final column.
Thank...
|
August 31st, 2009 08:34 PM
by israel
|
9 |
150 |
|
|
Hiding rows and columns in XL 07 by
mlenard
How do I get the top column row, which contains only the column letters, and
the row number, which is the narrow column to the left of Column A, to
disappear...
|
|
3 |
145 |
|
|
Comment box size by
pcor
Is there a way to control the size of the comment box. Currently the box
opens as about a 2 X 3 in box. I would prefer to have it open as a rectangle.
I know...
|
August 31st, 2009 03:10 PM
by pcor
|
2 |
196 |
|
|
|
|
1 |
140 |
|
|
problem combining 2 formulas by
kinsey
Hello, I have two rates of exhange and I want to find the mid point and
deduct 3% all in one formula.
The bank buy rate is 1.6706 (cell a1)
The bank sell...
|
August 30th, 2009 10:08 AM
by kinsey
|
2 |
127 |
|
|
|
August 30th, 2009 01:32 AM
by JLatham
|
1 |
118 |
|
|
|
|
0 |
162 |
|
|
Auto complete by
Gene L.
My e-mail program inserts a name when just a few initial letters are
entered. Can Excel do this when updating a list of customers (or others)? It
would be...
|
August 29th, 2009 08:22 PM
by Gene L.
|
2 |
119 |
|
|
Macro to "save as" by
JS
Hi,
Am using excel 2003 and am wanting to create a macro, attached to a button,
that will save as a particular cell #, say A2, and then print. Have the...
|
August 29th, 2009 12:27 PM
by JS
|
4 |
166 |
|
|
named cell list by
Keith[_22_]
Could some kind person please tell me how to list the named cells of a XL
2007 spreadsheet in a worksheet. I have just upgraded from 2003 where I used
the...
|
|
1 |
119 |
|
|
Zeros if cell is blank by
pcor
I would like to be able to select a portion of my spread sheet and then have
a macro that would search every cell in the selected area: if the cell is
blank...
|
August 28th, 2009 06:31 PM
by pcor
|
2 |
142 |
|
|
|
|
0 |
152 |