Printing a unique number on each copy of a spreadsheet

[Ewar2020]

Hi

Can someone help me? I'm trying to print a spreadsheet with a unique reference on each copy from a list on another sheet.

Any ideas?

Ed

[Richard Buttrey]

Hi,

You'll need to give us an example and explain exactly what you want to occur. Terms like 'a spreadsheet' are often misinterpreted to mean a whole workbook. Don't expect us to guess. Uploading a workbook with appropriate notes would help.

So where does each unique reference occur. On each sheet tab within a workbook or just on a single sheet?
Are you saying that you want to pick the next item from a list of unique references?
Should these references change each time you print a worksheet/workbook or is this a one off event?

Hopefully you can see that there are so many questions that we need to know much more.

[Ewar2020]

Hi Richard

Thanks. Attached is the workbook. Sheet 1 is what i need to print. In the cell B3 i would like the information from Sheet 2 coloumn A on each copy that I print.

I will only need to print them in a batch as a one off.

Ed

[Richard Buttrey]

Hi,

How about

Please Login or Register  to view this content.

[Ewar2020]

Thanks Richard worked perfectly!