acsishere
07-21-2008, 11:28 AM
Dear Friends,
First of all, I sincerely thank Mr. MDmackillop for excellent solution to my previous post.
Now, this is regarding Page Header. First I would like to explain the problem.
I have some 7500 rows of data (A4:CZ7500). It goes more than 2000 pages. The data of First page starts from Row4. 2nd page is from 47. 3rd page is from 89.... and so on. i.e. The no. of rows in each page may vary as per page break.
Whenever I print, I need to get the first row value of ColB of that particular page should appear in Left Header.
IS IT POSSIBLE? I explained in detail in the attached sample workbook.
As like earlier, I eagerly seek positive reply.
Thanks in advance, acsishere.
First of all, I sincerely thank Mr. MDmackillop for excellent solution to my previous post.
Now, this is regarding Page Header. First I would like to explain the problem.
I have some 7500 rows of data (A4:CZ7500). It goes more than 2000 pages. The data of First page starts from Row4. 2nd page is from 47. 3rd page is from 89.... and so on. i.e. The no. of rows in each page may vary as per page break.
Whenever I print, I need to get the first row value of ColB of that particular page should appear in Left Header.
IS IT POSSIBLE? I explained in detail in the attached sample workbook.
As like earlier, I eagerly seek positive reply.
Thanks in advance, acsishere.