2 system generated auto number columns


Hi Team,

I have sheets from different departments that have auto generated numbers in them. What I’m wanting is when the sheets are copied to a master sheet, I want to have another system generated number as a unique code. But I can’t get it to work. I need each department to have its auto number, then once moved to the master sheet, another system number is generated, before the rows are moved again.

Is there a work around for this?