Mac Forum / Applications / Excel / May 2006

I suspect that this group is way past my Excel abilities and I hope you can
help with an ongoing problem.
In many of the workbooks that I have created, one of my worksheets is a
tally of data from all of the individual worksheets.

What I'm trying to do is make an order form that consists of 4 columns:
v - catalog # - title - price. But I'd like to see them twice on the
same page. So that my header row will show: v - catalog # - title -
price - v - catalog # - title - price. And I need to sort this

Anyone have a good formula or setup to doing a simple Checkbook
register in Excel?
Thanks

I have a .txt file consisting of values separated by ", ", i.e. a comma
and a space. When trying to open this file, Excel 2004 starts the Text
Import Wizard, and manages to put the values in separate columns in one
row. However, I want these values in separate ROWS in one column. I ...

I have a VBA macro that has been working thus far, and I'm pretty sure it
worked after I added sheet protection, but suddenly I get errors on a
simple cell write.
I press a button, and a macro is supposed to do a few things including

New to this hope somebody can help.  The following is an exam question
beit an old one but still in use.  "Erase all the data in the
Spreadsheet to leave all cells blank without reloading the software" Am
I missing something or am I overthinking the question - HOW can this be

Is there a way to unprotect a spreadsheet that was given to me?  I don't want
to have to keep supplying the password.

I am using Excel version 11.2.3 for Macintosh. My problem is that I
need to import CSV files that are generated by a Windows system in
UTF-8. The file contains Eastern European characters, in this special
case Czech characters.

I have to hide the status bar when the excel application is completed.
So, I call obj.hide but when I went to print preview, it has an error
and crash the excel application. For some reason, the excel doesn't
work well with call obj.hide. How do I kill the memory and make sure

my date column contains Y-M-D, but I want to only sort by Y-M and withn
each month by another column (name). How?

Hi Guys. I have the following problem:
When I format some text/tables in Excel and I'd like to paste it into a
Mail (Entourage), then it just shows the text inside the table without
any color/format/table. It just looses any format it had before.

when I enter a number 1-19, the cell automatically set this Jan-19. I try to
set it to General under by right-clicking the cell and selecting Formatting
Cells, but it changes to some number like 38909.  I keep on trying and does
the same thing.  Is there away to make General the ...

I am trying to set up work books and work sheets to update information
automatically and can't work out which is the best way to do this.
Initially I have a workbook (A) which has 52 sheets, one for each week. I
need to carry some of the information over each week - what is the ...

I would like to create a Macro that runs automatically when I first
open an Excel spreadsheet.  The Macro can reside on either the primary
spreadsheet, or on a secondary one.  The Macro will actually open a
second spreadsheet that contains additional Macros for use on the

I have problem in deleting the specific cell that has date format. The
cell has date format set in the spreadsheet. For example - 28-Apr-2005
Basically, I would like to delete the cell when user enter the wrong
value. For example: 666