Hi! I'm currently working on a report and what I'm trying to do is get a Row of information to pull into 4 rows
My current formula looks like this:
=INDIRECT("'Paste SAP'!H"&IF(MOD(ROW()-1,4)=1,ROUNDDOWN(((ROW())+3/4),0)," "),1)
I change the bolded number to correspond to which row (1,2,3,0) but it's not functioning.
I've done it with other but for some reason this one doesn't work. I've attached the template so you can see what it looks like.
The problem is with the SAP Tab and the info from the Paste SAP tab.
Thanks!
Bookmarks