hide values loop and print n times

[fabdav]

I have a worksheet with in column A values such as:

907873
907880
907900

these values rapressents a code which identifies a person.

I need to print the page n times depending how many rows have a value (in this case 3 times)

I need one at a time to hide the all the values except one such as:
1st printed page:

907873
XXXXX
XXXXX

2nd printed page:
XXXXX
907880
XXXXX

3rd printed page:
XXXXX
XXXXX
907900

an this for all the row.

All the values in column B C D, etc remain visible

I am attaching a file as example.

I could do as a recorded macro but each time the number of row and as consequence the number of printed pages might change

[mrice]

Try this macro

Please Login or Register  to view this content.