Help Please For Formula Copy Skipping Cells?

Originally Posted by FDibbins

waits, Im confused

Do you mean you have 2 files, with 80 tabs each? Or, what do you mean by pages?

The first tab 'Full Survey' effectively contains a questionnaire that has been repeated 80 times on the one tab, each repetition has been formatted to be one page when printed. I cant amend this tab.

I'm summarising one question onto a separate tab into a table, which has 80 rows (one for each questionnaire). The summary table starts in cell B3 and relates to cell B4 of the full survey, then cell B4 relates to B31 of the full survey and B5 relates to cell B58 etc etc