Read list and write one by one to another sheet in fixed cells

I have a problem when I copy a list row by row to another sheet in fixed cells ,but failed,when I use for each row activitly, I found can not write in fixed cells,will increase rows automatically,but this is not what I want,I need write in fixed cell,due to this sheet have formula in it,if row increased ,formula will be invalid,so can someone help me ,thanks in advance.

Hi @ting801215
can u show how you need the output ?

you can do it like this

Thanks so much ,it was works after tried, I found only write cell can work normal,before I tried write range, can not always write in the fixed position

1 Like

no problem :slight_smile: Yes, write range wont write in fixed position since it writes a table

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.