how do you split a file into two (in Excel) when you have exceeded the
limit of 66000 lines.  please advise.
thanks,
pago

Im just looking for opinions here and suggestions. I have an older
file here (6mos)that has some odd behaviour. When I right click on the
sheets present, I do not have the option to insert a new worksheet. I
can't figure out for the life of me why, as every other file that I

I am trying to transfer values from cells D1:D400 in worksheet2(ws2) to cells
B1:B400 in worksheet1(ws1). I only want the values to appear in worksheet1
and not the cell reference formula. One method is to copy cells form ws 2 and
do edit paste special-values but I am wondering ...

I have one worksheet with user fist name and last name. I have a
second sheet with users first name and last name and username . I want
to match up the second sheets user name with the first sheets first
\last name and insert it to a new column in the first worksheet i was

So, normally I would use this format for my conditional formulas:
=SUMPRODUCT(--((X2:X500="foo")+(X2:X500="oof")>0),--(Y2:Y500<100),(Z2:Z500))
Which gets me the sum of column Z, if column Y is less than 100, and column X
is "foo" OR "oof"

I'm trying to look up Metric Prefixes using their abbreviations.  However,
the lookup needs to be case sensitive to distinguish between, for example,
"E" for exa and "e" for dekao or "M" for mega and "m" for milli.
I would suspect that there is a way to do this using the Exact ...

I want to take a dollar amount and round it up to the nearest nickel.

I have a large file with dates formatted mm/dd/yy.  I want to create a
formula or macro that says "if mm/dd/yy is current week M-F,then week #."
Help!
thx.

Does anyone have any idea how to accomplish the following using a
macro?  The first sheet has 'n' number of rows.  I want to
automatically create a seaparate worksheet for each block of 25 rows.
The 2nd worksheet would contain the data from rows 1-25 of the 1st

I know to pull the earliest date or latest date from a range of cells I use
the min or max functions, but I need to wirte a more complex statement.  
1.) I need to search a range of cells and pull the earliest date and latest
date for all those tools.  

I would like to change a date into text.
Cell A1 - 03/14/2007
I would like to change that value to March 2007, and I don't mean by
changing the format of the cell.  I want the value to be March 2007.

In Excel 2000, I’m told that I can’t reference other worksheets or workbooks
when using conditional formatting.  Looking through these forums, I put
together a formula that highlights cells if there are duplicate listings of
companies found in column S (row 2 has headers and the ...

Hello, i basically put on stock records on the sheets.
we have got few cafe n shops. i have got a standard format one a sheet and i
copy paste it. now i take stocks weekly and every week i have to copy paste
the format on new sheet.

I want to tabulate a From->To places list
to signify trips FromA->ToB.
Say I have col A validated against a list that
signifies the "From". Col B is also validated

I have a column of data comprising a series of 25 arrays.  I would like to
generate an array whose elements are the average of the corresponding
positions in each of the 25 arrays.  
Suppose, for example, the first array is in cells A1 to A1000, the 2nd in