lost_in_the_sauce
Board Regular
- Joined
- Jan 18, 2021
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
I have a workbook with multiple tabs, I'm trying to copy over formulas in only the rows that are visible when the groups are closed (account subtotals) - I tried Find & Select -> Go To Special -> Visible Cells Only -> copy -> paste formula but it just pastes them in successive rows instead of the same ones I just copied from. Guessing the visible cells only requires hiding or filtering, not grouping?