Rows of data from two sources have been combined and sorted on one worksheet.
To identify the source of the data, the rows are 'flagged' with the acromyns
"ign" or "leg".  The only reason they are appearing on this report is that
there is/are cell(s) of data that have been ...

How do I disable the Clipboard Full Notification in Excel 2000?

Anybody know of a search engine that will find a word or phrase in a file,
such as Excel, which has several 'sub' documents/worksheets, and
identify not only the file but the worksheet it is on?  I have Agent
Ransack, which is good but doesn't seem to do that.

I am hoping someone will help me out with a problem that I am currently
having.
Users all share a common spreadsheet that I have created.  I have placed
this spreadsheet in their own sub directory on our server (windows server

Does anyone know a way to change an excel file icon that is placed on the
quick-launch area of a task bar?  I have several shortcut icons on everyone's
task bar to take them to a specific spreadsheet that I have created located
on our server.  I would like to be able to ...

How do I automatically select the next empty cell, in column "A", when data
has been inserted.

Hello  I want to display a message "Please contact your Manager" whenever the
number 040 0r 044 is entered into a cell.  F another number besides i040 or
044 is entred nothing happens      I tried an if formula but that gets
deleted whenever a number is entred in the cell  HELP!  ...

I frequently need to re-sort data in a shared workbook. The Data>Sort button
recognizes the header row and remembers the sort order when the workbook is
not being shared but does not recognize the header row when the workbook is
shared. Nothing else has been changed except ...

This may be a bit confusing, but I was puzzling over this over the weekend
and can't figure out a solution.  I'm assuming the answer to this lies in VBA.
I have in mind a template for calculating bond interest payments.  What I
would like to do is to enter the number of periods, ...

I have a column with a formula to calculate a date based on a date entered in
the previous column.  I want the result in the column to be blank until the
date is entered.  Now it reads 01/01/00 until I enter a date for it to
calculate correctly.  Please help!

I am adding a background color (Red, Yellow or Green) to a cell to indicate
progress attained.  I would like a different cell in a 2nd tab of the
workbook to automatically be updated with the color that was put into the 1st
cell.

I have a column that contains dates in this format mm/dd/yyyy. I need
mmddyyyy no slashs. If I do a custom format it still shows mm/dd/yyyy in the
the fx bar. I have tried using vbscipt replace method and copy the new date
to a different column but it drops the zeros no matter ...

some muppet has reassigned Crtl+Z to a macro and i cannot find where to
put it back to 'undo'
any ideas?
I have been through the 'help' and know how to do it if i knew where it

how do i use REPLACE to change 48.5M to 48,500,000?

I have a macro that I'd like to limit the pages it can work on.
Sub columnremove()
   Dim myRng As Range
   Set myRng = ActiveSheet.Rows(4)