I have a data set and have created pivot tables using this data set.  In my
data set I have a column for comments so that I may write text.  I have
created a pivot table and incorported my "comments" column in the pivot table
as a column.  However in my pivot table the cells in ...

i set up a macro below to filter out a column (dates) that are more than
cell F2, where cell F2 is also a date. But it just doesn't work. Why? Thanks!
Sub Filter_BS()
   Selection.AutoFilter Field:=7, Criteria1:=">" & Range("f2"),

Excel 2007 - I can easily change the source data in Excel 2003..Click on
Chart, Source Data, Series, etc... but now I have moved to Excel 2007 and
need an easy way to expand or revise a chart and I can't seem to get it.  Any
help Appreciated.

Need Excel formula to merge one list of phone numbers with another...like I
have a voter listing and a list of voters in 2006 and I want to create a
column that indicates whether each voter...voted in 2006?

My workbooks with macros are created and work fine with Excel 2003.
The problem started when I tried to install xl2007 on the same OS with
xl2003.
Now when I open a file it opens by default with xl2007 and makes a big mess

I have a question involving exceeding the amount of IF statements.
Cell A1 has drop down list of 100 choices, the user selects one
Cell B1 has another drop down list of 100 choices, of which the user selects
one

i was able to set up the hyperlink but i would also like to include the page
number in the table of content page. how do i get it to look like this.
Report..............1
Report II...........2

I have data validation set up with the In Cell Dropdown, and the list has 10
values.  However, the dropdown only displays 8 rows, so selecting one of the
last two options requires scrolling.  Not that big of a deal, but it would be
great if there was a way to have the dropdown ...

I installed Excel 2007 (part of Office for Student and Home) on my computer, but left my old Office
2003 in tack.
Now I can not get any desktop shortcut to frequent files to work in either version of Excel.
If I change the file association to the old Excel, I get 8 warning messages ...

I am doing statistical analysis and as part of explaining my research
methodology I have to clarify my sampling method. I selected my sample from a
large spreadsheet by using the ctrl f tool to look for care homes within
different geographical areas. the first home that came up ...

A    B    C    D
03/31/07    17    40    3/31/07 17:40
04/01/07    14    45    4/1/07 14:45
04/01/07    13    45    4/1/07 13:45

Dear NG:
I'm somewhat new to spreadsheets and VB so please bear with me.
I wanted to restrict the scroll area of sheet01 (since it only contains a
graph) to A1:Q26.

I have names in column A  and in columnB I have rates in spreadsheet 1.  
I have to make another spreadsheet (spreadsheet 2)  where column A says the
name like Column A and column B in  that says the rate like spreadsheet 1.
I would to have a drop down menu where I dont have to ...

I'm working on a sheet where I need a formula in a column that is, say, col A
* col B. Easy without merged cells.
Say that nothing in Col B is merged. But, Col A, for instance, consists of
two cells vertically merged, maybe 3 or 4 in places. So A1 and A2 are a

I'm trying to do a vlookup with 2 sets of criteria.  For example:  I want to
look up a customer name in column A and the customer state in column D, if
they both match then bring back the # of employees per state in column F.