General

Delete the contents of a cell if it contains #DIV/0! Automaticall.
I am building an execl sheet that holds production data. Some pieces of equipment only run occasionally and because of this they cause a #DIV/0! error. I want to be able to look through the complete range (a1:di54) of cells and whenver I find the error i want to delete the contents of the cell. I guess this is ... 27 Apr 2010 07:39

Column to column of diff. wkbk
Each week a new date and amount is entered, and the sum for YTD is updated. I would like to copy only those columns that have a date entered and the YTD, to another worksheet with the same item list. The problem is when I select the range I end up with the blank columns as well. This has to be dynamic and have ... 27 Apr 2010 06:33

Multiple Rows of Sheet Tabs
In excel 2003 is there are way of having the sheet tabs (at bottow of excel window) to show in more than one row? ... 27 Apr 2010 11:03

Find max with a lookup
I have a list of data as follows A B C 1 Belfast 21 2 South 36 =abs(B1-B2) 3 Laganbank 25 =abs(B1-B3) 4 Balmoral 19 ... 27 Apr 2010 11:03

very urgent : to write the value of next column of the same row
I applied the following formula to find the matching and write the data of the corresponding next cell. Sheet1. the column C:C has custom format 000-000 having the data like this 123-456 12 001-789 11 313-245 13 456-779 16 084-321 18 IF(ISNA(MATCH(D5,Sheet1!C:C,0)),"Not exist",Sheet1!D2). th... 27 Apr 2010 05:26

Creating Appointment
Is it possible to create an appointment within Outlook using Excel? The sheet will have a date when passwords expire, and this will be changed each month. Is there a macro to look at this date and then create an appointment within the Outlook calendar to say something along the lines of 'Change Password for sy... 28 Apr 2010 03:58

unable to cast ..Excel.ApplicationClass to ..Excel._Application
trying to deploy a vb.net dll to clients; on some machines the following run-time error occurs: Unable to case COM object of type 'Microsoft.Interop.Excel.ApplicationClass to interface type 'Mirosoft.ofiice.interop.Excel._Application'. This operation failed because the Queryinterfacecall on COM component for the ... 27 Apr 2010 03:14

how do i get rid of doubles from my database?
i have a large database with many of the email address' doubled or tripled, how can i easily filter all the doubles out? ... 27 Apr 2010 03:14

Please help to search a custom format
the column A1 has custom format 000-000 having the data like this 123-456 001-789 313-245 456-779 084-321 The column B1 has the following data ABC123456 DSD001789 HGH084321 YYY343434 like this 7500 record exist. I want to find column B1 value (numeric ) in Column A1. So ABC123456,DSD001789, HGH084321 ... 27 Apr 2010 06:33

alter column ref
my column references are displayed in numeric rather than alphabetic. eg. the first column is 1, instead of A. Can anyway help me? thanks Kaz ... 26 Apr 2010 22:52