tribtown
12-15-2021, 01:12 PM
I have attached the file I'm working on (it's not my file, I just have to prepare it to print). I'm pretty new to VBA but I have a macro that will hide all the blank rows and another to unhide them all but I can't figure out how to get the rest of the way to what I want to accomplish.
Tab A is the base that I'm working with. Tab B s what I want it to end up as.
Here's what I think I'm trying to make happen:
1) Start at the top of column C
2) Move down until left 4 digits are 2021
3) Select all rows until right 4 digits in column F are 2022
4) Move up 1 row (to leave row with Account # visible)
5) Hide selected rows
6) Loop until no more cells in C start with 2021
Tab A is the base that I'm working with. Tab B s what I want it to end up as.
Here's what I think I'm trying to make happen:
1) Start at the top of column C
2) Move down until left 4 digits are 2021
3) Select all rows until right 4 digits in column F are 2022
4) Move up 1 row (to leave row with Account # visible)
5) Hide selected rows
6) Loop until no more cells in C start with 2021