I'm using excel 2010
I would like to write a macro that Looks at Column A and finds the value "b" (start of the range) and then keeps looking until it finds the next "b" (end of the range).
I'd like it to copy only visible rows for columns B,DD, and E for this range and paste to another sheet and then continue to the next "b"
I can't seem to figure out how to make this happen,
your help would be greatly appreciated
I would like to write a macro that Looks at Column A and finds the value "b" (start of the range) and then keeps looking until it finds the next "b" (end of the range).
I'd like it to copy only visible rows for columns B,DD, and E for this range and paste to another sheet and then continue to the next "b"
I can't seem to figure out how to make this happen,
your help would be greatly appreciated