So I’m trying to write 10 to the 10 series sheet and 20 to the 20 series sheet.
Sheet name works fine, I get two sheets.
However the string that goes into the data appears in TWO cells.
So 10 appears on sheet 10 series but 1 is in cell A5 and 0 is in cell A6.
20 appears on sheet 20 series but 2 is in cell B5 and 0 is in cell B6.
I want 10 to be in A5 only on the 10 series sheet and for 20 to be in B5 only on the 20 series sheet.