Hello,
I need help finding a way to copy down a column pattern. I will be creating list that starts in cell B7 and continues down for 200 rows. I'd like to be able to drag/copy down a column pattern. For example:
Cell B7 will refer to cell M99 (=M99)
Cell B8 will refer to cell AH99 (=AH99)
Cell B9 will refer to cell BC99 (=BC99)
Essentially, each cell is skipping ahead in column references by 21 columns. Can you help me figure out how best to do this? Thanks so much for the help!
Bookmarks