Hi,
I've got a range in a sheet which contains value in every other row. I would like to set the value in row 1 equal value in row 2 in the columns E:I. So that E1=E2, F1=F2 and so on. Furthermore E3=E4, F3=F4 and so on.
It will differ from time to time how many rows which conatins data, so that part should be flexible.
I hope that you understand what I want to do, and that someone can help me with this![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I've got a range in a sheet which contains value in every other row. I would like to set the value in row 1 equal value in row 2 in the columns E:I. So that E1=E2, F1=F2 and so on. Furthermore E3=E4, F3=F4 and so on.
It will differ from time to time how many rows which conatins data, so that part should be flexible.
I hope that you understand what I want to do, and that someone can help me with this