Anyone know (have) a function or macro to relocate entire arrays
from rows to columns?
I have a set of calculations that are just easier for me to deal with
in a column format.

I need your input. I made program in Excel and all is working great. My
problem:
I need a way to produce a summary of the daily activities. We are using a
seperate file for each transaction.

I have a spreadsheet that I manage inmates with.
I have one column (H) that ranks them in order of "needs assessment".  They
can be either H, M, or L (High, Medium or Low).
Columns M through Q are the Basic programs they take.  If they are on the

Hi, I am looking for some help with this;
I have a worksheet with up to 2000 lines, the first column contains
numbers, the entries in this column are either 7 or 8 digit numbers, by
formatting it with 0#.###.### I force it to be a 8 digit number in case

I haven't done much research yet but I'm hoping to take the easy way out.
Does anyone have a good sugestion of how we can turn an excel file into a
read only file once we are done with it?  In this case, I don't think we
want anyone to be able to edit it anymore, so I was ...

I have an access macro that creates four reports then exports them as
excel documents. I would like to add a toolbar button to excel that
will run macro-- it will save me opening access running the macro and
closing access. Not a real time saver I suppose, but I'd like to do it

I want to...
open new file
check cell data (If data="xyz" then goto close file or whatever)
   write cell data

My computer and my wife's computer are networked.  I have WinXP and Excel
2000 9.0.3821 SR-1 on my computer.  She has Win98 and Excel 2000 9.0.2720.
When I print a spreadsheet created in Win98 with an earlier version of Excel
(I'm not sure which version), I get "squiggilly" ...

My computer and my wife's computer are networked.  I have WinXP and Excel
2000 9.0.3821 SR-1 on my computer.  She has Win98 and Excel 2000 9.0.2720.
When I print a spreadsheet created in Win98 with an earlier version of Excel
(I'm not sure which version), I get "squiggilly" ...

I am using the following formula, copied across and down the sheet, which I
arrived at with help from this group. (Thanks once again for that).
=IF(ISERROR(SMALL('Input List'!$AR:$AR,ROWS($A$1:$B1))),"",INDEX('Input
List'!$B:$B,MATCH(SMALL('Input List'!$AR:$AR,ROWS($A$1:$B1)),'Input

Is there a way to merge text and a cell value such that the cell value
has a particulat format.
For example, suppose I want to display the following in a cell:
Less 5% of (contents of another cell) =

This seems like an easy question but I can't seem to find the answer.  Does
anyone know if Excel has a limit to the number of characters allowed in a
cell?  Thanks.

1st Thanks for reading/helping, I sure can't get this to work.
I have a group of numbers on sheet 1, these numbers are then sent over
to sheet #2 and sorted. I want these numbers to be resorted when I go
from sheet 1 to sheet 2 automatically

I have a table which requires sorting due to changes in values
everymonth.
For eg.. We have 6 clients. The growth % of these clients changes from
month to month. These are automatically picked from the system. Through