I am testing Advanced Filtering for an application.  I read the Microsoft
article
http://office.microsoft.com/en-us/excel/HP100739421033.aspx
Unless I am doing something wrong, it appears that every time I want to

I have a table with three columns of data. Column A contains a part
number such as "Part XX", or "Part ZZ". Column B has a date in the
01/01/05 format. Column C has a numeric value. There are about 20,000
rows of data. The dates cover three years. For example:

me debashis
is there anybody to help me?
my probs is
how can I create list through data validation

I imported a lotus 123 file for tracking investments.  When I try to enter a
date Excel gives me back 1/0/00, which is the beginning of the 20th century.  
I've tried several date formats to no avail.  I also get a flag in the cell
saying the date string only has 2 digits for the ...

Me, Debashis
I want to create a vlookup in, say file, book1
But refarences will come from, say, book2
how will I create it

I'm wondering if there is a way I can use those SUM() or Average() functions
with the addresses referring to the value of a certain cell ?
I have my 30-day daily sales data from Column B to AE, and my subtotals (e.g.
=SUM(B2:AE2) / averages are on column AF and AG - I'm just ...

I want to create a spreedsheet that allows text to stay in one cell without
writing over to other cells..like instead of making the cell longer, I'd like
the cell to get thicker and have more than one line of text in the cell.  Can
someone please ofer some help? Thanks.

I have a column that shows employees working on a given day.  The bottom
cell of that column "total"s the number of employees working.
I would like to have the cell below the "total" cell, which would be
"overtime shifts available", increase by "1" for each decrease in the

Folk:
After one of the updates, whenever I open a previously saved Excel document,
it opens about 1/8 the size it did previously.  How do I set the page size
when a doc is opened?

I've created a checkbox in A1.
If the checkbox is checked, I want B1 to appear as 1 and if not, 2.  I
cannot get my if function to work.  The worksheet recongnizes A1 as an empty
cell.  I tried checkbox1>"1", and got a name error message.  Help.

When I click on the data in the pivot table and deselect a column by
unchecking it, it disappears from the data list and I can't get it back
unless I go back to the layout & manually put it back in each time.  Does
anyone know how to prevent this from happening?

How does one delete a checkbox? I added a checkbox (ActiveX control)
to a cell, and now I want to remove it. But when I select the cell and
hit the delete key, the checkbox remains. I've tried deleting the
column or row, but the checkbox simply moves to the next column or

I have a long list of names and some of them have tilde's over certain
letters in their names.  I need all of those tilde's removed but it doesn't
seem like the Find/Replace is going to work in this instance.
Can anyone help?

How can I change the statement below to use the name of the workbook running
the macro rather than the hardcoded workbook name in that statement?
Windows("workbook_a.xls").Activate
Don

In my reinstallation of Excel 2007, in the list of macros (Alt+F8) the name
of the workbook containing the macro is displayed first followed by the
macro name which makes it quite difficult to track down the one you are
after.  I don't think workbook names were shown in the ...