software

Using Excel, I want to test data in a column to see if each individual entry
in the column meets a criterion (say, equals 3). If it does, I then want to
perform certain tasks, using that and otehr relevant data, and enter the
results in other cells elsewhere on the sheet or workbook, then go back and
test the enst item in the original column of data. If any data item does not
meet theinitial criterion, I want to move to the next item in the column,
test it and, if it passes, perform the results and store the reults in the
next available position of my results section.

Any suggestions as to how to go about this in Excel (version Office Xp)?

Many thanks to all in advance.

Looks easy with a VBA macro.

Formulae can't do it.

HTH
--
AP

quot;Neilquot; gt; a écrit dans le message de news:
...
gt; Using Excel, I want to test data in a column to see if each individual
gt; entry
gt; in the column meets a criterion (say, equals 3). If it does, I then want
gt; to
gt; perform certain tasks, using that and otehr relevant data, and enter the
gt; results in other cells elsewhere on the sheet or workbook, then go back
gt; and
gt; test the enst item in the original column of data. If any data item does
gt; not
gt; meet theinitial criterion, I want to move to the next item in the column,
gt; test it and, if it passes, perform the results and store the reults in the
gt; next available position of my results section.
gt;
gt; Any suggestions as to how to go about this in Excel (version Office Xp)?
gt;
gt; Many thanks to all in advance.
Thanks Ardus

Trouble is, I am not at all experienced with VBA or macros - in fact, I have
never written a macro yet. So it's just as difficult that way to me!
Any clues as to how to do the macro - or at least, how to start it off?

Thanks again
Neil

quot;Ardus Petusquot; wrote:

gt; Looks easy with a VBA macro.
gt;
gt; Formulae can't do it.
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;Neilquot; gt; a écrit dans le message de news:
gt; ...
gt; gt; Using Excel, I want to test data in a column to see if each individual
gt; gt; entry
gt; gt; in the column meets a criterion (say, equals 3). If it does, I then want
gt; gt; to
gt; gt; perform certain tasks, using that and otehr relevant data, and enter the
gt; gt; results in other cells elsewhere on the sheet or workbook, then go back
gt; gt; and
gt; gt; test the enst item in the original column of data. If any data item does
gt; gt; not
gt; gt; meet theinitial criterion, I want to move to the next item in the column,
gt; gt; test it and, if it passes, perform the results and store the reults in the
gt; gt; next available position of my results section.
gt; gt;
gt; gt; Any suggestions as to how to go about this in Excel (version Office Xp)?
gt; gt;
gt; gt; Many thanks to all in advance.
gt;
gt;
gt;

Start macro recorder (Toolsgt;Macrogt;New macro),
do your stuff
Stop recording (click in stop in floating toolbar)
Have a look at what was recorded (Alt F8)

HTH
--
AP

quot;Neilquot; gt; a écrit dans le message de news:
...
gt; Thanks Ardus
gt;
gt; Trouble is, I am not at all experienced with VBA or macros - in fact, I
gt; have
gt; never written a macro yet. So it's just as difficult that way to me!
gt; Any clues as to how to do the macro - or at least, how to start it off?
gt;
gt; Thanks again
gt; Neil
gt;
gt; quot;Ardus Petusquot; wrote:
gt;
gt;gt; Looks easy with a VBA macro.
gt;gt;
gt;gt; Formulae can't do it.
gt;gt;
gt;gt; HTH
gt;gt; --
gt;gt; AP
gt;gt;
gt;gt; quot;Neilquot; gt; a écrit dans le message de news:
gt;gt; ...
gt;gt; gt; Using Excel, I want to test data in a column to see if each individual
gt;gt; gt; entry
gt;gt; gt; in the column meets a criterion (say, equals 3). If it does, I then
gt;gt; gt; want
gt;gt; gt; to
gt;gt; gt; perform certain tasks, using that and otehr relevant data, and enter
gt;gt; gt; the
gt;gt; gt; results in other cells elsewhere on the sheet or workbook, then go back
gt;gt; gt; and
gt;gt; gt; test the enst item in the original column of data. If any data item
gt;gt; gt; does
gt;gt; gt; not
gt;gt; gt; meet theinitial criterion, I want to move to the next item in the
gt;gt; gt; column,
gt;gt; gt; test it and, if it passes, perform the results and store the reults in
gt;gt; gt; the
gt;gt; gt; next available position of my results section.
gt;gt; gt;
gt;gt; gt; Any suggestions as to how to go about this in Excel (version Office
gt;gt; gt; Xp)?
gt;gt; gt;
gt;gt; gt; Many thanks to all in advance.
gt;gt;
gt;gt;
gt;gt;