I understand how to remove macro modules, but I seem to have seen
numerous posts by other Excel users who question how macros could have
gotten into their workbooks to begin with; they say they didn't create
any macros, so why the warnings when they open the workbook. I'm

I was wondering if I can get some Excel help for a problem I have
encountered:
Below is a list of the field names corresponding to the columns in
Excel (separated by comma's):

I am using trying to use the formula shown below, but not getting a
result when I should.
=SUMIF('MERSEY RAIL'!A6:'MERSEY RAIL'!A100,">=M2",'MERSEY RAIL'!
C6:'MERSEY RAIL'!C100)

Hi to all,
I have a workbook called(test) with one single sheet (sheet1). This sheet
(sheet1) is a summary sheet taken from 24 different books that has the
names: g1a, g1b, g2a, g2b, .... , g24b. All of the workbooks has the same

sheet1
table1    col1_1
table1    col1_2
table1    col1_3

how to insert the tab character into the cell?
tia.

I would like to be able to hide A33 and J33 if I33 is null via
conditional formatting in white.
I have tried setting Formula is : =I33="" but does not seem to work.
Any ideas????

How to accomplish the following:
I want to perform conditional formatting on a cell range that
indicates the month. I need to use =TODAY() I guess.
How is the cell format for Jan, Feb, etc.

I have been using VLOOKUP on a few reports recently and it has been
working great, however, cannot seem to get it working on a particular
field. I am linking from a master file and linking to current
workbook.

I would like to be able to compare data between two tables. Each table
contains around 60 brands; however,the exact number of brands varies
month to month, but the top brands are always there.
This is the data I have each month:

I need to sort a rather large data base. Coulmns are State, Customer,
Product, Product Size etc. The entries currently are in order of invoice.
I need to start by sorting by state, keeping all information together
(State, customer ,product, product size etc.) just as it appeared ...

I made formulas that are working good. But I can not copy them easily.
Can anyone help me ?
My problem is detailed into the following Excel file  http://cjoint.com/?hpv1YggtI1
Thanks for your support.

Can anyone suggest an interactive video/CD course vendor for a basic entry
level user, not technically oriented, for Excel 2003?
Thanks,
P

The easiest way to explain my dilemma is by example.  I need a custom
field that is always thirty character spaces long no matter how long
the text is.  So for example, lets say the word is PIZZA which is 5
characters, I would need 25 blank spaces afterwards to get to 30

I need to put a manual toggle (or tick box, check box, radio button,
whatever) in each cell of a column so that if the toggle is on/ticked (value
1), a formula extracts the value from an adjacent cell, performs a
mathematical function on it and enters the result in a third cell.