I need to create a personalized form, to correct bases of information, where
it could neither eliminate nor give of high records
Isaac

Need help for formula to extract number...
abc de/f 123456 123.45/678.90 - extract 123.45
abcd 4.5% 456789 12345.67/23456.78 - extract 12345.67
abcd e 123789 abc1234 - nothing to extract, show 0

Is there anyway that I can have several lists in a given worksheet so
that they act independently on each other, not simply dependent on the
primary list?  I would like to select certain info from one list,
certain info from another, and so forth, without being limited to the

=countif(sheet1:sheet31!E6:E35,">=1")
FOR some reason this formula fails when I use the (sheet1:sheet31) wit
the column range (E6:E35).  

I have a worksheet in which Excel does not allow me to change the
alignment of a range of cells from, say, left-justified to centered.
I am experienced with Excel/VBA and have not seen this before.  The
cells are not protected and do contain numerical data.  If I add a

I'm being asked to create a "master spreadsheet" that includes information
for over 500 school districts. I'm bringing together several different data
sets into one sheet.  I'm arranging data by hand, which is time consuming.  
How can I arrange data in one column to exactly match ...

I down loaded a calendar template from M/S but I want to change the numerical
dates to an other font. I can change  the numbers one at the time but I'm not
about to to that to 365 numbers. I tried highlighting a month of numbers and
changing the font but it still reverts back to ...

I am sorry if this is a stupid question but here goes .
If I type in dates as 010106 it gives me 01/09/27
This was raised in an earlier Question I tried the reply by  Ragdyer which was
(If you were going to enter a *very* large number of dates into a column,

Hi, I have a large spreadsheet which to make easier to search visually
I have colored the font according to the action required. Manually
changing the
font color for each cell is a bore. Can i indicate at the begining of

Greetings group, my 1st post here.
I've been trying to figure out how to use/create additional text font colors
beyond the 40 palate or 16 additional in the Format Cells dialog.
Is this possible?  Is there a show codes area to tweak?  or better still a

How can I automatically change data entered in cell A1 (32454521) into a
dollar amount in cell A2 ($16.25)?  Thanks for your guidance!

New to VBA and need help.
I am trying to hide columns based on a condition.  My workbook has
numerous worksheets.  Each worksheet contains data for a specific
"account" and each column within the "account" worksheet has month end

There is a Excel 2000 workbook at my workplace that is shared among multiple
departments.  The book contains a spreadsheet per patient and our ancillary
staff enters data on the worksheets of the patients that they have seen for
the week.  There are times when a user will ...

I have a workbook with a number of sheets all individually named.
I am trying to loop through most of them in VBA by using something
along the lines of:-
for a=5 to 16

Hi... is it possible by macro to know its file name??? something like
variable receaving "teste.xls" as valu
--
redf1r