VBA Code to copy a range of cells between 2 specifc values and repeat to end of range

I've been attempting to solve this problem for a few days now.

I would like to write a code 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 column B, D, 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. Any help would be greatly appreciated

let me work on the visible/hidden row part, for now..

Please Login or Register  to view this content.

Thank you very much for your help.

I tried the code that you have written above and I don't think that it is working. When I updated the sheet names to apply to my worksheet I get an error message that a variable is not define. I believe that the error is with "i" but I'm not sure.

I also tried the code on a blank sheet to see if I could get it to work that way. And it does, it enters the number 2 in Sheet 2 cell A1.

I'm just not sure how to modify it to fit what I need. Potentially I just need to wait for you to finish the copy/paste part of the code?

Thank you so very much for your help

please send me a sample (non-sensitive) so I can fit it exactly