Dynamic Spreadshets

[JPS]

Help! I am using Excel 2003 and I have a spreadsheet approaching 150 columns
and 1000 rows. I need to dynamically create reporting spreadsheets from this
“Master†by filtering data in a selected column or columns. For example, if
column P in the “Master†contains an “S†I need to pull columns
A,I,J,K,DE,DF,Q,U,DG-DM into the report. Is this doable within 2003?

 

[Jim Rech]

Is this doable within 2003?

Since your columns are out of order only by Copy and Paste I think (probably
paste special formats/values). Of course you'd want to write a macro to
make that easier.

--
Jim
| Help! I am using Excel 2003 and I have a spreadsheet approaching 150
columns
| and 1000 rows. I need to dynamically create reporting spreadsheets from
this
| "Master" by filtering data in a selected column or columns. For example,
if
| column P in the "Master" contains an "S" I need to pull columns
| A,I,J,K,DE,DF,Q,U,DG-DM into the report. Is this doable within 2003?
| --
| JPS

 

[Dave Peterson]

You could look at View|Custom views (xl2003 menu system)

or

You could record a macro that would hide the columns you don't want to see.
Then rerun this macro whenever you want.