You could write a macro that is triggered when an up date occurs in the
worksheet cell F34 is in that evaluates that cell and acts accordingly. The
macro would be placed in the worksheet module, using the Change event for
that sheet.

--
Kevin Backmann


"Pheasant Plucker®" wrote:

Hello again,

I have received some great advice from this ng in the past and so am
throwing this one open to those of you who may be able to help me some more?

I have a spreadsheet made up of 5 worksheets and I would like to insert a
line of text on the worksheet called Percentages if a specific condition is
met on another worksheet called Other.

For example on Other I currently have a Data Validation box in F34 where I
can choose Y or N and depending upon the result enters in the adjacent cell
a 1 or leaves it blank.
That current formula is =IF(E34="Y",1,"")

Instead of the above formula - but still if E34=Y - I would like to insert a
line of text 'Training Issue' into the Percentages worksheet at say I41
which is currently a blank cell (ideally I would like to insert this text
between two rows which are already populated but this might impact upon a
result in one of those cells that is read by another formula)

Is this even possible?

--
Thanks in advance & regards,
-pp-