This is my problem. I must create four combo boxes to display unique data
(from numerous duplicate entries), where the data displayed is dependant upon
the previous combo box. An example of data may be:
Class    Category    Sub-Cat    Type

I have a workbook containing a picture.  How can I save that individual
picture as a bitmap or jpeg or other image file as I want to use it
elsewhere as a background for an Access from?
Many thanks......Jason

I have two  columns of text strings, one of which (col A) is just an
alphabetic string  and the other (col B) is an alpha-numeric.
What I want to do is  check whether each of the strings in col A is in
col B (if the numeric suffixes were removed).

Using XL 2002.
I was looking for this in XL's help, but couldn't find it:  What is the row
limit for pivot tables?
I have a set of data that I know will have 48,309 rows (less than the 65,536

I have a "main' sheet, which is setup as a floor plan. I have 5 other
sheets, each a portion of the the floor plan. I am looking for a way
to make a change to the numbering on the main page, and have it
updated on the corresponding portion sheet.

I am using the following formual to find dates (9days after a specific
date).
=IF(G4>0,INDEX(DATES,MATCH(G4,DATES,1)+9)," ")
What I am needing is;

Column Z contains multiple dates ranging over 10 years.  I am trying to count
the number of cells in Column A that are between two dates (e.g., 01/01/07 -
01/31/07.)
I tried using

In column "A", rows "7-46" are cells to record the day of the week worked by
multiple employees.  Each week is new and different.  The day "MON" might be
recorded in rows 7-10, "TUE" might be in rows 11-15, etc.  I want a formula
to count the numbers of days worked in a week. ...

It's my first time posting so I hope I am asking a not too basic
question...I tried searching for previous posting relating to this but
had no luck.   My question is,  I have a worksheet with months
starting in July 07 - June 08.   Each month, as data become available,

Does anyone know how cells can be adjusted automatically to the amount
of data that a cell contains? Is there a property setting or
something?
Thanks,

Sorry about the form of this question, I'm not very good at explaining
things!!
I have compared values in conditionA against condition B. It is a
unidirectional comparison in that I cannot compare condition B against

Hello to all,
I tried to record a macro to sort a list of names in 4 sheets. The names are
actualy copied from the main sheet to the other 3.
I selected the rows in the main sheet (P1) from row 14 to 58 and selected

I would like a macro that will do the following:
Copy data from A1 to b1 to c1 to d1 to e1 to e2 to e3 to e4 to d4 to c4 to
b4 to a4 to a3 to a2
(I am created a rectangle with the data.

Running Office 2000
Whenever I exit a workbook I now get the following prompt:
                     'do you want to save the changes you made to Book 1'
I've repaired my Office installation, but this had no effect.

I need help with a macro. I need it to be able to complete the following
task in a workbook. I have a main sheet with data, and I need to be able to
assign a word or numerical to say column "H", and it would take the
information in that row and create another worksheet named the ...