| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering or preselecting columns
"Otto Moehrbach" wrote: 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" wrote in message ... 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 Thanks, Otto! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering Multiple Columns... | Excel Discussion (Misc queries) | |||
| Filtering Columns | Excel Discussion (Misc queries) | |||
| filtering columns-left nav | Charts and Charting in Excel | |||
| Filtering on multiple columns | Excel Discussion (Misc queries) | |||
| Filtering by Columns | Excel Worksheet Functions | |||
Threaded Mode
