software

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=quot;Yquot;,1,quot;quot;)

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 amp; regards,
-pp-
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 Backmannquot;Pheasant Plucker®quot; wrote:

gt; Hello again,
gt;
gt; I have received some great advice from this ng in the past and so am
gt; throwing this one open to those of you who may be able to help me some more?
gt;
gt; I have a spreadsheet made up of 5 worksheets and I would like to insert a
gt; line of text on the worksheet called Percentages if a specific condition is
gt; met on another worksheet called Other.
gt;
gt; For example on Other I currently have a Data Validation box in F34 where I
gt; can choose Y or N and depending upon the result enters in the adjacent cell
gt; a 1 or leaves it blank.
gt; That current formula is =IF(E34=quot;Yquot;,1,quot;quot;)
gt;
gt; Instead of the above formula - but still if E34=Y - I would like to insert a
gt; line of text 'Training Issue' into the Percentages worksheet at say I41
gt; which is currently a blank cell (ideally I would like to insert this text
gt; between two rows which are already populated but this might impact upon a
gt; result in one of those cells that is read by another formula)
gt;
gt; Is this even possible?
gt;
gt; --
gt; Thanks in advance amp; regards,
gt; -pp-
gt;
gt;
gt;

Thanks for the quick reply Kevin,

So it is possible then...

As I know little (nothing?:-) about Macros in Excel is there a resource or
anywhere that would give an idiots guide to this approach please?

Thanks amp; regards,
-=pp=-

quot;Kevin Bquot; gt; wrote in message
...
gt; You could write a macro that is triggered when an up date occurs in the
gt; worksheet cell F34 is in that evaluates that cell and acts accordingly.
The
gt; macro would be placed in the worksheet module, using the Change event for
gt; that sheet.
gt;
gt; --
gt; Kevin Backmann
gt;
gt;
gt; quot;Pheasant Plucker®quot; wrote:
gt;
gt; gt; Hello again,
gt; gt;
gt; gt; I have received some great advice from this ng in the past and so am
gt; gt; throwing this one open to those of you who may be able to help me some
more?
gt; gt;
gt; gt; I have a spreadsheet made up of 5 worksheets and I would like to insert
a
gt; gt; line of text on the worksheet called Percentages if a specific condition
is
gt; gt; met on another worksheet called Other.
gt; gt;
gt; gt; For example on Other I currently have a Data Validation box in F34 where
I
gt; gt; can choose Y or N and depending upon the result enters in the adjacent
cell
gt; gt; a 1 or leaves it blank.
gt; gt; That current formula is =IF(E34=quot;Yquot;,1,quot;quot;)
gt; gt;
gt; gt; Instead of the above formula - but still if E34=Y - I would like to
insert a
gt; gt; line of text 'Training Issue' into the Percentages worksheet at say I41
gt; gt; which is currently a blank cell (ideally I would like to insert this
text
gt; gt; between two rows which are already populated but this might impact upon
a
gt; gt; result in one of those cells that is read by another formula)
gt; gt;
gt; gt; Is this even possible?
gt; gt;
gt; gt; --
gt; gt; Thanks in advance amp; regards,
gt; gt; -pp-
gt; gt;
gt; gt;
gt; gt;
There are a number of books out there that are extremely useful, but if
you're a novice I can recommend from experience the Excel 2000 Visual Basice
for Applications Fundamentals by Reed Jacobson, and the Excel 2003
Programming, Inside Out Series. Both titles are published by Microsoft Press
and I've used them to teach classes to novices over the years. Both come
with CD's and each chapter is a stand-alone lesson, so you're not forced to
finish one chapter before being able to move to the next.

I'm not getting a kickback from MS by the way, I've just found these books
to be excellent teaching tools.

The following URL is an site with quite a bit of useful information and
links to other resources as well:

kayodeok.users.btopenworld.co...fficeexcel.htm

Best of luck...
--
Kevin Backmannquot;Pheasant Plucker®quot; wrote:

