|
|
|
|
4 |
434 |
|
|
Hidden worksheets displaying on opening by
randula
I have a problem that I haven't seen before. I have a
workbook that I update and distribute daily. This
workbook contains hidden worksheets that I do not...
|
October 7th, 2003 04:49 PM
by Danny
|
1 |
629 |
|
|
Worksheets by
Mike Psarras
How can I locate a value in a worksheet but among
multiple worksheets. I don't want to use find&replace
from edit menu. I prefer to use a function such...
|
|
1 |
172 |
|
|
Pause in an Excel Macro by
Harry Bennett
I need to create a macro with multiple functions, one of
which is "SaveAs", so I can save the worksheet to a
different name. How can I record/enter a "pause"...
|
|
1 |
544 |
|
|
Inserting symbols shortcut by
Warren
Is there a way to provide a shortcut to inserting symbols
in excel. I've only found the cut and paste from the
characer map. Anyone know how to add-in...
|
|
1 |
310 |
|
|
BAHTTEXT by
manharawy
I have a problem working with the BAHTTEXT function in the
Excel,
As i enter the numbers in the box inorder to be shown as
text , the excel displays the text...
|
|
2 |
288 |
|
|
VLOOKUP next greatest value? by
bostitch
I would like to find the SMALLEST value in an array that
is GREATER than lookup_value.
However VLOOKUP returns the LARGEST value in an array that
is LESS than...
|
|
3 |
192 |
|
|
|
October 7th, 2003 06:54 PM
by Barbara
|
2 |
459 |
|
|
Where is circular reference? by
Brett
I'm using Excel 2002. I have a spreadsheet with several function cells.
When I open the sheet, I get a circular reference message. It doesn't tell
me where...
|
October 7th, 2003 07:22 PM
by Brett
|
3 |
486 |
|
|
Next Row by
Jay Easley
I am using a vlookup to find a value in a list and then
directly below that I would like to find the value beneath
the value found in the list. For...
|
|
4 |
173 |
|
|
Extracting Data based on Equal Cell Values by
Ken Wright
Take a look at Advanced Filter / Unique records only. Debra Dalgleish has a good intro on her
site:-
http://www.contextures.com/xladvfilter01.html
Look at...
|
|
5 |
707 |
|
|
|
October 7th, 2003 07:58 PM
by rpb
|
2 |
237 |
|
|
Calculating Dates by
Kerrick Sawyers
Need a little help:
Trying to calculate the number of days between two dates
formatted as mm/dd/yy hh:mm:ss. Any help would be greatly
appreciated. ...
|
|
3 |
163 |
|
|
macro by
kendra lewin
Is it possible to assign unique macros to individual items
in a "combo drop down box"? For example, I have 5 items
that a user can select in a combo box. I can...
|
October 7th, 2003 08:39 PM
by Dan E
|
1 |
196 |
|
|
Combine Multiple Spreadsheets by
CCourtois
I have about 200 separate spreadsheet files that I need
to combine into one. Other than copying and pasting I
don't know how to do this. Can it even be...
|
|
3 |
276 |
|
|
user input in macros by
donna culberson
How do I create a macro with a prompt inserted to force
the user to enter input then resume the macro once the
user input has been entered?
|
October 7th, 2003 10:03 PM
by Danny
|
3 |
333 |
|
|
Extract Data by
Steved
Hello from Steved
A1 is text = Arthur St
A2 is text = Penrose High
A3 is a number = 4.0
Could somebody be kind enough to write me a lookup
The...
|
|
2 |
149 |
|
|
|
|
1 |
219 |
|
|
add zeros to front of text string by
Dave R.
Here ya go
=+CHOOSE(10-LEN(D7),"0","00","000","0000","00000","000000")&D7
What this does is decides how many 0s to put in front of the number based on
how...
|
|
5 |
283 |
|
|
|
October 7th, 2003 11:56 PM
by Dan E
|
1 |
649 |