Hello all and happy new year!
I'v written this formula that is pulling data from another sheet:
=IF('Sheet 1'!A1="","",'Sheet 1'!A1)
This formula needs to pull data from A1 to AA1.
The data set on Sheet 1 is 20 rows.
The summary Sheet that the formula is on needs to be pasted every forth row
but pull data from the next row on the dataset.
Is there a proper offset formula that I should be writing in here?