I have an Excel sheet with the following:
Column A(PIN) A1-A1000
Column B(Serial Number) B1-B1000
I need a VBA or any other code to make 4 columns and 25 rows/page out of this data where each cell has PIN and serial number or PIN on top then Serial Number below like the recharge card style then print.
The serial numbers are already in series.
I need to combine each PIN with it's serial number with 100 of those per page in a 25 by 4 format then print.
The code should do the same for all entries until all 1000 are done.
It's been a while now, manual copy and paste is time consuming ?
Thank you in advance.
Column A(PIN) A1-A1000
Column B(Serial Number) B1-B1000
I need a VBA or any other code to make 4 columns and 25 rows/page out of this data where each cell has PIN and serial number or PIN on top then Serial Number below like the recharge card style then print.
The serial numbers are already in series.
I need to combine each PIN with it's serial number with 100 of those per page in a 25 by 4 format then print.
The code should do the same for all entries until all 1000 are done.
It's been a while now, manual copy and paste is time consuming ?
Thank you in advance.