View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Creating a row that is constant and updatable across all worksheet

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?