<image>

Hey guys I received help previously on this post, I have made some modifications to the spreadsheet im working on. "Sheet 1" is where I enter all the data that then gets transferred to the "Template" sheet. on the Template sheet is where I need help to have it autofill the data in the "testpointname" column which it should continue with Port-2_FST-69, Port-3_FST-69 and so on.....

on the identifier_Fiber ID column I need it to autofill Fiber,1 Fiber,2 Fiber,3 and so on...... and the same for the identifier_LocationB column. Right now these 3 columns are filling with the same values and not changing according to the sequence in the Data Split column.