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

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
"JPS" wrote in message
...
| 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

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.

JPS wrote:

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