I have used the find and replace function within excel.
Unfortunatley I did not type a value for find.
Is there a way to stop it running (over 2 hours now!!)

Would you please help on the below example: -
Pls refer to attached example:
I need to put the drop down menu on cell B1 (done) - with the lookup info on
the lookup tab

I need a function that can tell me number of hours worked during morning,
evening and night shifts as well as divide the shifts into regular time and
overtime hours worked.  
For example:

I am looking if there is a function that can retrive the number of cells
with specific value in one column according to a specific value in another
column. for example:
A table with 2 columns, one for dates and the other is 0 or 1 values. I am

Can Code be linked to cells?
Mike H graciously created this code to change cell colors per my question
which follows:
Private Sub Worksheet_Change(ByVal Target As Range)

=IF(C3<>0, (C3-C2)/B2*100 & " (" & C3-C2 & ")","")
This is the function I used at this moment. but it has some problem. all
data in column B & C are number format with no more than 4 decimal digits, so
that both (C3-C2)/B2*100 and C3-C2 are still number, especially without

I want to automate a row with summary calculations for each worksheet that is
added to my workbook. Is there a macro that would enable me to add a row with
calculations for a series of worksheets? The worksheets will use the same
format, so that the data will be easily found. I ...

i have a work sheet that will be used by two users/computers, in the same
domain but have different IP's. i want to restrict the other user to enter
the data in a single column only and that data entry will be password
pretected at his end, so that i cannot enter the data in his ...

I am the sole user of this computer. The files are stored on this computer
(Vista Home Premium, Excel 2003) I create an Excel file and save it. I
immediately go to the file in Explorer or "Open" in Excel and try to open the
file again, but I get the message that "filename.xls is ...

my logic isn't working here.  i have if a1=multiple of 60, then return a1
otherwise return 0.  can i do a "multiple of 60? - for example 60, 120, 180
etc...or i can hard code these since it's only up to 360.

how do i get this logic to work.  if x>30 and ends with .00 then (basically i
want it to give me the result of 24.00 etc but not 24.21

Please is there an easier way of copying a row with formulae containing
relative rows and insert the row elsewhere in the document

how do i do a if A1 >200 and <300 return A1 otherwise return 0.  i can't get
the logic to work

i'm trying to figure out how to make this formula work.  if the account id is
"123" then sum colum "a" and "b" for all numbers in the account.  example:
acct   debit    credit
123    -200    

I want to put the word "COPY" on a worksheet when I print it.  Can it be
done?  It would be two pages of the same worksheet, only pg#2 would have the
word COPY on it.