datafilterautofilter

--
Don Guillett
SalesAid Software

"Priscilla" wrote in message
...
Hello,

I am not sure if this is possible.

I have a excel database that have a lot of information. What I want to do
is, creat another worksheet within the workbook, and select only the cell
that have information in the database worksheet.

ie. (database worksheet)
column 1 column 2
column 3
Apple TY
1,000
Banana NN
1,500
Grape CA
2,000
Orange

If column 2 is not blank, then take the information and put it in another
worksheet. In the event there is a duplicated field it should group it
together. Prensently, I created a pivot table to do that, but everytime I
make changes to the database worksheet, I need to refresh the pivot table
and
copy it over to the worksheet. I know I can do this easily using Access.

Thanks,
Priscilla