I am working with Excel 2003 at the office.
I like the Data List feature, but I really miss the Custom Views feature especially for hiding columns to simplify data entry updates. Unfortunately, the Data List feature does not allow Custom Views.
My perfect macro would deal with a tab 1 that would have the data with the columns. Tab 2 would have a column with the column names going down. The other columns would be for different views. There could be a macro button above each view to hide or show the columns listed below.
Tab 1
First Middle Last Project Status Status_Date
W. Alex Smith ABC Design 07/01/2010
B. James Calhoun XYZ Review 07/02/2010
David Thomas Harris DEF Discuss 07/09/2010
Tab 2
[Macro Button]
Updating_Status View
First
Middle
Last x
Project x
Status x
Status_Date x
Tab 1 after running Updating_Status View
Last Project Status Status_Date
Smith ABC Design 07/01/2010
Calhoun XYZ Review 07/02/2010
Harris DEF Discuss 07/09/2010
I like the Data List feature, but I really miss the Custom Views feature especially for hiding columns to simplify data entry updates. Unfortunately, the Data List feature does not allow Custom Views.
My perfect macro would deal with a tab 1 that would have the data with the columns. Tab 2 would have a column with the column names going down. The other columns would be for different views. There could be a macro button above each view to hide or show the columns listed below.
Tab 1
First Middle Last Project Status Status_Date
W. Alex Smith ABC Design 07/01/2010
B. James Calhoun XYZ Review 07/02/2010
David Thomas Harris DEF Discuss 07/09/2010
Tab 2
[Macro Button]
Updating_Status View
First
Middle
Last x
Project x
Status x
Status_Date x
Tab 1 after running Updating_Status View
Last Project Status Status_Date
Smith ABC Design 07/01/2010
Calhoun XYZ Review 07/02/2010
Harris DEF Discuss 07/09/2010
