Could be done through event code but we need a few more details.

Your macro will create a new worksheet for potentially up to 86 cells in column
B when the cell value turns to "Red"?

How does the cell get the value "Red"?

Through direct entry or via is it a calculated value?

Would a cell that has a value of "Red" be liable to change to "Blue" then back
to "Red" or stay "Red" once that result has been returned?

i.e. if a worksheet for a cell exists, do not create another one?

Does each new worksheet need to be named according to some convention?


Gord Dibben MS Excel MVP


On Tue, 24 Jul 2007 07:28:01 -0700, deancarpenter
wrote:

I want a Macro to run only if a cell listed in column B says "Red" to create
a seperate spreadsheet.
I currently have 86 line items in this sheet which could potentially go
"Red", so the Macro needs to run each time this happens.