|
|
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 |
338 |
|
|
|
September 16th, 2003 08:14 PM
by Todd
|
1 |
489 |
|
|
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 |
|
|
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 |
370 |
|
|
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 |
|
|
|
|
1 |
473 |
|
|
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 |
461 |
|
|
|
|
2 |
298 |
|
|
calculating with displayed values by
Tobit
I have two cells, each displaying numbers to with 2 decimal points
Cell A1 contains the number 15.333333333 (the figure the result of a
calculation)
Cell A2...
|
September 16th, 2003 06:57 PM
by King
|
9 |
441 |
|
|
Pivot table update by
aablank
I have a number of pivot tables based on the same data
worksheet. Right now when I add more data, I have to go
to each table and update the range manually. ...
|
September 16th, 2003 06:46 PM
by aablank
|
3 |
463 |
|
|
Choice and effect by
Gerry Kuta
From within A1 which contains the text Area 1;Area 2;Area
3; Area 4 I'd like C1 to display Area 1 if in B1 I enter
1. (Area 2 on entry of 2 in B1 etc.)
From...
|
|
1 |
334 |
|
|
Entering numbers by
Jorr
I'm entering long numbers on an Excel 2000 spreadsheet in
a cell set for number format. When I enter a long number,
such as a credit card number (16 digits)...
|
September 16th, 2003 05:25 PM
by FBC
|
1 |
423 |
|
|
If value is greater than, then.... by
Robert
Hi,
I am trying to create a formula. Column A has a number
Column B is a sum of A*1,2 only if A is over 100 otherwise
B=A
Logic: If A1100 then B1=(A1*1,2);...
|
|
5 |
283 |
|
|
Newbee show cell address by
Microsoft Newsgroups
I am having difficulty tranfering from C to VB.
How can I assign, pss, or MsgBox the string address of a particular cell.
If I use
Dim cellref as...
|
|
2 |
385 |
|
|
Index & Match by
Greg Malenky
excel 2000
I am having trouble finding the proper function to arrive
at the following answer for this table:
employee store
john store1
dave ...
|
|
2 |
617 |
|
|
IF cell contents = ????? by
HeatherM
I want to count the instances of each value in a column
with various references in it(a mixture of text entries
and number entries). I would normally put an IF...
|
September 16th, 2003 04:18 PM
by Ed Lisay
|
1 |
622 |
|
|
Pop up function ??? by
MsSwiss
I am creating an excel document that several people will
use. I am using a pivot table in one of the sheets and I
would like to have a pop up or a callout that...
|
September 16th, 2003 04:18 PM
by Andy B
|
2 |
304 |
|
|
Lookup question by
FBC
I'm trying to compile a database based on info from
another databse. I would like to take only the rows that
contain a certain value in a cell to make the...
|
|
1 |
266 |
|
|
Pivot table - formatting by
akk
Hi Anon,
That option was ticked. Despite that, the formatting
changes.
-----Original Message-----
"akk" wrote in...
|
September 16th, 2003 03:35 PM
by akk
|
0 |
459 |
|
|
crore formatting by
kaushik
I want to format a range of cell/ a entire column in crore
format i.e 1,00,00,000.00 and also want to sum that entire
column.
I tried it with "fotmat cell"...
|
|
1 |
286 |