I have the following problem to solve.
I have 2 seperate sheets with data which I need to be merged. I.e.
there is the following data:
Sheet1 - Sales 2006

I have 15 sheet is one workbook.
12 of them represent months starting June 2006 until May 2007.
the other 3 sheets are reports.
For each month in the range AW201:AW249 either 1 or empty (nothing is

Hi, I hope someone can help me with this.
I'm using Excel 2003 and I have the following function:
=IF(A1>=0,A1/IF(OR(B1=0,ISERROR(B1)),AVERAGE($C$1:C4),B1),-A1/
IF(OR(ISERROR(B1),B1=0),AVERAGE($C$1:C4),B1))

simple spreadsheet which allocates numbers of duties depending upon number of
employees,  allocations always need rounding up or down. I can do this but
need to put remainder ( i.e between -0.49 and +0.49 into a new cell in order
to carry forward to the next round of alocations)  ...

I have two columns, A and B. Each column contains a list of data in
text format e.g.  01TI518A.PV . It is possible that duplicates of this
text may appear within either column. Also, the number of data values
in each column is variable as they are imported from an external

my workbook have a password protected macro.
I'll implement userform, its have ok button. I enter the macro call
statement in OK button click event
if I click the button, it displays "COMPILE ERROR HIDDEN MODULE: MACRO

I have A, B columns,
and I want to do conditional-formatting for rows whose A is the same and
B is not the same.
I mean

Excel 2002
Q1::         When I attempt to record a macro, the I don't see the
macro 'toolbar' that should hang in the Excel window. It was there but
now does not appear.

I have a report in excel that gives the diagnostic codes for a person.
I want the report to say the diagnosis insted of the code. I have a
list of what each code is in excel. Ex: Column I has the diagnosis by
number ( 711. or 739.99) column Q is numbered 710. - 739.9. Column R

What is the way to leave the formula (sum, etc.) intact after erasing the
contents inside?  Where I do set this?
Thanks in advance.

I'm not sure what's wrong but I think I may have some settings wrong on my
pc at work.  I am on a network and the problem is this.  When I create a
spreadsheet I have to have shading in certain cells but when I shade them
they do not show on the spreadsheet but they show up if I ...

I have a sheet like this:
cat dog horse rat bird
9   6    8    1   3
I use the SMALL function to get the smallest three numbers

Here is a c/p of partial of my post from the other forum. Any and all help
is greatly appriceated guys! Thanks!
So I have this list that has product numbers in
column A, product prices in column B, and order number for the products in

I inherited an Excel2003 spreadsheet that has historical data on it.  The
titles are in columns A and B, and the data is Columns C and following.  The
person that created the file put the data in order of most recent to oldest,
instead of vice versa.  IOW, July 2007 data is now ...

I have a 2 cells merged, the data in the cells are always 1 of three choices ( 2-1/2, 3-1/2, 4-1/2) If I select my choice of the three and try to extend it to the next cell it automatically raises it by 1 with each cell added. For example:
cell A:1 = 2-1/2 when I drag that the ...