Excel spreadsheet

[grierfield]

I have a spreadsheet with 12 columns and hundreds of rows of data.

New rows (records) of data are constantly being added.

One column has 5 different data specification.

If I do an auto filter to show information for one of the 5 data types in the specific column and save the steps as a Macro – --- when more data is added – the macro does not pick up the new data.

I would like to place 5 buttons on the spreadsheet with the name of each of the 5 specific data types so that when one clicks the button it will run the auto filter macro and also includes new data that was added.

thanks

 

[SkipVought]

Hi,

This seems like a purely Excel-related question, and, as such, belongs in Forum68.

Why not turn on Data > Filter > AutoFilter

There's your button!

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[grierfield]

Thanks, but apparently snippy response neglected to note I stated I was using Auto filter but wanted to know how to get the saved macro to recognize data added after the macro was recorded.

Thanks anyway

 

[SkipVought]

maybe posting you code might help to find out why your VBA approch is not working.

My original point; you really don't need a macro to get AutoFilter results.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[grierfield]

My original point; you really don't need a macro to get AutoFilter results."

that much i know - i am not doing it for me - it's for people who have difficulty with Auto filter

 

[SkipVought]

wow! But it is such a complex and obscure concept and completely inconcievable.

But your code is necessary in order to make a cogent suggestion.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}