It can be done. How depends on what you're looking to do.
You can always use
VB code thatr views your updated item and will run either
an If Then r a Case Select depending on the number of possible options.
But if it's relatively simple, you can just do If statements in your header
rows to indicate what you want them to say. Copy and paste from one extrnal
sheet to all the others to achieve the same effect.
Perhaps if you give a bit more detail?
"Global Sys Admin" wrote:
I have a workbookwith several worksheets in it. I want to create a type of
header row that remains constant across all worksheets, but can be updated in
all by only updating one item. What is the best way to accomplish this, do I
need a type of master list in the same workbook?