Lets say i have 80 rows and i want to print 20 rows in one page so i have four pages. Here i want to increment a cell value or the header of the excel every time i print the pages. For example if i print for the first time the print counter cell will be 1 in the first page 2 in the second page 3 in the third page and 4 on the forth page. Again if i print one copy i need to see 5 on the first page 6 in the second page 7 in the third page and 8 on the forth page... so i need a Macro code for this if possible. I will be happy to get any assistance on it. Thanks
Bookmarks