I have a Excel 2021 on Windows spreadsheet with many columns and rows
I need a macro that can look at every column from B to SL and hide that column if the value of row 1790 is below 200%. For complete disclosure row 1790 is a calculation of two other elements in the column divided by the other and the result is displayed as a percentage
Example =B1783/B1279
or simply show columns where row value of cell 1790 in that column is above 200%
I am open to suggestions. I have researched for days but not found a solution that applies.
Thanks in advance.
Mark
I need a macro that can look at every column from B to SL and hide that column if the value of row 1790 is below 200%. For complete disclosure row 1790 is a calculation of two other elements in the column divided by the other and the result is displayed as a percentage
Example =B1783/B1279
or simply show columns where row value of cell 1790 in that column is above 200%
I am open to suggestions. I have researched for days but not found a solution that applies.
Thanks in advance.
Mark