Hi there,
I have a table with customer information, product name, product model and a
date. Also using another worksheet to paste the vales on it, because I
arranged the 2nd sheet with the size of the labels i am using to help me with
the exact printing style. When I paste the date on sheet2 it looks like

Jhon Smith
Power Supply PwS02
01.02.2008

but in Sheet1 its a row as you can guess.
Is there a way to automatically past the values to sheet two? Then I can do
the printing

or another creative way might be;
Check if there is more then 1 enerty run n instances to paste the 1st enrery
to sheet2 then after the print command paste the second entery so on

I know this might sound hard or complex but it will help a lot

Thank you