I've got a worksheet with customer invoice data in it; e.g. Invoice No,
Name, Address line1, Amount, etc etc. I've designed another worksheet that
is laid out like an invoice with all the headings etc plus the cells ready
to copy the data.

I'm not very expert (obviously) but I was wondering if there was an easy way
whereby I could produce a copy of an invoice for any entry just by entering
an invoice or row number?

Hope this makes sense,

TIA

Liam