I have a workbook with 5 sheets.
Sheet1 is Customers
Sheet2 is YTD Sales 07
Sheet3 is Total Sales 06

I have a sheet that pulls info from several other fields to create a
text string.  The problem is that I need all of the values from my
other cells to be a tab space apart.  Right now they are separated by
several spaces, but it is throwing off my numbers.

Vista Business, Office 2007.
On one Vista of my three machines (2 Vista, 1 XP Pro SP2) date formatting
does not work.
I have tried a blank sheet.

I have a workbook with 2 worksheets in it. I would like to synchronize the
rows between those worksheets, so that when a row is inserted or deleted in
the first worksheet, a row is inserted or deleted in the second worksheet.  I
would like to do this without using a macro or VB.

Using Excel 2000, I see a menu choice to save the current workspace
but not one to open a workspace.   The only way I have found to open a
workspace is to double click its entry in the Windows Explorer.
Also, the folder in wich the workspace is saved seems to be whatever

I want to know, how to expand and minize the rows by clicking + and -. Pls
send detail report.

This seems so basic to me, but I want to take the calculation of a
formula in a cell, let's say the result of some financial calculation
and then later on I have some text explaining what I did. Something
like this:

Every excel file I open shows numbered columns instead of the normal letter
columns?
Also there is only 256 columns in every excel sheet, 65537 rows.

I would like to know if there is an easy(?) way to change the shape
of an array of numbers.
I have a data set consisting of 300 numbers.  They are in an array of
12 rows and 25 columns.  I would like to change the list to just one

When I open up my excel application (office XP or office 2007) I get
this error-
You receive a "Compile error in hidden module" DistMon.
What is that?

I have a questionnaire that I have written on Sheet1 of an excel
spreadsheet.
1. Do you have a radio    Yes/No
2. Do you own a TV        Yes/No

Is that possible to add a label to a particular data point in the line
chart? I used macro to update my charts regularly and automatically,
but the labels on particular data points cannot be shifted accordingly
when new data point inserted. How can i shift it or fix the label to

I have recorded a macro and am experiencing problems because during the
recording of the macro sheet names have been hard coded. As time has
progressed, extra data has been added and extra sheets have been added and
therefore when I run it I get the message “Run time Error ‘9’, ...

I wasn't really sure how to phrase this one -- this isn't your Typical
Drop-Down List.
I have a SELECT statement which queries SQL Server 2005 and displays the
data in Excel.

i have the following problem :
i am using extremely large excel sheets with specific data in it.
i can report approx 10 weeks into one sheet before it is full. then i
need to use a 2nd sheet.