Hi All.
I have a big problem and i cant figure it out...

I have a workbook with 2 tabs.

1st tab is called DATA and it contains information in 200 rows by 7 columns.

2nd tab is called SIGN PRINT and this is only a template of a sign that needs to contain information from every row in DATA tab.

What im after is a macro that selects a row (and then next one, etc) and after selecting a row, trasfers info from the cells in selected row onto relevant cells in the SIGN PRINT tab, prints it and moves to the next row. But it needs to look at the number for how many copies it needs to print of each rows data (no. of copies is a number in each row)

The whole purpose of it is, that i have to print 2000 signs, some of them in A4, some of them in A3 and sometimes is 1 copy, sometimes is 2 copies etc.

Im really struggling to achieve something simple but fully automated.

Could anyone help?

Thanks and regards!