gt; Thanks for the quick reply Kevin,
gt;
gt; So it is possible then...
gt;
gt; As I know little (nothing?:-) about Macros in Excel is there a resource or
gt; anywhere that would give an idiots guide to this approach please?
gt;
gt; Thanks amp; regards,
gt; -=pp=-
gt;
gt; quot;Kevin Bquot; gt; wrote in message
gt; ...
gt; gt; You could write a macro that is triggered when an up date occurs in the
gt; gt; worksheet cell F34 is in that evaluates that cell and acts accordingly.
gt; The
gt; gt; macro would be placed in the worksheet module, using the Change event for
gt; gt; that sheet.
gt; gt;
gt; gt; --
gt; gt; Kevin Backmann
gt; gt;
gt; gt;
gt; gt; quot;Pheasant Plucker®quot; wrote:
gt; gt;
gt; gt; gt; Hello again,
gt; gt; gt;
gt; gt; gt; I have received some great advice from this ng in the past and so am
gt; gt; gt; throwing this one open to those of you who may be able to help me some
gt; more?
gt; gt; gt;
gt; gt; gt; I have a spreadsheet made up of 5 worksheets and I would like to insert
gt; a
gt; gt; gt; line of text on the worksheet called Percentages if a specific condition
gt; is
gt; gt; gt; met on another worksheet called Other.
gt; gt; gt;
gt; gt; gt; For example on Other I currently have a Data Validation box in F34 where
gt; I
gt; gt; gt; can choose Y or N and depending upon the result enters in the adjacent
gt; cell
gt; gt; gt; a 1 or leaves it blank.
gt; gt; gt; That current formula is =IF(E34=quot;Yquot;,1,quot;quot;)
gt; gt; gt;
gt; gt; gt; Instead of the above formula - but still if E34=Y - I would like to
gt; insert a
gt; gt; gt; line of text 'Training Issue' into the Percentages worksheet at say I41
gt; gt; gt; which is currently a blank cell (ideally I would like to insert this
gt; text
gt; gt; gt; between two rows which are already populated but this might impact upon
gt; a
gt; gt; gt; result in one of those cells that is read by another formula)
gt; gt; gt;
gt; gt; gt; Is this even possible?
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Thanks in advance amp; regards,
gt; gt; gt; -pp-
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

Hi Kevin,

Thanks for the reply and the heads-up.

I will take a look-see.

Thanks amp; regards,
-=Glyn=-quot;Kevin Bquot; gt; wrote in message
...
gt; There are a number of books out there that are extremely useful, but if
gt; you're a novice I can recommend from experience the Excel 2000 Visual
Basice
gt; for Applications Fundamentals by Reed Jacobson, and the Excel 2003
gt; Programming, Inside Out Series. Both titles are published by Microsoft
Press
gt; and I've used them to teach classes to novices over the years. Both come
gt; with CD's and each chapter is a stand-alone lesson, so you're not forced
to
gt; finish one chapter before being able to move to the next.
gt;
gt; I'm not getting a kickback from MS by the way, I've just found these books
gt; to be excellent teaching tools.
gt;
gt; The following URL is an site with quite a bit of useful information and
gt; links to other resources as well:
gt;
gt; kayodeok.users.btopenworld.co...fficeexcel.htm
gt;
gt; Best of luck...
gt; --
gt; Kevin Backmann
gt;
gt;
gt; quot;Pheasant Plucker®quot; wrote:
gt;
gt; gt; Thanks for the quick reply Kevin,
gt; gt;
gt; gt; So it is possible then...
gt; gt;
gt; gt; As I know little (nothing?:-) about Macros in Excel is there a resource
or
gt; gt; anywhere that would give an idiots guide to this approach please?
gt; gt;
gt; gt; Thanks amp; regards,
gt; gt; -=pp=-
gt; gt;
gt; gt; quot;Kevin Bquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; You could write a macro that is triggered when an up date occurs in
the
gt; gt; gt; worksheet cell F34 is in that evaluates that cell and acts
accordingly.
gt; gt; The
gt; gt; gt; macro would be placed in the worksheet module, using the Change event
for
gt; gt; gt; that sheet.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Kevin Backmann
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Pheasant Plucker®quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hello again,
gt; gt; gt; gt;
gt; gt; gt; gt; I have received some great advice from this ng in the past and so am
gt; gt; gt; gt; throwing this one open to those of you who may be able to help me
some
gt; gt; more?
gt; gt; gt; gt;
gt; gt; gt; gt; I have a spreadsheet made up of 5 worksheets and I would like to
insert
gt; gt; a
gt; gt; gt; gt; line of text on the worksheet called Percentages if a specific
condition
gt; gt; is
gt; gt; gt; gt; met on another worksheet called Other.
gt; gt; gt; gt;
gt; gt; gt; gt; For example on Other I currently have a Data Validation box in F34
where
gt; gt; I
gt; gt; gt; gt; can choose Y or N and depending upon the result enters in the
adjacent
gt; gt; cell
gt; gt; gt; gt; a 1 or leaves it blank.
gt; gt; gt; gt; That current formula is =IF(E34=quot;Yquot;,1,quot;quot;)
gt; gt; gt; gt;
gt; gt; gt; gt; Instead of the above formula - but still if E34=Y - I would like to
gt; gt; insert a
gt; gt; gt; gt; line of text 'Training Issue' into the Percentages worksheet at say
I41
gt; gt; gt; gt; which is currently a blank cell (ideally I would like to insert this
gt; gt; text
gt; gt; gt; gt; between two rows which are already populated but this might impact
upon
gt; gt; a
gt; gt; gt; gt; result in one of those cells that is read by another formula)
gt; gt; gt; gt;
gt; gt; gt; gt; Is this even possible?
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; Thanks in advance amp; regards,
gt; gt; gt; gt; -pp-
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;