newbie needs help!

hi!

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
else
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
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories