I'm trying to make an excel spreadsheet that can automatically hide rows when a cell value on that row is not equivalent to the value on a reference row. I'm not really that good with VB so I really do not know what to write on the macro
here is what I would like to happen..
let b1 = ref.cell
jump to cell c3
if c3=b3 then
move down to the cell bellow the current cell
hide current row then move down to the cell bellow the current cell
do this if statement while current cell<=bottom cell of the range
I hope I can get an answer here. I've been working on the spreadsheet for a week now trying to accomplish it without macros but until now I still haven't found any solution.
using macro is my only hope for it
thanks in advance