Hi,
Could someone help me how can I copy the values from the other sheet to another. I would need to get those values in a way: A1=A5, A4=A6, A8=A7 A11=A8 and so on.
Thank you for your help!
Hi,
Could someone help me how can I copy the values from the other sheet to another. I would need to get those values in a way: A1=A5, A4=A6, A8=A7 A11=A8 and so on.
Thank you for your help!
Pls attach a sample excel file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
OR TRY
=INDEX(Sheet1!A:A,4+CEILING(ROWS(A$1:A1)/3,1))
CHANGE THE SHEET NAME AS PER YOUR NEEDS
Hereīs a example of the situation that I made.
Thanks a lot for the help!
On sheet 2 you can see the current situation and on Sheet 1 is what I am aiming for. I would need to drag the formula to copy those values for every nth row and then insert it in a way that it automaticly updates itself.
A2 OF SHEET1
=IF(MOD(ROWS($A$2:$A2),2)=1,INDEX(Sheet2!$A$2:$A$12,INT((ROWS($A$2:$A2)-1)/2)+1),"")
Try this and copy towards down
It works!!!! Iīve been working on it work 5 hours now and I didnīt get it to work. You saved me! Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks