I have a tracking sheet that is set up in excel07 and used to track an entire
project for capital equipment builds. The spreadsheet has columns A thru BA
and the number of rows are dependent on the number of parts within that
project. However, the headings are universal. My issue is that there are
crossfunctional groups using, and populating information into this sheet at
different times. Is there a way that I could implement a macro for views or
some way that I can identify columns viewed at the click of a button, so if I
click the "BUYER" button, I only see colums A(item#),
B(description),C(price), D(qty) (F)PO number, or if I click on "ENGINEER" I
only see A(item#), B(description),D(qty), E(Print #),G(rev level)?

Please help.

Candida