I copied a populated worksheet into a new, blank workbook. I then
selected all cells in the new worksheet and deleted. I also reset the
last used row. No data, no hidden sheets, no macros...no code behind
the book or sheet.

I use dynamic range names quite a bit, and although they appear
correctly in the Names list accessed via Insert/Names/Define [eg.
=Offset(Sheet1!$B$2,0,0, CountA(Sheet1!$B:$B),1)], I can't get them to
appear in the NameBox dropdown list.  This applies whether I create

Dear People,
Does anyone know how to delete duplicate entries from excel?
With conditional formatting it seems ezy enuf to find dupliates but
how to delete them ... apart from one at a time that is. Ok when the

I'm currently in the middle of doing an assignment for college on models for
decision making using excel. One of the question I am asked is to give a
description of the inputs, assumptions and output in the model. I understand
everything but the assumptions. Could anyone shed ...

Months ago, I created a drop down list for one of the columns on my
worksheet.  Since then, I have decided to eliminate the list. I went in to
the place where I defined the range and deleted the name.  I also deleted the
referenced range.  But, when I click on a cell in this ...

How can I format the contents of a database created in Excel to be used in a
mail merge? Please help!

Is it possible to insert a picture or clip art into the header or footer?
If so, how? We are on version 2000.
Thanks,
Jasper

I am making WHMIS label templates and need a wide hash border. Is it
possible to create new borders for excel. Again, I need wide (1/4") hash
borders. If anyone knows of templates on the web with these types of
borders....

What function can I use/make to figure the difference in percentage between 2
monetary amounts?

I have a pivot table with 69 columns and 42 rows created with VB from another table of values.  I am trying to loop through the seriescollection representing each of the columns.  I have noticed that I cannot refer to seriescollection(i) when that set of y-values (column) has no ...

http://www.ozgrid.com/News/excel-validation-tips.htm
Please consider the following, under "Excel VBA Tips and Tricks", then
"Updating Validation List", and note there is a link..."Download a working
example from here".

Hi!  
Would appreciate any help you can send my way:
I have a sales spreadsheet showing sales per month for last year versus
the current year.  The data is input for all of last year and the data

Is there any way to use the value shown in a drop down box in a sum
formula.
I am trying to work out the total of a column including whatever
number is shown in the drop down box. The formul at the moment is

Customer wants averages from worksheet containing data.  I have set up a
pivot table for him but it gives sum information.  Can that be changed to
average instead of sum?
Thanks.

I have a question regarding auto filter usage. I have a sheet/table
which has a table calculating certain values regarding certain other
values manually typed in by third persons.
In order to protect the formulas I have locked the cells but now I