Filtering or preselecting columns

[gregfrgusa]

Hello,

What is the best way to preselect or filter the same columns from a
different file each day? Example -- I have a new downloadable file each day.
The file has many, many more columns than I need. So I want to define a
view or macro or sheet or ?? so that, when I download this file, it
automatically hides columns and formats the columns I want. Once I set up
this view/macro/sheet, the process to print this file each day is very, very
simple, just a few clicks away.

Does anyone have any ideas? If I have not been clear in this explanation,
please let me know.

Thanks,
Greg

 

[Otto Moehrbach]

Greg
The simplest way I can think of is for you to record a macro and place
that macro in your Personal.xls file. The Personal.xls file is a hidden
file that is opened automatically each and every time that Excel is opened.
So once you have the file you want to operate on open, you simply run that
macro. You may or may not have a Personal.xls file already created. To
find out, open Excel and click on Windows - Unhide. If Personal.xls file is
displayed in the box, you have it. If it isn't or if "Unhide" is grayed
out, you don't.
If you don't have a Personal.xls file, do the following:
With Excel open, click on Tools - Macro - Record New Macro. In the space
labeled "Store macro in:", select "Personal macro workbook".
Close the macro recorder.
Done. Come back if you need more. Otto

 

[gregfrgusa]

Greg
The simplest way I can think of is for you to record a macro and place
that macro in your Personal.xls file. The Personal.xls file is a hidden
file that is opened automatically each and every time that Excel is opened.
So once you have the file you want to operate on open, you simply run that
macro. You may or may not have a Personal.xls file already created. To
find out, open Excel and click on Windows - Unhide. If Personal.xls file is
displayed in the box, you have it. If it isn't or if "Unhide" is grayed
out, you don't.
If you don't have a Personal.xls file, do the following:
With Excel open, click on Tools - Macro - Record New Macro. In the space
labeled "Store macro in:", select "Personal macro workbook".
Close the macro recorder.
Done. Come back if you need more. Otto



Thanks, Otto!