Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I go to the next cell that meets criteria
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I go to the next cell that meets criteria
Looks easy with a VBA macro.
Formulae can't do it. HTH -- AP "Neil" a écrit dans le message de news: ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I go to the next cell that meets criteria
Start macro recorder (ToolsMacroNew macro),
do your stuff Stop recording (click in stop in floating toolbar) Have a look at what was recorded (Alt+F8) HTH -- AP "Neil" a écrit dans le message de news: ... 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 "Ardus Petus" wrote: Looks easy with a VBA macro. Formulae can't do it. HTH -- AP "Neil" a écrit dans le message de news: ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Highlight a row automatically if a cell meets certain criteria | Excel Worksheet Functions | |||
Get data if cell within a row meets criteria | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
"criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) |