...frequently makes answering your question so much easier!
Bob Umlas

In Excel 2003 I would like to combining (for lack of a better term)
several rows into one and have it structured so that when I click the main
row (Call it Misc;) it would expand all the Misc,/Items rows hidden under
it. I would also need to be able to add/total any numbers in the ...

I have a data as below, each gourp have time with
1st row is Calls Offered
2nd row is Calls Answered
3nd row is Calls Terminated

Key words:
Key word        Category Code
ACCIDENT        1
ACCOUNT            2

I have a large 42,000 list of US zip codes which each row (42,000 rows) has a
zip code column,  a counties column and states column that I want to match to
a smaller 4,000 zip code list- with a zip code column & dollar amount column.
Or even, use all the Illinois zip codes ...

I have a user who has a workbook open and when she opens a second workbook,
the first one automtically closes.  What causes this?

I have a spreadsheet with a bunch of cells that have green corners.
I would like to get rid of the green corners now if someone can tell
me how?
A few weeks ago if I recall correctly I formatted these cells and

I have a table of data with the following layout
Flag        Name      Service
1             mike       service 1
                            service 2

...frequently makes answering your question so much easier!
Bob Umlas

I have a worksheet with 6 columns (by Month)
Sep   Aug   Jul    Jun    May    Apr
I have to review starting for example with May, I need to find any cell in
May range that is null <> where Jun and Apr both are not null <>

Each month we need the identities of employees who joined the company 3
months and one year ago.
It is nonsense to go through the list manually, but I can't find a way to do
it automatically. Ideally, I would end up with a separate spreadsheet, or

I have an application written in Visual Basic 6. My application
creates a Customer Details Report in Excel. All done till here but now
my problem is that I want to prevent the users from making changes to
the excel report or to copy/paste/delete data from my report or to

I have a long list (column) of whole numbers (dollar amounts) and would like
to add a decimal point on each number.  example change the numbers from
2927568021 to 29275680.21.  I have tried changing the format, but it keeps
adding 2 zeros on the end.  thanks

I'm newbie. Sorry, if this question is trivial.
In the column D in the cells there are the words "apple" or "pie".
I want to delete those rows in which the corresponding cell in column
D

I am working with Excel 2007 and when I try to select a range of cells,
nothing happens.  The lovely blue shading is not visible.  I first notice
this when I tried to select non-adjacent ranges.  When I pressed CTRL, then
clicked a cell with my mouse, a box appeared inside the ...