Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace cell values in multiple columns
I have a worksheet that has 51 columns, each column is a state label, that
shows a status of "1" or "0". This includes is a column that indicates "ALL STATES". I am looking to see how to write a macro that would look at "All States" (column M) and if "1" than look in same row for each state and replace if remaining states are equal to "1" (1- 50) to a "0" Then do this for each row. Example: ALL STATES AK AL CA CO CT 1 1 1 0 1 0 Final Results ALL STATES AK AL CA CO CT 1 0 0 0 0 0 Not sure how to write this in code. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace all formulas with values in multiple worksheets | Excel Discussion (Misc queries) | |||
Cell for Changing Multiple Values in other columns | Excel Worksheet Functions | |||
Automatically Accept Replace Values in Text-to-Columns macro | Excel Programming | |||
Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
total value relating to cell values in multiple columns! | Excel Discussion (Misc queries) |