I'm trying to repeat every 3rd row from another sheet.
The sheet that I want every 3rd row is called "Blue". The sheet that I'm trying to do this in is called "Test". So in the Test sheet I enter the command 'Blue '!B14. The next row I entered 'Blue '!B17. Now I select both cells and place my mouse in the lower right-hand corner and drag it down 500 rows and I was hoping that it would grab every 3rd row i.e.
'Blue '!B20
'Blue '!B23
'Blue '!B26
'Blue '!B29
and so on, but it's not.
Can someone help me write a formula that would do this?
Thanks
The sheet that I want every 3rd row is called "Blue". The sheet that I'm trying to do this in is called "Test". So in the Test sheet I enter the command 'Blue '!B14. The next row I entered 'Blue '!B17. Now I select both cells and place my mouse in the lower right-hand corner and drag it down 500 rows and I was hoping that it would grab every 3rd row i.e.
'Blue '!B20
'Blue '!B23
'Blue '!B26
'Blue '!B29
and so on, but it's not.
Can someone help me write a formula that would do this?
Thanks