Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
New to macros! Need Help!
I want to create a macro that will read in a range of cells (ex: i2 - as2)
and then look at each value in the cells. If that value matches a certain value I would like it to print out a certain phrase. But if it doesn't then I would like it to not do anything and just move on until it finds the equal value. Look through a row to find a value and for each case found, print out a phrase in column. Example: If you have table, x y z a 1 1 1 b 0 0 1 c 1 1 0 abc are names while xyz and certain topics. if a has a 1 value for any of the xyz i want it to print out something like: a x y z b z c x y If I'm not making clear just let me know and I'll try to clarify. Also remember that I'm new to macros so I might need some additional guidance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
Purge macros | Excel Worksheet Functions | |||
sharing macros | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) |