I already know how to create new worksheets from a template file but
I don't know how to import
my data in an automated way.
When I type "Excel /t TemplateName.xlt" it generates a new empty

my spreadsheet consists of about 7 columns of data, each row has
relevant data that corresponds to each column in that row. For example,
in Row 1, I have A which is product, B which is description, C which is
price, D which is stock, and so on. I had to sort column A in ascending

Hello.  I would really appreciate some help with writing a macro, please.
I have a report that imports data from another system as a list.  It
contains upwards of 20,000 rows and can be considerably consolidated, but it
has issues.  I filter for zero dollar values on the money ...

I'm having a problem with an if statement (given below) for varying tax
rates based on given amounts.
The purpose is to determine the stamp duty payable for a purchase of a given
value. The rates are:

How do I divide an entire column by a specific number? Furthermore, is
it possible to round those numbers so I dont get "4.758" for example,
and can it overlook text in the same column on certain cells ?

Can you use formulas to change the shadow of the cell when certain
conditions are met?  I am very good using Excel, but have never tried this
and I cannot find any documentation.  So, I think that it just cannot be
done.

I am creating a document in word with excel VBA.  I figured out how to
add a command button to word from excel VBA, but I can not figure out
how to add code to that command button for when the command button is
clicked on.  I do not want to use a userform.  I know how to add code

hi, I have a big excel 2003 book with many sheets,graphs and formulas, I use
"save as" command for saving a copy in a different location,
when i try to open it  Excel shows the repair window telling that thefile is
seriously damaged. The file opens perfect using openoffice calc ...

I have a report that is layed out calendar style. By this I mean there
are 31 rows of data about 20 columns wide.
QUESTION: Is there a way to hide entire rows number 29, 30 and 31 in
February and row 31 in April, June, September and November based on the

First time & new to excel macros. I have a macro which copies data &
inserts it into a viewable summary sheet which can be printed. The
range is 6 cells & if cell k7 is selected I want to stop the macro. I
have attempted to use IF command with Then End but it ignores it. Here

A user here is having the same problem as described in a previous topic
(http://groups.google.com/group/microsoft.public.excel/browse_thread/thread/b32b5
0c3e69981d/dc8adb6c01616d70%23dc8adb6c01616d70).
Windows XP Pro, SP2
Office 2003 Pro, SP2

I have an excel colour document (red, white & grey) which I want users
to print in colour ONLY. I use the grey font as a shadow font which
users can write over in pen.
The problem arises when they print it in black & white; even the faint

i have this sheet which contains user information. User name in the
sheets are repeated. I have used pivot tables to display this data.
However, I also want a column which shows the total number of users.
Currently, when I select "Count of user name" in the pivot, it counts

How can I delete column "B" for example and then add a new column after
column "F"/
thanks

I have an inventory worksheet with 3 columns. Each of the columns
contains values that should exist in at least one of the other two
columns. We want to visualize the rows that contains values not
represented in another column.