Hi Group,
I have 2 sheets. One called WORKSHEET one called REPORT.
In the report sheet I want to copy a formula down the page so
that the referenced cells increment by 12 instead of 1 as per
below.
C18 =IF(WORKSHEET!C10=0,"",WORKSHEET!C12)
C19 =IF(WORKSHEET!C22=0,"",WORKSHEET!C24)
C20 =IF(WORKSHEET!C34=0,"",WORKSHEET!C36)
I feel like this should be very simple but I just can't work it out,
Any help would be much appreciated.
Bookmarks