Hard Code a Copied Cell
SHEET 1: has an auto-number field.
SHEET 2: I am copying (via automation) the data from SHEET 1 to SHEET 2. SHEET 2 already has an auto-number field.
When the rows are copied from SHEET 1 to SHEET 2 auto-number fields go into the existing auto-number field.
I believe this is because you can only have ONE auto-number field per sheet.
So my question is.... is there a way to HARD CODE the auto-number field in SHEET 1 (into its own seperate column that is not auto-number column) so I can, in turn, copy that HARD CODE number can be moved to SHEET 2?