I’m using the following formula to set my print area as I add data rows to my worksheet.
=OFFSET('CustomerList'!$C$10,0,0,COUNTA('CustomerList'!$J:$J),8)
My column headers start from row 10. But before that I have the company information and other details starting from row 5 to row 8. Row 9 is empty.
The formula does not set the rows 5 to 8 in print area.
My question of concern is how to make the formula to include the print area starting from row 5 onwards and to get increased as I enter data to the sheet.
Any help on this would be kindly appreciated.
Thanks in advance.