I have the following statements:
DataFileName = Application.GetOpenFilename(fileFilter:="Text or ASC Files,
*.txt; *.asc", Title:="Select the Data File")
...code

I have a summary sheet which I need to summaries the results of various
projects on subsequent sheets.  I wish be able to turn projects "on and off"
in the summary.  ie:
Project Name    Include (Y/N)

I'm working in an excel spreadsheet that has a row of "1" and a column of "1"
resulting a cell being R1C1.  How do I change that be a row of "1" column of
"A"? And why wont it let me copy my formulas into other fields?

Imagine:
           Jan Feb Mar Apri May June July Aug Sep Oct Nov Dec
part 1     2    2.5  2.5   3   3.25
part 2                 1     1.1

I am creating a list of students that will be served lunch for the following
month at my school. They have two choices of lunches. Red or Blue. By their
name  the input of R or B is placed under the date. I need to count the
number of R's and B's so I can know how much of each ...

How do I put this into an excel formula ?
If this "MID(N3;6;3)" equals "OLA" then do this "MID(N3;6;3)&LEFT(N3;3)"
otherwise
Y3&MID(N3;6;3)

I have a list with some records that start with *.  I would like to exclude
these from the list with a query.  I have tried   Not Like '~*%'  but it does
not exclude the records.  Does anyone have a suggestion for me.

OK, I am thouroughly confused and need some help.  I am trying to compute the
difference in working hours between when an object starts on the line to when
it leaves the line, accounting for an 8 hour workday and excluding holidays
and weekends, although some saturdays are spent ...

Formula #1 = {=(IF(full_date=($B5),"Yes","No"))}
Formula #2 = {=(IF(full_date=($B5+1),"Yes","No"))}
full_date represents a Vertical table of Dates.
Formula searches full_date and sees if it matches $B5 (also a date), returns

Have a database and need to subtotal by a column that has no set number of
characters, some with "-" and a letter after, some just whole numbers.  I
want to sort by the whole number and ignore the "-".  Ideas?

Is there a way to change the "voice" that excel uses with this function ?
Thank you in advance.

I am trying to calculate an annualized rolling sum for data as follows:
ColumA           Column B
10/01/97                5
10/12/97                6

Firstly, I am a basic Excel user, alas coding etc means nothing to me.
Please help, I have a drop down list where I woudl like it possible to
select more than one option (tick box) I have gone to validation and have
nothing that mentions "multiple". I have Excel 2003 and would ...

I have a colum of 2000 numbers (negative) and I would like to have them all
positive.  I know I can multiple each number by -1 so it will be positive
(ex:  -25 *-1=25)  but I do not want to have to do  *-1  to each cell, cell
by cell.  Is there a way that I can change the sign in ...

I am not so good with using excel and nobody in my office can figure out
what I'm doing wrong.
I am trying to sort a list of folders first by Box Letter and then by Folder
Number.  I want my list to look like this: