Auto increment

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

1 way to handle, the counter in sheet counter, just change the red part to the ranges needed

Please Login or Register  to view this content.

Kind regards
Leo

Dear LeoTaxi,

Thanks for the reply but the code couldn't give me what i want.
What i want is like for example

I have 80 rows to be printed in four pages and then i print for the first time the first printed page should have a page numbered 1 the second page will be 2 the third page will be 3 and the fourth page will be 4. If again print it then the first page should be 5(continuation from the last page of the previous print out. The second page will be 6 the third will be seven the fourth will be 8. If again i print four the third time 9, 10, 11 and 12. That is what i want.

Thanks,

So only thing to do is changes the ranges to

Please Login or Register  to view this content.

Kind regards
Leo

Every thing is in one sheet names sheet1 i don't have any other sheet. when i run this code you wrote it shows the sheet error.

If data is only in 1 sheet, first code works, only you have to add new sheet and name it Counter
and adjust the 4 ranges marked in red.

Kind regards
Leo

Dear LeoTaxi,

Thanks, now it is working fine but when i print for the second time it starts counting from four, but it should begin from 5(continuation from the last page which is 4). Is there a way to fix this?

Thanks,

yes, forgot to mention, cell A1 from sheets counter should have value 1 before use

Kind regards
Leo

I understood the code and it is working good but i don't understand why it is getting in to problem when it comes to the second print it repeats page four as i told you before after adjusting the a1=1 in the Counter sheet as you told me.

Dear LeoTaxi,

Thanks for your support now it is working as expected.

Thanks,

Glad i could help and tanksfor the rep.

Kind regards
Leo