Printing a specific area in a form while keeping its position

[be_kul]

Hello all Excel experts,

I need help with printing a weekly form that is continuously updated everyday with new lines and entries. Basically I am restricted to printing on the same paper for a week and at the end of everyday I have to print any new line items that has been added to the table.

The problem I encounter by using the 'print area' option is it automatically set the selected area to the top of the paper as if its printing on a fresh blank paper thus overprinting on top of my previously printed lines.

My question specifically, is there any way I can print a selected area of a worksheet WHILE keeping its position relative to the form/table. That way, I can just select my newly added lines and print them on its position relative to the table every time there is a new entry.

Can anyone help me with this? Is there something I'm missing here? Thanks ahead.

[royUK]

Read the Forum Rules& don't use unnecessary words or abbreviations in Thread Titles. Your title has been edited