Hello. I hope I posted this in the rigth forum. If not, I apologize.

I have a problem for which I haven't found a real solution but I am sure there has to be one so here I am praying you guys can point me in the right direction.

Firsty of all my knowledge of Excel is intermediate and NONE for macros.

I started at a new job.

They have a spreadsheet with conctact information divided into columns by company, contact name, email, tel, division, address on sheet # 1.

Every year they send invoices to those companies, but they create the labels and the invoices kind of mannually, I mean they go to sheet # 2 and they create the mailing labels by referencing to the cells one by one, for 150 companies. They do the same thing for the invoices on sheet # 3. I mean it takes like three days to update all that.

Now I am sure Exel must have a very easier and quick way to generate labels and invoices but I have googles around and haven't found the right formula or commands.

Can anybody help me here?