Forum Discussion
#REF! error when I delete a line on master sheet
I'm trying to create a workbook where I enter data into sheet 1, outputs in the format in sheet 2. The lines in sheet 1 need to be able to be deleted, but when I do, it breaks the link in the formula...
Thank you! This worked perfectly for page 1 of sheet 2. How to I continue the pattern for more pages? See attached.
Hi,
First, i'd remove column names for entire page from within the sheet and repeat them only for printing through page layout setup
With that assuming each page has 33 roows the formula will be
=OFFSET(Sheet1!$A$1,ROW()+33*(4*INT((ROW()-2)/33)+INT(COLUMN()/4))-1,0)
for A2, and with 1 and 2 at the end for B2 and B3. Copy that block to the right on each next 3-columns block and after that row 2 till end of the file.
See Sheet2(2) in the attached file.
If you prefer to repeat columns titles within the sheet the formula will be bit complicated, but the idea is the same.
This is exactly what I needed. Thank you very much!