Is there anyway to make autofilter run automatically?

I want a spreadsheet that shows all data on one worksheet and a second
worksheet that has filters information fed from the first worksheet.

Unfortunately, when I add new information to the first worksheet it does not
appear on the second worksheet until I veiw all records and run the filter
again.

Is there anyway to automate this?

--
Lori

Yes, it's a bit involved but it can be done using macros. What you would do
is freeze a few lines above your data to make a workspace for "buttons"
(which can be created from Drawing Objects and assigned titles) that would do
various AutoFilter sorts for you through the macros assigned thereto, and
then erase all the old data on the "Report sheet" and copy and paste that
current sort to the "Report sheet.

Vaya con Dios,
Chuck, CABGx3



"Lori Burton" wrote:

Is there anyway to make autofilter run automatically?

I want a spreadsheet that shows all data on one worksheet and a second
worksheet that has filters information fed from the first worksheet.

Unfortunately, when I add new information to the first worksheet it does not
appear on the second worksheet until I veiw all records and run the filter
again.

Is there anyway to automate this?

--
Lori

How about if I didn't use autofilter?

Is there a better way to write the second sheet so that it only takes rows
of data from the first sheet that meet one simple critiera?
--
Lori


"CLR" wrote:


Yes, it's a bit involved but it can be done using macros. What you would do
is freeze a few lines above your data to make a workspace for "buttons"
(which can be created from Drawing Objects and assigned titles) that would do
various AutoFilter sorts for you through the macros assigned thereto, and
then erase all the old data on the "Report sheet" and copy and paste that
current sort to the "Report sheet.

Vaya con Dios,
Chuck, CABGx3



"Lori Burton" wrote:

Is there anyway to make autofilter run automatically?

I want a spreadsheet that shows all data on one worksheet and a second
worksheet that has filters information fed from the first worksheet.

Unfortunately, when I add new information to the first worksheet it does not
appear on the second worksheet until I veiw all records and run the filter
again.

Is there anyway to automate this?

--
Lori

I would stick with the AutoFilter personally.

Vaya con Dios,
Chuck, CABGx3



"Lori Burton" wrote:

How about if I didn't use autofilter?

Is there a better way to write the second sheet so that it only takes rows
of data from the first sheet that meet one simple critiera?
--
Lori


"CLR" wrote:


Yes, it's a bit involved but it can be done using macros. What you would do
is freeze a few lines above your data to make a workspace for "buttons"
(which can be created from Drawing Objects and assigned titles) that would do
various AutoFilter sorts for you through the macros assigned thereto, and
then erase all the old data on the "Report sheet" and copy and paste that
current sort to the "Report sheet.

Vaya con Dios,
Chuck, CABGx3



"Lori Burton" wrote:

Is there anyway to make autofilter run automatically?

I want a spreadsheet that shows all data on one worksheet and a second
worksheet that has filters information fed from the first worksheet.

Unfortunately, when I add new information to the first worksheet it does not
appear on the second worksheet until I veiw all records and run the filter
again.

Is there anyway to automate this?

--
Lori