I want to delete all dat in the sheet1 when I close the workbook,
but not understand to write VBA code for excel.Is it possible ?
How to write it?
Many thank's.

I have a chart that is using numbers on a sheet. One of the columns
has a conditional formula in it that returns either a number or #N/A
using to avoid a divide by zero error. I using the formula N/A() if
the IF Statement formula would be divisible by Zero. I want this

On the Worksheet tab, I will ultimately have quotes from one or more
different vendors.
I want the vendor (columns i,K,M,O,Q) with the lowest price (columns
J,L,N,P,R) from the Worksheet to populate over to my Order sheet.

I am using a workbook with 4 worksheets:  RFQ, WORKSHEET, QUOTE,
ORDER.... The RFQ worksheet is the request for quote from the
customer.  When the customer gives me part #'s to quote for him, I
enter them into the RFQ worksheet.  This automatically populates the

I have a formula that works fine, written as:
=IF(AND(MAX(Q10:R10)=1,MID(A10,1,3)="ARU"),2,MAX(Q10:R10))
My problem, though, is that I want to check cell A10 for other
possibilities besides"ARU". Let's say I also want to check for "CON"

I have 2 worksheets in the same workbook.  One worksheet is for the
price quote to the customer and has many rows, each item/price/
quantity in its own row.  The other worksheet is for the actual order
sheet which the customer has purchased based on the quoted items.

I have a list of auction items, and as they are sold I will be filling in the
customer number next to the corresponding item (column headings are cust# and
item description).  I want to be able to create a receipt from this data.  I
have the receipt formatted and created.  ...

I am trying to create a form on Excel that does the following:
The user enters a piece of data unto 3-4 columns.  The user then hits a
function start key.  The data is then stored in a different sheet using the
next available line.  I do not know VB except for BASIC Macros.

I am having real problems with data validation and understanding how to
attach formulas and named ranges
One of the issues I have is as follows:
My List exists on a sheet called "lists" and  is called "fback" - it

if a vlookup returns "#n/a" how can I make that cell show a zero instead of
an "n/a" but return a value when it is not n/a?

Ugh!  This is turning into quite a mess.  I have a date (1/31/2008) in E2.  
Using the day function, I have the number of days in that month, which is 31,
in cell E4.  I have a start date (1/29/2008) in A5 and an End Date
(1/15/2009) in B5.  I have the number of days in C5 and an ...

I am running Excel 2000 in Windows XP.  I received an email with an .xls
attachment which, when I opened gave me the macro warning.  I didn't need the
macros so I chose the disable option.  I copied same to a new worksheet so I
could rework some of the data - which was not ...

I am developing a spreadsheet for us to use at for keeping track of bonuses.  
I have 7 columns - date, policyholder, policy, type, premium, bonus, and
initials.  The date, policyholder and premium columns we'll fill in.  I have
created dropdown boxes for the policy and type ...

Hello all, help requested on date stamp.
I have a workbook with several name tabs.  Within these name tabs, colum
H,I,J,K will have a 1 entered into them as people update the cells.  
I then have sheet3 that has these same names and a link to cells h-K of

I'd like a dropdown list to apper when criterion isn't met. For example:
=IF(J1="","",dropdown list using a list called =Options)
Because I don't want a drop  down list in every cell in the column, and it
would take too long to do it manually, can this be done?