|
|
Ignoring formulas in Custom Headers by
Mizuchi
I want to display the path of the excel file in the header, but it changed
"&D" into a date.
How do I prevent Excel from doing this?
|
April 1st, 2005 05:19 AM
by JulieD
|
3 |
106 |
|
|
|
|
3 |
130 |
|
|
|
April 1st, 2005 05:35 AM
by JulieD
|
1 |
80 |
|
|
|
|
3 |
83 |
|
|
|
|
1 |
157 |
|
|
can you make one worksheet update another by
Jaime S.
I have two similar worksheets within the same workbook. One sheet is sorted
by name and the other sheet is sorted by a date for a speicfic name. Is
there a...
|
|
1 |
78 |
|
|
|
April 1st, 2005 05:57 AM
by JulieD
|
1 |
138 |
|
|
|
|
1 |
72 |
|
|
dynamic formulas by
Cal@tech-etch
Hi!
I have an Exel spreadsheet where the charts work dynamicaly. Every time
data
is entered into successive cells the chart will fully expand to...
|
|
1 |
94 |
|
|
|
|
1 |
413 |
|
|
|
April 1st, 2005 06:43 AM
by Rowan
|
1 |
110 |
|
|
|
|
4 |
87 |
|
|
Creating a Search Form by
Karen
I have a simple address book spreadsheet. I would like to create a Search
form, where the user can enter the Last Name of the person they are searching
for.
( 1 2)
|
|
12 |
391 |
|
|
Writting Function using VBA by
nc
Hi
I am trying to write a function to return an address but
instead I get #VALUE!.
Public Function fnd(a, b)
fnd = Range(a).Find(b).Address
End Function
|
|
3 |
85 |
|
|
I cannot choose Conditional Formatting by
Shawna
I have used conditional formatting on some spreadsheets, so I know how to use
it. My problem is that on other spreadsheets I cannot choose it from the
Format...
|
April 1st, 2005 07:17 AM
by Kassie
|
4 |
75 |
|
|
If function by
Bob Phillips
=IF(A1="yes",RAND(),"")
--
HTH
RP
(remove nothere from the email address if mailing direct)
|
April 1st, 2005 07:48 AM
by Greg
|
6 |
95 |
|
|
IF statement - Help! by
James
I have three columns of data, column A, B & C.
I want to write an IF statement that looks at column A,
and if it either retruns the contents of column B...
|
April 1st, 2005 08:47 AM
by JulieD
|
4 |
74 |
|
|
data range properties by
baz
Hi
I have a problem with external data. In the Data Range Properties, under
Data Layout.
There are 3 options after
'If the number of rows in the data range...
|
April 1st, 2005 08:53 AM
by baz
|
0 |
234 |
|
|
Database check by
gunga
I have a database of 12 different numbers, contained in the same column, on
12 successive rows.
Does anyome know if Excel is able to check whether a number...
|
April 1st, 2005 08:55 AM
by gunga
|
2 |
81 |
|
|
|
April 1st, 2005 09:29 AM
by bobf
|
6 |
81 |