Selecting Column & Row contain text

[Priscilla]

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

[Don Guillett]

data>filter>autofilter>

--
Don Guillett
SalesAid Software
[email protected]
"Priscilla" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
>
>

[Priscilla]

Advance filter, does not allow me to move the filter information into another
worksheet. The data only reflected in the active worksheet.

Priscilla

"Don Guillett" wrote:

> data>filter>autofilter>
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Priscilla" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
> >
> >
> >
>
>
>

[Don Guillett]

select all>data>filter>AUTOfilter>nonblanks>copy\paste

--
Don Guillett
SalesAid Software
[email protected]
"Priscilla" <[email protected]> wrote in message
news:[email protected]...
> Advance filter, does not allow me to move the filter information into
> another
> worksheet. The data only reflected in the active worksheet.
>
> Priscilla
>
> "Don Guillett" wrote:
>
>> data>filter>autofilter>
>>
>> --
>> Don Guillett
>> SalesAid Software
>> [email protected]
>> "Priscilla" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
>> >
>> >
>> >
>> >
>>
>>
>>