|
|
Worksheet updates by
cherri isbell
Is it possible to have one worksheet automatically update
a master worksheet?? I have 8 worksheets, and I have one
master worksheet. When I make changes to...
|
September 16th, 2003 07:35 PM
by Sandi
|
1 |
469 |
|
|
|
|
1 |
492 |
|
|
date f(x) by
briank
I am trying to automate an average function. At the
present I am trying to average six columns. Next month
there will be new data and thus the average range...
|
|
2 |
298 |
|
|
View problems by
Lynn
I have a worksheet created by another user that I am
working with. My view of the file is in black and white
only and none of the cell colors are displaying. ...
|
|
2 |
371 |
|
|
Formulas not automatic by
Jessica
I have some formulas that I have dragged down from other
cells and they do not automatically calculate. What I
mean by that is the formula is based on the...
|
|
1 |
289 |
|
|
|
September 16th, 2003 08:14 PM
by Todd
|
1 |
495 |
|
|
spreadsheet question by
koxo12
I have conected 3 sheets but if I change something in one
sheet other two will change only if I open them. Can I
update other sheets without opening them?
|
|
1 |
339 |
|
|
Sorting by cell or text format by
Does anyone know of a way to sort a list by the cell
format or by the text format? I have a very long list
where the 'good' cells have been colored in yellow....
|
|
1 |
660 |
|
|
Excel formulas by
D A Brook
Is it possible for data from several sheets in a workbook
to be brought forward to a collection sheet by selecting
the other sheets from a reference (a list of...
|
|
1 |
306 |
|
|
Exposant by
garnote
Hi all,
I have X values in Range("A2":A42")
I write x^2, 1-x^2, x^3-2*x^2+12,
e^x, sin(x) ... in B1 (Format: Text)
and use this macro for obtain graphic...
|
September 16th, 2003 08:57 PM
by garnote
|
1 |
304 |
|
|
lotus 2.4 macro by
Joe Silvers
The following is an example of a simple macro I used in
Lotus 123.
{goto}E3~
'{?}{D}'{?}{D}'{?}~
{GOTO}C8~'{?}~
Once invoked, the cursor goes to cell E3,...
|
|
1 |
306 |
|
|
match formula by
donny
I want to create a match formula, I want the formula to
look in column A AND B where numeric values are placed and
look in cells j1 AND J3 because i have a...
|
|
3 |
272 |
|
|
average f(x) by
briank
Any ideas why this won't work?
=average(ADDRESS(4,26):address(4,33))
|
|
2 |
344 |
|
|
|
|
2 |
294 |
|
|
Average function by
Jeff Kimbell
When I use the average function over a range of cells that
includes a cell with "#VALUE!", the function returns
with "#VALUE!". The description of the average...
|
|
2 |
514 |
|
|
worksheet protection/macro by
wally
Hi,
I have windows xp, home edition. After protecting a worksheet, which
contains formulas, I would like to run a macro to copy and paste the
text only of the...
|
September 16th, 2003 09:50 PM
by wally
|
3 |
315 |
|
|
"If" or "sumif" by
Peter
I am holding a function where if the person comes alone,
the price is $300, but if he brings his wife, the price is
$400. I am collecting deposits, and will...
|
September 16th, 2003 10:06 PM
by Ken L
|
4 |
312 |
|
|
average function by
Rod
When I use the average function like this =AVERAGE(B3:C3),
I get a #DIV/0! error.
B3 C3
(0.6 1.6
Any ideas?
|
September 16th, 2003 10:09 PM
by Rod
|
2 |
472 |
|
|
cell references by
Sandi
does anyone know how to enter a formula to link two pages
when the cell reference always increases by 7 rows.
Right now I have to type the formula in each...
|
September 16th, 2003 10:28 PM
by GB
|
4 |
722 |
|
|
drop down by
anita
Does anyone know how to create a drop-down menu in Excel?
For example in Cell A1 I want there to be a list that I
can choose from.
|
|
2 |
391 |