Log In
Register
Home
December 8, 2017
Offline
Hi Every one
i have attached file i need serial no automatically while printing. if i print one time it should be come 1 if i print 100 system should be auto generate 1 to 100.
after again if i give print system should print from 101 to how many i have given print.
Thanks
Saliha
VIP
Trusted Members
June 25, 2016
Offline
Hi Mohamed
There are 2 items in your worksheet.
Are you printing them both at once or one by one?
Are you selecting them if you are printing one by one?
Sunny
December 8, 2017
Offline
Hi Sunny
yes i am printing both in one time.
VIP
Trusted Members
June 25, 2016
Offline
Hi Mohamed
Give this a try.
Please note that it will always increase the serial number in cell J3 before it prints.
So if you are printing for the 1st time, leave J3 to be blank. Otherwise J3 will be the last number you printed.
I have currently set the option to PrintPreview. Change to PrintOut when you have tested that is is OK.
Hope this helps.
December 8, 2017
Offline
Hi Sunnykow
Thanks yes! this is the one i need
Saliha
December 8, 2017
Offline
Hi Sunny Good Morning
please see the attached file its displaying Error.
Saliha
VIP
Trusted Members
June 25, 2016
Offline
Please check your macro setting.
December 8, 2017
Offline
i have check and shown to our technical system member also.
