I have a list of products that I have employees use as a reference sheet to confirm item # with the right product. The sheet is set up as
column A - item #
column B - Item name
column C - Small picture of item
column D - how to package it
As I need to add/remove products from time to time I have it as a single "column" A-D list but since the info is fairly simple I would like to be able to print it with those 4 columns listed twice per page. I can fit twelve rows per page with a header on top. So my goal would be to have this
Row 1 - header in A-D and again in E-H
Range A2:D13 would be the first 12 products in my list
Range E2:H13 would be products 13-24 on my list
This would repeat with all remaining products in the list.
Thanks
Andrew
column A - item #
column B - Item name
column C - Small picture of item
column D - how to package it
As I need to add/remove products from time to time I have it as a single "column" A-D list but since the info is fairly simple I would like to be able to print it with those 4 columns listed twice per page. I can fit twelve rows per page with a header on top. So my goal would be to have this
Row 1 - header in A-D and again in E-H
Range A2:D13 would be the first 12 products in my list
Range E2:H13 would be products 13-24 on my list
This would repeat with all remaining products in the list.
Thanks
Andrew